Archive

Archive for the ‘Uncategorized’ Category

Changing the heap size of the OMS in EM12c

September 3, 2014 Leave a comment

em12c

2 ways to do it 

1. via emctl  increasing it to 4GB 

emctl set property -name JAVA_EM_MEM_ARGS
-value “-Xms256m -Xmx4096m -XX:MaxPermSize=768M -XX:+UseConcMarkSweepGC
-XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled
-XX:CompileThreshold=8000 -XX:PermSize=128m”

modify only the ‘-Xmx’ parameter to change the heap size for JAVA.
Leave all other parameters at their default,
including the defaults for the values of the ‘-Xms’ and/or ‘-XX’ parameters.

Stop and start OMS

emctl stop oms -all
emctl start oms

check the property 

emctl get property -name “JAVA_EM_MEM_ARGS”

 

2. via script startEMServer.sh script changing it to 4G 

cd /u01/app/oracle/middleware/oms12c/gc_inst/user_projects/domains/GCDomain/bin
cp startEMServer.sh startEMServer.sh.bak
edit startEMServer.sh

look for

if [ “${SERVER_NAME}” != “EMGC_ADMINSERVER” ] ; then
USER_MEM_ARGS=”-Xms256m -Xmx1024m -XX:MaxPermSize=612M -XX:-DoEscapeAnalysis -XX:+UseCodeCacheFlushing
-XX:ReservedCodeCacheSize=100M -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled”
if [ “${JAVA_VENDOR}” = “Sun” ] ; then
if [ “${PRODUCTION_MODE}” = “” ] ; then
USER_MEM_ARGS=”-Xms256m -Xmx1024m -XX:MaxPermSize=612M -XX:-DoEscapeAnalysis -XX:+UseCodeCacheFlushing
-XX:ReservedCodeCacheSize=100M -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled
-XX:CompileThreshold=8000 -XX:PermSize=128m”

change to

if [ “${SERVER_NAME}” != “EMGC_ADMINSERVER” ] ; then
USER_MEM_ARGS=”-Xms256m –Xmx4096m -XX:MaxPermSize=768M -XX:-DoEscapeAnalysis -XX:+UseCodeCacheFlushing
-XX:ReservedCodeCacheSize=100M -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled”
if [ “${JAVA_VENDOR}” = “Sun” ] ; then
if [ “${PRODUCTION_MODE}” = “” ] ; then
USER_MEM_ARGS=”-Xms256m –Xmx4096m -XX:MaxPermSize=768M -XX:-DoEscapeAnalysis -XX:+UseCodeCacheFlushing
-XX:ReservedCodeCacheSize=100M -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled
-XX:CompileThreshold=8000 -XX:PermSize=128m”

Stop and start OMS

emctl stop oms -all
emctl start oms

Check that your OMS has started up with the correct memory settings:

grep “JAVA Memory arguments” /u01/app/oracle/middleware12.1.0.4/oms12c/gc_inst2/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out

JAVA Memory arguments: -Xms256m –Xmx4096m -XX:MaxPermSize=768M -XX:-DoEscapeAnalysis -XX:+UseCodeCacheFlushing -XX:ReservedCodeCacheSize=100M -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled -XX:CompileThreshold=8000 -XX:-DoEscapeAnalysis -XX:+UseCodeCacheFlushing -XX:ReservedCodeCacheSize=100M -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled

 

 

 

Advertisements
Categories: Uncategorized

Oracle 12c RAC Upgrade – Best Practices

March 20, 2014 Leave a comment

Oracle 12c RAC Upgrade – Best Practices

Good webinar by Syed Jaffar Hussain about upgrading to oracle 12c 

 

Categories: Uncategorized

kill semaphore in Oracle Instance / remove shared memory from oracle instance

December 13, 2013 Leave a comment

if you have an issue after shutting down the instance you cannot start the instance it probably due to the fact that the semaphore of the instance is stil locked

#ipcs |grep oracle

Image

Set the ORACLE_SID

Image

sysresv is command to find symaphore attached to Instance.It will also shows shared memory address.

Image

To confrim

ipcs -a | grep oracle | grep <id> | grep <key>

 Image

To clean up symaphore.

ipcrm -s 5996551   <- ID
ipcrm -M 0x9fcf02b4 <- key

confirm that the semaphore is killed

#sysresv

IPC Resources for ORACLE_SID “rmancpr” :
Shared Memory
ID              KEY
No shared memory segments used
Semaphores:
ID              KEY
No semaphore resources used
Oracle Instance not alive for sid “rmancpr”

 

 

Categories: Uncategorized

Performance tuning: HugePages in Linux

December 13, 2013 Leave a comment

Performance tuning: HugePages in Linux

Good article on pythian about huge pages in Llinux

 

Categories: Uncategorized

No diagnostic or tuning pack , dont get robbed by Oracle

July 9, 2013 Leave a comment

To Track what features are being used in a database you can run the following sql

SELECT output FROM TABLE( DBMS_FEATURE_USAGE_REPORT.DISPLAY_TEXT);

Categories: Uncategorized

RAC Data Guard setup and management with Oracle 11gR2 (11.2.0.2)

April 9, 2013 Leave a comment

Dataguard setup for 11gr2

Guenadi N Jilevski's Oracle BLOG

RAC Data Guard setup and management with Oracle 11gR2 (11.2.0.2)

In the article we will look at Data Guard creation and management using both Oracle 11gR2 RAC as a primary and standby database. In the article OEL 5.4 and Oracle 11.2 Grid Infrastructure and RDBMS are used and ASM is used as storage. Oracle 11gR2 GI and RDBMS installation or update is a prerequisite for setup a DR primary and standby sites using RAC. The primary database is a RAC database created as described here.. The article will emphasize on creating and managing standby RAC database using sqlplus, RMAN and Data Guard Broker (dgmgrl) without OEM, whereas information related to OEM Grid Control 11g and Data Guard can be obtained here. The general approach for creating a DR standby database includes the following steps:

View original post 5,626 more words

Categories: Uncategorized

Add New Post ‹ Mike Desouza’s Blog — WordPress

June 7, 2012 Leave a comment
Categories: Uncategorized