Oracle Magazine, May/June 2019
ORACLE MAGAZINE MAY JUNE 2019 62 Database Developer OPEN SOURCE PREREQUISITES Here are the prerequisites for following along with the steps in this article Have an Oracle Autonomous Transaction Processing instance provisioned and running If you dont have a current instance you can sign up for a free trial Have a database schema and password created that you can use for testing Have access to the Oracle Autonomous Transaction Processing service panel or have someone with access available to help Download and install Oracle Database Instant Client Optional but a good idea Have SQLcl or Oracle SQL Developer installed to verify the connection in a neutral environment Download and install the database driver for your preferred language Make sure the driver you choose uses Oracle Database Instant Client to make its connection I will provide links to the language specific drivers used in my examples DOWNLOAD CLIENT CREDENTIALS ORACLE WALLET With the prerequisites complete download the client credentials for your Oracle Autonomous Transaction Processing database instance 1 Go to the Oracle Autonomous Transaction Processing Database Details page for your Oracle Autonomous Transaction Processing database instance 2 Click the DB Connection button shown in Figure 1 3 Click the Download button shown in Figure 2 The client credentials zip file you download will contain a tnsnames ora file that includes the TNS Name values listed in the Connection Strings panel You can refer to the documentation for an explanation of when to use each of these For my examples I will be using the BlaineATP_ MEDIUM TNS Name value
You must have JavaScript enabled to view digital editions.