Home » Developer & Programmer » Forms » Connectivity Problem ORA 12154
Connectivity Problem ORA 12154 [message #78500] Tue, 26 February 2002 22:54 Go to next message
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 Go to previous message
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
Previous Topic: Re: inserting data in tabular form
Next Topic: Re: inserting data in tabular form
Goto Forum:
  


Current Time: Sun May 24 18:49:06 CDT 2020