Re: Name Server?

From: Harald <hp.raptor_at_web.de>
Date: Wed, 8 Jan 2003 15:32:22 +0100
Message-ID: <1042039559.990793_at_cache2.news-service.com>

Hello !

Type the correct IP and Port-Number in the file "tnsnames.ora" on your workstation
like:

---

# TNSNAMES.ORA Network Configuration File: /opt/oracle/OraHome1/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

LISTENER_DEVL.SANT.COM =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = santdevl)(PORT = 1526))   )

DEVL.SANT.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = santdevl)(PORT = 1526))
    )
    (CONNECT_DATA =
(SERVICE_NAME = devl)

    )
  )

EXTPROC_CONNECTION_DATA.SANT.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

---

The IP and the Port-Number is defined in the file "listener.ora" on the server
see this example:

---

STARTUP_WAIT_TIME_LISTENER = 0 LISTENER =
  (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = IPC)(KEY = devl))
    (ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.58)(PORT = 1526))

  )

CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = devl)
(ORACLE_HOME = /opt/oracle/OraHome1)
(SID_NAME = devl)

    )
    (SID_DESC =
(SID_NAME = ExtProc)
(ORACLE_HOME = /opt/oracle/OraHome1)
(PROGRAM = extproc)

    )
  )

TRACE_LEVEL_LISTENER = OFF

---

Best Regards

Harald

"CodeToad" <MayhemZero_at_hotmail.com> schrieb im Newsbeitrag news:kHBS9.2943$t06.24470_at_news2.east.cox.net...

> I posted this in Linux setup also, but hope someone here
> can help.
>
> I am not a Linux expert.  A friend of mine has a linux setup
> where he is using a Linksys cable router and as his DHCP server,
> for his Linux and Win2k systems.  He is a DBA.  On his Linux
> machine, he has Oracle 8.1.x installed or 9.x.x.  In either case, those
> familiar with Oracle know the TNSNAMES.ORA file wants a
> system name not an IP address for resolution.
>
> My question is, how does he adjust his system to get a name?
>
> Does he have to make the Linux box the DNS server?
> Does he have to have the name in TNSNAME.ORA?
>
> Please help.  I hope I stated this correctly.
>
>

Received on Wed Jan 08 2003 - 15:32:22 CET