Re: Cannot connect to Oracle 10g database
Date: Wed, 23 Apr 2008 22:40:11 +1000
Message-ID: <funan6$nl1$1@registered.motzarella.org>
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
> descriptor
> snippage
> 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.
Try this:
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