Wednesday, August 21, 2013

ORA-27504: IPC error creating OSD context

Error:

Errors in file /u01/app/oracle/admin/DEMO/udump/demo1_ora_29106.trc:
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:skgxnqtsz failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: SKGXN not av
clsssinit ret = 21
interconnect information is not available from OCR
  WARNING: No cluster interconnect has been specified. Depending on
           the communication driver configured Oracle cluster traffic
           may be directed to the public interface of this machine.
           Oracle recommends that RAC clustered databases be configured
           with a private interconnect for enhanced security and
           performance.

Workaround:

Add this parameter in init file cluster_interconnects=192.168.1.201

ORA-15183: ASMLIB initialization error

Below errors received while creating 10g database on 11gR2 grid infrastructure 


Error:

Errors in file /u01/app/oracle/admin/DEMO/bdump/demo1_rbal_30217.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
Thu Jul 25 21:31:19 IST 2013
Errors in file /u01/app/oracle/admin/DEMO/bdump/demo1_rbal_30217.trc:
ORA-15183: ASMLIB initialization error [/opt/oracle/extapi/32/asm/orcl/1/libasm.so]
ORA-15183: ASMLIB initialization error [driver/agent not installed]
Thu Jul 25 21:31:19 IST 2013
Errors in file /u01/app/oracle/admin/DEMO/bdump/demo1_psp0_30162.trc:
ORA-00600: internal error code, arguments: [kfkLoadByNum03], [0x20006728], [], [], [], [], [], []
Thu Jul 25 21:31:20 IST 2013
Errors in file /u01/app/oracle/admin/DEMO/bdump/demo1_psp0_30162.trc:
ORA-00600: internal error code, arguments: [kfkLoadByNum03], [0x20006728], [], [], [], [], [], []
Thu Jul 25 21:31:20 IST 2013
PSP0: terminating instance due to error 490
Thu Jul 25 21:31:20 IST 2013
Trace dumping is performing id=[cdmp_20130725213120]
Thu Jul 25 21:31:22 IST 2013
Dump system state for local instance only
System State dumped to trace file /u01/app/oracle/admin/DEMO/bdump/demo1_diag_30160.trc
Thu Jul 25 21:31:22 IST 2013
Trace dumping is performing id=[cdmp_20130725213122]

Workaround:
          
as root user:
# cd $ORACLE_HOME/bin
# chgrp asmadmin oracle
# chmod 6751 oracle
# ls -l oracle


          
$ su - grid
[grid@vm11 ]$ /usr/sbin/oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=grid
ORACLEASM_GID=asmadmin
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
[grid@vm11 ]$ cd /u01/app/11.2.0.3/bin/
[grid@vm11 bin]$ ./setasmgidwrap o=/u01/app/oracle/product/10.2.0/bin/oracle
[grid@vm11 bin]$
 

How to add shared disks in Virtual Box





VBoxManage createhd --filename G:\VBOX\shared\asm1.vdi --size 1024 --format VDI --variant Fixed
VBoxManage createhd --filename G:\VBOX\shared\asm2.vdi --size 1024 --format VDI --variant Fixed
VBoxManage createhd --filename G:\VBOX\shared\asm3.vdi --size 4096 --format VDI --variant Fixed



VBoxManage.exe storageattach vm31 --storagectl "SATA" --port 1 --device 0 --type hdd --medium "G:\VBOX\shared\asm1.vdi" --mtype shareable
VBoxManage.exe storageattach vm31 --storagectl "SATA" --port 2 --device 0 --type hdd --medium "G:\VBOX\shared\asm2.vdi" --mtype shareable
VBoxManage.exe storageattach vm31 --storagectl "SATA" --port 3 --device 0 --type hdd --medium "G:\VBOX\shared\asm3.vdi" --mtype shareable


VBoxManage.exe storageattach vm32 --storagectl "SATA" --port 1 --device 0 --type hdd --medium "G:\VBOX\shared\asm1.vdi" --mtype shareable
VBoxManage.exe storageattach vm32 --storagectl "SATA" --port 2 --device 0 --type hdd --medium "G:\VBOX\shared\asm2.vdi" --mtype shareable
VBoxManage.exe storageattach vm32 --storagectl "SATA" --port 3 --device 0 --type hdd --medium "G:\VBOX\shared\asm3.vdi" --mtype shareable

PRCT-1011 : Failed to run "kfod" error while upgrading GI from 11.2.0.3 to 12.1.0.1



ERROR:
PRCT-1011 : Failed to run "kfod". Detailed error: WARNING: Using brute force method to determine the size of /dev/raw/rawctl.| There will be performance issues. Please check configuration to determine the cause for the failure of ioctl


Workaround:

Please remove  /dev/raw/rawctl file then retry upgrade