ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

August 30, 2012 7 Comments

Error description:

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Cause:

The database was crashed itself or you issued shutdown abort or startup force commands.

In my case I issued the following command, to take database into mount state.

SQL> startup mount force;

Solution:

SQL> select status from v$instance;

STATUS
————————————
MOUNTED

SQL> alter database open;

Database altered.

SQL> shutdown immediate;

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 88081064 bytes
Database Buffers 197132288 bytes
Redo Buffers 7139328 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

 

 

 

Filed under DB, Real World Scenarios Tagged with , , , ,

ORA-29701: unable to connect to Cluster Synchronization Service

August 20, 2012 Leave a comment

Error:

ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

Solution:

[grid@orcl ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 20 21:26:26 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
SQL> exit

[grid@orcl ~]$ crsctl start resource ora.cssd
CRS-2672: Attempting to start ‘ora.cssd’ on ‘orcl’
CRS-2679: Attempting to clean ‘ora.diskmon’ on ‘orcl’
CRS-2681: Clean of ‘ora.diskmon’ on ‘orcl’ succeeded
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘orcl’
CRS-2676: Start of ‘ora.diskmon’ on ‘orcl’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘orcl’ succeeded

[grid@orcl ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 20 21:32:40 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL>

Filed under DB Tagged with , , , ,

ORA-19554, ORA-27211: Failed to load Media Management Library

August 16, 2012 Leave a comment

Error text:

RMAN-03009: failure of allocate command on t1 channel at 03/30/2011 15:18:21
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information:2

Solution:

/usr/openv/netbackup/bin/libobk.so64 should have r-xr-xr-x

Or make link in $ORACLE_HOME/lib

cd $ORACLE_HOME/lib
ln -s /usr/openv/netbackup/bin/libobk.so64 libobk.so

Filed under DB Tagged with , , , ,

Changing SYSMAN password(can cause problems)

April 5, 2012 Leave a comment

After changing SYSMAN password from PL/SQL Developer, Enterprise Manager showed me: Agent Unreachable. I started to drill down and checked status of the agent on Oracle server. It showed me that agent was started. But after running the following: 

emctl upload

It showed me the exact error: ORA-28000: the account is locked.

Let’s clarify: I’ve changed SYSMAN password, but EM stores and uses the old password during connecting(because changes from PL/SQL developer was not reflected to EM repository) . That’s why SYSMAN account was going to lock.

If you try to go to the EM URL it will show some unusual messages, that database is in shutdown or needs recovery. Don’t do anything! (this is caused because of the SYSMAN password has been changed, neither database is down nor needs recovery)

Let’s just solve it.

1. Stop dbconsole

emctl stop dbconsole

2. Go to the file $ORACLE_HOME/<hostname_sid>/sysman/config/emoms.properties and change the following lines to:

oracle.sysman.eml.mntr.emdRepPwd=<your_new_password>

oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

Don’t worry about plain text password , it will be encrypted automatically after you save the file.

3. Start dbconsole

emctl start dbconsole

Enjoy!

Filed under DB Tagged with , , ,

ORA-20446: The owner of the job is not registered

October 31, 2011 1 Comment

If you have the following error in EM:

ORA-20446: The owner of the job is not registered ORA-06512: at "SYSMAN.MGMT_JOBS", line 168 ORA-06512: at "SYSMAN.MGMT_JOBS", line 86 ORA-06512: at line 1

It is said to be a bug in  Oracle 11g .

To solve this, you should login as a sys user and run the following command:

execute MGMT_USER.MAKE_EM_USER('USERNAME');

Filed under DB Tagged with ,