| ORA-12154 [message #80867] |
Mon, 09 December 2002 20:11  |
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  |
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....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
