Oracle server and client Configuration

1. you can use $ ORACLE_HOME/bin/netca to configure the listener on the Oracle server. If the listener Configuration does not use the default listener name (listener), but changes it to another name, the startup method is

[Oracle@www.bkjia.com admin] $ lsnrctl ora_listener start

If the default value is used

[Oracle@www.bkjia.com admin] $ lsnrctl start

2. Configure the client listener

First, you must follow the oracle client or have oracle software. If it is an oracle client, the location is \ oracle \ product \ 10.2.0 \ client_1 \ NETWORK \ ADMIN \ tnsnames. ora

You can add the following configurations:

ORA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.26.130) (PORT = 1521 ))

)

(CONNECT_DATA =

(SID = ora) // ora is the remote database service_names

)

)

You can use sqlplus scott/tiger @ ora in the cmd command line to connect to a remote database.