Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP : SQL/net installation
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) )
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)
)
(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