ORA-12528: TNS:listener: all approriate instances are blocking new connecti

from oracle forum:

The error message as below:

connecting ...ORA-12528: TNS: listiner: all appropriate instances are blocking new connections. 

The tes did not succeed.

some of the information you provided may be incorrect. 

Click back to review the information provided for net service name, 

or change login to change username

HOw to find listener to see if the service is in BLOCKED state:

C:\Documents and Settings\chinar>lsnrctl services

C:\>lsnrctl



LSNRCTL> services



post the output here.



also



SQL> select instance_name,  status, database_status from v$instance;

C:\Documents and Settings\FAY>sqlplus

C:\Documents and Settings\FAY>lsnrctl

SQL> select instance_name, status, database_status from v$instance;
 
INSTANCE_NAME    STATUS       DATABASE_STATUS
---------------- ------------ -----------------
orcl             STARTED      ACTIVE

SQL> shutdown
ORA-01507: database not mounted
 
 
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
 
Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             444599172 bytes
Database Buffers          159383552 bytes
Redo Buffers                7135232 bytes
ORA-00214: control file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL'
version 1723 inconsistent with file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL' version 1721
 
 
SQL> conn scott/tiger@orcl
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
 
 
Warning: You are no longer connected to ORACLE.

I had already asked for the database state (select name,open_mode,database_role from v$database) in my previous post.

The database is not getting mounted.The controlfile is not consistent.

control file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL'
version 1723 inconsistent with file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL' version 1721

1. Shutdown the database

2. Make a copy of all the controflies.

3. replace the control02.ctl with copy of control01.ctl

4. startup the database

5. Then try to login to the database.




https://forums.oracle.com/forums/thread.jspa?threadID=1098776&start=15&tstart=0