This content has been marked as final. Show 3 replies
It could be that the db is in a restricted state.
You could try the following using sql worksheet on a sysdba connection:
alter system disable restricted session;
If this solves the problem, great, but then the question is, why is it in a restricted state.
Data Miner, during upgrade or when a repository is dropped, puts the db into restricted mode.
If there is a failure during one of these processes, then it could be possible that the db was left in a restricted mode.
This generally should not happen when using Data Miner to perform these administrative actions, but could come up when running the scripts manually.
Here are some other links that may help.
There are a lot of results that come up when you google for this error.
ORA-12528: TNS:listener: all approriate instances are blocking new connecti
i am still facing the same problem , but when i tried to shutdown and startup oracle instance this msg appeared:
ORA-01507: database not mounted
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area __________ bytes
Fixed Size _______ bytes
Variable Size _______ bytes
Database Buffers _______ bytes
Redo Buffers ________ bytes
ORA-00204: error in reading <block 3, #block8> of control file
ORA-00202: control file :'D:\APP\ENGHAGAR\ORADATA\ORCL\CONTROL03.CTL'
ORA-27070: async read/write failed
OSD-04006: ReadFile<> failure, unable to read from file
O/S-error: <OS 1117> The request could not be performed because of an I/O device error.
another small question is how can i take print screen from sqlplus 11g window? the prt sc keyboard button did not work on this oracle forum window.
thanks a lot.