Skip to content

Instantly share code, notes, and snippets.

@rayhassan

rayhassan/11g-install-notes.txt

Created May 11, 2017 13:38
Show Gist options
  • Save rayhassan/f6dc9be07b1fd65ab907840c73e8588f to your computer and use it in GitHub Desktop.
Save rayhassan/f6dc9be07b1fd65ab907840c73e8588f to your computer and use it in GitHub Desktop.
Download ZIP
Oracle 11G install notes + ASM - Virtualised
Raw
11g-install-notes.txt
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