SAPInst & Oracle

2y ago
32 Views
2 Downloads
817.76 KB
35 Pages
Last View : 2m ago
Last Download : 2m ago
Upload by : Laura Ramon
Transcription

SAPInst & OracleASM, Exadata, DB Rename in SAPinstUwe Specht SAP AGOracle Platforms16 November, 2011

About MeNixdorf Computer AG / Siemens Nixdorf8 yearsOrdix AG2 yearsSAP Basis consultant (freelance)2 yearsSAP LGD3 yearsSAP AGover 10 years 2011 SAP AG. All rights reserved.2

About Me SAP AGR3INST Oracle versions 6 - 7R3SETUP Oracle versions 8 - 10SAPInst Oracle versions 9 - 11R3*tools Oracle versions 6 - 11Shell scripts startsap, stopsap, SAP environment 2011 SAP AG. All rights reserved.3

AgendaSAPInst & DB Rename LVM Landscape Virtualization Management 1.0SAPInst & ASM What is possible and what notSAPInst & Exadata PlansSAPInst Outlook Downward-compatible releases New Oracle platforms 2011 SAP AG. All rights reserved.4

SAPInst & DB Rename

Outlook: System Copy – Storage-BasedOracle DBCI/JI/ /oracleABC/sapdata oraarch origlogusrsapsapmntABCInstances of thesource system ABCRepresentation ofthe file systems ofthe source systemABCput trans ABC1.2.3.Copy / clones of the file systems of all instancesMounting the file systems on the target host - under the new SIDAdaptations: file system permissions, profiles, user environments, Secure Store, OPS user, sapdata oraarch origlogABC XYZ/oracleOracle DB 2011 SAP AG. All rights reserved.put trans ABC XYZABC XYZsapusrsapmnt/CI/JI/ Representation of thefile systems of thetarget system XYZInstances of the targetsystems XYZ6

SAPinst & DB RenameLandscape Virtualization Management LVM 1.0 Enterprise/Standard EditionEnterprise Edition in LVM 1.0Note: 1527538 Chargeable Complete automation includingPost System Copy Automation http://www.sdn.sap.com/irj/sdn/virtualization http://service.sap.com/instlvmStandard EditionReleased for 7.0.x products Freely available and installable with SAPinst No Post System Copy AutomationPlanned RTC: end November 2011 2011 SAP AG. All rights reserved.7

SAPinst & DB RenameDialogs (1/2)SAP system parametersEnter the parameters for source andtarget system. 2011 SAP AG. All rights reserved.SAP instances selectionEnter the parameters for source andtarget instances.8

SAPinst & DB RenameDialogs (2/2)Creating a renamed Oracle databaseEnter the parameters for source and targetdatabase. 2011 SAP AG. All rights reserved.Oracle database configurationEnter the target system parameters.9

SAPInst & DB RenamePrerequisites for Unix (1/2)You must reset Unix mountpoints. SAPinst can move directories.Stop the database before the snapshot (recovery is not yet possible for rename).No support for ASM or Exadata./oracle/ DBSID /112 64 must be a relative link (as of 11.2.0.3 with runInstaller)Permissions are only transferred for database files under directories /oracle/ DBSID and/oracle/client/1[01]x 64/instantclient/Permissions of Oracle oraInventory (/etc/oraInst.loc) are reset. 2011 SAP AG. All rights reserved.10

SAPInst & DB RenamePrerequisites for Unix (2/2)TNS ADMIN /usr/sap/SID/SYS/profile/oracleInstallations that do not follow SAP naming conventions are not fully supported. 2011 SAP AG. All rights reserved.11

SAPInst & DB RenamePrerequisites Windows (1/2)The Oracle software must already be installed and the path to ORACLE HOME must not havebeen changed. As of LVM 1.1, the Oracle database software is also renamedYou must stop the database before the snapshot (recovery is not yet possible for rename).No support for ASM or Exadata.Important: The ABAP schema can not be determined on Windows platforms. Therefore, youmust enter this correctly in the dialog.Installations that do not follow SAP naming conventions are not fully supported. 2011 SAP AG. All rights reserved.12

SAPInst & DB RenamePrerequisites Windows (2/2)Oracle Software at d:\oracle\ORAOracle Database with new DB SID : MB3 - MB4Oracle file systemsc:\oracle\MB4, d:\oracle\MB4, e:\oracle\MB4SAP system MB3 - MB4 2011 SAP AG. All rights reserved.13

SAPInst & DB RenameConversion of the Oracle e ixunixrelink alloracle binariesrunroot.shUnix 2011 SAP AG. All rights reserved.chownsapdataHomeunix14

