Re: tnsping resolves but ORA-12154

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = tcpnbo.world)(PROTO
COL = TCP)(Host = nb009984)(Port = 1521)) (CONNECT_DATA = (SID = lwcrown) (GLOBA
L_NAME = lwcrown.world)))
OK (1030 msec)

SQL> set instance lwcrown
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production
SQL> My passwords had been messed with .This is a classic example of make no assumptions where a problem pops up...

G Quesnel wrote:
> It's not that I don't believe you, but ...
>
> Can you do a screen capture of the following ... replacing abc1 with
> your service name, and feel free to remove specific server name
> information - both from the server with the problem:
>
> tnsping abc1
>
> sqlplus /nolog
> set instance abc1
>
> sorry to be so doubting, but ...
Received on Tue Oct 24 2006 - 14:35:09 CDT