Home » Developer & Programmer » Forms » ORA-12154
ORA-12154 [message #80867] Mon, 09 December 2002 20:11 Go to next message
Ben Parker
Messages: 9
Registered: December 2002
Junior Member
I've installed Oracle 8i and Developer Forms & Reports
6i on the same machine (under Windows 98).
I am getting the message ORA-12154: 'TNS could not resolve service name' when I try to connect to the
database using Forms Builder; oddly I'm able to connect
when I run SQLPLUS from the applications menu. I'm
using the forms for a tutorial and have no need for a
remote connection.

Apparently I must configure the tnsnames.ora file somehow but am unsure how to proceed. Any suggestions?
Re: ORA-12154 [message #80909 is a reply to message #80867] Fri, 13 December 2002 07:00 Go to previous message
Malcolm
Messages: 6
Registered: March 2002
Junior Member
When you installed both Oracle and Developer - did you creat 2 oracle homes on your machine?

if so - you will need your TNSNAMES.ORA file in both network/admin (or net80/admin) directories....

- SQL*Plus will work as you have the tnsnames file in the Oracle 8 home - but not in the Developer 6 home...

- Find the tnsnames.ora file in the oracle 8 home directory and then copy this to the eqivalent directory in the Developer home.

- i home some of this makes sense!!

- You may also need to install the correct protocol adaptor for your system - but i'm having trouble running oracle installer and can't find the details for this solution at the moment....
Previous Topic: Forms 6.0 crash and generate dump file
Next Topic: Developer6i
Goto Forum:
  


Current Time: Thu Mar 28 16:32:51 CDT 2024