Home » RDBMS Server » Server Administration » listener log (11.2.0.2.0 HP-AUX 64 BIT)
listener log [message #559185] Fri, 29 June 2012 09:33 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi Expert,

To one of my server i can see listener log are on normal location i.e. $ORACLE_HOME/network/log and on other server listener log is DIAG home. So please help in understanding how to move listener log from ORACLE_HOME to DIAG_HOME.

oracle > lsnrctl status LISTENER

LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 29-JUN-2012 10:20:14

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for HPUX: Version 11.2.0.2.0 - Production
Start Date                03-MAY-2012 08:09:57
Uptime                    57 days 0 hr. 10 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/samphine/product/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/samphine/product/11.2.0/grid/log/diag/tnslsnr/thunder/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.191.118.24)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "samphine" has 1 instance(s).
  Instance "samphine", status READY, has 1 handler(s) for this service...
Service "samphineXDB" has 1 instance(s).
  Instance "samphine", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle > 

Other server:

oracle>lsnrctl status LISTENER

LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 29-JUN-2012 10:24:55

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=192.186.11.122)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for HPUX: Version 11.2.0.2.0 - Production
Start Date                09-APR-2012 10:21:19
Uptime                    81 days 0 hr. 3 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File         /opt/oracle/product/11.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.186.11.122)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Services Summary...
Service "samphine" has 1 instance(s).
  Instance "samphine", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle>
Re: listener log [message #559186 is a reply to message #559185] Fri, 29 June 2012 09:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>/opt/oracle/product/11.2.0/network/admin/listener.ora

post content of file above from correct system (HOST=192.186.11.122)
Re: listener log [message #559187 is a reply to message #559186] Fri, 29 June 2012 09:39 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

oracle>cat /opt/oracle/product/11.2.0/network/admin/listener.ora
listener =
  (ADDRESS_LIST=
       (ADDRESS=(PROTOCOL=tcp)(HOST=192.186.11.122)(PORT=1521))
       (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

SID_LIST_listener=
   (SID_LIST=
       (SID_DESC=
          (SERVICE_NAME = samphine)
          (SID_NAME=samphine)
          (ORACLE_HOME=/opt/oracle/product/11.2.0)
#         (PROGRAM=extproc)
        )
       )
Re: listener log [message #559188 is a reply to message #559187] Fri, 29 June 2012 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I suspect that posted response it NOT really the whole file

http://docs.oracle.com/cd/B28359_01/network.111/b28317/listener.htm#BGBJEHGC
Re: listener log [message #559190 is a reply to message #559188] Fri, 29 June 2012 09:47 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

I apologize yes, below lines are missed.

#CONNECT_TIMEOUT_LISTENER = 0
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
INBOUND_CONNECT_TIMEOUT__LISTENER=115
DIAG_ADR_ENABLED_LISTENER = OFF
samphine:/home/oracle

[Updated on: Fri, 29 June 2012 12:40] by Moderator

Report message to a moderator

Re: listener log [message #559191 is a reply to message #559190] Fri, 29 June 2012 09:55 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
if you are still confused, then ask the local senior DBA
Previous Topic: enabling PK on a big table
Next Topic: High water mark
Goto Forum:
  


Current Time: Fri Mar 29 10:08:19 CDT 2024