| ORA-12203: TNS:unable to connect to destination [message #138541] |
Thu, 22 September 2005 07:59  |
tall_gs
Messages: 6
Registered: July 2005
|
Junior Member |
|
|
Hi,
I am a silent reader of this forum.
I installed Oracle 9i and Oracle Developer - Forms 6i successfully in my personal Laptop(Win XP). I configured TNSNAMES.ORA file in "C:\oracle\ora92\network\admin" folder for SQL Plus and "C:\oracle\ora\NET80\ADMIN" folder for Forms. I was able to run Forms and SQL Plus successfully.
Today I installed Netscape Internet service. After this installation i am not able to connect neither to Forms nor to SQL Plus. I am getting the errors "ORA-12517: TNS:Packet writer failure" and "ORA-12203: TNS:unable to connect to destination". Also, with SQL Plus, without giving connection string, I'm able to connect with scott/tiger.
If i uninstall Netscape, I'm able to connect to both.
My questions are,
1. what Netscape has to do with Oracle DB?
2. How I'm able to connect to SQL Plus without giving connection string? Which connection string SQL Plus is using by default?
3. What do I need to do to make Forms and SQL Plus work properly(without uninstalling Netscape) 
This is the configuration I made.
---------------------------------
DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = babu-t698gaaty6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB)
)
)
Kindly help..
Thanks in Advance!
|
|
|
|
| Re: ORA-12203: TNS:unable to connect to destination [message #138676 is a reply to message #138541] |
Fri, 23 September 2005 00:35  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
1) no idea
2) Search this forum (or google) for 'two_task', which is the Unix equal to windows 'default', for which you could also search. I don't remember where it is but it is the entry that controls the default Oracle session. Maybe Oracle.ini??
3) Search this forum for 'ifile' and use the technique to make the two tnsnames.ora files match. Having different databases for different applications is probably not a 'good' idea.
David
[Updated on: Mon, 26 September 2005 18:50] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
