password file for standby and primary
|
10031
2009-FEB-25 14:53:53
|
|
User
|
|
|
Registered On: Feb 2009
Total Posts: 2
|
|
Hi my question is simple but I having problems with the password file. Should
the file name of the password file be the same on both the standy and primary?
I have verified that the sys passwords are the same for both DB's. My error is
below: Thanks for the help.
Wed Feb 25 14:39:00 2009
Errors in file /Panera/Production/Apps11i/10.2.0/admin/ENT02_dbdev/bdump/ent02_arcl_23940.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARCl]: Heartbeat failed to connect to standby 'ENT02DG'. Error is 16191.
Wed Feb 25 14:44:00 2009
Errors in file /Panera/Production/Apps11i/10.2.0/admin/ENT02_dbdev/bdump/ent02_arcl_23940.trc:
ORA-01017: invalid username/password; logon denied
Wed Feb 25 14:44:00 2009
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
|
10036
2009-FEB-25 17:01:39
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 267
|
|
It's funny because when I went to check on my test standby / primary I had exact
same issue! (My test standby database was down for over 6 months ...)
## on ZEPHIR (PRIMARY) I got the following error:
##
Wed Feb 25 14:26:20 2009
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
## from the 10gr2_arc0_27565.trc trace file (on PRIMARY)
##
Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'rightcube'
Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'rightcube'
*** 2009-02-25 14:36:21.311 61287 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'rightcube'. Error is 16191.
*** 2009-02-25 14:36:21.311 59530 kcrr.c
kcrrfail: dest:2 err:16191 force:0 blast:1
*** 2009-02-25 14:41:21.398
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
*** 2009-02-25 14:41:21.470 61287 kcrr.c
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'rightcube'
Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'rightcube'
*** 2009-02-25 14:41:21.470 61287 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'rightcube'. Error is 16191.
*** 2009-02-25 14:41:21.470 59530 kcrr.c
kcrrfail: dest:2 err:16191 force:0 blast:1
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> !hostname
atlas
SQL>
SQL> !hostname;ls -l $ORACLE_HOME/dbs/orapw*
atlas
-rw-r----- 1 oracle dba 1536 Oct 1 2007 /u01/app/oracle/product/10.2.0/db_1/dbs/orapw10GR2
SQL> !hostname;ls -l $ORACLE_HOME/dbs/orapw*
zephir
-rw-r----- 1 oracle dba 1536 Jan 31 11:38 /u01/app/oracle/product/10.2.0/db_1/dbs/orapw10GR2
SQL>
##
## SOLUTION:
##
## copy password file from primary to standby
##
zephir.10GR2-> cd /u01/app/oracle/product/10.2.0/db_1/dbs/
zephir.10GR2-> rdist -c orapw10GR2 oracle@atlas:/u01/app/oracle/product/10.2.0/db_1/dbs/orapw10GR2
updating host atlas
updating: orapw10GR2
zephir.10GR2->
## bounce standby db
##
SQL> connect / as sysdba
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2029880 bytes
Variable Size 230688456 bytes
Database Buffers 92274688 bytes
Redo Buffers 2162688 bytes
Database mounted.
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
atlas.10GR2->
|
10040
2009-FEB-26 07:40:06
|
|
User
|
|
|
Registered On: Feb 2009
Total Posts: 2
|
|
Thanks for the help - it is working now.