Home » RDBMS Server » Server Administration » listener erorr
listener erorr [message #64197] Sat, 01 January 2005 23:01 Go to next message
ramya
Messages: 87
Registered: August 2002
Member
when i am adding one more address in listener address list it is failing with the following errors.the listener is up and running in that host(192.2.230.2
) .Tnsping zak2 is working fine it is pinging to both host(zakat2 and 192.9.230.2).I am implementing dataguard.At a time one db should be open another will be in recovery mode(standby).

tnsnames.ora
ZAK2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zakat2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.230.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZAK2.world)
)
)

Listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zakat2)(PORT = 1521) )
(ADDRESS= (PROTOCol= TCP)(HOST=192.9.230.0)(port=1521)) )
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oradatazak2/ora9i/920)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ZAK2.world)
(ORACLE_HOME = /oradatazak2/ora9i/920)
(SID_NAME = ZAK2)
)
)

TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
System parameter file is /oradatazak2/ora9i/920/network/admin/listener.ora
Log messages written to /oradatazak2/ora9i/920/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zakat2)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCol=TCP)(HOST=192.9.230.0)(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

with regards
ramya
Re: listener erorr [message #64206 is a reply to message #64197] Sun, 02 January 2005 22:34 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Looks like a typo in your listener.ora file. Try to change 192.9.230.0 to 192.9.230.2; or remove "(ADDRESS= (PROTOCol= TCP)(HOST=192.9.230.0)(port=1521))" (leave the last bracket).

Best regards.

Frank
Previous Topic: Who should own Xserver on Oracle box?
Next Topic: ora -27146 ;post/wait initialization failed error
Goto Forum:
  


Current Time: Fri Mar 29 06:16:22 CDT 2024