Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Ask DBA › Question Id: 3572 | Permalink

password file for standby and primary

Question ID: 3572
Created By: 2009-FEB-25 14:53:53 [Davikm15]
Updated By: 2009-FEB-26 07:40:06 [Davikm15]
Status: Open
Severity: Normal
Read Only: No
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: 289
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.