SQL*Plus Client connections to several Oracle Autonomous (Always-Free)

Oracle Autonomous is a great service and Always-Free is a nice offering launched at OpenWorld 2019.

But what happens if I need to connect via SQL*Plus to two or more ADB from the same machine/terminal? The Oracle documentation provides good reference usable when connectiong to one autonomous database but if we need to use several ADB’s, the instructions provided by Oracle will be usable only if we keep changing the local TNS_ADMIN environment variable! That would not be possible for some of my Clients that have single TNS_ADMIN location and content that is managed at entreprise level!

Continue reading “SQL*Plus Client connections to several Oracle Autonomous (Always-Free)”