ORA-12528 error

I am getting the error "ORA-12528: TNS:listener: all appropriate instances are blocking new connections."

Brian Peasland

Published: 09 Aug 2006

My database says:

java.sql.SQLException: Listener refused the connection 
with the following error: 
ORA-12528, TNS:listener: all appropriate instances 
are blocking new connections 
The Connection descriptor used by the client was: 
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=
(PROTOCOL=TCP)(HOST=192.168.0.18)(PORT=1521)))
(CONNECT_DATA=(SID=DBPMRB)(SERVER=DEDICATED)))

I shut down and restarted the database.

I addressed this issue in November 2004. You can see my answer here: ORA-12528 after shutting down and restarting instance. If that does not fix your problem, then on your database server, restart the Listener.

lsnrctl stop
lsrnctl start

Wait up to 10 minutes and then try to connect again.

Dig Deeper on Oracle database backup and recovery

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

SearchDataManagement

How AI data privacy can help your enterprise

Enterprises benefit in many ways from AI data privacy tools that reduce the need for manual efforts from data professionals. Read...

The new normal for enterprise data governance

Mastercard data exec highlights the foundational role of enterprise data governance during the pandemic era with more people ...

Oracle accelerates Exadata database cloud service

More powerful server hardware is coming to the Exadata database service, bringing increased scalability and throughput for ...

SearchBusinessAnalytics

Data literacy skills key to cost savings, revenue growth

As organizations develop data-driven cultures, they need to implement programs to teach employees how to work with and make ...

Yellowfin 9.3 features embedded app development upgrades

New application programming interfaces to help app designers build embedded BI apps are among more than 25 new features in the ...

Looker adds mobile app, developer tools to analytics suite

While Looker revealed no new integrations with Google, a mobile app and additional tools for developers highlight the new ...

SearchSAP

Decide on SAP S/4HANA Cloud: Single-tenant vs. multi-tenant edition

Understanding the benefits and limitations of S/4HANA Cloud versions is essential to making the right choice. Here are some ...

How 2 S/4HANA projects wrapped up remotely due to COVID-19

Here's how two SAP S/4HANA migration projects by De Nora Group and Vistaprint were completed on time after the COVID-19 crisis ...

Wookey returns to SAP to head Intelligent Spend unit

Industry veteran John Wookey is back at SAP to run the newly formed SAP Intelligent Spend and Business Network as SAP Ariba ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

3 ways to implement AI in software development

Further advancements to AI make it a more appealing and useful option for enterprise software development. Here are three ways to...

5 helpful tips to reduce webpage load time, improve performance

Nobody wants to wait for a webpage to load. Follow these tips to reduce website load time and improve the user experience for a ...

Is Apache Tomcat the right Java application server for you?

What is the best application server? The answer depends on what an enterprise is looking for. Compare Apache Tomcat to these four...

SearchDataCenter

Figure out the differences of asset management vs. CMDB

There is no shortage of software options for change management tools. Operational goals can help IT teams decide if ITAM or CMDB ...

IBM partners with HBCUs to promote quantum computing

IBM is partnering with a group of historically Black colleges and universities to set up a quantum computing center in hopes of ...

Learn SELinux commands for management and troubleshooting

SELinux provides a more secure way to run Linux servers. Key commands for status, file management and troubleshooting can help ...

SearchContentManagement

How automated content tagging improves findability

Companies that use AI to automatically tag their metadata can improve findability of content across the entire organization. AI ...

Hyland Software CEO discusses Alfresco, RPA, blockchain

Hyland moves on incorporating Another Monday RPA, Learning Machine blockchain credentials into its platform. Alfresco integration...

How businesses can best build a WordPress knowledge base

A WordPress knowledge base can be useful for companies that want an easy-to-use and customizable product with many plugins that ...

SearchHRSoftware

Tensions over politics at work have HR on guard

Politics at work may hurt productivity and office harmony. One strategy for defusing a charged atmosphere may be to get employees...

Top 9 tech skills HR professionals need for success

Today's HR departments are increasingly reliant on a range of technologies. That means human resources professionals must get ...

As contingent employee hiring rises, HR gives it focus

The use of contingent employees is increasing, Gartner said, and with it an interest from HR departments for better control over ...

Dig Deeper on Oracle database backup and recovery

Battle through the recurring Oracle TNS mistakes admins make

ORA-12514 error when connecting to the Oracle database through Toad

Why am I receiving the ORA-12535 error when using a remote database?

Solving common Oracle error codes guide

Related Q&A from Brian Peasland

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.