Skip to Content
0
Former Member
Mar 04, 2011 at 06:14 AM

ORA-12541: TNS:no listener

1048 Views

Dear All,

I installed Oracle Software(10.2.0.1.0) and when i try to login with administrator user and run

SQLPLUS "/@SID as sysdba" then getting following error.

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 3 16:39:23 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12541: TNS:no listener

Enter user-name:

FYI...

1. There is only one file sqlnet.ora in Directory:\oracle\SID\Ora_Ver\NETWORK\ADMIN and consist following txt.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

2. the Net Manager --> Oracle Net Configuration --> Service Naming is blank mean there is nothing under it.

3. the OracleSID102iSQLPlus* service is running now

would anyone guide me about this error and how can i successful login.

Regards,

Diya