| Connectivity Problem ORA 12154 [message #78500] |
Tue, 26 February 2002 22:54  |
payal
Messages: 6
Registered: February 2002
|
Junior Member |
|
|
HI
I installed Oracle 8.1 Ent edition and the Forms and Reposrts developer (6i). My problem is that i cant connect the backend to the front end. I always get the error ORA -12154 TNS: could not resolve service name. My O/S is Windows 2000. The TNSnames ORA file look like -
# TNSNAMES.ORA Network Configuration File: C:orant4networkadmintnsnames.ora
# Generated by Oracle configuration tools.
DB4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = payal)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db4)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = payal)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = db4)
(PRESENTATION = http://admin)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC7))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
I can work on the database through SQL, but just cant connect the front end to the back end...The TNS listener is enabled...any ideas??
|
|
|
|
| Re: Connectivity Problem ORA 12154 [message #78503 is a reply to message #78500] |
Tue, 26 February 2002 23:45  |
Imran
Messages: 56
Registered: November 2001
|
Member |
|
|
When you install Forms6i You must change the home name and location of the folder. But do not change the home When you install REPORTs (after FORMS).
e.g : if home name is OracleOraHome81
then change to OracleOraHome6i
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
