How to Setup PL/SQL with Instant Client? | Add TNS Names | EXPLAINED
This video will answer many of comments questions.
How to add TNS names?
How to setup PL/SQL software?
How to use instant client with SQL Developer?
How to connect to external database servers via PL/SQL?
What are TNS files?
Setting up PLSQL developer with oracle instant client is sometimes tricker.
0:15 How to download and install PL/SQL Developer Evaluation
1:10 How to download Oracle Instant Client
1:47 How to install PL/SQL Developer
3:00 Setup the instant client package
3:50 Configure Environment Variables with Instant Client folder address
4:54 Save the tnsnames.ora file and tns information
5:30 Enter the Host address, server, port, service name information in the tns file
06:25 Select OCI Library address
6:45 Connect to the database
Download PL/SQL Developer:
https://www.allroundautomations.com/products/pl-sql-developer/features/new-features-pl-sql-12-0/
Download Instant Client:
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
