Re: how to use oracle client in linux

CJ,

Hi!  Have you properly added the service name of your
Oracle database in 
${ORACLE_HOME}/network/admin/tnsnames.ora?  If not,
you may use netca to do that in a graphical way.

Here is a sample tnsnames.ora entry:

This is an example of a connect string for a 3-node
RAC with transparent application failover (TAF). 
Netca can't create one like this:
PD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =
rac1-1-vip.domain.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST =
rac1-2-vip.domain.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST =
rac1-3-vip.domain.com)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pd.transco.local)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

This is an example of an entry for a single-instance
DB.
MILACL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =
milacl.domain.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = milacl)
    )
  )


Charlton "Charlie" H. Lopez
Novell Certified Linux Professional for SUSE Linux
Enterprise Server 9
Oracle9i Database Administrator Certified Associate

--- jhuniepi <[email protected]> wrote:

> hi to all,
> 
> i installed oracle 10g client on suse 10 how can i
> use it to connect to our
> database server. i can't see it in the K menu. i
> can't connect using
> sqlplus.
> 
> --
> cj pangilinan
> linux user, java programmer
> >
_________________________________________________________
> Philippine Linux Users' Group (PLUG) Newbie Mailing
> List
> [email protected] (#PLUG @
> irc.free.net.ph)
> Read the Guidelines: http://linux.org.ph/lists
> Searchable Archives: http://archives.free.net.ph


Send instant messages to your online friends http://uk.messenger.yahoo.com 
_________________________________________________________
Philippine Linux Users' Group (PLUG) Newbie Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph