Home » Developer & Programmer » Forms » ORA-12203: Unable to connect to destination
ORA-12203: Unable to connect to destination [message #129268] Fri, 22 July 2005 23:28 Go to next message
bluebeta
Messages: 14
Registered: June 2005
Junior Member
Hi,

I have installed Oracle 9i database Personal edition and Oracle form 6i in same computer. But when i want to connect from the oracle form to database, it give me this error: ORA-12203: Unable to connect to destination.

The listener services is running. the database services is also running. I even configure the TNS_ADMIN and ORACLE_SID in window registry and also the environment variable.

The database is running properly. I have test method as below:

tnsping test01
the response is OK

sqlplus
sqlplus /nolog
SQL> connect hr/hr@test01
Connected.

Please tell me what should I do to solve this problem? I already stucked on this problem for 2 days. Please help.

Thanks in advance for any reply.


Best Regards,
Andrene

Report message to a moderator

Re: ORA-12203: Unable to connect to destination [message #129360 is a reply to message #129268] Sun, 24 July 2005 19:10 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Your Oracle is in two homes. They need to have the comparible information in both TNSNAMES.ORA files. Search this forum for 'tnsnames' and 'ifile' (this is an intelligent solution).

David

Report message to a moderator

Previous Topic: Forms MDI window in 9i
Next Topic: Creating alert in forms 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:47:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.