OraFAQ Forum: Forms » Connectivity Problem ORA 12154

Home » Developer & Programmer » Forms » Connectivity Problem ORA 12154

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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??

Report message to a moderator

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

Report message to a moderator

Previous Topic:	Re: inserting data in tabular form
Next Topic:	Re: inserting data in tabular form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 14:02:20 CDT 2025