tnsnames/tnsping problems

From: Otis Gospodnetic <otis_at_my-deja.com>
Date: Wed, 26 Jan 2000 19:37:04 GMT
Message-ID: <86nid0$pi9$1@nnrp1.deja.com>

Hello,

This seems to be a FAQ on Usenet, yet it looks like there is no clear answer.

I am trying to do this:
tnsping <address>

I am trying to do this from the same machine where the Oracle database is running. Listener is running, and my database is running, too. The Unix 'ping' works fine, and TCP/IP in general.

I basically can't ping the <address> no matter how I specified it. Depending on how I specify it (i.e. with or without domain name) I get different errors, such as:

If I do not specify the domain name: TNS-03506: Failed to create address binding
If I do specify the domain name: TNS-03505: Failed to resolve name

Here are relevant portions of relevant config files. If anyone can see anything wrong with them please tell me. Note: this is Oracle 8.1.5. (patched to .02) on Linux (Red Hat 6.1). The database I created is called 'NMDB'.

FILE: /ora01/app/oracle/admin/NMDB/pfile/initNMDB.ora

  db_name                 = NMDB
  instance_name           = NMDB
  db_domain               = mydomain.com
  service_names           = NMDB

FILE: /ora01/app/oracle/product/8.1.5/network/admin/listener.ora

LISTENER =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.254.11)(PORT=1521))
(ADDRESS= (PROTOCOL= IPC)(KEY= NMDB))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

SID_LIST_LISTENER =
(SID_LIST =

      (SID_DESC =


        (GLOBAL_DBNAME= NMDB)


        (ORACLE_HOME= /ora01/app/oracle/product/8.1.5)


        (SID_NAME = NMDB)


      )

)

FILE: /ora01/app/oracle/product/8.1.5/network/admin/tnsnames.ora

NMDB =

        DESCRIPTION =


        (ADDRESS =


                (PROTOCOL = tcp)
                (HOST = 192.168.254.11)
                (PORT = 1521)
        )


        (CONNECT_DATA =


                (SID = NMDB)
        )

FILE: /ora01/app/oracle/product/8.1.5/network/admin/sqlnet.ora

  NAMES.PREFERRED_SERVERS =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.254.11)(PORT = 1575))     )

  NAMES.DEFAULT_DOMAIN = mydomain.com
  SQLNET.EXPIRE_TIME = 0
  NAMES.DIRECTORY_PATH= (TNSNAMES)
  SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

Any help would be much appreciated.
Thanks!

Otis

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 13:37:04 CST