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

First download Oracle 11.2.0.3 Patchset

Http://yunpan.cn/cHgQuIuxUTThS

Access password 043f

Upload Patchset to the server

[oracle@localhost ~] $lsp10404530_112030_Linux-x86-64_1of7.zip p10404530_112030_Linux-x86-64_2of7.zip

Extract the installation package

[oracle@localhost ~] $unzip p10404530_112030_Linux-x86-64_1of7.zip [oracle@localhost ~] $unzip p10404530_112030_Linux-x86-64_2of7.zip

Enter the installation directory

[oracle@localhost ~] $cd database/ [oracle@localhost database] $lsdoc install readme.html response rpm runInstaller sshsetup stage welcome.html

First, install 11.2.0.3 only install software

Run runInstaller

[oracle@localhost database] $export ORACLE_HOME= "/ u01/app/oracle/product/11.2.0.3/db_1" [oracle@localhost database] $. / runInstaller

Select the install software only option

Select a new ORACLE_HOME

Second, after the installation of 11.2.0.3, you need to run a script to perform a pre-check before the upgrade.

[root@localhost ~] # su-oracle [oracle@localhost ~] $export | grep ORACLE_HOMEdeclare-x ORACLE_HOME= "/ u01/app/oracle/product/11.2.0.1/db_1"

Note that use the old version to log in to the database

SQL > SPOOL upgrade_info.logSQL > @ / u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/utlu112i.sql SQL > SPOOL OFF

The log is as follows

Oracle Database 11.2 Pre-Upgrade Information Tool 09-17-2015 22:13:08Script Version: 11.2.0.3.0 Build: 001.Please collect databases * * *-- > name: ORCL-- > version: 11.2.0.1.0-> compatible: 11.2.0.0.0-> blocksize: 8192-> platform: Linux x86 64 -bit-- > timezone file: V11.****Tablespaces: [make adjustments in the current environment] * * * *-> SYSTEM tablespace is adequate for the upgrade. Minimum required size: 681MB-- > SYSAUX tablespace is adequate for the upgrade. Minimum required size: 468 MB-- > UNDOTBS1 tablespace is adequate for the upgrade. Minimum required size: 400 MB-- > TEMP tablespace is adequate for the upgrade. Minimum required size: 60 MB.****Flashback: OFF** * Update Parameters: [Update Oracle Database 11.2 init.ora or spfile] Note: Pre -upgrade tool was run on a lower version 64-bit database.****-- > If Target Oracle is 32-Bit Refer here for Update Parameters:-- No update parameter changes are required..-- > If Target Oracle is 64-Bit Refer here for Update Parameters:-- No update parameter changes are required..****Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile] * *-No renamed parameters found. No changes are required..****Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile] * *-- No obsolete parameters found. No changes are required.****Components: [The following database components will be upgraded or installed] * * * *-- > Oracle Catalog Views [upgrade] VALID-- > Oracle Packages and Types [upgrade] VALID-- > JServer JAVA Virtual Machine [upgrade] VALID-- > Oracle XDK for Java [upgrade] VALID-- > Oracle Workspace Manager [upgrade] VALID-- > OLAP Analytic Workspace [upgrade] VALID- -> OLAP Catalog [upgrade] VALID-- > EM Repository [upgrade] VALID-- > Oracle Text [upgrade] VALID-- > Oracle XML Database [upgrade] VALID-- > Oracle Java Packages [upgrade] VALID-- > Oracle interMedia [upgrade] VALID-- > Spatial [upgrade] VALID-- > Expression Filter [upgrade] VALID-- > Rule Manager [upgrade] VALID-- > Oracle Application Express [upgrade] VALID... APEX will only be upgraded if the version of APEX in... The target Oracle home is higher than the current one.-- > Oracle OLAP API [upgrade] VALID.****Miscellaneous Warnings* * WARNING:-- > Database is using a timezone file older than version 14. After the release migration, it is recommended that DBMS_DST package.... Be used to upgrade the 11.2.0.1.0 database timezone version.... To the latest version which comes with the new release.WARNING:-> Your recycle bin is turned on and currently contains no objects. Because it is REQUIRED that the recycle bin be empty prior to upgrading.... And your recycle bin is turned on, you may need to execute the command: PURGE DBA_RECYCLEBIN.... Prior to executing your upgrade to confirm the recycle bin is empty.WARNING:-> Database contains schemas with objects dependent on DBMS_LDAP package. Refer to the 11g Upgrade Guide for instructions to configure Network ACLs. USER APEX_030200 has dependent objects..****Recommendations** * * Oracle recommends gathering dictionary statistics prior toupgrading the database.To gather dictionary statistics execute the following commandwhile connected as SYSDBA: EXECUTE dbms_stats.gather_dictionary_stats * Oracle recommends reviewing any defined events prior to upgrading.To view existing non-default events execute the following commandswhile connected AS SYSDBA: Events: SELECT (translate (value,chr (13) | | chr (10)) ) FROM sys.v$parameter2 WHERE UPPER (name) = 'EVENT' AND isdefault='FALSE' Trace Events: SELECT (translate (value,chr (13) | | chr (10)) '') from sys.v$parameter2 WHERE UPPER (name) ='_ TRACE_EVENTS' AND isdefault='FALSE'Changes will need to be made in the init.ora or spfile.****

