Created
May 11, 2017 13:38
-
-
Save rayhassan/f6dc9be07b1fd65ab907840c73e8588f to your computer and use it in GitHub Desktop.
Oracle 11G install notes + ASM - Virtualised
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://packages.vmware.com/tools/esx/5.5u1/repos/index.html | |
| yum install http://packages.vmware.com/tools/esx/5.5u1/repos/vmware-tools-repo-RHEL6-9.4.5-1.el6.x86_64.rpm | |
| yum install vmware-tools-esx-nox | |
| 20GB additional harddisk - for /u01/app/oracle | |
| /dev/sdb1 20G 44M 19G 1% /u01/app/oracle | |
| [root@dbhost2 ~]# grep sdb1 /etc/fstab | |
| [root@dbhost2 ~]# grep oracle /etc/fstab | |
| LABEL=/u01/app/oracle /u01/app/oracle ext4 defaults 1 2 | |
| yum install tuned | |
| 8 HDD | |
| 4 HDD's 100G each on scsi1, 1-4 | |
| 4 HDD's 100G each on scsi2, 1-4 | |
| [root@dbhost2 ~]# lsscsi | |
| [1:0:0:0] cd/dvd NECVMWar VMware IDE CDR10 1.00 /dev/sr0 | |
| [2:0:0:0] disk VMware Virtual disk 1.0 /dev/sda | |
| [2:0:1:0] disk VMware Virtual disk 1.0 /dev/sdb | |
| [2:0:4:0] disk VMware Virtual disk 1.0 /dev/sdc | |
| [3:0:0:0] disk VMware Virtual disk 1.0 /dev/sdd | |
| [3:0:1:0] disk VMware Virtual disk 1.0 /dev/sde | |
| [3:0:2:0] disk VMware Virtual disk 1.0 /dev/sdf | |
| [4:0:0:0] disk VMware Virtual disk 1.0 /dev/sdg | |
| [4:0:1:0] disk VMware Virtual disk 1.0 /dev/sdh | |
| [4:0:2:0] disk VMware Virtual disk 1.0 /dev/sdi | |
| [4:0:4:0] disk VMware Virtual disk 1.0 /dev/sdj | |
| [root@dbhost2 disks]# oracleasm createdisk DATA1 /dev/sdc1 | |
| Writing disk header: done | |
| Instantiating disk: done | |
| [root@dbhost2 disks]# oracleasm createdisk DATA2 /dev/sdd1 | |
| Writing disk header: done | |
| Instantiating disk: done | |
| [root@dbhost2 disks]# oracleasm createdisk DATA3 /dev/sde1 | |
| Writing disk header: done | |
| Instantiating disk: done | |
| [root@dbhost2 disks]# oracleasm createdisk DATA4 /dev/sdf1 | |
| Writing disk header: done | |
| Instantiating disk: done | |
| [root@dbhost2 disks]# oracleasm createdisk FRA1 /dev/sdg1 | |
| Writing disk header: done | |
| Instantiating disk: done | |
| [root@dbhost2 disks]# oracleasm createdisk FRA2 /dev/sdh1 | |
| Writing disk header: done | |
| Instantiating disk: done | |
| [root@dbhost2 disks]# oracleasm createdisk FRA3 /dev/sdi1 | |
| Writing disk header: done | |
| Instantiating disk: done | |
| [root@dbhost2 disks]# oracleasm createdisk FRA4 /dev/sdj1 | |
| Writing disk header: done | |
| Instantiating disk: done | |
| shmall | |
| [root@dbhost2 ~]# echo "16 * 1024^3 / 4096" | bc | |
| 4194304 | |
| shmmax | |
| [root@dbhost2 ~]# echo "16 * 1024^3 / 2" | bc | |
| 8589934592 | |
| [root@dbhost2 lib]# echo $LD_LIBRARY_PATH | |
| /u01/app/oracle/grid/stage/ext/bin/kfod | |
| [root@dbhost2 lib]# export LD_LIBRARY_PATH=/u01/app/oracle/grid/stage/ext/lib | |
| [root@dbhost2 lib]# /u01/app/oracle/grid/stage/ext/bin/kfod status=TRUE asm_diskstring='/dev/oraclasm/disks/*' disk=all | |
| /u01/app/oracle/grid/stage/ext/bin/kfod: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory | |
| [root@dbhost2 lib]# /u01/app/oracle/grid/stage/ext/bin/kfod status=TRUE asm_diskstring='/dev/oraclasm/disks/' disk=all | |
| /u01/app/oracle/grid/stage/ext/bin/kfod: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory | |
| # yum install /lib/libaio.so.1 | |
| Installed: | |
| libaio.i686 0:0.3.107-10.el6 | |
| from ntcontab.c:7: | |
| /usr/include/gnu/stubs.h:7:27: error: gnu/stubs-32.h: No such file or directory | |
| INFO: mv: cannot stat `ntcontab.o': No such file or directory | |
| Installed: | |
| glibc-devel.i686 0:2.12-1.132.el6_5.4 | |
| /u01/app/grid/product/11.2.0/grid/srvm/lib/libsrvm11.a: could not read symbols: File in wrong format | |
| collect2: ld returned 1 exit status | |
| mv -f /u01/app/grid/product/11.2.0/grid/lib/libsrvm11.so /u01/app/grid/product/11.2.0/grid/lib/libsrvm11.so0 | |
| mv: cannot stat `/u01/app/grid/product/11.2.0/grid/lib/libsrvm11.so': No such file or directory | |
| make[1]: [isrvm] Error 1 (ignored) | |
| mv -f libsrvm11.so /u01/app/grid/product/11.2.0/grid/lib/libsrvm11.so | |
| mv: cannot stat `libsrvm11.so': No such file or directory | |
| make[1]: [isrvm] Error 1 (ignored) | |
| - Linking Oracle OSDBA Group tool | |
| gcc -o osdbagrp -m32 -L/u01/app/grid/product/11.2.0/grid//lib/ -L/u01/app/grid/product/11.2.0/grid/lib/ -L/u01/app/grid/product/11.2.0/grid/lib/stubs/ -L/u01/app/grid/product/11.2.0/grid/lib/ -lirc -lipgo /u01/app/grid/product/11.2.0/grid/rdbms/lib/config.o /u01/app/grid/product/11.2.0/grid/srvm/lib/sprdbgrp.o /u01/app/grid/product/11.2.0/grid/srvm/lib/pradmgrp.o `cat /u01/app/grid/product/11.2.0/grid/lib/sysliblist` -Wl,-rpath,/u01/app/grid/product/11.2.0/grid/lib -lm `cat /u01/app/grid/product/11.2.0/grid/lib/sysliblist` -lm -lm -L/u01/app/grid/product/11.2.0/grid/lib | |
| /u01/app/grid/product/11.2.0/grid/rdbms/lib/config.o: could not read symbols: File in wrong format | |
| collect2: ld returned 1 exit status | |
| make[1]: Leaving directory `/u01/app/grid/product/11.2.0/grid/srvm/lib' | |
| make[1]: *** [osdbagrp] Error 1 | |
| make: *** [iodbagrp] Error 2 | |
| [root@dbhost2 ~]# mount -o remount,size=12g /dev/shm | |
| [root@dbhost2 ~]# df -h | |
| Filesystem Size Used Avail Use% Mounted on | |
| /dev/mapper/vg_dbhost2-lv_root 18G 7.0G 9.3G 43% / | |
| tmpfs 12G 0 12G 0% /dev/shm | |
| /dev/sda1 477M 77M 375M 17% /boot | |
| shmfs 12G 0 12G 0% /dev/shm | |
| /dev/sdb1 20G 4.6G 15G 25% /u01/app/oracle | |
| [root@dbhost2 app]# lsscsi | |
| [1:0:0:0] cd/dvd NECVMWar VMware IDE CDR10 1.00 /dev/sr0 | |
| [2:0:0:0] disk VMware Virtual disk 1.0 /dev/sda | |
| [2:0:1:0] disk VMware Virtual disk 1.0 /dev/sdb | |
| [2:0:4:0] disk VMware Virtual disk 1.0 /dev/sdc | |
| [3:0:0:0] disk VMware Virtual disk 1.0 /dev/sdd | |
| [3:0:1:0] disk VMware Virtual disk 1.0 /dev/sde | |
| [3:0:2:0] disk VMware Virtual disk 1.0 /dev/sdf | |
| [4:0:0:0] disk VMware Virtual disk 1.0 /dev/sdg | |
| [4:0:1:0] disk VMware Virtual disk 1.0 /dev/sdh | |
| [4:0:2:0] disk VMware Virtual disk 1.0 /dev/sdi | |
| [4:0:4:0] disk VMware Virtual disk 1.0 /dev/sdj | |
| [5:0:0:0] disk VMware Virtual disk 1.0 /dev/sdk | |
| [root@dbhost2 app]# fdisk /dev/sdk | |
| Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel | |
| Building a new DOS disklabel with disk identifier 0xaa4e1ceb. | |
| Changes will remain in memory only, until you decide to write them. | |
| After that, of course, the previous content won't be recoverable. | |
| Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) | |
| WARNING: DOS-compatible mode is deprecated. It's strongly recommended to | |
| switch off the mode (command 'c') and change display units to | |
| sectors (command 'u'). | |
| Command (m for help): q | |
| [root@dbhost2 app]# fdisk -cu /dev/sdk | |
| Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel | |
| Building a new DOS disklabel with disk identifier 0x7f087f04. | |
| Changes will remain in memory only, until you decide to write them. | |
| After that, of course, the previous content won't be recoverable. | |
| Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) | |
| Command (m for help): t | |
| No partition is defined yet! | |
| Command (m for help): n | |
| Command action | |
| e extended | |
| p primary partition (1-4) | |
| t | |
| Invalid partition number for type `t' | |
| Command action | |
| e extended | |
| p primary partition (1-4) | |
| p | |
| Partition number (1-4): 1 | |
| First sector (2048-41943039, default 2048): | |
| Using default value 2048 | |
| Last sector, +sectors or +size{K,M,G} (2048-41943039, default 41943039): | |
| Using default value 41943039 | |
| Command (m for help): t | |
| Selected partition 1 | |
| Hex code (type L to list codes): L | |
| 0 Empty 24 NEC DOS 81 Minix / old Lin bf Solaris | |
| 1 FAT12 39 Plan 9 82 Linux swap / So c1 DRDOS/sec (FAT- | |
| 2 XENIX root 3c PartitionMagic 83 Linux c4 DRDOS/sec (FAT- | |
| 3 XENIX usr 40 Venix 80286 84 OS/2 hidden C: c6 DRDOS/sec (FAT- | |
| 4 FAT16 <32M 41 PPC PReP Boot 85 Linux extended c7 Syrinx | |
| 5 Extended 42 SFS 86 NTFS volume set da Non-FS data | |
| 6 FAT16 4d QNX4.x 87 NTFS volume set db CP/M / CTOS / . | |
| 7 HPFS/NTFS 4e QNX4.x 2nd part 88 Linux plaintext de Dell Utility | |
| 8 AIX 4f QNX4.x 3rd part 8e Linux LVM df BootIt | |
| 9 AIX bootable 50 OnTrack DM 93 Amoeba e1 DOS access | |
| a OS/2 Boot Manag 51 OnTrack DM6 Aux 94 Amoeba BBT e3 DOS R/O | |
| b W95 FAT32 52 CP/M 9f BSD/OS e4 SpeedStor | |
| c W95 FAT32 (LBA) 53 OnTrack DM6 Aux a0 IBM Thinkpad hi eb BeOS fs | |
| e W95 FAT16 (LBA) 54 OnTrackDM6 a5 FreeBSD ee GPT | |
| f W95 Ext'd (LBA) 55 EZ-Drive a6 OpenBSD ef EFI (FAT-12/16/ | |
| 10 OPUS 56 Golden Bow a7 NeXTSTEP f0 Linux/PA-RISC b | |
| 11 Hidden FAT12 5c Priam Edisk a8 Darwin UFS f1 SpeedStor | |
| 12 Compaq diagnost 61 SpeedStor a9 NetBSD f4 SpeedStor | |
| 14 Hidden FAT16 <3 63 GNU HURD or Sys ab Darwin boot f2 DOS secondary | |
| 16 Hidden FAT16 64 Novell Netware af HFS / HFS+ fb VMware VMFS | |
| 17 Hidden HPFS/NTF 65 Novell Netware b7 BSDI fs fc VMware VMKCORE | |
| 18 AST SmartSleep 70 DiskSecure Mult b8 BSDI swap fd Linux raid auto | |
| 1b Hidden W95 FAT3 75 PC/IX bb Boot Wizard hid fe LANstep | |
| 1c Hidden W95 FAT3 80 Old Minix be Solaris boot ff BBT | |
| 1e Hidden W95 FAT1 | |
| Hex code (type L to list codes): 82 | |
| Changed system type of partition 1 to 82 (Linux swap / Solaris) | |
| Command (m for help): w | |
| The partition table has been altered! | |
| Calling ioctl() to re-read partition table. | |
| Syncing disks. | |
| [root@dbhost2 app]# partprobe /dev/sdk | |
| [root@dbhost2 app]# mkswap -L SWAP2 /dev/sdk2 | |
| /dev/sdk2: No such file or directory | |
| [root@dbhost2 app]# mkswap -L SWAP2 /dev/sdk1 | |
| Setting up swapspace version 1, size = 20970492 KiB | |
| LABEL=SWAP2, UUID=66a1a67e-d162-4d1f-a6e4-fc1166baa038 | |
| [root@dbhost2 app]# vi /etc/fstab | |
| [root@dbhost2 app]# | |
| [root@dbhost2 app]# | |
| [root@dbhost2 app]# swapon -a | |
| [root@dbhost2 app]# swapon -s | |
| Filename Type Size Used Priority | |
| /dev/dm-1 partition 2097148 0 -1 | |
| /dev/sdk1 partition 20970492 0 -2 | |
| [root@dbhost2 app]# free -m | |
| total used free shared buffers cached | |
| Mem: 16049 11176 4872 0 94 10346 | |
| -/+ buffers/cache: 736 15313 | |
| Swap: 22526 0 22526 | |
| [Thread-237] [ 2014-09-15 11:05:46.314 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=channel ORA_DISK_1: starting datafile backup set restore | |
| [Thread-237] [ 2014-09-15 11:05:46.315 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=channel ORA_DISK_1: specifying datafile(s) to restore from backup set | |
| [Thread-237] [ 2014-09-15 11:05:46.315 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=channel ORA_DISK_1: restoring datafile 00003 to +DATADG | |
| [Thread-237] [ 2014-09-15 11:05:46.316 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/12.1.0/NXORA/assistants/dbca/templates/Seed_Database.dfb | |
| [Thread-237] [ 2014-09-15 11:05:53.321 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=channel ORA_DISK_1: ORA-19870: error while restoring backup piece /u01/app/oracle/product/12.1.0/NXORA/assistants/dbca/templates/Seed_Database.dfb | |
| [Thread-237] [ 2014-09-15 11:05:53.321 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-19504: failed to create file "+DATADG" | |
| [Thread-237] [ 2014-09-15 11:05:53.321 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-17502: ksfdcre:4 Failed to create file +DATADG | |
| [Thread-237] [ 2014-09-15 11:05:53.321 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-15001: diskgroup "DATADG" does not exist or is not mounted | |
| [Thread-237] [ 2014-09-15 11:05:53.322 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-15064: communication failure with ASM instance | |
| [Thread-237] [ 2014-09-15 11:05:53.322 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-15295: ASM instance software version 12.1.0.1.0 less than client version 12.1.0.2. | |
| [Thread-237] [ 2014-09-15 11:05:53.327 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=failover to previous backup | |
| [Thread-237] [ 2014-09-15 11:05:53.328 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output= | |
| [Thread-237] [ 2014-09-15 11:05:53.346 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=creating datafile file number=3 name=+DATADG | |
| [Thread-237] [ 2014-09-15 11:05:56.505 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=RMAN-00571: =========================================================== | |
| [Thread-237] [ 2014-09-15 11:05:56.505 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== | |
| [Thread-237] [ 2014-09-15 11:05:56.505 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=RMAN-00571: =========================================================== | |
| [Thread-237] [ 2014-09-15 11:05:56.505 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=RMAN-03002: failure of restore command at 09/15/2014 11:05:56 | |
| [Thread-237] [ 2014-09-15 11:05:56.505 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-01119: error in creating database file '+DATADG' | |
| [Thread-237] [ 2014-09-15 11:05:56.505 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output= | |
| [Thread-237] [ 2014-09-15 11:05:56.506 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-15001: diskgroup "DATADG" does not exist or is not mounted | |
| [Thread-237] [ 2014-09-15 11:05:56.506 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-15064: communication failure with ASM instance | |
| [Thread-237] [ 2014-09-15 11:05:56.506 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=ORA-15295: ASM instance software version 12.1.0.1.0 less than client version 12.1.0.2.0 | |
| [Thread-237] [ 2014-09-15 11:05:56.506 BST ] [RMANEngine.readSqlOutput:889] Log RMAN Output=RMAN-06956: create datafile failed; retry after removing +DATADG from OS |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment