Home » RDBMS Server » Server Administration » apply patchset for 8.1.7.0 upgrade to 8.1.7.4
icon9.gif  apply patchset for 8.1.7.0 upgrade to 8.1.7.4 [message #142471] Fri, 14 October 2005 12:31 Go to next message
roones3
Messages: 3
Registered: October 2005
Junior Member
I wanted to upgrade my 8.1.7.0 Oracle on HP-UX (11.0).

During the install I saw errors that I ignored:

Exception thrown from action: copyGroupFromJar
Exception Name: IOException2
Exception String: Error in writing to file /u01/oracle/lib/libwtc8.sl
Exception Severity: 2
Exception handling set to prompt user with options to RETRY IGNORE
User choice : Ignore
Calling action fileActions1.7.1.7.0 copyGroupFromJar
selectedNodes = null
copyGroup = lib
permissions = null
owner = null
group = null
copyAsText = null
JarLoc = /tmp/OraInstall/temp312

Exception thrown from action: copyGroupFromJar
Exception Name: IOException2
Exception String: Error in writing to file /u01/oracle/lib/libclntsh.sl.8.0
Exception Severity: 2
Exception handling set to prompt user with options to RETRY IGNORE
User choice : Ignore
Starting install install phase 1 of component Oracle Database Utilities Patch
Calling action fileActions1.7.1.7.0 copyGroupFromJar
selectedNodes = null
copyGroup = bin
permissions = 755
owner = null
group = null
copyAsText = null
JarLoc = /tmp/OraInstall/temp421

Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target install of makefile /u01/oracle/rdbms
/lib/ins_rdbms.mk
Exception Severity: 1
Calling action unixActions1.7.1.8.0 make
installMakePath = /usr/ccs/bin/make
installMakeFileName = /u01/oracle/network/lib/ins_net_server.mk
installTarget = install
undoMakeFileName =
installArguments = ORACLE_HOME=/u01/oracle,
logFile = /u01/oracle/install/make.log
undoTarget =

Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target install of makefile /u01/oracle/rdbms
/lib/ins_rdbms.mk
Exception Severity: 1
Calling action unixActions1.7.1.8.0 make
installMakePath = /usr/ccs/bin/make
installMakeFileName = /u01/oracle/plsql/lib/ins_plsql.mk
installTarget = install
undoMakeFileName =
installArguments = ORACLE_HOME=/u01/oracle,
logFile = /u01/oracle/install/make.log
undoTarget =

It told me I was "successful", but when I tried to start the instance, the svrmgrl would hang and never come to the SVRMGR> prompt.

I then restored the /u01 directory from backup, and I tried to start the instance, but got this message:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/oradata/acp/system01.dbf'

Would that file have not been recovered from my restore?

So I am stuck with no ORACLE now.
Re: apply patchset for 8.1.7.0 upgrade to 8.1.7.4 [message #142656 is a reply to message #142471] Mon, 17 October 2005 02:25 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

I dont know much about applying patches... but as far as the error mention by you
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/oradata/acp/system01.dbf'

says that your system01.dbf datafile requires recovery.

If your database was running in archive log mode then

 Restore the backed up data file
o Copy the backed up data file to original location

 Go to Server Manager(8i)/sql(9i).

 Issue following commands :
 SQL>Startup mount.
• You will see an error ora-1113:file 9 needs media recovery
 SQL>Recover database.
 SQL>Alter database open.
---------------------------------------------------------------

Regards
Always Friend Sunilkumar
Re: apply patchset for 8.1.7.0 upgrade to 8.1.7.4 [message #142751 is a reply to message #142656] Mon, 17 October 2005 09:23 Go to previous messageGo to next message
roones3
Messages: 3
Registered: October 2005
Junior Member
Thanks for the response.

That did not work.

I get this error:

SVRMGR> startup mount
ORACLE instance started.
Total System Global Area 30862356 bytes
Fixed Size 76820 bytes
Variable Size 13836288 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
SVRMGR> recover database
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [17585], [0], [1074692640], [], [], [
], [], []
SVRMGR>
Re: apply patchset for 8.1.7.0 upgrade to 8.1.7.4 [message #142853 is a reply to message #142751] Tue, 18 October 2005 00:57 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Your are getting error ORA-00600 so please check the below given link

http://www.orafaq.com/forum/m/142359/67993/#msg_142359

May god help you.... Laughing

Regards
Always Friend sunilkumar

Re: apply patchset for 8.1.7.0 upgrade to 8.1.7.4 [message #142868 is a reply to message #142853] Tue, 18 October 2005 01:56 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
During installation you got writing error to files in /u01/oracle directory.

Did the user under which you carried out this installation had the privilege to write to these directorites?

You were told you were successful as you ignored every such error.

Also did you followed every instruction that the doc attached with the patch set mentions for patch's installation?

--Girish
Re: apply patchset for 8.1.7.0 upgrade to 8.1.7.4 [message #142977 is a reply to message #142868] Tue, 18 October 2005 09:55 Go to previous message
roones3
Messages: 3
Registered: October 2005
Junior Member
Thanks.

I was able to recover back to 8.1.7.0.

I think I will focus on upgrading to 10.
Previous Topic: Storing table's date in a particular datafile
Next Topic: database logon trigger problem
Goto Forum:
  


Current Time: Tue Feb 04 00:37:19 CST 2025