Exadata DB Compute node config

DB Node config : Compute node :

Do all prerequisite for database installation
such as : sysctl.conf , limits.conf , rpm install there after star the below steps


  1. sudo iptables -I INPUT 1 -p tcp --dport 5042 -j ACCEPT
  2. stop iptables for DB node :   /etc/init.d/iptables stop
  3. Ceate folder : /etc/oracle/cell/network-config
  4. create file : Cellip.ora , cellinit.ora
  5. Cellip.ora will contain the ip addressof cell node : e.g : cell="IP of cell node "
  6. Cellinit.ora will contail IP address of compute database node ipaddress1=10.0.0.50/24
  7. /oracle/app/grid/gr_home/bin/kfod disks=all op=disks


if you get error check


vi /oracle/app/grid/gr_home/bin/kfod
change $Oname to oracle home
export LD_LIBRARY_PATH=/oracle/app/grid/gr_home/lib
strace /oracle/app/grid/gr_home/bin/kfod disks=all op=disks

/root/oradiag_root/diag/clients/user_root/host_1857169048_107/trace

[root@dm01db01 trace]# /oracle/app/grid/gr_home/bin/kfod disks=all op=disks
--------------------------------------------------------------------------------
 Disk          Size Path                                     User     Group 
================================================================================
   1:     122880 MB /dev/sda                                 root     disk 
   2:       8192 MB /dev/sda10                               root     disk 
   3:       2000 MB o/10.0.0.100/DATA_CD_DISK01_exacel01                   
   4:       2000 MB o/10.0.0.100/DATA_CD_DISK02_exacel01                   
   5:       2000 MB o/10.0.0.100/DATA_CD_DISK03_exacel01                   
   6:       2000 MB o/10.0.0.100/DATA_CD_DISK04_exacel01                   
   7:       2000 MB o/10.0.0.100/DATA_CD_DISK05_exacel01                   
   8:       2000 MB o/10.0.0.100/DATA_CD_DISK06_exacel01                   
   9:       2000 MB o/10.0.0.100/DATA_CD_DISK07_exacel01                   
  10:       2000 MB o/10.0.0.100/DATA_CD_DISK08_exacel01                   
  11:       2000 MB o/10.0.0.100/DATA_CD_DISK09_exacel01                   
  12:       2000 MB o/10.0.0.100/DATA_CD_DISK10_exacel01                   
  13:       2000 MB o/10.0.0.100/DATA_CD_DISK11_exacel01                   
  14:       2000 MB o/10.0.0.100/DATA_CD_DISK12_exacel01                   
[root@dm01db01 trace]#


Start with Grid Install 

example of root.sh 

[root@dm01db01 trace]# /oracle/app/grid/gr_home/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /oracle/app/grid/gr_home

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /oracle/app/grid/gr_home/crs/install/crsconfig_params
The log of current session can be found at:
  /oracle/app/grid/crsdata/dm01db01/crsconfig/roothas_2020-04-09_09-48-06PM.log
2020/04/09 21:48:09 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node dm01db01 successfully pinned.
2020/04/09 21:48:30 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dm01db01'
CRS-2673: Attempting to stop 'ora.evmd' on 'dm01db01'
CRS-2677: Stop of 'ora.evmd' on 'dm01db01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dm01db01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.

dm01db01     2020/04/09 21:49:54     /oracle/app/grid/gr_home/cdata/dm01db01/backup_20200409_214954.olr     0   
2020/04/09 21:49:55 CLSRSC-327: Successfully configured Oracle Restart for a standalone server


ASMCMD> lsdsk --candidate -p
Group_Num  Disk_Num  Incarn  Mount_Stat  Header_Stat  Mode_Stat  State   Path
        0         4       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK01_exacel01
        0         2       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK02_exacel01
        0         7       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK03_exacel01
        0         1       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK04_exacel01
        0         0       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK05_exacel01
        0         5       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK06_exacel01
        0         6       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK07_exacel01
        0         9       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK08_exacel01
        0         8       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK09_exacel01
        0         3       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK10_exacel01
        0        11       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK11_exacel01
        0        10       0  CLOSED      CANDIDATE    ONLINE     NORMAL  o/10.0.0.100/DATA_CD_DISK12_exacel01

Previous
Next Post »

1 comments:

Click here for comments
kalyan
admin
June 25, 2021 at 12:15 PM ×

Thanks a lot for the nice document. ASM creation is getting failed every time. looking for some help.

Congrats bro kalyan you got PERTAMAX...! hehehehe...
Reply
avatar