Re: tnsnames/tnsping problems

Try
> (GLOBAL_DBNAME= NMDB.mydomain.com)
in listener.ora
and
NMDB.mydomain.com = ....
in tnsnames.ora
IMO, domain needs to be an existing DNS-domain or world. I can't see other fakes will work.

Hth,

--
Sybrand Bakker, Oracle DBA
Otis Gospodnetic <otis_at_my-deja.com> wrote in message news:86nid0$pi9$1_at_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 - 15:04:39 CST