ORA-01017: invalid username/password; logon denied
Hi Sir,
I am trying standby setup on single windows machine(both primary and standby on same machine).
I am getting below issue, trace file content from primary database(Orange)
** 2011-05-28 12:29:14.359
*** SESSION ID:(135.3) 2011-05-28 12:29:14.359
*** CLIENT ID:() 2011-05-28 12:29:14.359
*** SERVICE NAME:() 2011-05-28 12:29:14.359
*** MODULE NAME:() 2011-05-28 12:29:14.359
*** ACTION NAME:() 2011-05-28 12:29:14.359
Redo shipping client performing standby login
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
ORA-01017: invalid username/password; logon denied
OCI_DBVER attribute value retrieval failed error=1017
*** 2011-05-28 12:29:14.500 4132 krsh.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
*** 2011-05-28 12:29:14.593 869 krsu.c
Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'MANGO'
Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'MANGO'
ORA-16191: Primary log shipping client not logged on standby
*** 2011-05-28 12:29:14.609 2747 krsi.c
krsi_dst_fail: dest:2 err:16191 force:0 blast:1
*** 2011-05-28 12:29:15.687
kcrrwkx: unknown error:16191
ORA-16055: FAL request rejected
and trace from standby database(Mango):
*** 2011-05-28 12:28:59.562
*** SESSION ID:(135.3) 2011-05-28 12:28:59.562
*** CLIENT ID:() 2011-05-28 12:28:59.562
*** SERVICE NAME:() 2011-05-28 12:28:59.562
*** MODULE NAME:() 2011-05-28 12:28:59.562
*** ACTION NAME:() 2011-05-28 12:28:59.562
Redo shipping client performing standby login
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
ORA-01017: invalid username/password; logon denied
OCI_DBVER attribute value retrieval failed error=1017
*** 2011-05-28 12:28:59.750 4132 krsh.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
*** 2011-05-28 12:28:59.859 4132 krsh.c
FAL[client, ARC1]: Error 16191 connecting to Mango for fetching gap sequence
ORA-16191: Primary log shipping client not logged on standby
ORA-16191: Primary log shipping client not logged on standby
I have created the password files and kept in oracle_home/database directory in either sides..
and *.remote_login_passwordfile='EXCLUSIVE' in both sides.
C:\app\Bhanu\product\11.2.0\dbhome_1\database>orapwd file=orapwmango password=test entries=5
C:\app\Bhanu\product\11.2.0\dbhome_1\database>orapwd FILE=orapworange password=test entries=5
Please help me how to solve this problem.