| ORA-12154: TNS Cannot resolve service name [message #101119] |
Tue, 11 May 2004 00:24  |
Peter Datum
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
Oracle 9i and Forms 6i are installed on a Windows 98 SE standalone machine. The database has been created successfully. However, I cannot access the Forms Builder component. I have tried the many solutions from the Web but to no avail. Listed below are copies of my tnsnames.ora file and sqlnet.ora file.
# TNSNAMES.ORA Network Configuration File: c:oracleora90networkadmintnsnames.ora
# Generated by Oracle configuration tools.
# b13
INST1_HTTP.ITBS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = b13) (PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
LANG.ITBS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = b13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lang)
)
)
EXTPROC_CONNECTION_DATA.ITBS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
--------------------------------------------------------------
# SQLNET.ORA Network Configuration File: c:oracleora90networkadminsqlnet.ora
# Generated by Oracle configuration tools.
# b13
NAMES.DEFAULT_DOMAIN = itbs
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
-------------------------------------------------------------
Note! No server is being used all procedures are local to the host.
I need an answer very soon!
|
|
|
|
| Re: ORA-12154: TNS Cannot resolve service name [message #101158 is a reply to message #101119] |
Fri, 28 May 2004 22:14  |
Tak Tang
Messages: 142
Registered: May 2004
|
Senior Member |
|
|
You have to install oracle products in ascending order of age (starting with the oldest) because they overwrite some shared files in the windows system directory.
Forms 6i can only use its own SQL*Net client libraries, which means it has to go into its own oracle home (default path is c:orant). If you install oracle 9i into the same home, you will probably break it, and need to de-install/re-install all oracle products.
Furthermore, since Forms6i has its own oracle home, it will look at a DIFFERENT tnsnames.ora - namely the one in c:orantnetworkadmin instead of c:oracleora90networkadmin.
Hope this helps. I've been running forms 6i and oracle 9i on w2k for a while now.
Takmeister
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
