Listner Help... [message #58669] |
Thu, 25 September 2003 06:46 |
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 #58676 is a reply to message #58671] |
Thu, 25 September 2003 07:58 |
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 |
|
Mahesh Rajendran
Messages: 10708 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
|
|
|