Tag: Osama mustafa

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

Unable to Ping ESXI 5.5 Host

Posted on by Osama Mustafa in Others
while i am continue working on my  Lab and configure ESXI i faced another problem and took 2 days to solve it maybe someone faced this issue but this will help other people as well.

The problem description like this :- after assigned IP to the server i want like normal people connect to this server using my laptop but simply when trying to ping :-

“Detestation unreachable” 

I thought at first it was my network card issue and maybe it’s not supported By ESXI, But this is not valid option because the weirdest part in this issue was when restart the server and ESXI loading the services i was able to ping without any problem then the message appeared again.

as you see from the above screenshoot ping then not ping !!!!!
The solution very simple i start missing with BIOS options and found new option there called “Network Stack” all you have to do is enable this option and link to IPV4.
Cheers
Osama Mustafa

2014 Achievement as an Oracle ACE

Posted on by Osama Mustafa in News
2014 is almost finished , new year will starting soon usually i don’t list what i have done, but there is always start point for everything. it was very busy year on all level : Personal, Work and as oracle ACE.

One of the major achievement for me this year is created and lead Jordan Amman Oracle User group which is the first Oracle Group in Jordan and I am working now to organize next event for this group and this is taking most of time now.

The 2014 Summary :-

Let’s Start with Conference :-

  • Dublin Conference.
  • Dubai Conference.
  • OTN Mena Tour.
  • Dublin Again 🙂 
  • Oracle open World.
  • New Zealand.
Sure during most of these conferences i was organizing RAC ATTACK Event around the world and simply it successful year for this amazing event.
Don’t forget the webinar as well. 
I have to mention One of the most amazing event all the time which is oracle open world, This is was my first time in SF OOW I met most of the people in oracle community i will try to mention all of them but i am sorry if i forgot someone :-
  • Gurcan Orhan
  • Yury Velikanov
  • Kai Yu
  • Jeff Smith 
  • Kellyn PotVin-Gorman.
  • Danny Bryant
  • Don Seiler.
  • Steve karam
  • Sarah Craynon Zumbrum
  • Leighton Nelson
  • René Antúnez Berdejo ( i met twice this year ) .
  • Francisco Munoz ( i met him in NZ ).
And Sure other People , my first time in OOW was my first time to present in this Big Event I would like to thank Debra Lilley to give me this chance 🙂
I also enjoyed my time with best company Gurcan Orhan He is amazing person and would like to meet him again who knows next conference or maybe in Turkey.
i enjoyed my time hanging out with ACE and ACED, a lot of activity to do in OOW such as presentation, Concert .. etc.
don’t forgot this year i wrote three articles to different magazine and i still have a lot of different topics to share, My Blog  i wrote blog post related to fusion middleware and Timesten in memory database most of these article what i faced in my real life challenging but amazing at the same time.
i was the first one in the middle east ( Jordan ) who appeared in Oracle Magazine Peer to Peer Thanks for Oracle ACE program i am really proud to be member of this amazing community.
I created magazine on flip-board that collect all the good articles posted by oracle community and share under one place and i am contribute in another one  Thanks for my friend Leighton Nelson.
the both magazine are simply amazing both sharing different idea.
I also passed Fusion middleware exam and upgrade my OCP certification. 
Finally I am really proud of one of the most achievement for this year which is created JAOUG ( Jordan Amman Oracle user group) i am working too hard to make this group success, i would like to give special thanks to Heli Helskyaho who supported me and gave me an idea to launch the group when i was in OOW.
i am sure 2015 will bring new things to me, 2014 was amazing year and fun at the same time. “Enshalla” 2015 will be more interesting i welcome any new challenge.
Cheers
Osama Mustafa

TT6003: Lock request denied because of time-out

Posted on by Osama Mustafa in Database
Trying to create cache group lead to the below error :-

java.sql.SQLException: [TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT6003: Lock request denied because of time-out
Details: Tran 143.23106 (pid 19946) wants Sn lock on rowid BMUFVUAAAAxogAALDp, table SUBSCRIBER. But tran 144.67398 (pid 19946) has it in Xn (request was Xn). Holder SQL (select ID,identifierType,identifiervalue,subscriberId,groupName,siid from subscriptionidentifie…) — file “tindex.c”, lineno 4277, procedure “sbTixNext()”

After check the Timesten parameter found the issue was with LockWait

Lockwait :- Allows an application to configure the lock wait interval for the connection.

LockWait may be set to any value between 0 and 1,000,000 inclusive to a precision of
tenths of a second. The default is 10 seconds.

Actual lock wait response time is imprecise and may be exceeded by up to one tenth of
a second, due to the scheduling of the agent that detects timeouts. This imprecision
does not apply to zero second timeouts, which are always reported immediately.

Cheers

Osama …

Cannot Integrated JDeveloper with SOA Server

Posted on by Osama Mustafa in Application
When trying to integrated JDeveloper with SOA server the below error Appeared :-

Testing JSR-160 Runtime … failed.
Cannot establish connection.
Testing JSR-160 DomainRuntime … skipped.
Testing JSR-88 … skipped.
Testing JSR-88-LOCAL … skipped.
Testing JNDI … skipped.
Testing JSR-160 Edit … skipped.
Testing HTTP … success.
Testing Server MBeans Model … skipped.

all my searching on internet not working most of the blogs indicate it’s proxy setting which is already disables in my case.

After invesgtation and check logs on the both side adminserver and Jdeveloper i found it’s DNS server issue therefore i edited hosts in windows like the below

Adminserver-IP   Hostname

After do this and put hostname instead of IP it’s worked Successfully.

Cheers
Osama Mustafa