Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12154:TNS:could not resolve service name

780926Jun 23 2010 — edited Jun 24 2010

Hi,

I installed oracle client and server on windows server 2003.When i try to connect the database it gives this error.
I have checked the TNS names.ora and sqlnet.ora.

In the TNS names.ora there ia a oracle service with the same name that has been configured in the Database Configuration Assistant.
Domain name is also the same.

This is the detail of the TNSnames.ora file..

DB.KLLAB.ININ.COM=
{DESCRIPTION=
{ADDRESS LIST={ADDRESS={PROTOCOL=TCP}
{HOST=TEST-SERVER}{PORT=1521}
}
{CONNECT DATA=
{SERVER=DEDICATED}
{SERVICE NAME=DB}
}
}

regards,Bushra

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2010

Added on Jun 23 2010

#general-database-discussions

17 comments

2,935 views