Today morning, My one of the friend reported me oracle error: “ORA-00845: MEMORY_TARGET not supported on this system” He has installed Oracle 11g R2 & not able to startup newly created database on newly installed oracle.

After diagnosis, I came to know it was the problem with ‘tmpfs’ with low space available.

This error pops up due to we are using Automatic Memory Management (AMM) feature of Oracle 11g R2 on shared memory filesystem (shmfs) which is found less than required.

Solutions for the mentioned error:

• Increase value of oracle parameter: ‘memory_max_target’ & ‘memory_target’ and try to startup database.
• If above not working than delete ‘memory_target’ parameter from parameter file & try to startup database.
• If above not working than increase ‘tmpfs’ space.

Continue reading →

If you are connected to your ASM instance with SYSDBA & try to add disk to your existing diskgroup then mentioned error will be appeared.

Workaround for the oracle error: ‘ORA-15260: permission denied on ASM disk group’ & ‘ORA-15032: not all alterations performed’ is to connect your ASM instance as SYSASM.

// Please consider following example, in which i was failed to alter existing ASM diskgroup with as SYSDBA: ( In my case DATA is my existing DG )
[root@database1 ~]# su – oracle
[oracle@database1 ~]$ grid_env
[oracle@database1 grid]$ echo $ORACLE_HOME
/u01/app/11.2.0/grid
[oracle@database1 ~]$ sqlplus “/ as sysdba”

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 20 14:54:00 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> ALTER DISKGROUP DATA ADD DISK ‘/dev/oracleasm/disks/RMAN’ NAME DATA_0003 REBALANCE POWER 11;
ALTER DISKGROUP DATA ADD DISK ‘/dev/oracleasm/disks/RMAN’ NAME DATA_0003 REBALANCE POWER 11
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
// Now connect ASM instance as SYSASM as follow:

[oracle@database1 ~]$ grid_env

[oracle@database1 ~]$ sqlplus “/ as sysasm”

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 20 14:54:38 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> ALTER DISKGROUP DATA ADD DISK ‘/dev/oracleasm/disks/RMAN’ NAME DATA_0003 REBALANCE POWER 11;

Diskgroup altered.

SQL>

 

Enjoy… 🙂

***********************************************************************
Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Today, while oracle database startup we got “ORA-27154: post/wait create failed” error message. ( We have multiple databases running on same env. )

After diagnosis, it was the problem with kernel parameter: kernel.sem

SQL> startup

ORA-27154: post/wait create failed

ORA-27300: OS system dependent operation:semget failed with status: 28

ORA-27301: OS failure message: No space left on device

ORA-27302: failure occurred at: sskgpcreates

Continue reading →

Since couple of days, I have set cron job for oracle 11g database backup with the export utility. Every export backup, i have encountered “ORA-06510: PL/SQL: unhandled user-defined exception” & “ORA-06512: at SYS.DBMS_EXPORT_EXTENSION” warnings.

After searching web, I came to know that user who has backup oracle database is ordinary user & user having lack of execute privileges that: DBMS_EXPORT_EXTENSION and DBMS_DEFER_IMPORT_INTERNAL. Continue reading →

Today morning, I have encountered “RMAN-04007: WARNING from recovery catalog database” & “ORA-28002: the password will expire within 5 days” warnings while logged in to RMAN prompt for daily database activities as below.

[oracle@dbserver ~]$ rman target / catalog rman/rman123@cata
Recovery Manager: Release 11.2.0.3.0 – Production on Mon Mar 3 14:47:41 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Continue reading →