Re: HELP!! setup sql*net on Workgroup server ...

From: Lun Wing San <wslun_at_qrcsun.qrc.org>
Date: 1996/11/19
Message-ID: <32920B6B.CD9_at_qrcsun.qrc.org>#1/1

MCC wrote:
>
> We have Oracle workgroup server (V7.1 and Sql*net 2.1) on IBM AIX 4.2.
> The listener look like startup correctly. I tried to do local loop test
> (sqlplus system/manager_at_db00) on server side. I have following error
> messages:
>
> ora-12154: could not resolve service name
>
> Can anyone help me on it? Is it possible someone send me your
> configuration files (listener.ora, tnsnames.ora, sqlnet.ora)? Thank you
> for help.

  You forget to create a service name in tnsnames.ora for db00

Following is a sample about a database called test reside in the host 520h with TCP/IP as the adapter.

################
# Filename......: listener.ora
# Name..........: 520h.world

# Date..........: 18-NOV-96 11:08:07

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

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= test.world)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= test)
        )
        (ADDRESS = 
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = 520h)
          (Port = 1521)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = test)
      (ORACLE_HOME = /disk1/oracle/7.2)
      (PRESPAWN_MAX = 99)
      (PRESPAWN_LIST = 
        (PRESPAWN_DESC = (PROTOCOL = TCP) (POOL_SIZE = 10) (TIMEOUT =
10))
      )

    )
  )

################
# Filename......: tnsnames.ora
# Name..........: Enterprise.world

# Date..........: 18-NOV-96 11:08:07

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

test.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = 520h)
          (Port = 1521)
        )

    )
    (CONNECT_DATA =

       (SID = test)
       (GLOBAL_NAME = test.world)

    )
  )

################
# Filename......: sqlnet.ora
# Name..........: 520h.world

# Date..........: 18-NOV-96 11:08:07

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

AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
SQLNET.CRYPTO_SEED = "791488150-1064937189" SQLNET.AUTHENTICATION_SERVICES = (ALL)

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841

Received on Tue Nov 19 1996 - 00:00:00 CET