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...