Skip to Content

This document includes system copy screenshots , executed for an ERP6.04 AIX-Oracle 10G system. With this operation we build a new system. This is not a system refresh.

Please obtain the latest SAP system copy guide, in order to view official information, latest notes and the most up-to-date instructions about operation:

service.sap.com/instguides

  • 1-Create your SAP system filesystems and resize them according to your source system./wp-content/uploads/2015/03/39_669893.jpg
  • 2-Execute ./sapinst from your “Installation Master” path. Enter your target system SID.

/wp-content/uploads/2015/03/04_669900.jpg

  • 3- Enter your “master password”.

/wp-content/uploads/2015/03/05_669902.jpg

  • 4-Enter your target system’s “DBSID”. Let it be same with your target system’s SID. (Step1)
  • 5-Select second one, since we’ll use the last backup of our source system.

/wp-content/uploads/2015/03/07_669908.jpg

  • 6-Enter uid and gid of your oraSID user. Let the password remain. It’s automatically copied from master password. (Step3)

/wp-content/uploads/2015/03/09_669909.jpg

  • 7-Prerequisite checker is executed and the result comes up. Take action if needed.

/wp-content/uploads/2015/03/10_669910.jpg

  • 8-DB schema owner credentials and instance memory amounts. Let schema owner be same with source system’s.

     Let the password remain. It’s automatically copied from master password. (Step3)

/wp-content/uploads/2015/03/11_669921.jpg

  • 9-Point Oracle 10G RDBMS DVDs path as shown.

/wp-content/uploads/2015/03/12_669922.jpg

  • 10-Enter Listener information. The port must be not-busy one.

/wp-content/uploads/2015/03/13_669923.jpg

  • 11-Enter system number. It can change according to your landscape’s naming and system number conventions.

/wp-content/uploads/2015/03/14_669924.jpg

  • 12-Message server port:36<System Number> and internal message server port:39<System Number>

/wp-content/uploads/2015/03/15_669925.jpg

  • 13-Enter the password of DDIC in source system’s 000 client.

/wp-content/uploads/2015/03/16_669938.jpg

  • 14-Point kernel cd and oracle client paths as shown.

/wp-content/uploads/2015/03/17_669939.jpg

/wp-content/uploads/2015/03/18_669940.jpg

  • 15-Archives to be unpacked.

/wp-content/uploads/2015/03/19_669948.jpg

  • 16-Check the values you’ve already provided from summary screen and start execution.

/wp-content/uploads/2015/03/20_669949.jpg

  • 17-You’ll be asked for solution manager key. Get it from your solman system from transaction smsy->Go To->Other objects.

/wp-content/uploads/2015/03/22_669971.jpg

  • 18-Sapinst will ask from you to install Oracle DB.

/wp-content/uploads/2015/03/23_669973.jpg

ORACLE INSTALLATION STEPS (From Step19 to Step24)


  • 19-Execute /oracle/stage/102_64/database/Disk1/rootpre/rootpre.sh script and then ./RUNINSTALLER under directory /oracle/stage/102_64/database/Disk1/SAP as instructed in the pop-up.
  • 20-Oracle 10G installer runs…

/wp-content/uploads/2015/03/27_669993.jpg

  • 21-After Oracle Universal Installer ends, you’ll be asked executing 2 scripts. Execute them as root user.

/wp-content/uploads/2015/03/28_669995.jpg

  • 22-After exiting installation window,execute /usr/sbin/slibclean as root user. Now you have a database with version 10.2.0.1. This version has lot of errors and bugs. Therefore you should install patch set 3 in order to have Oracle DB with version 10.2.0.4. There is an important step before installing patchset. Kill oracle processes before you begin patchset installation.

root@HOST:/mnt/sapdvd/ORACLE_PATCH_10204> ps -ef |grep ora

root 237654 430108   0 09:36:54  pts/0  0:00 grep ora

  orasid 467170      1   0 17:05:51      –  0:00 /bin/sh /oracle/SID/102_64/jdk/bin/java -Djava.awt.headless=true -Doracle.oc4j.localhome=/oracle/SID/102_64/sqlplus -Djava.security.properties=/oracle/SID/102_64/oc4j/j2ee/home/config/jazn.security.props -jar /oracle/SID/102_64/oc4j/j2ee/home/oc4j.jar -config /oracle/SID/102_64/oc4j/j2ee/isqlplus/config/server.xml

  orasid 475266 467170   0 17:05:51      –  0:25 /oracle/BDP/102_64/jdk/bin/java.bin -Dibm.stream.nio=true -Djava.awt.headless=true -Doracle.oc4j.localhome=/oracle/SID/102_64/sqlplus -Djava.security.properties=/oracle/SID/102_64/oc4j/j2ee/home/config/jazn.security.props -jar

