STEP 1: Install The Software:
Download Oracle Database 11gR2 software . Execute runInstaller to install “SOFTWARE ONLY” option. Make sure that you select “software only” option.
STEP 2: Run Pre-Upgrade Information tool
I have installed the software under “/u01/app/oracle/product/11.2.0/dbhome_1″ location. Once the software is installed, then go to location $ORACLE_HOME/rdbms/admin and copy utlu112i.sql script to /tmp directory. Now login to 10g database “/ as sysdba” and startup the 10g database
va-idb01:RPTDB:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin $ls utlu*.sql
utlu112i.sql utlu112s.sql utlu112x.sql utluiobj.sql utlurl.sql utlusts.sql
va-idb01:RPTDB:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin $cp utlu112i.sql /tmp
SQL > spool /tmp/upgrade.splUsing DBUA utility
Execute the DBUA from 11gR2 software home as
$ cd $ORACLE_HOME/bin
11G Upgrade >
Upgrading Oracle database from 10.2.0.4.0 to 220.127.116.11.0
Oracle Database 11g includes fine-grained access control to the UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, or UTL_INADDR packages using Oracle XML DB. If you have applications that use these packages, then you must install Oracle XML DB if it is not installed. You must also configure network access control lists (ACLs) in the database before these packages can work as they did in earlier releases.
The following example first looks for any ACL currently assigned to host_name. If one is found, then the example grants user_name the CONNECT privilege in the ACL, only if that user does not have this privilege. If no ACL exists for host_name, then the example creates a new ACL called ACL_name, grants the CONNECT privilege to user_name, and assigns the ACL to host_name.
DECLARE acl_path VARCHAR2(4000); BEGIN SELECT acl INTO acl_path FROM dba_network_acls WHERE host = 'host_name' AND lower_port IS NULL AND upper_port IS NULL; IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(acl_path, 'user_name','connect') IS NULL THEN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl_path, 'user_name', TRUE, 'connect'); END IF; EXCEPTION WHEN no_data_found THEN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('ACL_name.xml', 'ACL description', 'user_name', TRUE, 'connect'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('ACL_name.xml','host_name'); END; COMMIT;
1-1 of 1