How PL/SQL developer connects to Oracle

1. Configure the Oracle database connection

In the previous article, we have learned how to use Oracle's net configuration assistant to configure database connections. In addition, you can modify the configuration file to connect to the database. Find the tnsnames. ora file under the Oracle Installation File. The general path is ORACLE_HOME % \ Network \ ADMIN:

Orcl =
(Description =
(Address = (Protocol = TCP) (host = localhost) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = orcl)
)
)

2. download and install the Pl. SQL. developer configuration application

Configure tools> preferences> connection

3. If you enable PLSQL again, you can log on to the database by entering the username and password with the oracledata option.

Username: SYS

Password: entered during installation