Скачать или смотреть 007 - 🚀 Oracle XE 21: Understanding SQLPlus Connection Types & TNS Configuration

In this tutorial, I’ll walk you through three essential connection types in Oracle XE 21 using SQLPlus and show how to configure TNS for simplified database access.

🔹 Connection Types Covered:

EZCONNECT: Direct connection using hostname, port, and service name.

sqlplus system/100@localhost:1521/XEPDB1

TNS Connection: Using tnsnames.ora to define aliases for database connections.

sqlplus system/100@XEPDB1_ALIAS
Configuration example in tnsnames.ora:

XEPDB1_ALIAS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-CNG1HIK)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = XEPDB1)
)
)

Local Bequeath Connection: Connecting directly to the local instance without network configuration.

sqlplus / as sysdba

For more connections typre:
https://docs.oracle.com/en/database/o...

💡 Like, share, and subscribe for more Oracle tutorials! 🚀💻