/oracle/SID/102_64/oc4j/j2ee/home/oc4j.jar -config /oracle/SID/102_64/oc4j/j2ee/isqlplus/config/server.xml

root@HOST:/mnt/sapdvd/ORACLE_PATCH_10204> kill 467170

root@HOST:/mnt/sapdvd/ORACLE_PATCH_10204> kill 475266


  • 23.Download Oracle 10.2.0.4 patch set and execute ./RUNINSTALLER like normal Oracle installation.

/wp-content/uploads/2015/03/33_669996.jpg

After this installation, execute /oracle/SID/102_64/root.sh as you’re instructed in the pop-up.

Now you have Oracle DB 10.2.0.4. You can install interim patches manually now or after restore. I’d suggest you install them just after Oracle patchset installation.

For more information, see notes:

1427900 – CPU Patches January 2010 (Oracle Critical Update Program)

839187 – Oracle 10.2.0: Patchset/Patches/Patchcollection-Installation

You can download Oracle interim patches from here: Databases | SAP Support Portal


  • 24.Now you can click “OK” in previous Sapinst pop-up (Step18). After sapinst configures your DB installation, “Restore” pop-up comes:

/wp-content/uploads/2015/03/37_669997.jpg´

  • 25.Restore your source DB backup to your target db. Restore steps vary up to your landscape’s backup infrastructure, tool, etc. The command restores Oracle .dbf datafiles under target system sapdata folders.

     brrestore –b BACKUP_LOG.anf -m full

     Then create a script with that command in source system and edit it.These steps will create a .trc file under /oracle/SID/saptrace/usertrace/ in your source      system:

     su – orasid

     sqlplus ” / as sysdba “

     SQLPLUS> alter database backup controlfile to trace;

     Edit it respectively to your target database SID. It should seem similar to the control_file.txt, that I’ve attached to this document. Copy edited file to a temp      folder in your target database. Execute it with sqlplus. This execution will create your new DB’s control file.

  • 26.Now you your DB should be mounted. Recover it “point in time (PIT)” with redo logs and then open your database with resetlogs:

SQLPLUS> recover database using backup controlfile until time ‘2015-03-12 21:00:00’;

ORA-00279: change 44164157 generated at 03/12/2015 01:58:29 needed for thread 1

ORA-00289: suggestion : /oracle/SID/saparch/SIDarch1_22754.dbf

ORA-00280: change 44164157 for thread 1 is in sequence #22754

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

AUTO

SQLPLUS> alter database open resetlogs;

  

    This command will create online logs of your oracle DB. The restore is completed. You can click “OK” in the previous pop-up (step24). Sapinst      will handle $OPS user convertions, Oracle user authorizations, etc. Before clicking OK in sapinst pop-up create a pseudo file called “CONTROL.SQL” under your installation directory. In our example that path is :/tmp/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP

This pseudo CONTROL.SQL file contains just those 2 commands:

startup;

exit;

Since we’ve already created control file (above step25) and mounted&opened DB, we don’t need a new one anymore. So we’re just going on.

  • 27.After sapinst finishes, it means that your new system is up. Now you should go on with post-processing steps like: License installation, BDLS conversion, kernel upgrade, parameter optimization … etc. For the list of post processing steps, see the latest system copy guide.


When I’ll have time I’ll try to share post processing steps as well with a seperate document. I hope this document helps you with your projects.

Good luck! : )



To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Fidel Vales

    well done but, keeping in mind that Oracle 10g has ended its extended support in 2013 and it is about to end its limited extended support, wouldn’t it better to do have done this for Oracle 11g?

    (0) 
    1. Serhat Yueceant Post author

      Hola Fidel,

      The document for 11G is also on the way! : )

      Yes, I’m aware of this information. However I thought it’ll be a basic concept document, since restore setps of 10G and 11G are not so different.

      Regards,

      Serhat

      (0) 

Leave a Reply