Re: tnsping TNS-03505 and ORA-12154

Argosy,

Try looking at the tnsnames.ora file in your $ORACLE_HOME/network/admin directory and check your entries to see if (or add) the alias is there and set for the new database instance.

Rob Calfee
Systems Consultant
Quest Software
602-741-9419
520-421-2734/7124
rcalfee_at_quest.com
www.quest.com

<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 - 00:00:00 CST