Dear All
Oracle version:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
OS: RHEL 5.8 64 bit
RAM: 70G
SGA: 21G
In my new environment, I can see that listener.log is not all generated after 6th July 2014 and the below was the last entry in listener.log
06-JUL-2014 21:22:26 * (CONNECT_DATA=(SID=twasl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.37)(PORT=57341)) * establish * twasl * 0
listener.ora
-----------------------
[oracle@antaresdb64 ~]$ cat /u01/app/oracle/product/10.2.1/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.1/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_test =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SID)
(ORACLE_HOME = /u01/app/oracle/product/10.2.1/db_1)
(SID_NAME = SID)
)
)
# INSERT BELOW LINE "SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF"
INBOUND_CONNECT_TIMEOUT_test=240
SUBSCRIBE_FOR_NODE_DOWN_EVENT_test=OFF
test =
(DESCRIPTION =
#(ADDRESS = (PROTOCOL = IPC)(KEY=extproc)) added
(ADDRESS = (PROTOCOL = IPC)(KEY=extproc))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = not the default one 1521))
)
LSNRCTL> show log_status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=extproc)))
test parameter "log_status" set to ON
The command completed successfully
Please help me in solving this issue.
Thanks & Regards
Rijo