1 / 48

Oracle E-Business Suite in an high available environment with 9i RAC on Itanium

Oracle E-Business Suite in an high available environment with 9i RAC on Itanium. Simone Bundschu & Wolfgang Herdtle HP/Oracle CTC June 2003. before we start...HP/Oracle CTC. located at hp in Böblingen, Munich, Sophia Antipolis & Oracle Reading founded in spring 1994

dorianw
Download Presentation

Oracle E-Business Suite in an high available environment with 9i RAC on Itanium

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle E-Business Suite in an high available environment with 9i RAC on Itanium Simone Bundschu& Wolfgang Herdtle HP/Oracle CTC June 2003

  2. before we start...HP/Oracle CTC • located at hp in Böblingen, Munich, Sophia Antipolis & Oracle Reading • founded in spring 1994 • oracle and hp people working in one team • part of hp/oracle alliance EMEA • focus areas: • Oracle9i/10i, 9iRAC (performance, high availability, data warehousing) • Oracle9iAS, Collaboration Suite • Oracle E-Business Suite (ERP & CRM) • technical (presales) services

  3. Just 4 steps... • Two-Node E-Business Suite Installation on two PA-Risc systems • DB upgrade from 8.1.7 to 9.2.0.2 • DB transition from PA-Risc to Itanium2 system • Migration from single instance db to 9i RAC

  4. overview hw architecture

  5. overview sw architecture Servlet Engine Data Server Java Server Pages (JSP) mod_plsql / WebDB (old) Browser Web Listener Forms 6i Graphics 6i Forms Server Reports Server Reports 6i Jinitiator Discoverer Server Discoverer 4i Oracle Workflow Concurrent Manager

  6. step1: two-node E-Business Suite installation on two PA-Risc systems • E-Business Suite 11.5.8 stack: • 8.0.6 Oracle Home 8.0.6.3 • Oracle 9iAS (1.0.2.2.2) — includes Oracle HTTP Server • Oracle JInitiator for the PC client (1.1.8.16) • Oracle Developer6i Patch 9, which includes: • Oracle Forms (6.0.8.18) • Oracle Reports (6.0.8.18) • Oracle Graphics (6.0.8.18) • Oracle Java Server Pages (1.1.2) • Client libraries (Required Support Files) (8.0.6.3) • Java Database Connector (8.1.7.1b) • Oracle8i Enterprise Edition (8.1.7.4)

  7. E-Business Suite installation • Check HP-UX Patch Requirements • Adjust the Kernel Parameters, if necessary (recommendation can be found at Metalink http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?284460 • Create login accounts     - oravis / <password>     - applvis / <password> • Check disk space (25 gb plus 15 gb staging area) • check if JDK 1.3.1.09 version has been installed on your server # java -version

  8. swlist on PA-Risc server # swlist -l Java B9788AA 1.3.1.09.00 Java2 1.3 SDK for HP-UX B9789AA 1.3.1.02.01 Java 2 RTE 1.3 for HP-UX (700/800), PA1.1 + PA2.0 Add on Support bundles GOLDAPPS11i B.11.11.0206.4 Gold Applications Patches for HP-UX 11i,June 2002 GOLDBASE11i B.11.11.0206.4 Gold Base Patches for HP-UX 11i, June 2002 OnlineDiag B.11.11.07.11 HPUX 11.11 Support Tools Bundle, Jun 2002 HWEnable11i B.11.11.0206.5 Hardware Enablement Patches for HP-UX 11i, June 2002 Oracle E-Business Suiterelated B3901BA B.11.11.04 HP C/ANSI C Developer's Bundle for HP-UX11.i (S800) B3913DB C.03.37.01 HP aC++ Compiler (S800) perl B.5.6.1.C Perl Programming Language General HPUX11i-OE-MC B.11.11.0206 HP-UX Mission Critical Operating Environment Component HPUXBase64 B.11.11 HP-UX 64-bit Base OS HPUXBaseAux B.11.11.0206 HP-UX Base OS Auxiliary

  9. start EBS installation • Two-node Installation with Rapid Installer according to the Oracle Installation Guide • Start Installation on db tier • Login as user root for multi user installation # cd /stage11.5.8/redCD/Disk1/rapidwiz # ./rapidwiz • Copy the configuration file (config.txt) you saved in Step 11 to each node in your installation. • Start Rapid Install on Application tier, and choose the Install Oracle Applications option. • choose the Read Configuration from file

  10. config.txt (extract) [VIS] VIS.DBS_HOST=oracle1 VIS.DBS_ORASID=VIS VIS.DBS_ORANAME=VIS VIS.DBS_PLATFORM=HP-UX VIS.DBS_APPLTOP=/oradata/apps/visappl -> appl top VIS.DBS_COMNTOP=/oradata/apps/viscomn -> common top VIS.DBS_ORA816=/oradata/apps/visdb/8.1.7 -> db home VIS.DBS_ORA806=/oradata/apps/visora/8.0.6 -> forms home VIS.DBS_ORAWDB=/oradata/apps/visora/iAS -> iAS home VIS.DBS_JDKHOME=/opt/java1.3 VIS.CON_REPSPORT=7002 -> Reports Server

  11. config.txt (cont‘d) VIS.FRM_HOST=oracle2 VIS.FRM_WEBPRT=8002 -> web server port VIS.FRM_WLSNR=VIS VIS.FRM_FORMSPRT=9002 -> forms server port VIS.FRM_METDATAPRT=9102 -> metrics server port VIS.FRM_METREQPRT=9202 -> metrics server port VIS.WEB_HOST=oracle2 VIS.WEB_SERVLETPORT=8802 -> jsp port VIS.WEB_JTF=9302

  12. step 2: DB upgrade from 8.1.7 to 9.2.0.2

  13. prepare to create the 9.2.0 Oracle home • Decide where you want to install the 9.2.0 Oracle home on the database server node; it must be in a different directory than the current Oracle home. • Log on to the database server node, as the owner of the Oracle RDBMS file system and database instance • unzip and extract the patch set file appropriate for your platform. • check the patch set notes (patch_note.htm)

  14. create the 9.2.0 Oracle home • Perform all the steps in the "Install the Release 9.2 Oracle Software" section of Chapter 3 of Oracle9i Database Migration, Release 2 (9.2), except for those steps that refer to the Database Upgrade Assistant. • Start Oracle Universal Installer • Enter the name of a new Oracle home in the Destination Name field. • Enter the complete path of the Oracle home directory where you want to install the new release (needs to be different to the oracle home of the old release) • following components are required by the Applications and must be installed: • Oracle9i • Enterprise Edition Options -> Oracle Spatial, Oracle Partitioning • Oracle Net Services -> Oracle Net Listener, Oracle Connection Manager • Oracle 9i Development Kit -> Oracle C++ Call Interface, Oracle Call Interface (OCI), Oracle Programmer, Oracle XML Developer's Kit • Oracle HTTP Server -> BC4J Runtime for Database, Oracle Mod PL/SQL Gateway

  15. 9.2 upgrade • When the Oracle Net Configuration Assistant window appears, use it to configure the Oracle Net listener for the Applications database instance as well as external procedures. Refer to the Oracle9i Net Services Administrator's Guide, Release 2 (9.2) for information about how to configure a listener. Use the listener.ora file in the old Oracle home as an example of how the listener.ora file in the 9.2.0 Oracle home should be configured. Do not start the new listener yet. • Shut down all Applications server processes except for the database instance. The Applications will be unavailable to users until all tasks in this section are completed. • Run the Database Upgrade Assistant # dbua select the db which needs to be upgraded

  16. 9.2 upgrade (cont‘d) • Grant dictionary privileges to the SYSTEM, APPS, and MRC schemas $ sqlplus apps/<apps password> @$AD_TOP/patch/115/sql/adgrn9i.sql <SYSTEM password> <APPS schema name> • Re-create grants and synonyms Oracle9i Release 2 (9.2.0) contains new functionality regarding grants and synonyms that Oracle8i and Oracle9i Release 1 (9.0.1) did not have. As a result, you must re-create the grants and synonyms in the APPS schema(s). On the administration server node, as the owner of the Applications file system, run AD Administration and select the "Recreate grants and synonyms for APPS schema(s)" task from the Maintain Applications Database Objects menu.

  17. 9.2 upgrade (cont‘d) • Restart Application server processes Restart all the Applications server processes that you shut down before upgrading the database instance. Remember that the Oracle Net listener for the database instance, as well as the database instance itself, need to be started in the 9.2.0 Oracle home from now on. Users may return to the system.

  18. step 3: transition from PA-Risc to Itanium

  19. transistion from PA-Risc to Itanium To migrate an Oracle database from HP-UX on PA-RISC to HP-UX on the Itanium architecture, the database on the PA-RISC system must be running one of the following Oracle versions: • Oracle9i release 2 (9.2.0): the only Oracle version supported on the Itanium architecture • Oracle8i (8.1.7): an 8.1.7 database can be migrated to the Itanium architecture but it must be upgraded to Oracle9i release 2 before it can be opened An 8i database can thus either be upgraded to 9i release 2 and then migrated to the Itanium architecture or migrated first and then upgraded to 9i release 2 on the Itanium-based system.

  20. prepare the Itanium system for Oracle transition • Install HP-UX 11i version 1.6 and any recommended patches Check swlist! # swlist

  21. swlist (extract) B3901BA B.11.22 HP C/ANSI C Developer's Bundle (S800) B3935DA A.11.14.01 MC / Service Guard B9788AA 1.3.1.04.01 Java2 1.3 SDK for HP-UX B9789AA 1.3.1.04.01 Java2 1.3 RTE for HP-UX OnlineDiag B.11.22.01.23 HPUX 11.22 Support Tools Bundle,Jun 2002 T1859BA A.11.14.01 ServiceGuard Extension for RAC perl B.5.6.1.D Perl Programming Language # # Product(s) not contained in a Bundle: # MeasureWare C.03.25.05 MeasureWare Software/UX PHKL_28465 1.0 Processes not reactivated for a long time. PHSS_27285 1.0 A.05.38 C++ library patch PHSS_27287 1.0 u2comp/plugin library Patch PHSS_27289 1.0 Improved performance/accuracy of libm. PHSS_27290 1.0 IPF Assembler updates PHSS_27291 1.0 fdm cumulative patch PHSS_27292 1.0 Aries cumulative patch. PHSS_27293 1.0 milli.a cumullative patch PHSS_27557 1.0 MC/ServiceGuard A.11.14.01 PHSS_27659 1.0 A.05.41 C Compiler Product PHSS_27661 1.0 linker + fdp cumulative patch

  22. 9.2 upgrade (cont‘d) • Modify the HP-UX user/account database (/etc/passwd and /etc/group) to ensure the Oracle owner and dba group are set up correctly. • Create the LVM structure, which will be used to hold the database. • Create the volume group directories (e.g., mkdir /dev/vgoracle) and the LVM “group” files (mknod /dev/vgoracle/group . . .) using standard LVM procedures. • If you’ll be copying your database to the Itanium-based system, create the file systems (newfs). • create the file-system mount points (e.g., mkdir /ora01)

  23. copy database files to the Itanium system • shut down the database on the PA-RISC system, then copy the data over to the Itanium-based system using whatever method is most appropriate for your environment and that you’re most comfortable with. • In the Oracle-home directory on the Itanium-based system, we set up the shell’s environment file (.profile) to create the ORACLE_SID environment variable using the same SID as on the PA-RISC system. (In the text that follows, we’ll refer to the Oracle Home on the PA-RISC system as “$oh‑pa” and on the Itanium-based system as “$oh‑ipf”.) • Using rcp, we copy all the database configuration and parameter files (including the initSID.ora, listener.ora and tnsnames.ora file) from the PA-RISC system to the Itanium-based system: # rcp $oh-pa/dbs/*.ora ipf-node:$oh-ipf/dbs # rcp $oh-pa/dbs/orapwsid ipf-node:$oh-ipf/dbs # rcp -r $oh-pa/admin/sid* ipf-node:$oh-ipf/admin The last command shown above copied the admin directory, which contains bdump, udump, etc.

  24. finish the transition • On Itanium system, edit the Oracle configuration files (e.g., init.ora, listener.ora, etc.) to reflect the new IP address, hostname, pathnames, and other characteristics of the Itanium-based system. • Log in as the Oracle user and start up the database

  25. step 4: migration from single instance to 9i RAC

  26. LVM steps 1. Initialize disks $ pvcreate –f /dev/rdsk/cxtydz ( where x=instance, y=target, and z=unit) 2. Create the volume group directory with the character special file called group:        $ mkdir /dev/vg_rac $ mknod /dev/vg_rac/group c 64 0x060000 Note: The minor numbers for the group file should be unique among all the volume groups on the system. 3. Create PV-LINKs and extend the volume group: $ vgcreate /dev/vg_rac /dev/dsk/c0t1d0 /dev/dsk/c1t0d0     $ vgextend /dev/vg_rac /dev/dsk/c1t0d1 /dev/dsk/c0t1d1 Continue with vgextend until you have included all the needed disks for the volume group(s). 4. Create logical volumes for the 9i RAC database with the command $ lvcreate –i 10 –I 1024 –L 100 –n Name /dev/vg_rac -i: number of disks to stripe across -I: stripe size in kilobytes -L: size of logical volume in MB

  27. LVM setup • Check to see if your volume groups are properly created and available: $ strings /etc/lvmtab $ vgdisplay –v /dev/vg_rac • Change the permission of the database volume group vg_rac to 777, change the permissions of all raw logical volumes to 660 and the owner to oracle:dba. $ chmod 777 /dev/vg_rac $ chmod 660 /dev/vg_rac/r* $ chown oracle:dba /dev/vg_rac/r* • Export the volume group: De-activate the volume group: $ vgchange –a n /dev/vg_rac Create the volume group map file: $ vgexport –v –p –s –m MyMAPfile /dev/vg_rac Copy the mapfile to all the nodes in the cluster: $ rcp MyMAPfile nodeB:/tmp/scripts

  28. LVM setup • Import the volume group on the second node in the cluster • Create a volume group directory with the character special file called group:     $ mkdir /dev/vg_rac $ mknod /dev/vg_rac/group c 64 0x060000Note: The minor number has to be the same as on the other node. • Import the volume group: $ vgimport –v –s –m MyMAPfile /dev/vg_rac         $ chmod 777 /dev/vg_rac$ chmod 660 /dev/vg_rac/r*$ chown oracle:dba /dev/vg_rac/r* • Check to see if devices are imported: $ strings /etc/lvmtab

  29. migration steps • Stop the filesystem database • copy all the datafiles to the Raw-Logical Volumes syntax: # dd if=file of=/dev/vg02/rlvol1 bs=1024k • dd_FS_to_RAW – example dd if=/oradata/VIS/dat14.dbf of=/dev/vg_rac/rRAC_dat14_1200 bs=8192k dd if=/oradata/VIS/idx01.dbf of=/dev/vg_rac/rRAC_idx01_1200 bs=8192k .... dd if=/oradata/VIS/cntrl01.dbf of=/dev/vg_rac/rRAC_cntrl01_50 bs=8192k .... dd if=/oradata/VIS/sys01.dbf of=/dev/vg_rac/rRAC_sys01_1200 bs=8192k

  30. create links from filesystem on RAW • create symbolic links to the Raw Logical Volumes ON BOTH Nodes ln -s /dev/vg_rac/rRAC_apps_undots01_400 /oradata/VIS/apps_undots01.dbf ….. ln -s /dev/vg_rac/rRAC_cntrl01_50 /oradata/VIS/cntrl01.dbf ….. ln -s /dev/vg_rac/rRAC_ctx01_50 /oradata/VIS/ctx01.dbf ln -s /dev/vg_rac/rRAC_dat01_1200 /oradata/VIS/dat01.dbf ….. ln -s /dev/vg_rac/rRAC_dat14_1200 /oradata/VIS/dat14.dbf ln -s /dev/vg_rac/rRAC_idx01_1200 /oradata/VIS/idx01.dbf ….. ln -s /dev/vg_rac/rRAC_log03_120 /oradata/VIS/log03.dbf ….. ln -s /dev/vg_rac/rRAC_sys01_1200 /oradata/VIS/sys01.dbf ….. ln -s /dev/vg_rac/rRAC_tmp01_1000 /oradata/VIS/tmp01.dbf # chown -R oravis:dba /oradata/VIS

  31. relink Oracle binaries with RAC option • for testing start the database • shutdown the database • relink binaries with RAC option $ cd $ORACLE_HOME/rdbms/lib $ make –f ins_rdbms.mk rac_on ioracle • create copies of local init.ora, one for each RAC instance Single instance: initVIS.ora RAC: initVIS1.ora initVIS2.ora

  32. InitVIS1.ora VIS1.instance_name = 'VIS1' VIS2.instance_name = 'VIS2' VIS1.undo_tablespace = 'APPS_UNDOTS1' VIS2.undo_tablespace = 'APPS_UNDOTS2' *.cluster_database = true *.cluster_database_instances = 2 *.service_names = 'VIS' db_name=VIS undo_management=AUTO local_listener=LISTENERVIS * - valid for all instances

  33. HP MC/Service Guard & HP SGeRAC check if the following products are already installed on the system, if not, proceed with the installation: • MC/ServiceGuard A.11.14.01 • ServiceGuard Extension for RAC (for shared disk access) A.11.14.01 Please note that beginning with version A.11.14.01, which is an Itanium release only, the product structure of ServiceGuard Extension for RAC (SGeRAC; formerly ServiceGuard OPS Edition) has changed. SGeRAC is now an add-on product to the MC/ServiceGuard offering, meaning that it simply can be installed on top of the existing MC/SG. This new structure will be introduced for PA-RISC with the next A.11.15 release of MC/SG.

  34. configure HP MC/Service Guard Cluster • After all the LAN cards are installed and configured, and all the OPS volume groups and the cluster lock volume group(s) are configured, you can start the cluster configuration. Since we only configured one volume group for the entire RAC cluster vg_rac, we used vg_rac for the lock volume as well. 1. Create a cluster configuration template: $ cmquerycl –n nodeA –n nodeB –v –C /etc/cmcluster/rac.asc 2. Edit the cluster configuration file (rac.asc). Make the necessary changes to this file for your cluster. For example, change the ClusterName, and adjust the heartbeat interval and node timeout to prevent unexpected failovers due to DLM traffic.

  35. rac.asc – example file # ********************************************************************** # ********* HIGH AVAILABILITY CLUSTER CONFIGURATION FILE *************** # ***** For complete details about cluster parameters and how to ******* # ***** set them, consult the ServiceGuard manual. ********************* # ********************************************************************** CLUSTER_NAME rac FIRST_CLUSTER_LOCK_VG /dev/vg_rac NODE_NAME oracle5 NETWORK_INTERFACE lan0 STATIONARY_IP 15.136.25.205 FIRST_CLUSTER_LOCK_PV /dev/dsk/c4t11d0 NODE_NAME oracle6 ........ HEARTBEAT_INTERVAL 1000000 NODE_TIMEOUT 2000000 # Configuration/Reconfiguration Timing Parameters (microseconds). AUTO_START_TIMEOUT 600000000 NETWORK_POLLING_INTERVAL 2000000 # Package Configuration Parameters. MAX_CONFIGURED_PACKAGES 5 # List of OPS Volume Groups. OPS_VOLUME_GROUP /dev/vg_rac

  36. configure HP ServiceGuard Cluster • Check your configuration $ cmcheckconf –v –C rac.asc • Create the binary configuration file and distribute the cluster configuration to all the nodes in the cluster: $ cmapplyconf -v -C rac.asc • Note: the cluster is not started until you run cmrunnode or cmruncl on each node.

  37. starting the ServiceGuard cluster • Start the cluster from any node in the cluster $ cmruncl -v Or, on each node $ cmrunnode –v • Make all RAC volume groups and Cluster Lock volume groups sharable and cluster aware (not packages) from the cluster configuration node: $ vgchange -S y -c y /dev/vg_rac (shared=yes; cluster=yes) • On all the nodes, activate the volume group in shared mode in the cluster: $ vgchange –a s /dev/vg_rac

  38. check cluster • Check the cluster status: $ cmviewcl –v CLUSTER STATUS RAC_VIS up NODE STATUS STATE oracle5 up running Network_Parameters: INTERFACE STATUS PATH NAME PRIMARY up 0/0/3/0 lan0 PRIMARY up 0/4/1/0 lan2 • Check to see if your volume group is properly created and available:$ vgdisplay –v /dev/vg_rac

  39. re-create control file • prepare control file for recreation sql> alter database backup controlfile to trace sql> shutdown immediate • edit the trace-file, remove all lines beginning with # • modify the MAXINSTANCES parameter to an value higher than 1 • save the modified trace file to recreate_rac.sql • sqlplus “/ as sysdba” sql> @recreate_rac.sql

  40. @recreate_rac.sql (1/2) STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "VIS" NORESETLOGS NOARCHIVELOG -- SET STANDBY TO MAXIMIZE PERFORMANCE MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 8 MAXLOGHISTORY 453 LOGFILE GROUP 3 '/oradata/VIS/log03.dbf' SIZE 100M, GROUP 4 '/oradata/VIS/log04.dbf' SIZE 100M, GROUP 5 '/oradata/VIS/log05.dbf' SIZE 100M -- STANDBY LOGFILE DATAFILE '/oradata/VIS/sys01.dbf', (…..) '/oradata/VIS/sys07.dbf', '/oradata/VIS/ctx01.dbf',

  41. @recreate_rac.sql (2/2) '/oradata/VIS/owa01.dbf', '/oradata/VIS/por01.dbf', '/oradata/VIS/apps_undots01.dbf', '/oradata/VIS/dat01.dbf', (…..) '/oradata/VIS/dat14.dbf', '/oradata/VIS/idx01.dbf', (…..) '/oradata/VIS/idx12.dbf' CHARACTER SET WE8ISO8859P1; ALTER DATABASE OPEN; # Commands to add tempfiles to temporary tablespaces. # Online tempfiles have complete space information. # Other tempfiles may require adjustment. ALTER TABLESPACE TEMP ADD TEMPFILE '/oradata/VIS/tmp01.dbf' SIZE 786432000 REUSE AUTOEXTEND OFF; # End of tempfile additions.

  42. manually enabling second instance • Automatic Undo Management requires an undo tablespace per instance therefore you would require a minimum of 2 tablespaces. execute on primary instance: create undo tablespace APPS_UNDOTS2 datafile '/oradata/VIS/undots_02.dbf' size 260M / alter database add logfile thread 2 GROUP 4( '/oradata/VIS/log_04.dbf', ) SIZE 60M, …. / alter database enable public thread 2 / • The second instance can be started

  43. Oracle E-Business Suite 9iRAC Instances Package Manager Cluster Manager Network Manager Software Stack Oracle Group Membership Service 9iRAC SGeRAC MC/ServiceGuard HP-UX Kernel with SLVM Operating System

  44. changes on EBS midtier • iAS home open tnsnames.ora edit and change from SID to service-name • 8.0.6 home open tnsnames.ora edit and change from single instance SID to SID of the RAC-cluster instances Example: single instance SID: VIS RAC node 1: VIS1 RAC node 2: VIS2 • Note: 8.0.6 does not yet support linking to a service name, therefore you need to add SID for both instances

  45. at the end....happiness! 9iRAC cluster middle tier

  46. conclusion • migrating your E-Business Suite to 9iRAC is easy! • transition of your E-Business Suite db from PA-Risc to Itanuim2 is even easier! • get all benefits of 9iRAC on Itanium2: • performance • scalability • availability • start now to develop your expertise! • plan for the transition-migration!

  47. references • Installing Oracle Applications, Release 11i 11.5.8 (November 2002) (B10245-01) http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?284460 • 9i transition from PA-Risc to Itanium (white paper) http://otn.oracle.com/tech/hp/PA-RISC_to_Itanium_wp.pdf • Oracle9i Database Release 2 Documentation for HP 9000 Series HP-UX http://download.oracle.com/docs/html/A96167_01/toc.htm • HP Platforms for Oracle 9iRAC http://h30097.www3.hp.com/oracle9irac

  48. Q & Q U E S T I O N S A N S W E R S Q & A A

More Related