Re: problem with oracle8 starter database

From: Daniel Ady Surya <Daniel.Surya_at_mincom.co.id>
Date: Wed, 14 Apr 1999 11:21:57 +0700
Message-ID: <371416c0@news1.us.ibm.net>

Hi...
If you want to connect between server and client, you must set tnsnames.ora in your client and listener.ora in your server. listener.ora looks like this:

################
# Filename......: listener.ora
# Name..........: taurus.world

# Date..........: 22-SEP-97 13:58:57

################

LISTENER =
(ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= kemdevl)


        )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
LOG_DIRECTORY_LISTENER = /oracle/network/log TRACE_LEVEL_LISTENER = ADMIN
TRACE_DIRECTORY_LISTENER = /oracle/network/trace SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (SID_NAME = kemdevl)
      (ORACLE_HOME = /data4/oracle/v716)
      (PRESPAWN_MAX = 10)

)
)

tnsnames.ora looks like this:
kemdevl.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = PTMI.world)


          (PROTOCOL = TCP)


          (Host = taurus)


          (Port = 1555)


        )

)
(CONNECT_DATA =

       (SID = kemdevl)
       (GLOBAL_NAME = kemdevl.world)

)
)

in your server, login as oracle owner and type lsnrctl start
then notice at services summary...

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=kemdevl.world)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for HPUX: Version 2.1.6.1.0 - Production
Start Date                16-MAR-99 09:15:08
Uptime                    29 days 2 hr. 2 min. 43 sec
Trace Level               off
Security                  OFF
Listener Parameter File   /data4/oracle/v716/network/admin/listener.ora
Listener Log File         /data4/oracle/v716/network/log/listener.log
Services Summary...
  kemdevl               has 1 service handlers

The command completed successfully

instance kemdevl must be there.

good luck..

Daniel
IT Consultant (DBA) Received on Tue Apr 13 1999 - 23:21:57 CDT