Oracle series-Article 5 connecting PLSQL to a local Oracle Database

This blog is intended for beginners and I am also a beginner :)

We have successfully installed oracle on our computer, so how can we connect PLSQL developer?

What about local oracle?

First, we must prepare for the following steps:

The following describes how to connect PLSQL developer to the oracle database.

Select: Net Configuration Assistant (indicated by the red box)

Start

Click Next

Click Next

The name can be any. click Next.

Click Next

Click Next

Click Next

Click Next

Click Next

Select Local Net service name configuration and click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Finish.

Start PLSQL, and select "cmdt" as the database.

Connection successful!

Dinner ......

Supplement:

In your oracle installation directory, my options are: F: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN

Find the file tnsnames. ora.

 # tnsnames.ora Network Configuration : F:\oracle\product\. # Generated   ORACT    (DESCRIPTION      (ADDRESS_LIST        (ADDRESS  (PROTOCOL  TCP)(HOST  localhost)(PORT        (CONNECT_DATA        (SERVICE_NAME     EXTPROC_CONNECTION_DATA    (DESCRIPTION      (ADDRESS_LIST        (ADDRESS  (PROTOCOL  IPC)(       (CONNECT_DATA        (SID        (PRESENTATION     )

As you can see, the configuration information can be found here.