Re: tnsping TNS-03505 and ORA-12154

run lsnrctl services or lsnrctl status. You should see 2 services now. Most likely you'll only see the oldsid, as most likely you didn't configure tnsnames.ora and or listener.ora correctly. Usually 3503 is a problem in listener.ora and 12154 a problem in tnsnames.ora
Please also check whether you have redundant tnsnames.ora and listener.ora files floating around on your server and/or point the TNS_ADMIN environment variable to the correct directory.

When it still doesn't work, include
trace_level_client = 16
trace_unique_client = true
in sqlnet.ora
and post the results along with tnsnames.ora and listener.ora

Hth,

Sybrand Bakker, Oracle DBA

<argosy22_at_my-deja.com> wrote in message news:8btruu$q6f$1_at_nnrp1.deja.com...
> HI,
>
> I just created a new database, giving a total of
> two databases on the one server.
>
> I can log onto SQLPLUS in a number of ways.
>
> From windows NT, entering:
> USERNAME, PASSWORD, SID
> or
> USERNAME/PASSWORD_at_SID in the username textbox.
>
>
> From Unix:
>
> export ORACLE_SID=eithersid
>
> sqlplus
> - enter username
> - enter password
>
>
> And with the old database, I can log on with:
>
> sqlplus username/password_at_oldSID
>
>
> But, if I try the same with the new database:
>
> sqlplus username/password_at_newSID
>
> I get:
>
> SQL*Plus: Release 3.3.4.0.1 - Production on Wed Mar 29 15:33:36 2000
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
> ERROR: ORA-12154: TNS:could not resolve service name
>
> Also, tnsping works with the old database,
> but not with the new database:
>
> tnsping newSID
>
> TNS Ping Utility for Solaris: Version 2.3.4.0.0 - Production on
> 29-MAR-00 16:12:28
> Copyright (c) Oracle Corporation 1995. All rights reserved.
> TNS-03505: Failed to resolve name
>
>
> Any ideas?
>
> Thanks,
>
> Argosy
>
>
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 29 2000 - 15:40:50 CST