Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP : SQL/net installation

HELP : SQL/net installation

From: ke <ke3_at_pacific.net.sg>
Date: 1997/05/02
Message-ID: <3369A785.5F86@pacific.net.sg>#1/1

Hi,

I am trying to connect the client workstation to the server using the SQL/net (via TCP/IP microsoft network) but I have the following error :

ERROR: ORA-12154: TNS:could not resolve service name

The content of the tnsnames.ora in the client PC and the server :

css.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS =

          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = 20.11.11.45)
          (Port = 1526)
        )

    )
    (CONNECT_DATA = (SID = css)
    )
  )

The content of the listener.ora

LISTENER =
  (ADDRESS_LIST =

     (ADDRESS=

(PROTOCOL=IPC)
(KEY=css.world)
) (ADDRESS=
(PROTOCOL=IPC)
(KEY=css)
) (ADDRESS=
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = 20.11.11.45)
(Port = 1526)
)

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

(SID_NAME = css)
(ORACLE_HOME = /opt/app/oracle/product/7.3.2)
(PRESPAWN_MAX = 0)
)

   )

The value of the environment

ORACLE_HOME=/opt/app/oracle/product/7.3.2
ORACLE_BASE=/opt/app/oracle
ORACLE_SID=css

Does anyone know what is the problem ......thank you.

Regards,

Swee Kiew Received on Fri May 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US