##########################
## Error
##########################
ORA-12560: TNS:protocol adapter error
##########################
# Error Occurred
##########################
I've created a new AWS RDS database and tried to connect the database using sqlplus from my laptop.
##########################
## Command Executed
##########################
sqlplus
**************************************** Step By Step Analysis ******************************************************
#########################################
# 1) Check the network connectivity
#########################################
Please check if the database inbound rules are allowed to connect this database.
Login to console and Choose RDS Under Database and then choose Instances
Select the Database you are trying to connect.
Click the Details Tab.
Click on the Security Groups. This will take you to the security groups page.
Click Inbound Tab and it shows its allowed to any ip.
=====================================================================================================================
##########################
## Solution
##########################
#########################################
# 2) Dont use Single Quotes
#########################################
While trying to connect from Windows command line don't use single quotes.
=====================================================================================================================
Establish the connection now and it works good.
=====================================================================================================================
=====================================================================================================================
Comments Are Always welcome
=====================================================================================================================
## Error
##########################
ORA-12560: TNS:protocol adapter error
##########################
# Error Occurred
##########################
I've created a new AWS RDS database and tried to connect the database using sqlplus from my laptop.
##########################
## Command Executed
##########################
sqlplus
**************************************** Step By Step Analysis ******************************************************
#########################################
# 1) Check the network connectivity
#########################################
Please check if the database inbound rules are allowed to connect this database.
Login to console and Choose RDS Under Database and then choose Instances
Select the Database you are trying to connect.
Click the Details Tab.
Click on the Security Groups. This will take you to the security groups page.
Click Inbound Tab and it shows its allowed to any ip.
=====================================================================================================================
##########################
## Solution
##########################
#########################################
# 2) Dont use Single Quotes
#########################################
While trying to connect from Windows command line don't use single quotes.
=====================================================================================================================
Establish the connection now and it works good.
=====================================================================================================================
=====================================================================================================================
Comments Are Always welcome
=====================================================================================================================
No comments:
Post a Comment