Home » RDBMS Server » Backup & Recovery » ORA-12528: TNS:listener: all appropriate instances are blocking new connections (oracle 10g on xp)
ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386751] Mon, 16 February 2009 23:05 Go to next message
venumsc2006
Messages: 7
Registered: February 2009
Junior Member
my databse oracle 10g on xp
iam getting this error ihave no idea about this
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Error.

Please can some body suggest me solution for this.


Thanx
Venu
Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386758 is a reply to message #386751] Mon, 16 February 2009 23:20 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

>Please can some body suggest me solution for this.

Read the contents of the URL & pay attention to where is say to use SEARCH & GOOGLE to find answers to FAQs.
Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386785 is a reply to message #386751] Tue, 17 February 2009 00:32 Go to previous messageGo to next message
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
Senior Member
@venumsc123,

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


Before following the below steps type services.msc and stop and strt the listener
Them try to connect to the database if not then try this,
Hope the below steps help you,
Open command Prompt and type cmd it will pop up you to the dos window type
--sqlplus sys/test as sysdba
--ShutDown Immediate
--Startup mount
--Alter Database open

Thanks and Regards,
Hammer

Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386792 is a reply to message #386785] Tue, 17 February 2009 00:44 Go to previous messageGo to next message
venumsc2006
Messages: 7
Registered: February 2009
Junior Member
Hi Hammer,

Thanks for the reply.

Till the Shutdown Immediate, it works fine.
On Startup mount, Getting the same error.

Thanx

Venu
Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386800 is a reply to message #386792] Tue, 17 February 2009 00:55 Go to previous messageGo to next message
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
Senior Member
@venumsc2006,

Can you post the exact error which hits your screen.Copy and paste the commands what you have typed in the cmd prompt.

Ok I think you have done like the below steps.

SQL> CONN SYS/TEST@ORCL AS SYSDBA
Connected.
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
SQL> EXIT;


Just type exit..

Follow the below steps which will work

C:\Documents and Settings\Administrator>SQLPLUS SYS/TEST AS SYSDBA
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Jan 6 12:41:59 2009
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> SHUTDOWN IMMEDIATE;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
Database mounted.


Then issue Alter Database open.


Thanks and Regards,
Hammer.

[Updated on: Tue, 17 February 2009 01:03]

Report message to a moderator

Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386808 is a reply to message #386800] Tue, 17 February 2009 01:06 Go to previous messageGo to next message
venumsc2006
Messages: 7
Registered: February 2009
Junior Member
Hi Hammer,

I pasted the Commands and results below & I attached a screenshot also.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\gfic-idc>sqlplus/nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Feb 17 12:29:42 2009

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected.
SQL> Shutdown Immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> Startup mount
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
SQL>


Thanx
Venu
  • Attachment: db_error.JPG
    (Size: 39.08KB, Downloaded 293 times)
Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386812 is a reply to message #386808] Tue, 17 February 2009 01:16 Go to previous messageGo to next message
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
Senior Member
@venumsc2006,
You are on your own.What i have given in my previous post explains you what needs to be done.

C:\Documents and Settings\gfic-idc>sqlplus/nolog



Instead of the above command you can try this

C:\Documents and Settings\gfic-idc>sqlplus  sys/.. as sysdba


Then follow the steps..

Thanks and Regards,
Hammer

[Updated on: Tue, 17 February 2009 01:17]

Report message to a moderator

Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386814 is a reply to message #386812] Tue, 17 February 2009 01:31 Go to previous messageGo to next message
venumsc2006
Messages: 7
Registered: February 2009
Junior Member
Hi Hammer,

Even though, I am getting the same error. I pasted the result here.


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\gfic-idc>sqlplus sys as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Feb 17 12:56:59 2009

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
With the Partitioning, OLAP and Data Mining options

SQL> Shutdown Immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> Startup mount
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
SQL>

Thanx
Venu
Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386817 is a reply to message #386814] Tue, 17 February 2009 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unset LOCAL (or TWO_TASK) variable.

Regards
Michel

[Updated on: Tue, 17 February 2009 01:52]

Report message to a moderator

Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386882 is a reply to message #386817] Tue, 17 February 2009 03:40 Go to previous messageGo to next message
venumsc2006
Messages: 7
Registered: February 2009
Junior Member
Can any one suggest solution for this

Thanx

Venu
Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386899 is a reply to message #386882] Tue, 17 February 2009 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 17 February 2009 08:52
Unset LOCAL (or TWO_TASK) variable.

Regards
Michel

Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386902 is a reply to message #386899] Tue, 17 February 2009 04:10 Go to previous messageGo to next message
venumsc2006
Messages: 7
Registered: February 2009
Junior Member
Hi Michel

Where Can I use 'Unset LOCAL (or TWO_TASK) variable.'

Thanx

Venu
Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386915 is a reply to message #386902] Tue, 17 February 2009 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Where it is set at DOS prompt, in registry...

Regards
Michel
Re: ORA-12528: TNS:listener: all appropriate instances are blocking new connections [message #386940 is a reply to message #386915] Tue, 17 February 2009 05:38 Go to previous message
venumsc2006
Messages: 7
Registered: February 2009
Junior Member
Hi Michel.

Thanks for reply.

Can you please give me full syntax of this ?

Thanx

Venu
Previous Topic: Rman Help (merged)
Next Topic: Which archive files are needed.
Goto Forum:
  


Current Time: Thu Dec 08 12:20:36 CST 2016

Total time taken to generate the page: 0.06043 seconds