主页 > CDN > > 正文

美国服务器_pc端cdn_9元

来源:胜利云 发布时间:2021-09-07 12:26 标签:服务器美国9元
浏览:

ORACLE UPGRADE STEPS FROM 11g TO 12c FOR SAP SYSTEMS ON LINUX – PART I

Document creation date :   10th OCT 2015 | 09:30 AM INDIA

Document Part                :  1st

Document Author            :  Gaurav Rana

Referred SAP Guide        :  Database Upgrade Guide to Oracle database 12c Release 1 (12.1.0.2 ) UNIX

Referred SAP NOTES      :  1. NOTE : 1914631 – Starting point for info about oracle 12c .

2. NOTE :  1915317-Migrating Software owner to ‘oracle’

3. NOTE : 1915323 – OS User Concept for database release 12c.

STEPS TO FOLLOW    :

PREREQUISITES

a) Source release must be Oracle DB 10.2.0.5,11.2.0.2,11.2.0.3 or 11.2.0.4 (Check your database version with command, SQL>select version from v$instance;)

b) Only 12.1.0.2 release 1 is supported for SAP platforms instead of 12.1.0.1 .

c) For SAP environments, Oracle Instant Client versions 11.2.0.4 and 12.1.0.2 are supported.

RESTRICTIONS

a) In order to run the SAP system with Oracle Instant Client version 12.1.0.2 ,you’ll have to apply the SAP support packages from SAP Note 1777021.

b) SAP Kernel release must be >= 7.21 EXT.

c) SAP BR*Tools minimum version for 12.1: BR*Tools 7.40 Patch Level 14.

d) Mandatory to apply the appropriate SAP Support package according to SAP Note 2157904.

e) Must be applied before or immediately after a database upgrade to Oracle release 12c or after a new installation with Oracle release 12c.

f) Secure Storage on File System (SSFS) must be configured and enabled to run SAP with Oracle Database 12c.

CHECKLIST BEFORE STARTING SAP SYSTEM OF UPGRADED SYSTEM

a). Migration of oracle software owner from ora to ‘oracle’.

b). Installation of database 12.1.0.2 with Patches.

c). Install the latest Oracle client (12.1.0.2) for the database 12.1.0.2 .

d). Update BR*Tools with version 7.40 .

e). SSFS database connection configurations (SAP Notes 1639578 & 1622837) .

PREPARATION

a). Download the Oracle 12c software with patches from

b). Download latest version of DBATOOLS (BR*Tools) which we need to be used after the upgrade .

c). Set the display parameters :0.0 or use command xhost + .

CHECKLIST STEPS IN DETAIL

a) Migration of database user ora to ‘oracle’ user .

For the step i recommends to refer SAP NOTE 1915317-Migrating Software owner to ‘oracle’  or can follow steps as below :

1.Shutdown the running SAP System & the database with use of command stopsap all or can stop the SAP System & Database individually along with listener with command lsnrctl stop .

2.Creation of oracle software owner account ‘oracle’ from the root account

# groupadd oinstall

# useradd -g oinstall -G dba,oper -c "Oracle Software Owner" -m -s "/bin/sh" oracle

# passwd oracle

# su – oracle -c "id;pwd"

3.Modification of SAP Admin account adm

Add the adm account as OS group ‘oinstall’ (Required to run BR*TOOLS)

# groupmod -A adm oinstall or execute

# usermod -G sapsys,sapinst,dba,oper,oinstall adm

4.Modification of Database Admin account ‘ora

Log on as ‘root’ and run the commands …

# mkdir -p /home/ora

# chown orasbx:dba /home/ora

# usermod -d /home/orasbx ora

# usermod -g dba -G oper,oinstall ora

From the root account :

# cd /oracle/

# mv .profile .login .bashrc .cshrc .sap* .dbenv* .j2eenv* /home/ora

# mv startdb stopdb /home/ora

# chown -R ora:dba /home/ora

Oracle Environment consistency

Note : If Oracle env for set for user ‘oracle’ differs from the oracle env for user ADM then system will not connect to the database.

To check, logon with user account adm & oracle to verify variables ORACLE_BASE,ORACLE_HOME & ORACLE_SID which should be set identical .

Ownership changes for data files & directories

Permissions & ownerships can be changed with help of script ‘orasid2oracle.sh’ (Script is attached with SAP Note 1915317 named orasid2oracle.zip)

On unzip the file, a directory will be created with name sapnote_1915317, contains executable script orasid2oracle.sh.

Parameters to be set before execution of the script :

1.Log on with root account

#export SAPDATA_HOME=/oracle/

#export ORACLE_BASE=/oracle/

#export DB_SID=

