Home » RDBMS Server » Networking and Gateways » ORA 12203:TNS:unable to connect to destination
ORA 12203:TNS:unable to connect to destination [message #192301] Mon, 11 September 2006 13:54 Go to next message
atul1981
Messages: 2
Registered: September 2006
Location: Vadodara
Junior Member
Plz help me out ....i copied the tnsnames.ora file from oracle 6i admin folder and paste it in oracle admin folder 9i....but despite i m going through the same problem ....plz help me out its urgent for me ....
Re: ORA 12203:TNS:unable to connect to destination [message #193436 is a reply to message #192301] Sat, 16 September 2006 15:02 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Can You ping the server etc.?
Re: ORA 12203:TNS:unable to connect to destination [message #194358 is a reply to message #192301] Thu, 21 September 2006 11:55 Go to previous message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

You can add this one to tnsnames.ora file :

<String name> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Hostname or IP>)(PORT = 1521))
)
(CONNECT_DATA =
(SID = <oracle-SID>)
(SERVER = DEDICATED)
)
)

Directly add in oracle 9i tnsnames.ora. after that connect to sql prompt.

Thanks,

Mohan Reddy

Previous Topic: Urgent: Transparent Gateway 2 MSSQL
Next Topic: Cold backup scripts
Goto Forum:
  


Current Time: Sun Dec 08 18:05:01 CST 2024