Home » RDBMS Server » Server Administration » Error ORA-12528 (merged)
icon4.gif  Error ORA-12528 (merged) [message #325842] Mon, 09 June 2008 03:01 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
sir see this error when i try to login i my 10g last day i user rightly when i use today that give me this error



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



sir i post this problem in other form

he give me this idea

check the listener status and also reload the listener

sir how i check and reload listener

please give me idae how i use my oracle 10g database


thank you

aamir
Re: when i try to login my 10g that give me error ORA-12528 : TNS:listener: all appropriate instance [message #325866 is a reply to message #325842] Mon, 09 June 2008 05:13 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Check alert log files for more info.
Re: when i try to login my 10g that give me error ORA-12528 : TNS:listener: all appropriate instance [message #325869 is a reply to message #325842] Mon, 09 June 2008 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.

Quote:
[I] check the listener status

And what does this give you? Don't you want to share it with us?
Always copy and paste what you do.

Regards
Michel

[Updated on: Mon, 09 June 2008 05:17]

Report message to a moderator

Re: when i try to login my 10g that give me error ORA-12528 : TNS:listener: all appropriate instance [message #325909 is a reply to message #325842] Mon, 09 June 2008 08:29 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Oh no, not THIS guy again. He won't understand a single thing you tell him. He doesn't know what documentation is. I don't know how he even knows how to post a question based on his track record.
Re: when i try to login my 10g that give me error ORA-12528 : TNS:listener: all appropriate instance [message #325919 is a reply to message #325909] Mon, 09 June 2008 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I don't know how he even knows how to post a question based on his track record.


Laughing

see my error and my try (for ora-12528 ) new err ora-00202 [message #326078 is a reply to message #325842] Tue, 10 June 2008 02:21 Go to previous messageGo to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
i try to connect my 10g database but that give me this error

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

some body give me idea i try this


c:\>set oracle_sid=universi
c:\>sqlplus sys as sysdba
enter password :
connecyt to
oracle database 10g enterprise edition release

sql> select status from v$instance;
status
------------------
started

sql>alter database mount;

alter database mount
error at line 1:
ora-00204: error in reading <block 3, # blocks 8> of control file
ora-00202: control file:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIVERSI\CONTROL01.CTL'
ora-27091: UNABLE TO QUEUE 1/0
ora-27070: ASYNC READ/WRITE FAILED
OSD-04006: ReadFo;e<> failure, unable to read from file
O/S-Error <OS 23> Data error <cyclic redundancy check>.




but after this i fasing this error

ora-00202
ora-00204

please give me idea how i connect my 10g

thank you

Re: see my error and my try (for ora-12528 ) new err ora-00202 [message #326094 is a reply to message #326078] Tue, 10 June 2008 03:07 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The answer is the same to the same question your posted yesterday.
Don't repeat your question every day.
If you have something new to say, add it to the previous topic.

ORA-00202: control file: '%s'
 *Cause:  This message reports the name file involved in other messages.
 *Action: See associated error messages for a description of the problem.


Regards
Michel

[Updated on: Tue, 10 June 2008 03:08]

Report message to a moderator

Previous Topic: Inserting Record Problem
Next Topic: possible causes of database hung
Goto Forum:
  


Current Time: Sun Dec 04 10:54:46 CST 2016

Total time taken to generate the page: 0.06451 seconds