Re: Cannot connect to Oracle 10g database
Date: Wed, 23 Apr 2008 22:40:11 +1000
Raj wrote,on my timestamp of 23/04/2008 10:30 AM:
> From SQL PLus, I cannot connect to our Oracle 10g database. The
> following errors shows up in the SQL-Plus.
> ORA-12514: TNS:listener does not currently know of service requested
> in connect
> What could be the problem and how to fix it?
> Any help you can provide is greatly appreciated.
The problem is that the description of the service
name in your tnsnames.ora entry does not match the
service names the listener knows about.
The most common case is when for example the SERVICE_NAME entry is set to the SID in the server, instead of the fully qualified domain name of the database.
Run the following query in the server logged on as sys or system:
select * from global_name;
then pick the resulting string and set the SERVICE_NAME parameter in the corresponding tnsnames.ora entry in the client to that string. Then try the connect again. Received on Wed Apr 23 2008 - 07:40:11 CDT