asked on

listener and tnsping

Hi
I am able to connect my databse using sql*plus, but if I use tnsping command getting an error that no listener. I am wondering that how could be it possible ? because without listener how it could be connected to the database using SQL*Plus?

Any help would be appreciated.

Thanks in advance.

paquicuba

Try the following command
lsnrctl start <SID>

ASKER CERTIFIED SOLUTION

paquicuba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Smruti1

ASKER

Thanks paquicuba and schwertner for quick reponse.

I issued this command and received this message--->

LSNRCTL> start orcl
Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
System parameter file is C:\oracle\product\10.1.0\Db_2\network\admin\listener.or
a
Log messages written to C:\oracle\product\10.1.0\Db_2\network\log\orcl.log
TNS-01151: Missing listener name, orcl, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

and yes I connected to the DB from the same computer.

Thanks in advance

paquicuba

>> Missing listener name

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = PROD.REGRESS.RDBMS.DEV.US.ORACLE.COM)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = PROD) ---<<------------ Check your SID

SOLUTION

rbrooker

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ritesh_Garg

You are able to connect to Oracle installed on your system due to tcp-loopback entry in your tnsnames.ora in which case listener is not required.

schwertner

There are two steps you have to do.

1. Check for firewalls and turn of if any. Especially if you are on Windows XP SP2
that has default firewall

2. Please investigate this:
For STATIC registration of the Oracle service to the Listener:

Go to the remote 10g installation.
In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Ora10g)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
)

Add the entry
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

Computer101

Forced accept.

Computer101
EE Admin