My Oracle Support Banner

How to Make SQLcl to Read TNS_ADMIN environment variable (Doc ID 2343404.1)

Last updated on OCTOBER 24, 2020

Applies to:

Oracle SQL Developer - Version 4.2.0 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle SQLcl - Version 18.4 and later
Information in this document applies to any platform.

Goal

Oracle SQL Developer command line version 4.2 & above cannot identify TNS_ADMIN alias.

Trying to connect to the  Oracle Database using below similar command, it fails to read TNS_ADMIN and throws exception:

Example:

SQL> connect <USER>/<PASSWORD>@<DB_ALIAS>

USER =<USER>
URL = jdbc:oracle:thin:@<HOST>:1521/<SERVICE_NAME>
Error message = I / O error: Unknown host specified

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.