I am having a problem with creating a standby database using the duplicate target from active standby command and am at my wits end....
My environment is linux x86.
I've got the listener and tnsnames configured on both servers and can connect to the standby database using the network service from both the primary and standby when it is open and when it is mounted with no problems.
When the standby database is not mounted, I can connect from the command line using sql*plus. Once in sql*plus, when I try to 'connect sys@<svcname> as sysdba' I get ora-01031 unsufficient privileges. This results in the same error
when I attempt the duplicate command.
I know I'm missing something and for the life of me can not figure out what it is. I don't understand why I'm only having this problem when the standby database is not mounted.
Thanks in advance...
properly copy password file from the primary to standby DB and rename it. or use orapwd to create password file on standby DB.
Here are my notes:
Check out step 2 and the "Keys to success" at the very end.
This is a great thing to master as you can use it to recreate a standby too.
Well, I checked the password file on both servers and everything looked good. I verified the user account in v$pwfile_users (sys with sysdba and sysoper). Everything looked good but just to maintain my sanity, I went ahead
and recreated the password file on both servers. Everything looks good there but I'm still unable to connect as sys when the standby is not mounted.
I'm going to start everything from scratch. It's the only thing I can think of at this point just to make sure everything was done correctly.
- Copy password file from primary to standby .
- Restart the standby to make sure the new passwordfile read is taking place
- Compare the checksums on the passwordfile in the primary and the standby, for example by using the sum command as inhttps://mosemp.us.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=298986.1Doc ID 298986.1