Posts

Installation Guide for VM

https://drive.google.com/file/d/0BwyzpvMqgJ_3YlItckpZWlNaY0E/view?usp=sharing

HOW TO RESOLVE Internal error detected: java.lang.IllegalStateException:oracle.sysman.gcagent.target.interaction.execution.ConfigStateMgr

EM 12c : Agent Raises Periodically Alerts for Target Agent : Internal error detected: java.lang.IllegalStateException:oracle.sysman.gcagent.target.interaction.execution.ConfigStateMgr:798 (Doc ID 1458858.1)

How to import in oracle as sysdba

imp \"/ as sysdba\" parfile=imp_filename_dec2014.par file=/filesystem_path/SID/filename_in_dec2014.dmp log=/filesystem_path/SID/imp_filename_dec2014.log fromuser=USERA touser=USERB

How to Restoring an unresponsive VM

The following steps will help you revive an un-responsive KVM on your linux work station.... fixing an unresponsive VM..... 1. Launch a terminal from the linux session... and logon using sudo 2. make sure the VM file is running.. by running #virsh list --all 3. If the VM is not listed under the running VMs, then go to /etc/libvirt/qemu and check if xml file for the affected VM is there 4. check /var/lib/libvirt/qemu/save/ for a copy of the affected vm (vm_name.save) and delete it 5. run virsh start (vm_name) This five short steps can help you save your VM...

How to reset password in oracle database:

Use this query to get the password of the user in the database: select user#, name,password from SYS.user$ where name = '<USERNAME>'; Then use this below to reset the password alter user <username> identified by values '<PASSWORD>';

How to resolve ORA-27123 error:

when getting error while starting RAC db,  and all the raw device for storage has the right permission and +ASM is up but db refuse to start with below error: oradb@HOSTNAME01:/dev $ ls -lrt asm-disk* lrwxrwxrwx 1 root root 3 Mar  6 20:43 asm-disk3 -> sde lrwxrwxrwx 1 root root 3 Mar  6 20:43 asm-disk2 -> sdc lrwxrwxrwx 1 root root 3 Mar  6 20:43 asm-disk5 -> sdg lrwxrwxrwx 1 root root 3 Mar  6 20:43 asm-disk4 -> sdf lrwxrwxrwx 1 root root 3 Mar  6 20:48 asm-disk1 -> sdd oradb@HOSTNAME01:/dev $    INST_ID GROUP_NUMBER NAME                      State ---------- ------------ ------------------------- -----------          1            1 DG_01                     MOUNTED          1            2 FRA                       MOUNTED          1            3 OCR_VOTE                  MOUNTED    INST_ID NAME                      PATH                           State       HEADER_STATU ---------- ------------------------- ------------------------------ ----------- ------------        

How to repair a disk in a diskgroup

SUMMARY ======== "DG01" diskgroup cannot be mounted due to one disk member is missing: ====================================================== SQL> ALTER DISKGROUP DG01 MOUNT /* asm agent *//* {1:16801:2} */ NOTE: cache registered group DG01 number=1 incarn=0x2929b317 NOTE: cache began mount (first) of group DG01 number=1 incarn=0x2929b317 NOTE: Assigning number (1,1) to disk (/dev/asm-disk5) Sat Feb 14 06:41:49 2015 ERROR: no read quorum in group: required 1, found 0 disks NOTE: cache dismounting (clean) group 1/0x2929B317 (DG01) NOTE: messaging CKPT to quiesce pins Unix process pid: 7194, image: oracle@SLSLMEDIDBOP01 (TNS V1-V3) NOTE: dbwr not being msg'd to dismount NOTE: lgwr not being msg'd to dismount NOTE: cache dismounted group 1/0x2929B317 (DG01) NOTE: cache ending mount (fail) of group DG01 number=1 incarn=0x2929b317 NOTE: cache deleting context for group DG01 1/0x2929b317 GMON dismounting group 1 at 18 for pid 29, osid 7194 NOTE: Dis