Home » RDBMS Server » Networking and Gateways » Need help reading listener.log (linux red hat Oracle 10.2.0.4)
Need help reading listener.log [message #535188] Mon, 12 December 2011 13:52 Go to next message
n2fontenay
Messages: 15
Registered: December 2011
Location: San Diego, CA
Junior Member
Good morning,

This is in a data guard environment.

This is my /etc/hosts (on vcas2)
192.168.4.41 vcas1
192.168.4.42 vcas2

The problem is on vcas2 where I can't get the service standby to work (as described in listener.ora).

The strange part is: In listener.log, why do I have a connection trying to be made on 192.168.4.41 (primary) with service_name 'standby' and why would that be in the listener.log?

So, how can I find out where this is coming from ?

this is my listener.ora on vcas2:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME=vcas)
(GLOBAL_DBNAME=standby_DGMGRL)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
)
(SID_DESC =
(SID_NAME=vcas)
(SERVICE=STANDBY)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = VCAS2)(PORT = 1521))
)
)

LSNRCTL> services (on vcas2)
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "standby_DGMGRL" has 1 instance(s).
Instance "vcas", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "vcas" has 1 instance(s).
Instance "vcas", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully

--> No service 'standby' from lsnrctl services

This is listener.log:
[oracle@VCAS2 admin]$ tail ../log/listener.log
12-DEC-2011 14:43:42 * (CONNECT_DATA=(SERVICE_NAME=standby)(CID=(PROGRAM=oracle)(HOST=VCAS1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.41)(PORT=30547)) * establish * standby * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
12-DEC-2011 14:44:42 * (CONNECT_DATA=(SERVICE_NAME=standby_DGB)(SERVER=dedicated)(CID=(PROGRAM=oracle)(HOST=VCAS1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.41)(PORT=30554)) * establish * standby_DGB * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
12-DEC-2011 14:44:42 * (CONNECT_DATA=(SERVICE_NAME=standby)(CID=(PROGRAM=oracle)(HOST=VCAS1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.41)(PORT=30555)) * establish * standby * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
12-DEC-2011 14:44:42 * (CONNECT_DATA=(SERVICE_NAME=standby_XPT)(SERVER=dedicated)(CID=(PROGRAM=oracle)(HOST=VCAS1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.41)(PORT=30556)) * establish * standby_XPT * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
12-DEC-2011 14:44:42 * (CONNECT_DATA=(SERVICE_NAME=standby)(CID=(PROGRAM=oracle)(HOST=VCAS1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.41)(PORT=30557)) * establish * standby * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Re: Need help reading listener.log [message #535267 is a reply to message #535188] Tue, 13 December 2011 05:39 Go to previous message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

Hi,

This error might be because of the log_archive_dest_2 value in standby .
It is trying to connecting using the tnsnames configured in that destination.

Try disabling the log_archive_dest_state_2.
Previous Topic: Changing standard port
Next Topic: Listener Utility error
Goto Forum:
  


Current Time: Mon Jun 21 20:48:22 CDT 2021