OraFAQ Forum: Forms » ORA-12154: TNS:could not resolve service name

Home » Developer & Programmer » Forms » ORA-12154: TNS:could not resolve service name

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

ORA-12154: TNS:could not resolve service name [message #83981]

Tue, 13 January 2004 03:26

Krupal Patel
Messages: 9
Registered: January 2004

Junior Member

I am getting this error.

ORA-12154: TNS:could not resolve service name

When I tried to connect (while creating data block wizard)Forms 6i with Oracle database 9i. I used the username scott, password as tiger and the correct database name. I checked the database name in tnsnames.ora and it is the correct database name. I checked database name in V$DATABASE also. Please help me with this.

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #83984 is a reply to message #83981]

Wed, 14 January 2004 01:21

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You have to change your oracle_home of forms to the oracle_home of the 9i database.

MHE

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #83993 is a reply to message #83984]

Thu, 15 January 2004 03:35

Krupal Patel
Messages: 9
Registered: January 2004

Junior Member

Maaher,
I installed Oracle 9i DS. I cannot login to SQLPLUS through Oracle9iDS but I can login to SQLPLUS through Oracle - OraHome92 (Which is Oracle 9i database).

How can I set Oracle_home to Oracle 9i Database?

Because when it prompt me for the destination (while installation of Oracle9iDS) it didn't accept as same location as Oracle9i Database.

Thank you for your reply.

Krupal

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #84010 is a reply to message #83993]

Fri, 16 January 2004 06:15

Krupal Patel
Messages: 9
Registered: January 2004

Junior Member

I copied tnsnames.ora, listener.ora, sqlnet.ora, snmp_ro, snmp_rw and pfile and spfile from OracleHome to DeveloperHome directory. And change the directory path and the required things.
Still it's showing me ORA-12560 - TNS: could not resolve service name.

Please let me know.

Krupal

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #84021 is a reply to message #83984]

Mon, 19 January 2004 03:16

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I haven't got a 9i around right now, but to my recollection there's a home selector tool in the Windows start menu which allows you to change the default_home of your IDS.

MHE

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #84237 is a reply to message #83984]

Wed, 18 February 2004 19:17

Gopal Saha
Messages: 1
Registered: February 2004

Junior Member

Hi,

I am trying to connect remote database through VPN connection using a DB link, So, I created a DB link but after that when I am using that DB link it gives me an error "ORA-12154".

I am attaching the part of tnsnames.ora.

LTK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.200.180)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ltk)
)
)

NUFO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.1.32)(PORT=1527))
)
(CONNECT_DATA=
(SERVICE_NAME=NUFO.TELEKOM.LV)(SERVER=dedicated))
)

LTK is a local database, and NUFO is remote database.
I can connect NUFO database but I can't use DB link which is created in local database pointing to remote database.
So, I need a solution ASAP.

Thanks & Regards,
Gopal

Report message to a moderator

Previous Topic:	ORA-12154: TNS:could not resolve service name
Next Topic:	commit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 11:35:45 CDT 2024