After installing the oracle database, we are going to use the PLSQLDeveloper software to connect to the server database!
After installing the oracle database, we are going to use the PLSQL Developer Software to connect to the server database!
After installing the Oracle database, we are going to use the PLSQL Developer Software to connect to the server database!
The following describes how to set the software and connect to the oracle database:
1. Download and install PLSQL Developer (Green Edition is also supported );
2. Download and decompress
Oracle Installation-free client:
3. Create a tns configuration file.
1, in the decompression: "nstantclient-basic-nt-11.2.0.3.0" folder to create a folder, path like this "nstantclient-basic-nt-11.2.0.3.0 \ neidown \ admin", in fact, this does not matter, it seems that it is closer to the server, and it corresponds to the environment variable after the article.
2. Copy the server directory "$ ORACLE_HOME $ \ network \ admin \ tnsnames. ora "to the client's" nstantclient-basic-nt-11.2.0.3.0 \ neidown \ admin "directory, the content of this file is as follows: (you can also create your own)
# Tnsnames. ora Network Configuration File:/home/oradb/oracle/product/11.2.0/db_1/network/admin/tnsnames. ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost. localdomain) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl. localdomain)
)
)
The above code is a brief introduction. In this example, the oracle database installed in linux is configured as follows:
ORACLE_BASE =/home/oradb/oracle
ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/db_1
ORACLE_SID = orcl
PATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin
LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib
LANG = C
After copying it to the client, open it in notepad and modify the following parameters:
# Tnsnames. ora Network Configuration File:/home/oradb/oracle/product/11.2.0/db_1/network/admin/tnsnames. ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl. localdomain)
)
)
Important: except that the HOST is the Server ip address, the other three red letters must be consistent with the file on the server. Otherwise, connection may causeORA-12514 error..