| ORA 12203:TNS:unable to connect to destination [message #192301] |
Mon, 11 September 2006 13:54  |
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 #194358 is a reply to message #192301] |
Thu, 21 September 2006 11:55  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
