Query for Tablespace usage with Autoextend

Oracle Database Upgrade 11gR1 (11.1.0.6) to 11gR1 (11.1.0.7)

Go to path where path is placed

 

And unzip the .zip file by unzip command

Step 1

Verify the Time Zone Definitions

        The 11.1.0.7 patch set includes the Oracle time zone definitions Version 4.

        This version of the time zone definitions includes the changes to daylight savings time in the USA in 2007 and other updates.

        SQL> SELECT version FROM v$timezone_file;

       

           VERSION

        ----------

                 4

       

        If the query reports version 4, no action is required.

        If the query reports a version lower or higher than 4, then use below Note.

        Metalink Note: Actions for the DSTv4 update in the 11.1.0.7 patch set ID:568125.1

Step 2

Create PFILE

        sqlplus '/as sysdba'

        create pfile from spfile ;

step 3

Invalids Count

        select object_name, owner, object_type

        from all_objects where status like ‘INVALID’;

        select count(*) 

        from all_objects where status like ‘INVALID’;

step 4

Version and DBA_REGISTRY

        select * from v$version

        set lines 150 pages 500

        column COMP_NAME format a60

        column version format a15

        column status format a12

        select comp_name,version,status from dba_registry;    

step 5

Stop the DB Server and Listener gracefully

        SQL> CONNECT SYS AS 

        SQL> SHUTDOWN IMMEDIATE

        > lsnrctl stop $ORACLE_SID

Step 6

Installing the 11gR1 patchset (11.1.0.7):-

 launch the runInstaller, from 11.1.0.7 Staged directory

        > cd /Disk1

        > ./runInstaller

Login to root user and cd /opt/oracle/product/11g/   and then run root.sh script

Now after complete installation we

Set the environment

Start sqlplus prompt

sqlplus / as sysdba

sql>startup upgrade and run script catupgrd.sql from sql prompt.