Saturday, June 18, 2011

TNS-12545-12560-00515, Solaris Error : 126: Cannot assign requested address

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:


Starting Database Listener  for and ACTIVE/PASSIVE cluster setup throw the following errors:


TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

Solaris Error: 126: Cannot assign requested address





Explanation:


We have active-passive 10g database under Sun Solaris 10 operating system cluster.

We tried to switch the database to work on the passive node.

when we tried to start the passive node, we got the following errors:
..................................................................
TNSLSNR for Solaris: Version 10.2.0.3.0 - Production

System parameter file is /oracle/aderp/10.2.0/network/admin/aderp_erp-lh/listener.ora

Log messages written to /oracle/aderp/10.2.0/network/admin/aderp.log

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erp-lh.auh.police)(PORT=1521)))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

Solaris Error: 126: Cannot assign requested address



Solution:


Active/Passive databases and listeners under operating system cluster setup should NOT be stopped or started manually, it should be throw the cluster.


    
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: