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

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

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

ORA-12154 TNS: Could not resolve the service name [message #119928]

Mon, 16 May 2005 14:47

imtiazmasud
Messages: 49
Registered: May 2005
Location: Bangladesh

Member

Hi gurus,
I am a new user of forms.I am using windows Xp Operating system. I have installed Oracle 9i and devloper 6i in my machine.I connected welly at first.Today Devloper is not connecting but I am using oracle but without host string,Its crazy man that my oracle is working but not devloper.what should I do not??

What is the problem.........????? Help me...Help !!!!!

Report message to a moderator

Re: ORA-12154 TNS: Could not resolve the service name [message #119931 is a reply to message #119928]

Mon, 16 May 2005 15:07

wucis
Messages: 60
Registered: March 2005

Member

Copy the files tnsnames.ora and sqlnet.ora from
oracle_9_home_directory/network/admin
into your
developer_6_home_directory/net80/admin

Report message to a moderator

Re: ORA-12154 TNS: Could not resolve the service name [message #119938 is a reply to message #119931]

Mon, 16 May 2005 15:55

imtiazmasud
Messages: 49
Registered: May 2005
Location: Bangladesh

Member

hi,
The Solution that you have given is not working..
If I give my host string then it shows that:
ORA:532 Invalid argument but I can still remember that all my info is right at all..

what should I do now...... HELP ........HELP !!!!!!!!!!!

Report message to a moderator

Re: ORA-12154 TNS: Could not resolve the service name [message #119989 is a reply to message #119938]

Tue, 17 May 2005 02:34

Neecharl
Messages: 15
Registered: May 2005
Location: Chennai/Mauritius

Junior Member

Create a listener.
a listener is like a pointer to your database.
Go to oracle administration> NET8 config assistant.
Select the database to connect to, give the listener a simple name,etc..

In developer, connect by entering the listener name which you created as the HOST-STRING.

Report message to a moderator