 Error ORA-12528 (merged) [message #325842] |
Mon, 09 June 2008 03:01  |
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 #325869 is a reply to message #325842] |
Mon, 09 June 2008 05:16  |
 |
Michel Cadot
Messages: 68675
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 |
|
|
|
|
|
|
|
| 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 |
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 |
|
Michel Cadot
Messages: 68675
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
