on 01-07-2009 6:31 AM
Hello friends
I have HP-UNIX 11.31 i.e v3 + Oracle 10.2 +ECC 6.0.
I want to update patches of oracle but i dont have dvd yet. on SMP lot of bin file are there.
im not getting exact procedure to do.
so please tell me how to update oracle patch, which file need to be download?
what's step involved in it.
thanks
sachin
Dear gurus
please let me what are post installation steps of oracle patch.
im not little bit clear on read me.
im having simple std SAP system.
thanks
Sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> im having simple std SAP system.
It has totally nothing to do with your SAP system.
Installing only patch 10.2.0.2 or 10.2.0.4 is also not enough, you need to install the latest interim patch(es) according to your platform.
Oracle is a complex piece of software, in most cases it's not enough to run setup.exe and you're done.
The Readme.html that comes with the patch has a section "Postinstallation Tasks". Do what's listed there.
Markus
Hello,
i successfully applied patch. after apply im not bale to even start data base.
details as
***************************************************************************************************************************
-
Wed Jan 7 04:48:17 BDT 2009
LOGFILE FOR STARTING ORACLE
Trying to start QAS database ...
-
Wed Jan 7 04:48:17 BDT 2009
checking required environment variables
ORACLE_HOME is >/oracle/QAS/102_64<
ORACLE_SID is >QAS<
-
Wed Jan 7 04:48:17 BDT 2009
check initora
-
Wed Jan 7 04:48:17 BDT 2009
check initora
-
Wed Jan 7 04:48:17 BDT 2009
checking V2 connect
TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 07-JAN-2009 04:48:17
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/oracle/QAS/102_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = erpqas) (PORT = 1527))) (CONNECT_DATA = (SID = QAS) (GLOBAL_NAME = QAS.WORLD)))
OK (0 msec)
tnsping: V2 connect to QAS
-
Wed Jan 7 04:48:18 BDT 2009
Connect to the database to check the database state:
R3trans: connect check finished with return code: 12
Database not available
-
Wed Jan 7 04:48:19 BDT 2009
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state
-
Wed Jan 7 04:48:23 BDT 2009
starting database
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jan 7 04:48:23 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 2365587456 bytes
Fixed Size 2045840 bytes
Variable Size 1191184496 bytes
Database Buffers 1157627904 bytes
Redo Buffers 14729216 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
-
Wed Jan 7 04:48:33 BDT 2009
Connect to the database to verify, that the database is now open
R3trans check finished with return code: 12
ERROR: Startup of database failed
Notify Database Administrator.
startdb: Terminating with error code 12
***************************************************************************************************************************8
thanks
sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The bin files have to be downloaded and "put" together.
The note 509314 "Downloading Oracle patches from SAP Service Marketplace" tells you how to do it.
The patch set has a "readme" file, you have to follow the indications of this file.
Note 1137346 contains the patches that have to be installed afterwards and also instructions/recommendations for the upgrade to 10.2.0.4
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sachin,
the files that you need are already mentioned above.
You have to execute the following command to merge and extract the patch
shell> cat Patchset_10204_HPUX-IA64aa.bin Patchset_10204_HPUX-IA64ab.bin Patchset_10204_HPUX-IA64ac.bin Patchset_10204_HPUX-IA64ad.bin >> 10204_Patchset.zip
shell> unzip 10204_Patchset.zip
Btw. this procedure is also described in sapnote #509314.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You need below files for 10.2.0.4 patch.
Patchset_10204_HPUX-IA64aa.bin
Patchset_10204_HPUX-IA64ab.bin
Patchset_10204_HPUX-IA64ac.bin
Patchset_10204_HPUX-IA64ad.bin
Use WinRAR for extraction of above files.
Regards,
Nikunj Thaker.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sachin,
Do you wanna know which bin files to use or the procedure to use the bin files?
Prasad
If you wanna know which bin files to use, please mention the file name here (alongwith description if any) so that I can help.
Prasad
Edited by: Prasad Kamath on Jan 7, 2009 9:27 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.