Problem
oracle connected to idle instance after patch oracle 10.2.0.2.0 to 10.2.0.4.0, OMU can not connect to oracle
$sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 10 13:38:27 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL>connect /as sysdba
Connected to idle instance
Log “alert_openview.log” error :
Mon Mar 9 18:17:14 2009
Errors in file /opt/oracle/admin/openview/udump/openview_ora_15384.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Mon Mar 9 18:17:14 2009
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 15384
Solution :
1. start a new sqlplus session
2. fire the following command on sqlplus
STARTUP UPGRADE
3. The database now opens successfully after which catalog and cataproc
sql's can be fired.
4. Now shutdown and startup the database as the database was started
with UPGRADE option.
There are 2 ways to mount iso file in hp-ux 1) using LVM method (to copy ISO into a logical volume) is the same as for older HP-UX releases: 1. Find out the size of the ISO image: # du -k /data/myImage.iso NOTE: The size will be in Kb. 2. Create a logical volume for the ISO image: # lvcreate -L -n iso /dev/vg00 NOTE: The name of the logical volume will be /dev/vg00/iso 3. Copy the ISO file to the raw logical volume: # dd if=/data/myImage.iso of=/dev/vg00/riso bs=64k 4. Create a temporary directory and mount the /dev/vg00/iso volume # mkdir /iso_image # mount /dev/vg00/iso /iso_image NOTE: For HP-UX 11.11 you must install the latest CDFS patches: PHCO_25841 Add Rock Ridge extension to mount_cdfs(1M) PHKL_26269 Rock Ridge extension for ISO-9660 PHKL_34153 CDFS cumulative patch 2) Available in HP-UX 11.31 0909: ISOIMAGE-ENH. Provides a new DLKM module fspd. Required to mount, read and umount the ISO image file. The comm...
Comments