Re: ORA-12514: TNS error

On 27 Feb 2003 05:47:24 -0800, dmagnatek_at_yahoo.com (David) wrote:

>Thanks for your reply. Per your suggestion I checked the service name
>in the connect_data sections of tnsnames.ora on my client, on the
>server and in init<sid>.ora for the database. They all match....
>
>Client (tnsnames.ora)
>...
>stage =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = stage-klump)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = stage)
> )
> )
>
>Server (tnsnames.ora)
>...
>stage =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = stage-klump)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = stage)
> )
> )
>
>Server (init.ora)
>...
>db_name = "stage"
>instance_name = stage
>service_names = stage

Hmmm
You don't have
names.default_domain = <something> in your sqlnet.ora If that's not the case, time to execute a level 16 trace

add

trace_level_client = 16
trace_unique_client = true
trace_directory_client = <any sensible directory>

to sqlnet.ora, retry the operation and post and/or e-mail the results.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Feb 27 2003 - 14:13:51 CST