SAPInst & DB RenameConversion of the Oracle Databaserename.sqlProcesssuccessful?run rename.sqlrecoverdatabase(next release)createcontrolfilebackupcontrolfile totracePostconversion –removeschema users 2011 SAP AG. All rights reserved.15

SAPInst & DB RenameSummary: Processing SequenceConversion of the database software runInstaller –detachHome - runInstaller –clone - chown –R orasid:dba Relink the Oracle executablesRun root.sh (file is generated from runInstaller –clone)Conversion of the RDBMS database Start the database with old name dbName but new data file names (rename.sql)Generate the control files with alter database backup controlfile to trace (run rename.sql)Recover the database (as of Version 1.2)Generate the new database with CREATE CONTROLFILE SET DATABASE Oracle log files (ora sql results.log, alert*.log) 2011 SAP AG. All rights reserved.16

SAPInst & ASM

SAPInst & ASMDialogsDatabase parametersDatabase on ASMDatabase on Exadata Only for Linux or SolarisOracle Database Machine 2011 SAP AG. All rights reserved.18

SAPInst & ASMUsers and GroupsOS database accountsOS users oracleOS groups oinstalldbaoperasmdbaasmoperasmadminUser sid adm remains 2011 SAP AG. All rights reserved.19

SAPInst & ASMAdvanced DB Configuration 1/4Advanced dialog changes for ASM 2011 SAP AG. All rights reserved.Mapping sapdata key to ASM data path20

SAPInst & ASMAdvanced DB Configuration 2/4 /row .DBSIZE.XML row fld name "tblspName„ strval ![CDATA[PSAP@SCHEMAID@USR]] /strval /fld fld name "tblspSize„ strval ![CDATA[20]] /strval /fld fld name "sapdataDir„ strval ![CDATA[SAPDATA4]] /strval /fld /row row . 2011 SAP AG. All rights reserved.sapdataDir SAPDATA4ASM Data Path DATA21

SAPInst & ASMAdvanced DB Configuration 3/4Mapping tablespace to sapdata key 2011 SAP AG. All rights reserved.Database control files for ASM22

SAPInst & ASMAdvanced DB Configuration 4/4Tablespace compression 2011 SAP AG. All rights reserved.Dialog to install the Oracle database softwarewith runInstaller23

SAPInst & ASMAvailabilityASM available in SAPinst for versions:7.03: SAP Business Suite 7 Innovation 20117.31: SAP NetWeaver 7.31ASM in SAPinst for the 11.2 downward-compatible DVDsIn progress SAPinst control files (control.xml, keydb.xml, dialog.xml) must be swapped There will (probably) be no installation master DVD for Oracle ASM 2011 SAP AG. All rights reserved.24

SAPInst & ASMProblems when RestartingCreate DatabaseWhen SAPint is restarted, in the createDB step the old tablespace data files are not overwrittenbecause the name is automatically generated. If restart is performed several times, this generates asurplus of old files in the ASM container (system, psaptemp, psapundo, sysaux)Create TablespacesWhen SAPint is restarted, in the createTablespace step all tablespaces are recreated. This can use alot of space because of the repeated execution of alter tablespace add datafile „ DATA‟. 2011 SAP AG. All rights reserved.25

SAPInst & Exadata

SAPInst & ExadataInitial Delivery via SAP NoteSAP Note 1619343SAPInst for Oracle ExadataPlatforms Oracle Linux on X86 64 (Red Hat) Solaris X86User environment is identical to that of ASM oracle user oinstall, asmdba, asmoper, asmadmin groupsRestrictions for Exadata compared to ASM ARCH disk group is not present Compatible parameters must be correctly set, for example:compatible 11.2.0.2 2011 SAP AG. All rights reserved.27

SAPInst & ExadataDelivery with SAPInstSAP Business Suite 7 Innovation 2011Installation MasterSAP Netweaver 7.31Installation MasterSAP Netweaver 7.03 --- Software Life-Cycle OptionsSAP Netweaver 7.31 --- Database Tools 2011 SAP AG. All rights reserved.28

SAPInst & OutlookNew Oracle Platforms Solaris 11 and Oracle Linux (Red Hat 6)Oracle 11.2 Downward-Compatible ReleasesNew ABAP Secure Store

SAPInst & OutlookNew Oracle PlatformsSAP Note: 1642058Adapt SAPInst Oracle Client 11.2.0.3 on Solaris 11 and Oracle Linux (Red Hat 6)All downward-compatible releases for Oracle Server 11.2.0.x use Oracle Client 10.2 Solaris 11 and Oracle Linux are only released with Oracle Client 11.2 Shell scripts adaptSapinst.sh and adaptDvd.sh generate new ORADBPAR.XML and packages.xml Shell scripts available as attachments to SAP Notes– adaptSapinst.sh– adaptDvd.sh 2011 SAP AG. All rights reserved.30

