TNS No Listener ORA - 12541

[basirul]

Hello,

I have Window '98 and Oracle 9i Personal Edition in my machine. I was trying to add an User Data Source. When I was trying the "Test Connection" Option (using a valid TNS Service Name and User ID = Scott), it is showing the following error.

[Oracle][ODBC][Ora]ORA-12541:TNS:no listener

Can anyone help me regarding this issue ?

Regards
Basirul

 

[cliousa]

Make sure you have Oracle<SID>TNSListener service up and running in the Services. If not use the Net8 Assistant to create one.


Hope that helps,

clio_usa - OCP DBA
------------------

http://www.dbaclick.com

 

[basirul]

Hi clio_usa,

I am herewith posting my sqlnet.ora, listener.ora and tnsnames.ora file

sqlnet.ora (Location c:\oracle\ora90\network\ADMIN)
----------

NAMES.DEFAULT_DOMAIN = abc.com

listener.ora (Location c:\oracle\ora90\network\ADMIN)
------------

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = blank)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = SBISLAM)
(ORACLE_HOME = c:\oracle\ora90)
(SID_NAME = SBISLAM)
)
)

tnsnames.ora (Location c:\oracle\ora90\network\ADMIN)
------------

SBISLAM.ABC.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = blank)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SBISLAM)
)
)

EXTPROC_CONNECTION_DATA.ABC.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

INST1_HTTP.ABC.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = blank)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION =

http://HRService)

)
)

Can you please help me what I am missing ?

Thanks in advance
Basirul