How to Start TNS & Listner Process

[Sharma]

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.

[m1l]

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.

[Sharma]

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)))

[mhaller]

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)
)
)

[sambavan]

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

[Sharma]

You are Great Guys.

Lot of Thanks,