SAPInst & OutlookOracle 11.2 Downward-Compatible Releases?No new installation master DVD (“latest and greatest”)All downward-compatible releases are installed with 11.2 server and 10.2 clientControl files are swapped: control.xml, keydb.xml, dialog.xmlProduct files are swapped: product.xml, packages.xml, ORADBPAR.XML 2011 SAP AG. All rights reserved.31

SAPInst OutlookNew ABAP Secure StoreOracle error as of 11.2.0.x: ORA-32006: REMOTE OS AUTHENT initialization parameter has been deprecatedOracle instance started.SAP Notes:1623922: Connect to Oracle DB157499: OPS Connect and security aspects– Aimed especially at SAP versions 6401622837: Connect to Oracle by SSFS (secure store)– Aimed at SAP versions 7.x 2011 SAP AG. All rights reserved.32

SAPInst OutlookNewr ABAP Secure StoreSAP Note:1431798: REMOTE OS AUTHENT– TRUE (optional, no longer recommended, but still SAPinst default)– Do not set ( FALSE), ifo SAP installations with SSFS for ABAP - see SAP Note 1622837o SAP installations without ABAP stacko Homogenous SAP installations on Windows 2011 SAP AG. All rights reserved.33

Questions?Thank You!For more information, see SDN:https://www.sdn.sap.com/irj/sdn/oraContact: uwe.specht@sap.com

2011 SAP AG. All rights reserved.No part of this publication may be reproduced or transmitted in any form or for any purposewithout the express permission of SAP AG. The information contained herein may bechanged without prior notice.Some software products marketed by SAP AG and its distributors contain proprietarysoftware components of other software vendors.Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of MicrosoftCorporation.IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x,System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer,z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server,PowerVM, Power Architecture, POWER6 , POWER6, POWER5 , POWER5, POWER,OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP,RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX,Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registeredtrademarks of IBM Corporation.Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks orregistered trademarks of Adobe Systems Incorporated in the United States and/or othercountries.Oracle and Java are registered trademarks of Oracle and/or its affiliates. HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C , WorldWide Web Consortium, Massachusetts Institute of Technology.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer,StreamWork, and other SAP products and services mentioned herein as well as theirrespective logos are trademarks or registered trademarks of SAP AG in Germany and othercountries.Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports,Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products andservices mentioned herein as well as their respective logos are trademarks or registeredtrademarks of Business Objects Software Ltd. Business Objects is anSAP company.Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybaseproducts and services mentioned herein as well as their respective logos are trademarks orregistered trademarks of Sybase, Inc. Sybase is an SAP company.All other product and service names mentioned are the trademarks of their respectivecompanies. Data contained in this document serves informational purposes only. Nationalproduct specifications may vary.The information in this document is proprietary to SAP. No part of this document may bereproduced, copied, or transmitted in any form or for any purpose without the express priorwritten permission of SAP AG.UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin aretrademarks or registered trademarks of Citrix Systems, Inc. 2011 SAP AG. All rights reserved.59

New Oracle Platforms SAP Note: 1642058 Adapt SAPInst Oracle Client 11.2.0.3 on Solaris 11 and Oracle Linux (Red Hat 6) All downward-compatible releases for Oracle Server 11.2.0.x use Oracle Client 10.2 Solaris 11 and Oracle Linux are only released with Oracle Client 11.2

Related Documents:

Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,

Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,

7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence

Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle

PeopleSoft Oracle JD Edwards Oracle Siebel Oracle Xtra Large Model Payroll E-Business Suite Oracle Middleware Performance Oracle Database JDE Enterprise One 9.1 Oracle VM 2.2 2,000 Users TPC-C Oracle 11g C240 M3 TPC-C Oracle DB 11g & OEL 1,244,550 OPTS/Sec C250 M2 Oracle E-Business Suite M

Oracle Database using Oracle Real Application Clusters (Oracle RAC) and Oracle Resource Management provided the first consolidation platform optimized for Oracle Database and is the MAA best practice for Oracle Database 11g. Oracle RAC enables multiple Oracle databases to be easily consolidated onto a single Oracle RAC cluster.

Specific tasks you can accomplish using Oracle Sales Compensation Oracle Oracle Sales Compensation setup Oracle Oracle Sales Compensation functions and features Oracle Oracle Sales Compensation windows Oracle Oracle Sales Compensation reports and processes This preface explains how this user's guide is organized and introduces

ALIENS 3 a Cap. 9. Acts 48 of 1964 25 of UBI. THE ALIENS ACT [28zh February, 1946.1 S. 11. PART 1. Preliminary 1. This Act may be cited as the Aliens Act. Short title lntcrpreta- tim. 2. In this Act- “embark” includes departure by any form of conveyance; “Hedth Officer” means any registered medical piactitioner