2.To test run

#./orasid2oracle.sh -v

3.To perform changes

#./orasid2oracle.sh -v -exec

Ownership change of Oracle Home

Under this step we’ll change the software owner of Oracle Home from ‘ora’ to ‘oracle’ and same can be achieved with the help of oracle cloning tool from SAP Note 1983457 (Recommended).

You can find the clone tool script named clone_oh-1.7-005.zip as an attachment with the SAP Note 1983457,& on extraction of the zip file a new directory will be created as sapnote_1983457.

From the directory we need to execute clone_assistant.sh .

Steps to execute clone_assistant.sh

Log on as ora & execute clone_assistant.sh script to generate the scripts.This script will ask some questions for further execution steps, For help sample answers can be find from the same SAP Note 1983457.

To save generated scripts from clone_assistant.sh we can provide our own location on the system. For ex. /oracle//ora_clone/pkg_clone_oh/change_sw_owner/

Scripts generated by the execution of clone_assistant.sh will be as follows :

config00_settings.sh

config01_show_env.sh

config02_detach_oh.sh

config03_set_swowner.sh

config04_clone_oh.sh

config05_run_rootsh.sh

config06_cleanup.sh

From the script directory execute the generated Oracle Home configuration scripts as per steps

From the old software owner ora

su –  ora

>./config01_show_env.sh

>./config02_detach_oh.sh

As a root user

# ./config03_set_swowner.sh

From the new software owner ‘oracle’

>./config04_clone_oh.sh

As a root user

#./config05_run_rootsh.sh

For cleanup action, login as a old software owner

su – ora

>./config06_cleanup.sh

STARTING OF DATABASE LISTENER AS A NEW SOFTWARE OWNER ‘oracle’

During startup of listener from new software owner ‘oracle’ i experienced troubles in terms of environment variable settings for same.

发表评论
验证码: 点击我更换图片

注:网友评论仅供其表达个人看法,并不代表本站立场。

热门文章

  • 谷歌云_mysql中间件_免费领
    谷歌云_mysql中间件_免费领

    谷歌云_mysql中间件_免费领

    现在工作场所正在发生重大变化。我们协作、计划项目和管理工作量的方式正在改变,如果企业没有做好准备,它们将很快被抛在后面。准确地理解是什么...

  • 域名交易_阿里云翼_企业级
    域名交易_阿里云翼_企业级

    域名交易_阿里云翼_企业级

    通常认为搅动器是一个漏水的桶。你有多少顾客?你损失了多少?你留了多少钱,漏了多少钱?让我们把顾客流失看作是导致医生就诊的原因,比如偏头痛...

  • 金山云_华为云台_怎么申请
    <strong>金山云_华为云台_怎么申请</strong>

    金山云_华为云台_怎么申请

    在我们发布通知(以前是Engage)后的四个月里,我们在后端做了大量的改进。大多数更新在UI中不可见。相反,我们的客户可能已经注意到他们发送的电子...

  • 云主机_深圳企业网站设计_评分榜
    <strong>云主机_深圳企业网站设计_评分榜</strong>

    云主机_深圳企业网站设计_评分榜

    更新:有本文的更新版本。阅读"RPA如何转换数据迁移"(2019年出版)。 在本文中,数据迁移被定义为将数据从旧的遗留系统移动到新的替换系统。通常,...

  • 域名备案_已备案未注册的域名_最新活动
    <strong>域名备案_已备案未注册的域名_最新活动</strong>

    域名备案_已备案未注册的域名_最新活动

    今天是Skype推出十年来的日子,Skype是一款免费的互联网通话应用,用户已超过3亿。Skype是一家来自爱沙尼亚的初创公司,来自点对点文件共享应用Kazaa的开...

云储存

更多 >
  • <strong>网站空间_电脑百度云_促销</strong>
    网站空间_电脑百度云_促销

    各位, 科技季又一次来临了。这不是一年中与同事和朋友见面最美妙的时刻,就是令人讨厌的"我去了TechEd,我得到的只是这件糟糕的t恤"博客占据了你的...

  • <strong>阿里云_专业网站建设开发_哪家好</strong>
    阿里云_专业网站建设开发_哪家好

    土著澳大利亚人 数据可视化有助于了解原始数据,使我们能够就研究领域的相关问题作出决策。在这个博客中,我们展示了从2007年到2013年收集的死亡原因...

云储存免备案CDN_国外服务器_免费6个月
云储存腾讯云_时王百度云_优惠券
云储存云主机_云空间服务器_0元
云储存腾讯云_长沙网站建设价格_多少钱
云储存大带宽_阿里巴巴云舒的年薪_免费1年