Upgrade Oracle Database 11.1.0 to 12.1.0 for EBS R12.1.3

将 EBS R12.1.3 的数据库 11.1.0.7 升级到 12.1.0.2

上篇文章将EBS12.1升级到12.3

这篇文章主要是介绍数据库 11.1.0.7 升级到 12.1.0.2，以及升级后的配置。

数据库版本：11.1.0.7.0

EBS：12.1.3

一、启动数据库

  # su - oracle
 $ cd /d01/oracle/PROD/db/tech_st/11.1.0/
 $ . ./PROD_ebs.env
 $ lsnrctl start 启动监听
 $ sqlplus /nolog 开启登录窗口
 
 SQL> conn / as sysdba 登录数据库
 Connected to an idle instance.
 
 SQL> startup 启动数据库
 ORACLE instance started.

二、停止所有应用程序服务并将应用程序置于维护模式。

 # su - applmgr
 $ cd /d01/oracle/PROD/apps/apps_st/appl/
 $ . ./APPSPROD_ebs.env 

adadmin命令菜单下或Oracle Applications Manager中启用（Enabled）和禁用（Disabled）维护模式

出现询问模式除了出现选项选择的时候其它回车即可。

Enter your choice [6] : 5
 
      Change Maintenance Mode
 ----------------------------------------
 
 Maintenance Mode is currently: [Enabled].
 
 
 Maintenance mode should normally be enabled when patching
 Oracle Applications and disabled when users are logged on
 to the system. See the Oracle Applications Maintenance
 Utilities manual for more information about maintenance mode.
 
 
 Please select an option: 1
 
 1. Enable Maintenance Mode
 
 2. Disable Maintenance Mode
 
 3. Return to Main Menu
 
 然后选择：5. Change Maintenance Mode
 再选择：1.  Enable Maintenance Mode，
 

三、使用adpatch 安装所有提到的补丁。

• 补丁 8796558
• 补丁 12923944
• 补丁 13473483
• 补丁 16289505
• 补丁 18843706
• 补丁 19558309

下载补丁链接

1.解压补丁软件zip

将下载好的补丁解压到/patch目录下

然后修改/patch权限

chmod -R 777 /patch
 或者
 chown –R applmgr:oinstall /patch 

2.执行adpatch命令

进入解压好的文件执行adpatch

**提示：**执行adpatch命令，会出现和adadmin相似的询问，大部分回车或者输入默认密码，以下例外：

Please enter the name of your AutoPatch driver file : （输入drv文件名，如u7461070.drv）

u7461070.drv： 在对应的文件夹下。

等待安装完成。

四、静默模式安装12.1.0.2

1.创建数据库12.1.0目录

[oracle@ebs 12.1.0]$ mkdir 12.1.0

2.下载链接：https://edelivery.oracle.com/

3.上传到12.1目录

4.解压并进入到database,修改db_install_new.rsp

**提示:**修改之前建议先备份

修改内容如下：

vim db_install_new.rsp
# 强制只安装数据库软件
oracle.install.option=INSTALL_DB_SWONLY
# 设置你的主机名
ORACLE_HOSTNAME=ebs
# 为 oracle 清单设置 unix 组
UNIX_GROUP_NAME=oinstall
# 为 oracle 清单设置目录
INVENTORY_LOCATION=/$ORALCE_HOME/oraInventory
# 为二进制文件设置 oracle home
ORACLE_HOME=/dO1/oracle/PROD/db/tech_st/12.1.0
# 为二进制文件设置 oracle home
ORACLE_BASE=/d01/oracle
# 设置要安装的二进制文件版本 EE - 企业版
oracle.install.db.InstallEdition=EE
DECLINE_SECURITY_UPDATES=true
# 为数据库管理指定额外的组
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
oracle.install.db.BACKUPDBA_GROUP=dba
oracle.install.db.DGDBA_GROUP=dba
oracle.install.db.KMDBA_GROUP=dba

5.开始安装 Oracle 12c 二进制文件

cd/database
./runInstaller -silent -responseFile /d01/oracle/PROD/db/tech_st/12.1.0/database/response/db_install.rsp -showProgress

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 5398 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 15992 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-12-03_07-32-41PM. Please wait ...[oracle@ebs122 database 07:32 PM]$You can find the log of this install session at:
 /ebs121/oraInventory/logs/installActions2020-12-03_07-32-41PM.log

Prepare in progress.
..................................................   8% Done.

Prepare successful.

Copy files in progress.
..................................................   13% Done.
..................................................   18% Done.
..................................................   23% Done.
..................................................   28% Done.
..................................................   33% Done.
..................................................   39% Done.
..................................................   45% Done.
..................................................   50% Done.
..................................................   55% Done.
..................................................   60% Done.
..................................................   65% Done.
..................................................   70% Done.
..................................................   75% Done.

Copy files successful.

Link binaries in progress.

Link binaries successful.

Setup files in progress.
..............................
Setup files successful.
..........
Setup Inventory in progress.

Setup Inventory successful.
..................................................   80% Done.
..........
Finish Setup successful.
The installation of Oracle Database 12c was successful.
Please check '/ebs121/oraInventory/logs/silentInstall2020-12-03_07-32-41PM.log' for more details.

Setup Oracle Base in progress.

Setup Oracle Base successful.
..................................................   95% Done.

As a root user, execute the following script(s):
        1. /ebs121/oracle/DEV121/db/tech_st/12.1.0/root.sh



..................................................   100% Done.
Successfully Setup Software.

执行root.sh脚本,查看日志文件

[oracle@ebs 12.1.0]$ sh /d01/oracle/PROD/db/tech_st/12.1.0/root.sh
Check /d01/oracle/PROD/db/tech_st/12.1.0/install/root_ebs122.lab_2020-12-03_19-41-52.log for
cat /d01/oracle/PROD/db/tech_st/12.1.0/install/root_ebs122.lab_2020-12-03_19-41-52.log
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /d01/oracle/PROD/db/tech_st/12.1.0
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.

6.创建一个临时的12c环境文件

vim 12.env
添加如下内容：
export ORACLE_HOME= /d01/oracle/PROD/db/tech_st/12.1.0

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export CLASS_PATH=$ORACLE_HOME/jlib

export ORACLE_SID=DEV121

export PERL5LIB=$ORACLE_HOME/perl/lib/5.14.1:$ORACLE_HOME/perl/lib/site_perl/5.14.1

执行12c 数据库环境

运行perl $ORACLE_HOME/nls/data/old/cr9idata.pl

. ./12.env
perl $ORACLE_HOME/nls/data/old/cr9idata.pl
已知错误：
perl：符号查找错误：/do1/oracle/DEV121/db/tech_st/12.1.0/perl/lib/5.14.1/x86_64-linux-thread-multi/auto/Tie/Hash/NamedCapture/NamedCapture.so：未定义符号：Perl_xs_apiversion_bootcheck

解决方案：

$ORACLE_HOME/p