11g logical standby database creation

In 10g, you manually create the password file.
In 11g, you have to copy password from primary. Otherwise, the following error will be reported:

*** 2010-07-08 14:46:17.196 4132 krsh.c
Error 1031 received logging on to the standby
*** 2010-07-08 14:46:17.196 869 krsu.c
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'xxx'
ORA-01031: insufficient privileges
*** 2010-07-08 14:46:17.197 4132 krsh.c
Error 1031 for archive log file 1 to 'xxxx'
*** 2010-07-08 14:46:17.197 2747 krsi.c
krsi_dst_fail: dest:2 err:1031 force:0 blast:1
ORA-01031: insufficient privileges
Destination is specified with ASYNC=61440

You also need to change the name of the password file.

So the command will be:

scp oracle@primary:/usr/orahome/dbs/orapwPrimarySid /usr/orahome/dbs/orapwStandbySid

The database do not need to be restarted.

Hongfeng Sun : 08 Jul 2010 15:11 |  Tags: Oracle-Availability |  Comments (0) |  Report a problem