Description: The process recorded is not very confident, only the basic steps are logged. is not suitable for the students who want to step by step.
Actions required under WIN10
1, the Microsoft Official website downloads instantclient, then receives to the local one folder, the attention path does not have the space, the Chinese and the parenthesis and so on characters.
2, in Instantclient unpack the root directory of the new/network/admin folder, and in the Admin folder under the new file Tnsnames.ora, the contents are as follows:
# tnsnames. ORA Network Configuration file:%oracle_home%\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = Span style= "COLOR: #ff0000" >192.168.152.128 ) (PORT = 1521 ))
Span style= "font-size:13px" > (connect_data =
(SERVER = dedicated)
(service_name = ORCL )
)
)
The first ORCL is the connection identity configured in the Oracle database Listener.ora.
The second ORCL is the instance name of Oracle. In terminal via: Echo $ORACLE _sid Command View
3. Configure environment variables (3 of the Red Line)
4. Download Plsql developer software, open and configure
Configuration required under Ubuntu
1. Locate the Listener.ora file in the Oracle directory. You can use the command: Find./-name ' Listener.ora '. There are probably two of them found here. Note Use the/network/admin/below.
Open it. The default content is:
# Listener.ora Network Configuration File:/home/fybing/tools/oracle11g/product/11.2.0/dbhome_1/network/admin/ Listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
)
Adr_base_listener =/home/fybing/tools/oracle11g
Add in the following:
Sid_list_listener=
(sid_list=
(sid_desc=
(global_dbname=ORCL)
(Oracle_home=/home/fybing/tools/oracle11g/product/11.2.0/dbhome_1)
(sid_name=ORCL))
(sid_desc=
(Sid_name=plsextproc)
(Oracle_home=/home/fybing/tools/oracle11g/product/11.2.0/dbhome_1)
(Program=extproc)))
Keep the file and restart the service
Lsnrctl stop
Lsnrctl start
Connection:
The ORCL in the Listener.ora configuration for sid_name=ORCL content.
And the ORCL of GLOBAL_DBNAME=ORCL corresponds to Tnsnames.ora first appearing ORCL
Win10 Plsql Developer connected to the Oracle 11g installed on Ubuntu