-
Oracle 8.1.6, Sun/Solaris (2.6)
I want to connect to the database from Client machine and I need to findout whether Listner process is running or not on Database server. If it is not running then How to Start it.
-
If you log in as Oracle and type
lsnrctl
this is the program that controls everything. To find out if it is running, type
services
If nothing is running, type
start
If it doesn't start anything, you will have to edit the file
listener.ora
Best of luck.
-
When I do lsnrctl and then type the services, I got the following errors
LSNRCTL> services
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
TNS-01103: Protocol specific component of the address is incorrectly specified
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 2: No such file or directory
My listener.ora looks like
trace_level_listener=admin
trace_directory_listener=/oracle/u01/admin/sqlnet
listener=
(ADDRESS= (PROTOCOL=TCP)(HOST=1xx.xx.xx.xx)(PORT=1521))
sid_list_listener=(SID_LIST=
(SID_DESC=(SID_NAME=test)
(ORACLE_HOME=/oracle/u01/8.1.6)
(ORACLE_SID=test)))
-
How to Start TNS & Listner Process
Try:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1xx.xx.xx.xx)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = /oracle/u01/8.1.6)
)
)
-
Did you try starting the listener
lsnrctl start
then try doing
lsnrctl services
# LISTENER.ORA Configuration File:/oracle/u01/8.1.6/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host_name)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/u01/8.1.6)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /oracle/u01/8.1.6)
(SID_NAME = test)
)
)
trace_level_listener=admin
trace_directory_listener=/oracle/u01/admin/sqlnet
Try the above piece of code.
Sam
-
You are Great Guys.
Lot of Thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|