Page 1 of 1

10g client problem

Posted: Tue Dec 12, 2006 1:46 am
by amar.reddy
Hi friends

I have a error for oracle 10g.

The problem when i am configuring the Oracle Net configurant assistant for client to connect the following error is coming..

<b>Connecting...ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
The test did not succeed.</b>
So any one pls rectify the problem .

Regards
Amar

Posted: Tue Dec 12, 2006 1:52 am
by ahmadbilal
TNSPING THE SERVICE NAME
tnsping ocs.world

Posted: Tue Dec 12, 2006 2:30 am
by amar.reddy
i could get u friend.

Posted: Tue Dec 12, 2006 3:13 am
by ahmadbilal
What ?


Please Reduce Your font Size.
and mention your complete architecture
OS
database version
Etc

Posted: Tue Dec 12, 2006 6:35 am
by amar.reddy
The Problem is

Connecting...ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
The test did not succeed.

OS is Windows XP
Database is 10g

Posted: Tue Dec 12, 2006 6:47 am
by ahmadbilal
TNS Ping is used for checking the Problem In TNSNAMES.ORA

whenever you face the error ORA-12514 most probably it is due to problem in your oracle Home or TNS names Configuration Its A basic measure to check your service name and connection descriptions

user tnsping in you database home(where in network/Net80 folder your tnsnames.ora exists)
ORA-12514: TNS: listener could not resolve SERVICE_NAME

Posted: Wed Dec 13, 2006 9:41 am
by amar.reddy
Thank U guys

I got the problem rectified..

Thank u for responding.

Regards

Amar

Posted: Wed Dec 13, 2006 11:32 am
by admin
Please share your findings with us in resolving your issue. thanks