Contents
Oracle Grid infrastructure Notes
Doing the install, Oracle ASM allocation unit size was set to 8
Grid install
The doc/patch number at supporthtml.oarcle.com 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 SQL*Plus: Release 11.2.0.3.0 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 11.2.0.3.0 - 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 ora....er.type 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 ora....se.type 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; ALTER system SET SESSIONS=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 PATH=$GI_HOME:$GI_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$CRS_HOME/bin:usr/ccs/bin/:/usr/local/bin:/usr/bin:/usr/sbin:/usr/cluster/bin:/usr/local/bin:/bin:/usr/ucb #export ORACLE_SID=OC 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_SID=+ASM 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
oracle:102::::process.max-file-descriptor=(priv,65536,deny);process.max-sem-nsems=(priv,256,deny);project.max-sem-ids=(priv,100,deny);project.max-shm-ids=(priv,100,deny);project.max-shm-memory=(privileged,27179869184,deny)
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 http://ec-host.domain.com:8082
Note: No root password will be asked, so make sure to disable if not needed.
THEN: lets troubleshot the issue
- Go in your browser https://ec-host.domain.com:[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
References
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