tnsping OK, but database does not exist what next

From: wayne <waynekerrxp_at_hotmail.com>
Date: 3 Aug 2001 07:53:49 -0700
Message-ID: <453849cf.0108030653.514bb8a9@posting.google.com>

Hi List,
I have added a new 8.1.6 database to a server taht already has 3 working dbs.
But when I try to connect with a Clarify Client it says "database does not exist".
Which I was not expecting, cos from the W2000 client tnsping ORT succeds.

The server tnsnames.ora, and listener.ora files look a bit strange, but they worked for UAT so why not ORT?
And the client tnanmes.ora is much the same.

Is there an obvious next move to diagnose this problem? Is a successfull tnsping good enough to prove that the sqlnet stuff is OK?

Just in case it isn't, I append some of the config files...

tia

Wayne

server:
<snip>
UAT.EUROPE.MICCOMP.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.153.0.5)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = UAT)

    )
  )

ORT.EUROPE.MICOMP.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.153.0.5)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = ORT)

    )
  )

listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.153.0.5)(PORT = 1521))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.153.0.5)(PORT = 2481))
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.6)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = UAT)
(ORACLE_HOME = /u01/app/oracle/product/8.1.6)
(SID_NAME = UAT)

    )
    (SID_DESC =
(GLOBAL_DBNAME = ORT)
(ORACLE_HOME = /u01/app/oracle/product/8.1.6)
(SID_NAME = ORT)

    )
  )

client:
tnsnames.ora....
UAT =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.153.0.5)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = UAT)
(SRVR = DEDICATED)

    )
  )
ORT =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.153.0.5)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = ORT)
(SRVR = DEDICATED)

    )
  ) Received on Fri Aug 03 2001 - 09:53:49 CDT