Home » RDBMS Server » Networking and Gateways » ORA-12541 TNS Does not currently know of service..... (oracle 10g developer suit 10g window 2003 server)
ORA-12541 TNS Does not currently know of service..... [message #400635] Wed, 29 April 2009 03:06 Go to next message
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
Re: ORA-12541 TNS Does not currently know of service..... [message #400650 is a reply to message #400635] Wed, 29 April 2009 03:58 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?
Re: ORA-12541 TNS Does not currently know of service..... [message #400691 is a reply to message #400635] Wed, 29 April 2009 05:16 Go to previous messageGo to next message
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>







Re: ORA-12541 TNS Does not currently know of service..... [message #400694 is a reply to message #400635] Wed, 29 April 2009 05:25 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is the orcl database actually running at the moment?
Re: ORA-12541 TNS Does not currently know of service..... [message #400699 is a reply to message #400635] Wed, 29 April 2009 05:38 Go to previous messageGo to next message
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





Re: ORA-12541 TNS Does not currently know of service..... [message #400700 is a reply to message #400699] Wed, 29 April 2009 05:40 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Post TNSNAMES.ORA

Re: ORA-12541 TNS Does not currently know of service..... [message #400719 is a reply to message #400635] Wed, 29 April 2009 06:26 Go to previous messageGo to next message
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


Re: ORA-12541 TNS Does not currently know of service..... [message #400725 is a reply to message #400719] Wed, 29 April 2009 06:41 Go to previous messageGo to next message
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

Re: ORA-12541 TNS Does not currently know of service..... [message #400728 is a reply to message #400635] Wed, 29 April 2009 06:48 Go to previous messageGo to next message
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
Re: ORA-12541 TNS Does not currently know of service..... [message #400732 is a reply to message #400728] Wed, 29 April 2009 06:59 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


What you tried. COPY/PASTE from your session.

Babu
Re: ORA-12541 TNS Does not currently know of service..... [message #400744 is a reply to message #400635] Wed, 29 April 2009 07:18 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
I Don't understand your point of view Babu


Shahzaib
Re: ORA-12541 TNS Does not currently know of service..... [message #400826 is a reply to message #400744] Wed, 29 April 2009 14:53 Go to previous messageGo to next message
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
Re: ORA-12541 TNS Does not currently know of service..... [message #407433 is a reply to message #400635] Wed, 10 June 2009 03:09 Go to previous message
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
Previous Topic: SERVICE_NAME confusion
Next Topic: filter for listener
Goto Forum:
  


Current Time: Fri Mar 29 00:15:40 CDT 2024