Posts

Showing posts from August, 2009

Can't change password for a user in solaris getting error permission denied

This error occurs when NIS LDAP or Shadow file is not sync properly Login as Root #passwd -r files username New Passwd Enjoy Cheers

Oracle Database console not able to start and giving error oracle 11 not running

WHat is the output of the following command? emctl status dbconsole. If not running emctl start dbconsole If still you are getting error If you want you can try also drop and recreate the repository again To drop $> emca -deconfig dbcontrol db -repos drop It will ask for Database name = Listerner port = 1521 or what ever you have specified To Recreate emca -config dbcontrol db -repos recreate This should solve your problem.

ORA 01172 recovery of thread 1 stuck at block 27269 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed

Error: ORA 01172 recovery of thread 1 stuck at block 27269 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed Cause: Crash recovery or instance recovery could not apply a change to a block because it was not the next change. This can happen if the block was corrupted and then repaired during recovery. Action: Perform a RECOVER datafile for the file containing the block. If this does not resolve the problem, then restore the file from a backup and recover it again. Are you archivelog or noarchivelog mode? Try this first 1. SHUTDOWN IMMEDIATE; 2. STARTUP MOUNT; 3. RECOVER DATABASE; 4. ALTER DATABASE OPEN; If this does not work then you will probably have to do media recovery. The type of recovery depends on type of archive mode you are running. Look at alert log for additional info such as file needing media recovery. The type of file needing recovery also determines type of recovery.