PL/SQL Connect Oracle Database 1, Brief introduction
Use PL/SQL to connect to a remote Oracle database without installing an Oracle database.
2. Detailed steps:
A) Install PL/SQL and install OracleClient based on your operating system (not related to the version number of the Oracle database).
b) Set the connection information to connect to the remote Oracle database, three ways (mainly in the Tnsnames.ora file), the following three ways to append the last content in the file is based on my own database connection information, only to do the reference:
I. A dialog box will pop up after the installation OracleClient to set the Tnsnames.ora file? Click Yes, join? Connection information, append at the end of the file:
II. My client installation folder is found TNSNames in the D:\Program files file, after installing the client, in the following address D:\Program files\instant Client\network\admin. Ora file open, append to file Last:
III. or login PL/SQL (no account login) Click help--"Support info--" TNS Names in the last append:
3. Additional content
Here, for example, my own connection information-remote database information:
<url>jdbc:oracle:thin:@10.45.35.67:1521:orcl67</url>
<!--Database Account--
<user>chy_user</user>
<!--database Password--
<passwd>chy_pwd</passwd>
The database information can be seen from the above:
Instance Name: orcl67
Machine ip:10.45.35.67:1521
Account Number: Chy_user
Password: chy_pwd
Additional content:
orcl67 = (DESCRIPTION = ( address_list = ( ADDRESS = (PROTOCOL = TCP) (HOST = 10.45.35.67) (PORT = 1521))
(Connect_data = (SERVER = dedicated) (service_name = orcl67)
The next step is to enter Usernamepassword and log in.
4. Summary
Things are very easy, but do not do or do not know.