In the case of enterprise development, the database (Oracle) is typically installed locally, and the Oracle database is large and installed locally, slowing down the computer. We can connect to the database remotely through the Oracle client. Here's how you install
1. Install the Oracle Instant Client (32-bit, Plsql does not support 64-bit) software.
2. Create Tnsnames.ora (Listening profile) file contents as
Orcl_ Database address = (DESCRIPTION = (address = (PROTOCOL = TCP) (HOST = database addresses) (port = ports)) (Connect_data = (SERVER = dedicated) (SERVICE _name = ORCL)))
Place the Tnsnames.ora file in the Oracle Instant Client installation directory
3. Configuring System Environment variables
(1) tns_admin = Tnsnames.ora file path
(2) Nls_lang = simplified Chinese_china. ZHS16GBK (used to identify the database
Character set, solve the problem of Chinese garbled. )
4. Install PL/SQL and configure PL/sql:
1. When you start PL/SQL, you do not need to login;
2. Open "Tools"-"Preferences"-"Oracle"-"Connection":
1:oracle Instant Client Installation directory
2:oracle oci.dll file under Instant Client
5. Configure the restart PL/SQL.
PL/SQL Installing and configuring Oracle database connections