Re: tnsnames/tnsping problems

In article <948920798.13351.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> 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.

As it turns out....
The .ora fiels were all fine, EXCEPT that the formatting was casing Oracle to malfunction.

Instead of:

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

I used:
  (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.254.11)(PORT = 1521))

And things started working.
Unbelievable!

Otis
P.S.
nmdb.mydomain.com does not have to be a real hostname. It is not supposed to be a hostname anyway, but rather something like "an Oracle- specific address of a database instance"

> 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.

>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 18:00:43 CST