Oracle provides five Network Services

Hostnaming: Host naming method (the client is windowsxp and the server is linuxoracle9i) 1. Configure sqlnet on the client. oraSQLNET. AUTHENTICATION_SERVICES (ETS) NAMES. DIRECTORY_PATH (TNSNAMES, HOSTNAME) 2. Configure the listener on the server. oraLISTENER (DESCRIPTION (

Host naming: host naming method (the client is windows xp, and the server is linuxoracle 9i) 1. Configure sqlnet on the client. ora SQLNET. AUTHENTICATION_SERVICES = (ETS) NAMES. DIRECTORY_PATH = (TNSNAMES, HOSTNAME) 2. Configure the listener on the server. ora LISTENER = (DESCRIPTION = (

Host naming: host naming method (the client is windows xp, and the server is linux + oracle 9i)

1. Configure sqlnet. ora of the Client

SQLNET. AUTHENTICATION_SERVICES = (CNT)

NAMES. DIRECTORY_PATH = (TNSNAMES, HOSTNAME)

2. Configure listener. ora on the server.

LISTENER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = linuxoracle) (PORT = 1521) # note that the HOST is configured as the HOST name.

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = linuxoracle) # note that GLOBAL_DBNAME is the host name.

(ORACLE_HOME =/u01/app/oracle/product/9.2.0)

(SID_NAME = dg1)

)

(SID_DESC =

(GLOBAL_DBNAME = linuxoracle)

(ORACLE_HOME =/u01/app/oracle/product/9.2.0)

(SID_NAME = OEMREP)

)

)

3. Link:

C: Documents and Settings ew> sqlplus system/lijie123 @ linuxoracle

Note:

1. If GLOBAL_DBNAME and sqlplus are not correctly configured, the following error is returned:

ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor

2. ORA-12154: TNS: the specified connection identifier cannot be resolved. It may be a client hosts or dns problem. Open hosts

#102.54.94.97 rhino.acme.com # source server

#38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost

To:

........................................ .......................

#102.54.94.97 rhino.acme.com # source server

#38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost

192.168.1.61 linuxoracle