move Oracle Binaries

[former_member182034]

Dear All,

Please tell how can i download Oracle Binaries from Source system and apply on Target system and which directory, i have to download/move of source system. there are Oracle version on Source and target system.

Source System

SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Target System

SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

[former_member184473]

Hello,

You just need to apply the 10.2.0.5 patchset in your source system.

Check the following note:

[871735 Current patch set for Oracle 10.2.0|http://service.sap.com/sap/support/notes/871735]

Regards,

Eduardo Rezende

[former_member182034]

Dear,

how can i download oracle binarie from source system and apply on Target system.

Regards,

[nicholas_chang]

Hi majamil,

Your target is higher than source, what you need to do is download patchset 10.2.0.5 and patch it.

service.sap.com -> software downloads -> Database Patches -> oracle -> oracle 10.2 Software (x bit) -> select your OS -> Download oracle RDBMS Patch 10.2.0.5

I would strongly advise you patch to latest SBP or patches to latest level using MOPatch / OPatch.

Cheers,

Nicholas Chang

[former_member182034]

Dear Nicholas,

I am getting this issue on Target system and want to move oracle binaries of source system.

suppose, if i applied oracle patch 10205 on source system then what will we do after patch. would you please explain me because you are saying about source system which is our Live/Production server.

Regards,

[nicholas_chang]

Hi Majamil,

There's a post update step when you need to perform, where you can refer to the readme file once you extracted the downloaded file. Read and follow the instruction cleary, not only post, also pre-upgrade and upgrade.

Cheers,

Nicholas Chang

[former_member182034]

Dear Nicholas,

Oracle patch set 10.2.0.5 successfully applied with following sequence

Install main patch 10205
Copy and past the OPatch
OPatch>opatch apply 8350262
 9584028
 9445675
 9843740
10357961
10431010

12429524
12914913

. you can check following log.

E:\oracle\PRD\102\OPatch>opatch lsinventory
========================================================
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY
========================================================
Invoking OPatch 10.2.0.5.0

Oracle Interim Patch Installer version 10.2.0.5.0
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : E:\oracle\PRD\102
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 10.2.0.5.0
OUI version       : 10.2.0.5.0
OUI location      : E:\oracle\PRD\102\oui
Log file location : E:\oracle\PRD\102\cfgtoollogs\opatch\opatch2012-01-30_15-48-
47PM.log

Patch history file: E:\oracle\PRD\102\cfgtoollogs\opatch\opatch_history.txt

Lsinventory Output file location : E:\oracle\PRD\102\cfgtoollogs\opatch\lsinv\ls
inventory2012-01-30_15-48-47PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (3):

Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 1                            10.2.0.2.0
Oracle Database 10g Release 2 Patch Set 4                            10.2.0.5.0
There are 3 products installed in this Oracle Home.


Interim patches (6) :

Patch  12914913     : applied on Mon Jan 30 15:48:14 GMT+05:00 2012
Unique Patch ID:  14166117
   Created on 5 Oct 2011, 02:45:06 hrs
   Bugs fixed:
     12914913, 10097176, 9545597, 11840910, 6011045, 7509714, 8354642, 8488233
     9322219, 9499302, 9767674, 10208905, 10214450, 10162036, 12565867
     12794025, 12799034, 9187546, 7115910, 9399589, 9386687, 12310567, 12421252
     5245039, 10244177, 8298501, 9431650, 10165083, 9926087, 7710224, 10350832
     12739299, 12807343, 12429524, 11066597, 9935787, 10236704, 11853331
     9825461, 8411930, 6651220, 7026523, 8882576, 9360157, 10068982, 10173237
     10324526, 8332730, 7516536, 11814891, 9871302, 6055658, 12363485, 10220194
     7592673, 10202758, 9735237, 10052339, 12332704, 8666117, 9145204
     9824435, 11703718, 7280234, 9269536, 10132870, 9094926, 9323583, 10144882
     9860769, 9488247, 10306945, 9532911, 9184754, 11657004, 9656004, 8528171
     10191707, 8943287, 11727013, 10407744, 11930680, 8966823, 10160615
     10637621, 4672767, 5638228, 12328269, 11731166, 9215341, 10159846
     11076894, 10269717, 10091171, 9061785, 8211733, 8412426, 9020537, 9024850
     9150282, 10010310, 7602341, 8865718, 11737047, 11675644, 10111381
     9368502, 8660422, 9032322, 9295217, 10224187, 10080775, 9841679, 8977287
     10054513, 10220046, 9577583, 10352673, 8277300, 8394351, 8350262, 9949948
     9879181, 9469117, 10017048, 8771916, 10155684, 6694396, 10308274
     10312161, 10157402, 8434467, 9668086, 9980062, 6151936, 10091698, 8228796
     9699654, 10114856, 9978573, 10156303, 5575218, 9081686, 10196896, 10080735
     5519322, 6768114, 6904068, 7045446, 7452759, 7612454, 8684595, 8811401
     9109487, 9320130, 9337325, 9362218, 9390484, 9548269, 9770451, 10155844
     9047975, 8663644, 7708267, 6086930, 9539556, 9355794, 8264642, 9495669
     6975402, 9659614, 9387574, 9320786, 9793452, 9024737, 9196440, 8970313
     9308296, 9663844, 10099855, 6402302, 7519406, 8224558, 8487143, 8544696
     8546356, 8664189, 8996060, 9261837, 9577921, 9586637, 9646836, 9683239
     9711859, 9713537, 9714832, 9726739, 9747153, 9772888, 9870614

Patch  10431010     : applied on Mon Jan 30 15:38:04 GMT+05:00 2012
Unique Patch ID:  13295575
   Created on 14 Jan 2011, 14:57:58 hrs PST8PDT
   Bugs fixed:
     9569264, 8874882, 9760734, 9099863, 6670871, 8980899, 8588311, 9680387
     8980918, 9105438

Patch  10357961     : applied on Mon Jan 30 15:36:32 GMT+05:00 2012
Unique Patch ID:  13813456
   Created on 6 Jun 2011, 01:39:07 hrs PST8PDT
   Bugs fixed:
     10357961

Patch  9843740      : applied on Mon Jan 30 15:35:52 GMT+05:00 2012
Unique Patch ID:  13572258
   Created on 21 Mar 2011, 00:17:02 hrs PST8PDT
   Bugs fixed:
     9843740

Patch  9445675      : applied on Mon Jan 30 15:35:24 GMT+05:00 2012
Unique Patch ID:  13823676
   Created on 17 Jun 2011, 12:52:27 hrs PST8PDT
   Bugs fixed:
     9445675

Patch  9584028      : applied on Mon Jan 30 15:34:35 GMT+05:00 2012
   Created on 30 Jun 2011, 13:52:29 CEST
   Bugs fixed:
     9584028

----------------
OPatch succeeded.

now..how can i move oracle binaries from source to target system?

Regards

[nicholas_chang]

Why u need to move binaries from source to target since your targer is 10.2.0.5?? basically you just need to patch your target to the same patches as source.

[former_member182034]

Dear,

actually, i am getting Oracle error ORA-01017: invalid username/password; logon deniedBR0310E Connect to database instance TVS failed in trace of work process. Eric's reply against of my post ORA-00205: error in identifying control file

Your Oracle instance is crashing because the DB binaries do not match the DB instance.
downgrade your Oracle binaries to 10.2.0.4 as in your original system, then try to startup your instance and recover it. it should now work.
when this is completes, upgrade it to 10.2.0.5.

Regards,

[nicholas_chang]

Hi,

To resolve invalid username issue, have you try to run sapdba.sql and change SAP schema password as suggested in your previous post?

i dont think you can just move the binaries for Windows system. Why not you just perform the restore and recovery again as both target and source are in same patchset version now, where you don't need to roll back your target patchset, and upgrade to 10.2.0.5 once more.

Cheers,

Nicholas Chang

[former_member182034]

hi Nicholas,

Ok, I agreed with your last reply but I need the answer of Subject of this post.

just send me steps of moving Oracle Binaries from source to target system.

Regards,