OraFAQ Forum: Networking and Gateways » ORA-12541 TNS Does not currently know of service.....

Home » RDBMS Server » Networking and Gateways » ORA-12541 TNS Does not currently know of service..... (oracle 10g developer suit 10g window 2003 server)

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

ORA-12541 TNS Does not currently know of service..... [message #400635]

Wed, 29 April 2009 03:06

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Hellow all

When i write this

c:\sqlplus connect scott/tiger@orcl

its give me error

ORA-12541 TNS does not currently know of service requested in connect descriptor

but when i write this

c:\sqlplus connect scott/tiger

it will connect to database i thing that's why when i run my form its give me error

ORA-12560 TNS Protocol Adapter Failure

How can i solve this problem i ping my server through TNSPING

i write

c:\TNSPING SERVER

its give me

Quote:

TNS ping utility for 32-bit window: version 10.2.0.1.0 - production on 29-apr-2009 13:02:13

Copyright <c> 1997,2005, oracle. all rights reserved

Used parameter files:
E:\oracle\prduct\10.2.0\db_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact <DESCRIPTION=<CONNECT_DATE<SERVICE_NAME=server>><ADDRESS=
<PROTOCOL=TCP><HOSE=192.168.1.2><PORT=1521>>>
OK <20 msec>

Any suggestion

Shahzaib Ismail

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400650 is a reply to message #400635]

Wed, 29 April 2009 03:58

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

What does:

c:\TNSPING SERVER

have to do with:

c:\sqlplus connect scott/tiger@orcl

They would presumably be different databases.

What have you got in your tnsnames.ora for orcl?
What does:

c:\TNSPING orcl

give?

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400691 is a reply to message #400635]

Wed, 29 April 2009 05:16

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Thanks for your reply

When i write

c:\tnsping orcl

its give me

Quote:

TNS ping utility for 32-bit window: version 10.2.0.1.0 - production on 29-apr-2009 14:48:28

Copyright <c> 1997,2005, oracle. all rights reserved

Used parameter files:
E:\oracle\prduct\10.2.0\db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact <DESCRIPTION=<ADDRESS=
<PROTOCOL=TCP><HOSE=server><PORT=1522>><CONNECT_DATE =
<SERVER = DADICATED><SERVICE_NAME = orcl>>>
OK <10 msec>

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400694 is a reply to message #400635]

Wed, 29 April 2009 05:25

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

Is the orcl database actually running at the moment?

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400699 is a reply to message #400635]

Wed, 29 April 2009 05:38

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

How can i know that my ORCL is running or not

i can connect with

Scott/tiger and also with system/manager

I have only one Oracle_sid and thats is orcl

Thats all

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400700 is a reply to message #400699]

Wed, 29 April 2009 05:40

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Post TNSNAMES.ORA

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400719 is a reply to message #400635]

Wed, 29 April 2009 06:26

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1522))

Quote:

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

This is my TNSNAMES file

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400725 is a reply to message #400719]

Wed, 29 April 2009 06:41

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

1/ Check your Oracle releated services in windows. If it's stopped then start.

2/ Set your ORACLE_SID

3/ Try to connect

Babu

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400728 is a reply to message #400635]

Wed, 29 April 2009 06:48

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

I start my all oracle services but the problem still unsolved

i set my oracle_sid=orcl

but still same problem

Shahzaib

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400732 is a reply to message #400728]

Wed, 29 April 2009 06:59

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

What you tried. COPY/PASTE from your session.

Babu

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400744 is a reply to message #400635]

Wed, 29 April 2009 07:18

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

I Don't understand your point of view Babu

Shahzaib

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #400826 is a reply to message #400744]

Wed, 29 April 2009 14:53

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

What exactly your trying to connect database. Please copy/paste those information from your session.

babu

Report message to a moderator

Re: ORA-12541 TNS Does not currently know of service..... [message #407433 is a reply to message #400635]

Wed, 10 June 2009 03:09

nqtrung
Messages: 25
Registered: April 2007

Junior Member

You can using SID instead SERVICE_NAME in TNSNAMES.ORA
Or
You add GLOBAL_DBNAME=orcl in LISTENER.ORA

Good luck

Report message to a moderator

Previous Topic:	SERVICE_NAME confusion
Next Topic:	filter for listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 31 12:38:07 CST 2025