OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » tns no listner error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tns no listner error [message #188838]

Tue, 22 August 2006 00:51

sheharyararshad
Messages: 10
Registered: May 2006
Location: KUWAIT

Junior Member

hello
can any one plz help me out in one problem i have a database oracle 10g n windows xp platform ,i am trying to connect visual studio 2005 to oracle database through database wizard in visual studio 2005 while connecting it gives error in visual studio "ORA-12154:TNS:COULD NOT RESOLVE SERVICE NAME" .listner is started already.name of the database is "orcl".computer name is "shary".
configuration of listner file is

# listener.ora Network Configuration File: H:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = H:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)

plz can nay one sort it out this problem i will be very thankfull.
take care
shary

Report message to a moderator

Re: tns no listner error [message #188845 is a reply to message #188838]

Tue, 22 August 2006 01:57

chinni_00
Messages: 30
Registered: October 2005

Member

Hi,

It would be better if you post your tnsnames.ora Contents also so that we can check Service Name from that

Regards
Prem

Report message to a moderator

Re: tns no listner error [message #189481 is a reply to message #188845]

Thu, 24 August 2006 15:14

sheharyararshad
Messages: 10
Registered: May 2006
Location: KUWAIT

Junior Member

hello
once again yes oracle database 10g is installed on oracle folder and developer is installed on developer folder separately but on the same drive.when i try to connect developer with database it gives error "TNS NO LSTNER UNABLE TO RESOLVE SERIVICE NAME".
so can u plz tell me the solution what can i do now in order to connect developer with database coz its giving me "TNS NO LSTNER UNABLE TO RESOLVE SERIVICE NAME".
plz tell me the complete procedure to solve the problem.
plz do the need full
take care bye
shary

Report message to a moderator

Re: tns no listner error [message #190515 is a reply to message #189481]

Thu, 31 August 2006 02:45

aorehek
Messages: 52
Registered: August 2006

Member

Post your TNSNAMES.ORA and SQLNET.ORA file. They are in $ORACLE_HOME$/network/admin directory.

Report message to a moderator

Previous Topic:	TNS:listener could not hand off client connection
Next Topic:	naming methods

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 20:20:19 CST 2024