BLOG

ORA-27102: out of memory

Posted on by Osama Mustafa in Database
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  

Configure E-mail For Oracle Enterprise manager DB 11gR2

Posted on by Osama Mustafa in Application
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

Error in invoking target ‘rat_on part_on dm_on olap_on sdo_on’

Posted on by Osama Mustafa in Operating system
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 ..  

sshUserSetup.sh & runcluvfy.sh

Posted on by Osama Mustafa in Database
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