Sunday, March 1, 2015

ORA-27102: out of memory

Operating system : Solaris Sparc 11.2
Database Version : 11.2.0.3.0

When Trying to startup the database the following error appeared :-

SQL> startup nomount ;
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument

Even when trying to know which instance process do this :-

SQL> oradebug setmypid
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory 

SQL> oradebug ipc
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory 

After investigation i found the cause for this error, the solaris SHMMAX was not set correctly on OS level which mean the database was configured more than permitted memory on OS.

to solve the above error

Find which project oracle user run using the below command :-

id -p
uid=59008(oracle) gid=10001(dba) projid=3(default)  

Then
prctl -n project.max-shm-memory -i project 3 

project: 3: default
NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT
project.max-shm-memory
        privileged      35GB      -   deny                                 -
        system          24EB    max   deny                                 -

So i have to increase it

prctl -n project.max-shm-memory -r -v 40G -i project 3

Note the above changes will be temporary till the next restart.

Cheers
Osama  

Apply psu on single database

This post describes how to apply PSU Patch on Single Node Oracle Database With Screenshot

To view the document from here

Cheers
Osama Mustafa

Thursday, February 26, 2015

Configure E-mail For Oracle Enterprise manager DB 11gR2

Sometimes you will be not be able to check the database out of the office, sick ....

Regarding to oracle documentation :-

The notification system allows you to notify Enterprise Manager administrators of alerts, policy violations, and the status changes of job executions. In addition to notifying administrators, the notification system can perform actions such as executing operating system commands (including scripts) and PL/SQL procedures when an alert is triggered.

Before Enterprise Manager can send e-mail notifications, you must first specify the Outgoing Mail (SMTP) servers to be used by the notification system. Once set, you can then define e-mail notifications for yourself or, if you have Super Administrator privileges, you can also define notifications for other Enterprise Manager administrators.

For More about E-Mail Notification Read here.


If everything is ready please follow the screen shot :-

Welcome Screen/Login Page


The Main Page, Click On preference on Upper Right :-

Add the E-mail below :-



If you need to schedule any Rule Just add it like the below :-


Cheers
Osama Mustafa


Tuesday, February 24, 2015

Error in invoking target 'rat_on part_on dm_on olap_on sdo_on'

Today while i was browsing on Oracle Fourms i found Threads related to 11gR2 Installation , the OP faced an error like the below :-



The above error related to Space On Temp File system all you have to do make sure that there is enough space on temp ( tmp ) or use the below command :-


export TMP=/u01/Foldername
export TMPDIR=/u01/Foldername

Try again now


Cheers
Osama ..  

Sunday, February 22, 2015

sshUserSetup.sh & runcluvfy.sh

Oracle 11gR2 RAC Grid install includes a useful script that can be used to make your life easier no more copying and waiting for errors the above scripts will make your easier simply.

./sshUserSetup.sh 

useful script to establish and exchange ssh keys between all the nodes of the cluster called sshUserSetup.sh

And Can Be Used like the below :-

./sshUserSetup.sh -user oracle -hosts "node1 node2" -noPromptPassphrase
./sshUserSetup.sh -user grid   -hosts "node1 node2" -noPromptPassphrase


./runcluvfy.sh

Cluster Verification Utility

Regarding to Oracle documentation :-

"performs system checks in preparation for installation, patch updates, or other system changes. Using CVU ensures that you have completed the required system configuration and preinstallation steps so that your Oracle Grid Infrastructure or Oracle Real Application Clusters (Oracle RAC) installation, update, or patch operation completes successfully."

you can learn More Here


Example :-
./runcluvfy.sh stage -pre crsinst -n  node1,node -fixup -verbose

How to apply new patch on siebel 8.2.2.4

In this post i will describe how to patch Siebel CRM Version 8.2.2.4

You Can check the document here

Cheers
Osama Mustafa

Wednesday, February 11, 2015

J2EE User Management Using DataWarehouse Builder

In this Document i explained how to Start and Create Control center management ( OC4J ) using Data Ware House Builder.

View Document from here

Cheers
Osama Mustafa