Perform database dictionary statistics according to log requirements

EXECUTE dbms_stats.gather_dictionary_stats;SQL > SELECT (translate (value,chr (13) | | chr (10),'') FROM sys.v$parameter2 WHERE UPPER (name) = 'EVENT' AND isdefault='FALSE';no rows selectedSQL > SELECT (translate (value,chr (13) | | chr (10),'') from sys.v$parameter2 WHERE UPPER (name) ='_ TRACE_EVENTS' AND isdefault='FALSE';no rows selected

Configure the new version of LISTENER

[oracle@localhost bin] $export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db_1 [oracle@localhost bin] $export TNS_ADMIN= "/ u01/app/oracle/product/11.2.0.3/db_1/network/admin" [oracle@localhost ~] $cd / u01/app/oracle/product/11.2.0.3/db_1/bin/ [oracle @ localhost bin] $. / netmgr [oracle@localhost bin] $cd / u01 / App/oracle/product/11.2.0.3/db_1/network/ admin [oracle @ localhost admin] $cat listener.ora# listener.ora Network Configuration File: / u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = / u01/app/oracle/) Product/11.2.0.3/db_1) (SID_NAME = orcl)) LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.199.240) (PORT = 1521) ADR_BASE_LISTENER = / u01/app/oracle

Turn off the old listener

[oracle@localhost] $lsnrctl stop LSNRCTL for Linux: Version 11.2.0.1.0-Production on 17-SEP-2015 22:54:22Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.199.240) (PORT=1521)) The command completed successfully

Start a new listener

[oracle@localhost admin] $cd / u01/app/oracle/product/11.2.0.3/db_1/bin/ [Oracle @ localhost bin] $. / lsnrctl startLSNRCTL for Linux: Version 11.2.0.3.0-Production on 17-SEP-2015 22:52:47Copyright (c) 1991, 2011, Oracle. All rights reserved.Starting / u01/app/oracle/product/11.2.0.3/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.3.0-ProductionSystem parameter file is / u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.oraLog messages written to / u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xmlListening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168. 199.240) (PORT=1521)) Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.199.240) (PORT=1521)) STATUS of the LISTENER----Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0-ProductionStart Date 17-SEP-2015 22:52:47Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File / u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.oraListener Log File / u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.199.240) (PORT=1521)) Services Summary...Service "orcl" has 1 instance (s). Instance "orcl", status UNKNOWN, has 1 handler (s) for this service...The command completed successfully

IV. Execute dbua

[oracle@localhost bin] $pwd / u01/app/oracle/product/11.2.0.3/db_1/ bin[ oracle @ localhost bin] $. / dbua

Click Next

Click Next

Click Yes

You can choose to update Timezone, or you can choose to back up the database. Click Next

Click Next

Click Next

Click Finish

Click OK

Check the upgrade results, and if there are no errors, the upgrade is complete.

Modify the ORACLE_HOME environment variable to point to the new Oracle home

[oracle@localhost ~] $vi .bash _ profile export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1

Modify / etc/oratab

[oracle@localhost ~] $vi / etc/oratab orcl:/u01/app/oracle/product/11.2.0.3/db_1:N

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.