ORA-12528: Message 12528 not found

Posted on 2006-03-27
Medium Priority
Last Modified: 2008-03-10
after 10g database installation on windows 2003 server, db user creation
i did reboot my pc
then the lsnrctl command reply the follow

status blocked

at sql plus from client pc winxp with sql 8.0 i received the bleow error

 "ORA-12528: Message 12528 not found " 

please advice ASAP
Question by:ashkaat
LVL 44

Accepted Solution

Arthur_Wood earned 1000 total points
ID: 16299552
[Oracle][ODBC][Ora]ORA-12528: TNS:listener: all appropriate instances are blocking new connections

GOOGLE - search on ORACLE ORA-12528

LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 16299558
here is the full message:

regarding the "message not found", this indicates that some environment variables are not properly set.
Anyhow; looking at the alert.log file of your database should reveil the underlying problem(s)

Expert Comment

ID: 33912031
This is very common probelm in Oracle 10g. Shut down with immediate option once more and then do startup. This will resolve.


Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question