Oracle SQL Developer - Connecting to a connection

Question

I have created two connections DatabaseTest and sectest2.

When accessing DatabaseTest:

An error was encountered performing the requested operation:

Listener refused the connection with the following error: ORA-12528, TNS: listener: all

appropriate instances are blocking new connections

vendor code 12528

When accessing sectest2:

I have facing an error when trying to access the connections that I have created by following the videos posted in Oracle sql developer. The error says

IO Error: The network adapter could not establish the connection Vendor Code 17002

smshafiqulislam · Accepted Answer · 2017-03-26 11:29:32Z

1

ORA-12528, TNS: listener: all

appropriate instances are blocking new connections

Reason behind this might be any of the following:
1. Database is in restricted mode. If so, below command will resolve the problem:
sqlplus "/as sysdba"
alter system disable restricted session;
2. Database might be in such state that, it is not accepting connection. For example, in starting mode. Not yet open. Please check that.
Please check by running the below command:
select instance_name, status, database_status from v$instance;

IO Error: The network adapter could not establish the connection Vendor Code 17002

Check whether listen is up or not.

lsnrctl status;

answered Mar 26, 2017 at 11:29

smshafiqulislam

5946 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle SQL Developer - Connecting to a connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related