Configure Oracle Instant Client 21.12 to connect to Oracle Database 21c Express in Windows

Опубликовано: 19 Март 2025
на канале: Subhroneel Ganguly
5,437
25

Configure Oracle Instant Client 21.12 on Windows 10 to connect to Oracle Database 21c Express in Windows 8.1

01:04 Download Oracle Database Client for Windows
01:54 Configure Oracle instant client step by step.
03:21 Set environment variable
05:53 Configure tnsnames by adding connection string totnsnames.ora file
06:53 Test the connection to the database

TNSNAMES.ORA connection string format

service name will be used by oracle client =
(DESCRIPTION=
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress or hostname)(PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME=database service name)
)
)


Some important software download links related to this video

Oracle Database Express Edition - https://www.oracle.com/in/database/te...

Oracle Instant Client - https://www.oracle.com/database/techn...

Oracle Database Express Edition for Windows -
https://download.oracle.com/otn-pub/o...