Standby Database log not transporting to standby location
Follow up by mail Click here


Subject: Standby Database log not transporting to standby location
Author: Umesh Sharma, India
Date: Nov 12, 2008, 14:35, 3538 days ago
Os info: sun 5.10
Oracle info: oracle 10.2.0
Error info: *** 2008-11-12 18:51:28.785 60679 kcrr.c
Error 12514 received logging on to the standby
Error 12514 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'OMSSTD'
Error 12514 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'OMSSTD'
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
*** 2008-11-12 18:51:28.785 60679 kcrr.c
PING[ARC0]: Heartbeat failed to connect to
Message: Log is not geting transported to Stand by database
***************
similar thread is there but for 10.1.0

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=11619
************************
-bash-3.00$ cat /product/data/admin/OMS/bdump/oms_arc0_8262.trc | more
/product/data/admin/OMS/bdump/oms_arc0_8262.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/oracle/product/10.2.0/db_1
System name: SunOS
Node name: Earth
Release: 5.10
Version: Generic_120012-14
Machine: i86pc
Instance name: OMS
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 8262, image: oracle@Earth (ARC0)

*** SERVICE NAME:() 2008-11-12 18:50:29.251
*** SESSION ID:(41.1) 2008-11-12 18:50:29.251
kcrrwkx: nothing to do (start)
*** 2008-11-12 18:51:28.781
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12514 and errmsg is 'ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
'
*** 2008-11-12 18:51:28.785 60679 kcrr.c
Error 12514 received logging on to the standby
Error 12514 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'OMSSTD'
Error 12514 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'OMSSTD'
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
*** 2008-11-12 18:51:28.785 60679 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'OMSSTD'. Error is 12514.
*** 2008-11-12 18:51:28.785 58941 kcrr.c
kcrrfail: dest:2 err:12514 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:52:28.911
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:53:28.921
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:54:28.931
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:54:42.966
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:55:28.941
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:56:28.950
tkcrrxmp: Stopping ARC2 to reduce ARCH processes from 3 to 2
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
*** 2008-11-12 18:56:34.085 60679 kcrr.c
Error 1031 received logging on to the standby
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'OMSSTD'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'OMSSTD'
ORA-01031: insufficient privileges
*** 2008-11-12 18:56:34.086 60679 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'OMSSTD'. Error is 1031.
*** 2008-11-12 18:56:34.086 58941 kcrr.c
kcrrfail: dest:2 err:1031 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:56:50.479
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:57:34.208
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:58:34.215
kcrrwkx: nothing to do (end)
*** 2008-11-12 18:59:34.225
kcrrwkx: nothing to do (end)
*** 2008-11-12 19:00:18.875
kcrrwkx: nothing to do (end)
*** 2008-11-12 19:00:34.235
kcrrwkx: nothing to do (end)
*** 2008-11-12 19:01:34.245
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
*** 2008-11-12 19:01:34.304 60679 kcrr.c
Error 1031 received logging on to the standby
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'OMSSTD'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'OMSSTD'
ORA-01031: insufficient privileges
*** 2008-11-12 19:01:34.304 60679 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'OMSSTD'. Error is 1031.
*** 2008-11-12 19:01:34.304 58941 kcrr.c
kcrrfail: dest:2 err:1031 force:0 blast:1
kcrrwkx: nothing to do (end)
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Standby Database log not transporting to standby location
Author: Demetrios Gogos, Greece
Date: Nov 12, 2008, 14:56, 3538 days ago
Message: Hi

has the listener be set correctly at the destination?
Are you able to connect to the at the destination?

Regards

Dimitrios
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Standby Database log not transporting to standby location
Author: Yousef Rifai, United Kingdom
Date: Nov 12, 2008, 14:59, 3538 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,
Recreate the password file on the standby database to have the same sys password as the primary database.

Regards
Yousef Rifai
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Standby Database log not transporting to standby location
Author: Umesh Sharma, India
Date: Nov 14, 2008, 06:21, 3536 days ago
Message: yes password file was the Reason of error.
Database Name Was in Caps Where as PWd file was in Small.
Now the Issue is resolved.
Tnhx
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here