| Need help reading listener.log [message #535188] |
Mon, 12 December 2011 13:52  |
 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
