Home » Developer & Programmer » Forms » ORA-12203 (Oracle Forms 4.5)
ORA-12203 [message #566609] Tue, 18 September 2012 00:46 Go to next message
RobinHound
Messages: 2
Registered: September 2012
Location: Philippines
Junior Member

Is there anyone here that can help me? I am having trouble connecting to oracle forms 4.5, I keep getting an "Ora-12203:TNS:unable to connect to destination" eror message. I am able to connect using sql plus or other similar application so there is no problem with my tnsnames.ora file.

What should I do?
Re: ORA-12203 [message #566611 is a reply to message #566609] Tue, 18 September 2012 00:53 Go to previous messageGo to next message
Littlefoot
Messages: 19347
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Note that every Oracle product contains its own TNSNAMES.ORA file. Therefore, if you entered database alias into TNSNAMES.ORA that is used by SQL*Plus, you should have done the same with the TNSNAMES.ORA which is used by Forms. Maybe you even did that, previously, but something has changed. In order to avoid similar problems, I'd suggest you to use TNS_ADMIN environment variable (have a look here).

Here's what Oracle says:
Oracle
ORA-12203: TNS:unable to connect to destination

Cause: Invalid address specified or destination is not listening. This error can also occur because of underlying network or network transport problems.

Action: Verify that the net service name you entered was correct. Verify that the ADDRESS portion of the connect descriptor which corresponds to the net service name is correct. Ensure that the destination process (for example the listener) is running at the remote node.


If that's not the issue, I guess you'll say so and we'll try to investigate further.
Re: ORA-12203 [message #566612 is a reply to message #566611] Tue, 18 September 2012 01:00 Go to previous messageGo to next message
RobinHound
Messages: 2
Registered: September 2012
Location: Philippines
Junior Member

there is no problem on that part, like i said i am able to connect to sqlplus and the tnsping. any other reason?
Re: ORA-12203 [message #566613 is a reply to message #566612] Tue, 18 September 2012 01:02 Go to previous messageGo to next message
Littlefoot
Messages: 19347
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you search your hard disk for TNSNAMES.ORA files, how many of them do you have?
Re: ORA-12203 [message #566667 is a reply to message #566612] Tue, 18 September 2012 08:22 Go to previous message
joy_division
Messages: 4490
Registered: February 2005
Location: East Coast USA
Senior Member
RobinHound wrote on Tue, 18 September 2012 02:00

there is no problem on that part, like i said i am able to connect to sqlplus and the tnsping. any other reason?


sqlplus and tnsping are using a different oracle_home, hence a different tnsnames.ora. Address what littlefoot is telling you.
Previous Topic: Want to display record on non database item
Next Topic: Create record above?
Goto Forum:
  


Current Time: Fri Aug 01 06:56:33 CDT 2014

Total time taken to generate the page: 0.27928 seconds