Oracle client connection

I haven't written a blog for a while recently. I learned too many things instead of being lazy. Later, I will try again.

1. Add an ORACLE data source to ODBC

The first condition for adding an ORACLE data source in ODBC:Install Oracle client. After the installation is complete, add a connection to the installation directory c:/Oracle/ora90/Network/admin/tnsnames. ora, in the following format:

DxS =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 9.83.70.13) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = dealer)
)
)

 

This information must be viewed on the Oracle server.

2. Connect to Oracle through sqlplus

To connect to Oracle through sqlplus, you must Ping tnsping first,

 

Previously, the ping failed, but the ping still failed.Net mangerAdd a service name, or add a connection string to C:/Oracle/product/10.2.0/client_1/Network/admin/tnsnames. ora in the format of 1.

Then you can use:

1. sqlplus/nolog

2. Conn user/pass @ service name

Connected.