Oracle Course 2# Install PL/SQL Developer and Configure TNSNAMES File

Опубликовано: 24 Июль 2026
на канале: Multiverso TI

6,781

104

In this lesson, we will learn how to connect the PL/SQL Developer database manager to the Oracle Express Edition database. We will also configure the sqlnet.ora and tnsnames.ora files.

Configuring sqlnet.ora
--------------------------------------------
SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.AUTHENTICATION_SERVICES=(NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME)

Configuring tnsnames.ora
------------------------------------------------
CLIENT_CONNECTION=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=localhost)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SID=XE)
)
)