Oracle Grid infrastructure Notes

Doing the install, Oracle ASM allocation unit size was set to 8

Grid install

The doc/patch number at is: 10404530
The db install is on disk 1 &2
The grid install is on disk 3
install slim_install – pkg install slim_install
Install missing library – pkg install pkg://solaris/library/motif
emdb rw user: usera
emdb rw password: password
emdb ro user: userb
emdb ro password: password

Helpful commends

Make sure the oracle listener is up or start-it

tnslsnr start

SQL*Plus: Release Production ON Tue Jul 10 16:49:45 2012
Copyright (c) 1982, 2011, Oracle.  ALL rights reserved.
Connected TO an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1.5400E+10 bytes
Fixed SIZE                  2241064 bytes
Variable SIZE            2046823896 bytes
DATABASE Buffers         1.3321E+10 bytes
Redo Buffers               29351936 bytes
DATABASE mounted.
DATABASE opened.
SQL> exit
Disconnected FROM Oracle DATABASE 11g Enterprise Edition Release - 64bit Production
WITH the Partitioning, Automatic Storage Management, OLAP, DATA Mining
AND REAL Application Testing options

Note: Make sure only the disk slice used by ASM to give Oracle access otherwise it wont start (on x86 its p0)

# To start cssd & asm
$GRID_HOME/bin/crsctl start res ora.cssd
$GRID_HOME/bin/crsctl start res ora.asm
# As per Oracle, do not use crs_stat, use below command to check status
crsctl stat res -t
crsctl stat res -t -init

General help…

# To start all resources
crs_start -all
# List resources status
crs_stat -t
Name           Type           Target    State     Host
ora.DATA.dg    ora....up.type ONLINE    ONLINE    emdb1
ora....ER.lsnr ONLINE    ONLINE    emdb1
ora.asm        ora.asm.type   ONLINE    ONLINE    emdb1
ora.cssd       ora.cssd.type  ONLINE    ONLINE    emdb1
ora.diskmon    ora....on.type ONLINE    UNKNOWN   emdb1
ora.evmd       ora.evm.type   ONLINE    ONLINE    emdb1
ora.orcl.db ONLINE    ONLINE    emdb1
# To start the listener
lsnrctl start
#ASM related stuff just run 
asmcmd # for example iostat, help for a list commends)
# Enable HAS auto start
crsctl enable has

DB session / process tuning

ALTER system SET processes=600 scope=spfile;
SELECT COUNT(*) FROM v$process;
SELECT COUNT(*) FROM v$session;
SHOW parameter processes;

Appendix A

ulimit -s unlimited
umask 022
export GI_HOME=/oracle/product/11.2.3/grid_1
export ORACLE_BASE=/oracle/db/11.2.3
export ORACLE_HOME=/oracle/db/11.2.3/db_1
export ORACLE_SID=orcl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/local/lib:/usr/lib
export SQLPATH=/usr/oracle/sql/tanel
PS1='\n\[\e[1;30m\]\[\033)0\016\]\[\]lq\[\017\033(B\](\[\e[1;37m\]\[\033[1;31m\]\u\[\033[00m\]@\[\033[1;31m\]\H\[\e[1;30m\])-(\[\e[1;34m\]\T\[\e[0;30m\])->\n\[\033)0\016\]\[\]mq\[\017\033(B\](\[\033[1;32m\]\w\[\e[1;30m\])--\[\033[1;32m\]> \[\e[0m\]\$ '
alias sql='sqlplus / as sysdba'
alias asmsql='sqlplus / as sysasm'
export ORACLE_UNQNAME=orcl
export ORACLE_HOSTNAME=emdb1
export ORACLE_HOME=/oracle/product/11.2.3/grid_1

Appendix B

/usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000
/usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500
/usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000
/usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500
/usr/sbin/ndd -set /dev/udp udp_xmit_hiwat 65536
/usr/sbin/ndd -set /dev/udp udp_recv_hiwat 65536

cat /etc/project


Appendix C

How to turn on debug mode

ecadm stop -w

SAVED_PARAM=`cacaoadm get-param -i oem-ec java-flags`
cacaoadm set-param -i oem-ec "$SAVED_PARAM -Dcom.sun.cacao.debug"

ecadm start -w

Access the R/W mode via

Note: No root password will be asked, so make sure to disable if not needed.

THEN: lets troubleshot the issue

  • Go in your browser[8082]/xvm/
  • After login you will be on EC – Ops Center Domain Model Navigator .
  • At left you have ‘Managed Resource Types ‘ , please click on ‘OperatingSystem’
  • Please identify at “UFN’ column the asset you want to remove.
  • Click on it (need to start with ‘NORM-‘) or the IP of asset at ‘Name’ column
  • Now you need get ‘Normalization Info’, at ‘Friendly Name’ it needs to appear ‘‘ name (or asset in question you tried to remove) .
  • Just navigate to the end of the page (of Normalized bean) and Click on the ‘UnRegister’ button
  • Now try to remove the asset from BUI.
  • If the asset still appear in BUI after you removed it, return steps above but change to ‘Server’ (step 3) . these are the steps I am using while having old entries

NEXT: Once completed

Go back to Domain Model read only mode as follows :

ecadm stop -w
cacaoadm set-param -i oem-ec "$SAVED_PARAM"
ecadm start -w


How to install grid doc1
How to install grid doc2
Oracle Grid install example
Grid install help
Oracle Grid & DB on VirtualBox
How to change scane IP address click here

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x
%d bloggers like this: