Installing sqlplus to connect to RDS and run queries

Download Tools

Download the following packages:

Unzip both packages in any folder say Documents.

Copy all the contents of Sqlplus download into the installclient_11_2 folder.

Double click folder, and copy full path from address bar:

Path sample: “C:\Users\Administrator\Documents\instantclient_11_2”

System Configuration

Open “Control Panel” > “System and Security” > “System”.

Click “Change settings” > “Advanced” > “Environment Variable”.

On System variable: ”Click “Path” > “Edit”.

Paste at the beginning of the folder path: “[folderlocation]\instantclient_11_2;” (include the semicolon “;”)

Click OK, and to close all system windows.

Below is another file called tnsname.ora, download and place the file in the same folder "installclient_11_2.

Edit the file in any of your favourite editor:

Copy one entry say 'aws' and paste below.

Change the name of aws to a desired name (say qatest) and also change the HOST to the new RDS.

Save the file.

Opening SQL Plus:

Go to folder “[folderlocation]\instantclient_11_2” (where instantclient folder was unzipped)

Shift Right click, and click “Open command window here”

On command line prompt, type:

sqlplus username/password@qatest

where username: is the root username of the RDS instance

password is the root password of the RDS instance

qatest is the alias name that was provided in tnsnames.ora

To verify connection with database, type

Select * from cat;

Once connected, run the OracleInitial.sql file by dragging and dropping placing an @symbol in the beginning.

Now connect again using utp/utp@qatest

Run OracleAppvance.sql file by dragging and dropping the file placing an @symbol in the beginning.