Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12528, TNS: Listener All appropriate instances are blocking new connect

465802Nov 6 2005 — edited Apr 3 2006

Hi all,

Im new to Oracle. Just installed Oracle XE on a Suse 9.3 machine. When I connect remotely to the machine (f.i with Aqua Data Studio) using JDBC I get the following error:

ORA-12528, TNS: Listener All appropriate instances are blocking new connections

When I run oracle-xe status I get the following result

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostip)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status BLOCKED, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

I must be doing something wrong. Anyone knows what ? Any help is appreciated!

regards
W.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2006

Added on Nov 6 2005

11 comments

6,561 views