Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Connecting to a DB Instance Running the Oracle Database Engine

After Amazon RDS provisions your Oracle DB instance, you can use any standard SQL client application to connect to the DB instance. In this topic, you connect to a DB instance running the Oracle database engine by using the AWS Management Console, SQL*Plus, or the AWS CLI.

AWS Management Console

To connect to an Oracle DB instance with Information from the RDS Console

  1. Open the RDS console, then select Instances in the left column to display a list of your DB instances.

  2. In the row for your Oracle DB instance, select the arrow to display the summary information for the instance.

  3. The Endpoint field contains part of the connection information for your DB instance. The Endpoint field has two parts separated by a colon (:). The part before the colon is the DNS name for the instance, the part following the colon is the port.

    
                        Locate DB instance server name and port

To connect to a DB Instance using SQL*Plus

You can use a utility like SQL*Plus to connect to an Amazon RDS DB instance running Oracle. SQL*Plus is part of the Oracle software distribution. To download a stand-alone version of SQL*Plus , see SQL*Plus User's Guide and Reference.

To connect to an Oracle DB instance using SQL*Plus

  • Type the following command on one line at a command prompt. Substitute the DNS name for your DB instance, then include the port and the Oracle SID. The SID value is the name of the instance's database that you specified when you created the DB instance, not the name of the DB instance.

    Note

    The shorter format connection string (Easy connect or EZCONNECT), such as sqlplus USER/PASSWORD@LONGER-THAN-63-CHARS-RDS-ENDPOINT-HERE:1521/DATABASE_IDENTIFIER, may encounter a maximum character limit and should not be used to connect.

    For Linux, OS X, or Unix:

    Copy
    sqlplus 'mydbusr@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<dns name of db instance>)(PORT=<listener port>))(CONNECT_DATA=(SID=<database name>)))'

    For Windows:

    Copy
    sqlplus mydbusr@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<dns name of db instance>)(PORT=<listener port>))(CONNECT_DATA=(SID=<database name>)))

    You will see output similar to the following.

    SQL*Plus: Release 11.1.0.7.0 - Production on Wed May 25 15:13:59 2011 SQL>

CLI

To connect to a DB Instance using the AWS CLI

  • Find the DNS name for your DB instance using the AWS CLI describe-db-instances command below.

    Copy
    aws rds describe-db-instances --headers

    You will see output similar to the following:

    DBINSTANCE  DBInstanceId  Created                   Class        Engine     Storage  Master Username  Status     Endpoint Address                             Port  AZ          Backup Retention  Multi-AZ  Version      Read Replica  Source ID  License
    DBINSTANCE  oracledb      2011-05-14T01:11:01.727Z  db.m1.small  oracle-ee  20       mydbusr          available  oracledb.mydnsnameexample.rds.amazonaws.com  1521  us-east-1a  1                 n         11.2.0.2.v3                           bring-your-own-license

Related Topics