tnsping TNS-03505 and ORA-12154

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:18:40 CST