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
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
Do all prerequisite for database installation
such as : sysctl.conf , limits.conf , rpm install there after star the below steps
- sudo iptables -I INPUT 1 -p tcp --dport 5042 -j ACCEPT
- stop iptables for DB node : /etc/init.d/iptables stop
- Ceate folder : /etc/oracle/cell/network-config
- create file : Cellip.ora , cellinit.ora
- Cellip.ora will contain the ip addressof cell node : e.g : cell="IP of cell node "
- Cellinit.ora will contail IP address of compute database node ipaddress1=10.0.0.50/24
- /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
1 comments:
Click here for commentsThanks a lot for the nice document. ASM creation is getting failed every time. looking for some help.
ConversionConversion EmoticonEmoticon