Home » RDBMS Server » Server Administration » Listner Help...
Listner Help... [message #58669] Thu, 25 September 2003 06:46 Go to next message
SP
Messages: 15
Registered: February 2002
Junior Member
Hi Guys,

I have two Oracle homes 9i(9.2.0.1.0) and 8i(8.1.7) running on Solaris server. I want all my 8i DBs to go thr' 9i Listener.
Problem is,this listener stops many times on its own.

Can u guys guide as to what can be the reason and anything i should be doing to avoid this?

Below is the error I always get and also included below is the Listener.ora file of 9i home.
----------------------------------------------------
>lsnrctl status
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 23-SEP-2003 12:36:49
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=capa.kobde.xxx.com)(PORT
=1521))) TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener Solaris Error: 146: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener
Solaris Error: 146: Connection refused
---------------------------------------------------
# LISTENER.ORA Network Configuration File: /dba2/app/oracle/product/9.2.0.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = capa.kobde.xxx.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /dba2/app/oracle/product/9.2.0.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = cpsdw.kobde.xxx.com)
(ORACLE_HOME = /dba2/app/oracle/product/9.2.0.1.0)
(SID_NAME = cpsdw)
)
(SID_DESC =
(GLOBAL_DBNAME = informer.capa.kobde.xxx.com)
(ORACLE_HOME = /dba1/app/oracle/product/8.1.7)
(SID_NAME = informer)
)
(SID_DESC =
(GLOBAL_DBNAME = metadata.capa.kobde.xxx.com)
(ORACLE_HOME = /dba1/app/oracle/product/8.1.7)
(SID_NAME = metadata)
)
(SID_DESC =
(GLOBAL_DBNAME = staging.capa.kobde.xxx.com)
(ORACLE_HOME = /dba1/app/oracle/product/8.1.7)
(SID_NAME = staging)
)
(SID_DESC =
(GLOBAL_DBNAME = cpsstag.capa.kobde.xxx.com)
(ORACLE_HOME = /dba1/app/oracle/product/8.1.7)
(SID_NAME = cpsstag)
)
)
Re: Listner Help... [message #58671 is a reply to message #58669] Thu, 25 September 2003 07:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
where u able to start the listener?
are u using TNS_ADMIN?
Enable tracing for more information.

May be, there is too much of load in the same port.
so edit the listener.ora in 9i home to seperate 9i and 8i connections in seperate ports...ie listen in seperate ports.
so that you can have a 
lsnr_9i listening in 1521 and
lsnr_8i listening in 1526

Re: Listner Help... [message #58676 is a reply to message #58671] Thu, 25 September 2003 07:58 Go to previous messageGo to next message
SP
Messages: 15
Registered: February 2002
Junior Member
Hi Mahesh,
where u able to start the listener?
- I did not get this question.

are u using TNS_ADMIN?
-If u r refering to TNS_ADMIN env variable then i have set it as below:
TNS_ADMIN=/dba2/app/oracle/product/9.2.0.1.0/network/admin.

Enable tracing for more information.
How to do that?
May be, there is too much of load in the same port.so edit the listener.ora in 9i home to seperate 9i and 8i connections in seperate ports...ie listen in seperate ports.so that you can have a lsnr_9i listening in 1521 andlsnr_8i listening in 1526

- when you say have two ports for 8i and 9i. Can i define the two ports in the same listener.ora file or you mean i should run both the 9i and 8i listeners at the same time on diff. ports.

Can give same example of such case and i will try doing the same.

Regards,
SP
Re: Listner Help... [message #58679 is a reply to message #58676] Thu, 25 September 2003 08:24 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. lsnrctl start -- starts the lisnter.
   where u able to do this?
   then check the status
   lsnrctl status
2.
quoting oracle docs

[b]Setting Trace Parameters Using Component Configuration Files[/b]

To set tracing parameters using component configuration files: 

Specify the following parameters in the component configuration file (SQLNET.ORA, LISTENER.ORA, NAMES.ORA, or CMAN.ORA): 
TRACE_LEVEL_component name=(OFF/USER/ADMIN/SUPPORT)
TRACE_DIRECTORY_component name=directory name

If you modified the configuration files while the component was running, start or restart the component to enable the changed parameters. 

[b]Setting Trace Parameters Using Component Control Utilities[/b]

To set trace parameters using component control utilities: 

For the listener, use the TRACE command from the Listener Control Utility, to set the trace level while the listener is running; 
For Oracle Names, use the SET TRACE_LEVEL command from the Names Server Control Utility, to set the trace level while the Names Server is running. Note: 

For Oracle Connection Manager, the trace level can only be set from the configuration file, CMAN.ORA  
 
 
[b]Using the Trace Assistant to Examine Your Trace Files[/b]

Net8 provides a tool called the Trace Assistant to help you understand the information provided in your trace files by converting existing lines of trace file text into a more readable paragraph. Note that the Trace Assistant runs against only a level 16 (SUPPORT) SQL*Net or Net8 trace file. 

To run the Trace Assistant, type the following at any command line prompt: 

trcasst [[options]] filename

3. example for a listener.ora

### assume all these entries are in a single listner.ora in $ORACLE9I_HOME/network/admin
# 8i Listener Service

LSNR_8i =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx )(PORT = 1526))
      )
    )
  )

# 9i Listener Service

LSNR_9i =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx )(PORT = 1521))
      )
    )
  )

# intances registered to lsnr_9i
SID_LIST_LSNR_9i =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
      (SID_NAME = 9idb1)
    )
    (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
      (SID_NAME = 9idb2)
    )
    (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
      (SID_NAME = 9idb3)
    )
  )

#instances registered to lsnr_8i

SID_LIST_LSNR_8i =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
      (SID_NAME = 8idb1)
    )
    (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
      (SID_NAME = 8idb2)
    )
  )

# usage for lsnrctl
#		now 
#		lsnrctl start LSNR_9i -- will start listener LSNR_9i in 1521 and listens for 9i database requests		
#		lsnrctl start LSNR_8i -- will start listener LSNR_8i in 1526 and listens for 8i database requests		
# similarly
#		lsnrctl stop LSNR_9i
#		lsnrctl stop LSNR_8i
#		lsnrctl status 	LSNR_9i
#		lsnrctl status 	LSNR_8i

Previous Topic: Which Database Mgt Tool To Buy ?
Next Topic: record created date
Goto Forum:
  


Current Time: Fri Sep 20 08:27:49 CDT 2024