Shulou(Shulou.com)06/01 Report--

Operating system version:

[oracle@D2-LZY245 ~] $cat / etc/redhat-release

CentOS Linux release 7.2.1511 (Core)

Database version:

SQL > select * from v$version

BANNER

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

PL/SQL Release 11.2.0.4.0-Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0-Production

NLSRTL Version 11.2.0.4.0-Production

Install 12cR2:

[oracle@D2-LZY245 ~] $ll linuxx64_12201_database.zip

-rw-r--r-- 1 oracle oinstall 3453696911 Sep 6 09:10 linuxx64_12201_database.zip

[oracle@D2-LZY245 ~] $unzip linuxx64_12201_database.zip

[oracle@D2-LZY245 ~] $export DISPLAY=192.168.17.100:0.0

[oracle@D2-LZY245 ~] $cd database/

[oracle@D2-LZY245 database] $. / runInstaller

Execute the script:

[root@D2-LZY245 ~] # / u01/app/oracle/product/12.2.0/dbhome_1/root.sh

Write 11g database information to / etc/oratab after installation:

[oracle@D2-LZY245 admin] $tail-1 / etc/oratab

Jhsitgg1:/u01/app/oracle/product/11.2.0/dbhome_1:Y

Start dbua under the home directory of 12cR2:

[oracle@D2-LZY245 database] $cd / u01/app/oracle/product/12.2.0/dbhome_1/bin/

[oracle@D2-LZY245 bin] $. / dbua

Verify:

After the upgrade, / etc/oratab has been modified to the home directory of 12cR2:

[oracle@D2-LZY245 bin] $tail-1 / etc/oratab

Orcl:/u01/app/oracle/product/12.2.0/dbhome_1:N

Manually modify the environment variables:

[oracle@D2-LZY245 ~] $env | grep ORACLE

ORACLE_SID=orcl

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1

Check that the database version has been upgraded:

SQL > select banner from v$version

BANNER

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production

PL/SQL Release 12.2.0.1.0-Production

CORE 12.2.0.1.0 Production

TNS for Linux: Version 12.2.0.1.0-Production

NLSRTL Version 12.2.0.1.0-Production

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.