Oracle RDS - achaltechlabs/AWS GitHub Wiki

C:\Users\achal.lute λ sqlplus 'aclorcl@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aclorcl.c4nwkmrqdp4t.us-west-2.rds.amazonaws.com)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))'

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 29 20:09:26 2017

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter password: ERROR: ORA-12560: TNS:protocol adapter error

C:\Users\achal.lute λ sqlplus aclorcl@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aclorcl.c4nwkmrqdp4t.us-west-2.rds.amazonaws.com)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 29 20:27:21 2017

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter password: ERROR: ORA-12170: TNS:Connect timeout occurred

Enter user-name: C:\Users\achal.lute λ sqlplus aclorcl@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aclorcl.c4nwkmrqdp4t.us-west-2.rds.amazonaws.com)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 29 20:35:46 2017

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining and Real Application Testing options

SQL>