Re: Oracle 8.0.5 Client Config ??? (Linux)

From: TurkBear <johng_at_nospam.mm.com>
Date: Fri, 04 Jun 1999 16:05:25 GMT
Message-ID: <3758f7e1.8285083@news.dot.state.mn.us>

Rene Bauer <rene.bauer_at_tesis.de> wrote:

>Hi,
>
>I need to access an Oracle Server which runs under NT from a Linux
>Workstation with SQL Plus. I installed the SQL Plus and all the other
>stuff needed for that (Oracle solved the dependencies) on my machine.
>Now I need to know how I can configure my client to access the server. I
>could not find any decent explanation. So where can I find one or what
>do I have to do?
>
>Ciao,
>Rene

In addition to SqlPLus you will need to install SqlNet to connect to a remote database...

After installation, read the docs on editing the tnsnames.ora file ( and on the location for it ) to set up a database connect string that will access your listener on the NT box....

Here is an example tnsnames.ora file to show its format....

( format only, actual content is dependent on your listener and protocols )

---

# 
# Installation Generated Net8 Configuration 
# Version Date: Oct-27-97 
# Filename: Tnsnames.ora 
#  

extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = <oracle_sid>))     (CONNECT_DATA = (SID = extproc))
  )

hrotcp =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= 151.111.xxx.xxx)(Port= 1521))     (CONNECT_DATA = (SID = ORA7))
  )

<oracle_sid>_BEQ =
  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /extra/ora_home)
               (argv0 = oracle<oracle_sid>)
               (args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
               (envs = 'ORACLE_HOME=/extra/ora_home,ORACLE_SID=<oracle_sid>')

    )
  )

---

Hope it points you in the right direction....

John Greco Received on Fri Jun 04 1999 - 11:05:25 CDT