Oracle 12.5.1.1 Error

Toad for Oracle & DevOps Toolkit
1

All:

Just loaded this application, and i’m getting the following error trying to connect:

ORA-12528-TNS:listener: all appropriate instances are blocking new connections.

I’m trying to connect to oracle XE for the first time but can’t seem to do it.

Any help would be appreciated.

Thanks.

2

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.

Action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.

Check instance status with sql:

select instance_name, HOST_NAME, status, to_char(STARTUP_TIME,‘dd.mm.yyyy hh24:mi:ss’) started from v$instance;
and
select name,open_mode,database_role from v$database;

where status column should be open (not started or mounted). and second query should confirm that (in a case of RAC instances).

if status is “open” then try next sql:

set ORACLE_SID=<YOUR_SID>
sqlplus "/as sysdba"
alter system disable restricted session;

which will terminate special kind of session restriction for privileged users.

Alse check listener staus with:

lsnrctl status

if you still get error, please give us output of next commands (full!):

set ORACLE_SID=<YOUR_SID>
sqlplus "/as sysdba"

shutdown immediate;
startup force;

Cheers!

3

Thanks, but I have no idea what you’re asking me to do. SQL? Where am I supposed to do that? The query window has all my buttons greyed out. I can’t run anything. Could I have specific directions, please.

Also, I re-installed XE 11g. I’m getting the following error:

ORA-12545: Connect failed because target host or object does not exist

I’m not sure what’s going on. I entered my SYSTEM and my password correctly. Apologies for my frustration, but I’ve been trying to create a simple database and this taken 2 whole days of my time.

Thanks.

4

try all commands from command prompt.

You invoke command prompt by Start|Run|cmd

then try all mine commands and output you get.