Win10 Plsql Developer connected to the Oracle 11g installed on Ubuntu

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.