[52957] in SAPr3-news
2 issues with oracle upgrade to 9.2
daemon@ATHENA.MIT.EDU (yls177)
Thu Jan 13 07:52:20 2005
To: sapr3-news@mit.edu
Date: 13 Jan 2005 04:52:14 -0800
From: "yls177" <yls177@hotmail.com>
Message-ID: <1105620734.044864.152840@z14g2000cwz.googlegroups.com>
A) Hi. Are there any specified patches required for oracle upgrade to
9.2 from 8.1.7.2?
I am on hpux 11.0. From "oracle 9i installation guide, A96167_01.pdf",
it mentions about the below patches for HPUX 11.0
PHCO_23792
PHCO_24148
PHCO_24268
PHKL_24729
PHKL_25475
PHKL_25525
PHNE_24715
PHSS_23670
PHSS_24301
PHSS_22868
Want to seek your experience whether the upgrade will go well without
these patches?
B) # pwd
/tmp/cdrom
# ls
CDLABEL.ASC COPY_TM.TXT LABEL.EBC ORA92_1 ORA92_4
VERSION.EBC
CDLABEL.EBC CRCFILE.DAT LABELIDX.ASC ORA92_2 README.TXT
COPY_TM.HTM LABEL.ASC ORA9204P1 ORA92_3 VERSION.ASC
# more CDLABEL.ASC
ORACLE 9.2 64-BIT
RDBMS
HP-UX
Number 51030322
i mounted my cdrom in /tmp/cdrom
# ls -ltr /tmp | grep -i cdrom
dr-xr-xr-x 1 -1 -1 4096 Apr 7 2004 cdrom
# ls -ltr /tmp/cdrom/ORA92_1/UNIX
total 18
-r-xr-xr-x 1 -1 -1 6465 Aug 27 2002 UPGRADE.ORA
dr-xr-xr-x 1 -1 -1 2048 Oct 16 2002 HP11_64
#
Here is how i try to import the DVD data into my staging area.
myhost:oradev 93> pwd
/oracle/stage
myhost:oradev 94> ls -ltr 920_64
total 0
drwxr-xr-x 2 oradev dba 96 Jan 13 15:59 lost+found
myhost:oradev 95> /tmp/cdrom/ORA92_1/UNIX/UPGRADE.ORA
SAPCAR: processing archive /tmp/cdrom/ORA92_1/UNIX/HP11_64/OR192064.SAR
x Disk1
SAPCAR: can not create directory Disk1 (error 3). Permission denied
The unpack of the first package is ready
please insert the second ORACLE 9.2 CD
and call UPGRADE.ORA on this CD
Please advise.