31 August 2013

Oracle Database Interview Questions

Q 1: What are the steps involved in database startup?
Ans: Start an Instance, Mount the database and Open the Database.

Q2: What are the steps involved in database shutdown?
Ans : Close the database ; Dismount the database and Shutdown the instance.

Q3: What is Archived Redo log?
Ans: Acrhived Redo Log consists of Redo Log files that have archived before being reused

Q4: What is a temporary segment?
Ans: Temporary segments are created by ORACLE when a sql statement needs a temporary work area to complete execution. When the statement finishes execution , the temporary segment extents are released to the system for future use.

Q5: What does a control file contain?
Ans: A control file records the physical structure of the database, database name,time stamp of database creation,max datafile limit,max redo log group,max log file members, database archive information,backup information..

Q6:What is a Tablespace?
Ans: A database is divided into Logical storage unit called tablespace. A tablespace used to grouped related logical structures together

Q7: Explain the relation ship among the database,tablespace and datafiles?
Ans: Each database logically divided in to one or more tablespaces. One or more datafiles are explicitly created for each tablespace.

Q8:What is Logical structure of the database?
Ans: Database àTablespacesàsegmentsàExtentsàOracle Blocks

Q9: What is the physical structure of the database?
Ans: Datafiles,Control File and redo log files.

Q10: What are Different types of segments?
Ans: Temp Segement, Undo Segment, Table Segment and Index Segment.

Q11: Can you name few DBMS Package names and their use?
Ans: DBMS_JOBS, DBMS_STATS,DBMS_SQLTUNE..

Q12: How Do you find whether the instance was started with PFILE or SPFILE?
Ans: Sho parameter spfile or query from v$parameter.

Q13: What Column differentiates the v$views to the gv$views and how?
Ans: The INST_ID Column which indicates the instance in a RAC environment the information came from ..

Q14: Explain an Ora -1555
Ans: You get this error when you get a snap shot too old within roolback.It can usually be solved by increasing the undo retention or increasing the size of rollbacks

Q15:What is Diffeernce between a temporary tablespace and a permanent tablespace?
Ans: A temporary tablespace is used for Sort Oprations of no sufficient space found in PGA. Permanent tablespace stores the true objects of dataase ..

Q16:How Do you add a datafile to a tablespace?
Ans: alter tablespace add datafile size ;

Q17: How Do you resize a datafile?
Ans: alter database datafile resize ;

Q18: What view Would you use to look at th size of a datafile?
Ans: dba_data_files,V$datafile

Q19: What view Would you use to determine free space in a tablespace?
Ans: dba_free_space

Q20: How can you gather statistics on a table?
Ans: The analyze command or using DBMS_STATS package.

Q21: List out the views names we can use to find about undo usage?
Ans: V$undostat,dba_undo_segs

Q22: What is view we can use to find out database locks?
Ans: v$lock

Q23: Using which view will check for session and process details?
Ans: V$session,v$process

Q24: Using which view will you find out , how much % Operation or job completed sofar it is running in database?
Ans: v$session_longops

Q25: How will you find out running job names from database?
Ans: Querying from dba_jobs,Dba_jobs_running views

Q26:How will find out Database creation time details? What is the column name?
Ans: v$database; created is column

Q27: How will you find out instance startup time?
Ans: v$instance,startup_time

Q28: How do you find archive is enabled for database?
Ans: archive log list or v$database ,log_mode Cloumn

Q29: How will you find active/inactive session count from database?
Ans: select status,count(*) from v$session group by status;

Q30: explain about temporary tablespace groups?
Ans: It is 10g new feature . it is a group of temporary tablespaces. We can get more details from dba_tablespace_groups if it is enabled.

Q31: What is undo_retention?
Ans : Time specification for undo segments hold the data ..and these reusable are reusable..

Q32: How will you find undo management is auto or manual?
Ans : Sho parameter undo_management

Q33: If your database contain 4 undo tablespaces..how will you find out which undo tablespace is used by database?
Ans: Sho parameter undo_tablespace

Q34: If you database contain 5 temporary tablespaces how will you find out what is default temporary tablespace to databse?
Ans: By querying database_properties

Q35. What is alert log file and how will you find out the location of file from database?
Ans : Sho parameter dump

UNIX:

Q36: How can you determine if an Oracle Instance is up from the Operating system level?
Ans: ps –efgrep smon/pmon

Q37: How can u find dead processes?
Ans: ps –efgrep zombie or who –d or ps –efgrep defunc

Q38: Give the command to display space usage on the UNIX File system?
Ans: df –lk or df –lh or df –k/h

Q39: Explain sar and vmstat?
Ans: sar used for to get system activity report and Vmstat reports on virtuval memory statistics for processes .

Q40: How do you find the Load average of a server?
Ans: using uptime command.

Q41: How do you find out swap usage on a server?
Ans: free –g

Q42: How will you kill a process id at OS level ?
Ans: kill -9

Q43: How will you find out the count of Oracle processes running on server?
Ans: ps –efgrep wc –l

Q44: How will you check if any Rman backup is running?
Ans: ps –efgrep rman

Q45: How will check cron schedule job details?
Ans: Crontab –l

Q46 : How will find ASM instance is running on server?
Ans : ps –efgrep +ASM

Q47 : I have a very big file at OS and I want see last 50 lines of the file only..Which command will you use?
Ans : tail -50

Q48: How can you find , file last accessed ( modified )date?
Ans : ls –l Q49: How will you find out howmany instances are running on a server?
Ans : ps –efgrep smon (gives all instance names which are running)

Q50 : What is the command we can use to find trace of process at OS level?(means what process is doing)
And : strace –p
Posted by Naresh Kumar 0 comments
Friday, December 17, 2010
Oracle DBA Interview Questions - Part 1
Oracle DBA Interview Questions - Part 1
------------------------------------------------

Below are the few of Oracle database interview questions, Watch this space for more questions & answers.

Please provide your comments, Feedback welcome.


1) List components of an Oracle instance?

Ans:

An Oracle instance is comprised of memory structures and background processes.
The Systems Global Area (SGA) and shared pool are memory structures. The process monitor is a background process (DBWn, LGWR, ARCn, and PMON). The Oracle database consists of the physical components such as data files; redo log files, and the control file.

2)Which background process and associated database component guarantees that committed data is saved even when the changes have not been recorded in the data files?

Ans:

LGWR (log writer) and online redo log files. The log writer process writes data to the buffers when a transaction is committed. LGWR writes to the redo log files in the order of events (sequential order) in case of a failure.

3)What is the maximum number of database writer processes allowed in an Oracle instance?

Ans:

The maximum is ten. Every Oracle instance begins with only one database writer process, DBW0. Additional writer processes may be started by setting the initialization parameter DB_WRITER_PROCESSES (DBW1 through DBW9).

4)Which background process is not started by default when you start up the Oracle instance?

Ans:

ARCn. The ARCn process is available only when the archive log is running (LOG_ARCHIVE_START initialization parameter set to true). DBWn, LGWR, CKPT, SMON, and PMON are the default processes associated with all instances (start by default).

5)Describe a parallel server configuration?

Ans:

In a parallel server configuration multiple instances known as nodes can mount one database. In other words, the parallel server option lets you mount the same database for multiple instances. In a multithreaded configuration, one shared server process takes requests from multiple user processes.

6)Choose the right hierarchy, from largest to smallest, from this list of logical database structures?

Ans:

Database, tablespace, segment, extent, data blocks.

7)Which background process is responsible for writing the dirty buffers to the database files?

Ans:

The purpose if the DBWn is to write the contents of the dirty buffer to the database file.
This occurs under two circumstances – when a checkpoint occurs or when the server process searches the buffer cache for a set threshold.

8)Which component in the SGA has the dictionary cache?

Ans:

The dictionary cache is part of the shared pool. The shared pool also contains the library cache and control structures.

10)When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user?

Ans:

The process monitor (PMON) releases the locks on tables and rows held by the user during failed processes and it reclaims all resources held by the user. PMON cleans up after failed user processes.


11)What is a dirty buffer?

Ans:

A dirty buffer refers to blocks in the database buffer cache that are changed, but are not yet written to the disk.

12)If you are updating one row in a table using the ROWID in the WHERE clause (assume that the row is not already in the buffer cache), what will be the minimum amount of information read to the database buffer cache?

Ans:

The block is the minimum amount of information read/copied to the database buffer cache.

13)What happens next when a server process is not able to find enough free buffers to copy the blocks from disk?

Ans:

To reduce I/O contention, the DBWn process does not write the changed buffers immediately to the disk. They are written only when the dirty buffers reach a threshold or when there are not enough free buffers available or when the checkpoint occurs.

14)Which memory structures are shared? Name two.

Ans:

The library cache contains the shared SQL areas, private SQL areas, PL/SQL procedures, and packages, and control structures. The large pool is an optional area in the SGA.

15)When a SELECT statement is issued, which stage checks the user’s privileges?

Ans:

Parse checks the user’s privileges, syntax correctness, and the column names against the dictionary. Parse also determines the optional execution plan and finds a shared SQL area for the statement.

16)Which memory structure records all database changes made to the instance?

Ans:

The redo log files holds information on the changes made to the database data. Changes are made to the database through insert, update, delete, create, alter, or drop commands.

17)What is the minimum number of redo log files required in a database?

Ans:

The minimum number of redo log files required in a database is two because the LGWR (log writer) process writes to the redo log files in a circular manner.

18)When is the system change numbers assigned?

Ans:

System changed numbers (SCN) are assigned when a transaction is committed. The SCN is a unique number acting as an internal timestamp, used for recovery and read-consistent queries. In other words, the SCN number is assigned to the rollback statement to mark it as a transaction committed.

19)Name the parts of the database buffer pool?

Ans:

The database buffer pool consists of the keep buffer pool; recycle buffer pool, and the default buffer pool.
The keep buffer pool retains the data block in memory.
The recycle buffer pool removes the buffers from memory when it’s not needed.
The default buffer pool contains the blocks that are not assigned to the other pools.

20)List all the valid database start-up option?

Ans:

STARTUP MOUNT, STARTUP NOMOUNT, and STARTUP FORCE.
STARTUP NOMOUNT is used for creating a new database or for creating new control files. STARTUP MOUNT is used for performing specific maintenance operations such as renaming data files, enabling or disabling archive logging, renaming, adding or dropping redo log files, or for performing a full database recovery. Finally, STARTUP FORCE is used to start a database forcefully, (if you have problems starting up an instance.) STARTUP FORCE shuts down the instance if it is already running and then restarts it.


21)Which two values from the V$SESSION view are used to terminate a user session?

Ans:

The session identifier (SID) and the serial number (SERIAL #) uniquely identify each session and both are needed to kill a session. Ex. SQL > ALTER SYSTEM KILL SESSION ‘SID’,’ SERIAL #’;

22)To use operating system authentication to connect the database as an administrator, what should the value of the parameter REMOTE_LOGIN_PASSWORDFILE be set to?

Ans:

The value of the REMOTE_LOGIN_PASSWORDFILE parameter should be set to NONE to use OS authentication. To use password file authentication, the value should be either EXCLUSIVE or SHARED.

23)What information is available in the alert log files?

Ans:

The alert log store information about block corruption errors, internal errors, and the non-default initialization parameters used at instance start-up. The alert log also records information about database start-up, shutdown, archiving, recovery, tablespace modifications, rollback segment modifications, and the data file modifications.

24)Which parameter value is use to set the directory path where the alert log file is written?

Ans:

The alert log file is written in the BACKGROUND_DUMP_DEST directory. This directory also records the trace files generated by the background processes. The USER_DUMP_DEST directory has the trace files generated by user sessions. The CORE_DUMP_DEST directory is used primarily on UNIX platforms to save the core dump files. ALERT_DUMP_DEST is not a valid parameter.

25)Which SHUTDOWN option requires instance recovery when the database is started the next time?

Ans:

SHUTDOWN ABORT requires instance recovery when the database is started the next time. Oracle will also roll back uncommitted transactions during start-up. This option shuts down the instance without dismounting the database.

26)Which SHUTDOWN option will wait for the users to complete their uncommitted transactions?

Ans:

When SHUTDOWN TRANSACTIONAL is issued, Oracle waits for the users to either commit or roll back their pending transactions. Once all users have either rolled back or committed their transactions, the database is shut down. When using SHUTDOWN IMMEDIATE, the user sessions are disconnected and the changes are rolled back. SHUTDOWN NORMAL waits for the user sessions to disconnect from the database.

26)How do you make a database read-only?

Ans:

To put a database into read-only mode, you can mount the database and open the database in read-only mode. This can be accomplished in one step by using STARTUP OPEN READ ONLY.

27)Which role is created by default to administer databases?

Ans:

The DBA role is created when you create the database and is assigned to the SYS and SYSTEM users.


28)Which privilege do you need to connect to the database, if the database is started up by using STARTUP RESTRICT?

Ans:

RESTRICTED SESSION privilege is required to access a database that is in restrict mode. You can start up the database in restrict mode by using STARTUP RESTRICT, or change the database to restricted mode by using ALTER SYSTEM ENABLE RESTRICTED SESSION.

29)At which stage of the database start-up is the control file opened?

Ans:


The control file is opened when the instance mounts the database. The data files and redo log files are opened after the database is opened. When the instance is started, the background processes are started.


30)Which command will “bounce” the database-that is, shut down the database and start up the database in a single command?

Ans:

STARTUP FORCE will terminate the current instance and start up the database. It is equivalent to issuing SHUTDOWN ABORT and STARTUP OPEN.

31)When performing the command SHUTDOWN TRANASACTIONAL, what actions oracle performs internally?

Ans:

SHUTDOWN TRANSACTIONAL waits for all user transactions to complete. Once no transactions are pending, it disconnects all sessions and proceeds with the normal shutting down process. The normal shut down process performs a checkpoint, closes data files and redo log files, dismounts the database, and shuts down the instance.

32)When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?

Ans:

If you enable the RESTRICTED SESSION when users are connected, nothing happens to the already connected sessions. Future sessions are started only if the user has the RESTRICTED SESSION privilege.

33)Which view has information about users who are granted SYSDBA or SYSOPER privilege?

Ans:

A dynamic view of V$PWFILE_USERS has the username and a value of TRUE in column SYSDBA if the SYSDBA privilege is granted, or a value of TRUE in column SYSOPER if the SYSOPER privilege is granted.

34)What is the recommended configuration for control files?

Ans:

Oracle allows multiplexing of control files. If you have two control files on two disks, one disk failure will not damage both control files.

35)How many control files are required to create a database?

Ans:

You do not need any control files to create a database; the control files are created when you create a database, based on the filenames specified in the CONTROL_FILES parameter of the parameter file


36)Which environment variable or registry entry variable is used to represent the instance name?

Ans:

The Oracle_SID environment variable is used to represent the instance name. When you connect to the database without specifying a connect string, Oracle connects you to this instance.

37)Which initialization parameter cannot be changed after creating the database?

Ans:

The block size of the database cannot be changed after database creation. The database name can be changed after re-creating the control file with a new name, and the CONTROL_FILES parameter can be changed if the files are copied to a new location.

38)Which script creates the data dictionary views?

Ans:

The catalog.sql script creates the data dictionary views. The base tables for these views are created by the script sql.bsq, which is executed when you issue the CREATE DATABASE command.

39)How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint?

Ans:

The invalid procedure, trigger, package, or view can be recompiled by using the ALTER COMPILE command.

40)How many data files can be specified in the DATAFILE clause when creating a database?

Ans:

You can specify more than one data file; the files will be used for the SYSTEM tablespace. The files specified cannot exceed the number of data files specified in the MAXDATAFILES clause.


41)Who owns the data dictionary?

Ans:

The SYS user owns the data dictionary. The SYS and SYSTEM users are created when the database is created.

42)

What is the default password for the SYS user?

The default password for the SYS user is CHANGE_ON_INSTALL, and for SYSTEM it is MANAGER. You should change these passwords once the database is created.


43)What is the prefix for dynamic performance views?

Ans:

The dynamic performance views have a prefix of V$. The actual views have the prefix of V_$, and the synonyms have a V$ prefix. The views are called dynamic performance views because they are continuously updated while the database is open and in use, and their contents related primarily to performance.

44)What piece of information is not available in the control file?

Ans:

The instance name is not available. The control files include the following:
Database name the control file belongs to, database creation timestamp, data files, redo log files, tablespace names, current log sequence number, most recent checkpoint information, and Recovery Manager’s backup information.

45)When you create a control file, the database has to be:

Ans:

Not mounted.


46)Which data dictionary view provides the names of the control files?

V$CONTROLFILES shows the names of the control files.

47)The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; what does this mean?

Ans:

LOG_CHECKPOINT_INTERVAL ensures that no more than a specified number of redo log blocks (OS blocks) need to be read during instance recovery. LOG_CHECKPOINT_TIMEOUT ensures that no more than a specified number of seconds worth of redo log blocks need to be read during instance recovery.


48) What will happen if ARCn could not write to a mandatory archive destination?

Ans:

Oracle will write a message to the alert file and all database operations will be stopped. Database operation resumes automatically after successfully writing the archived log file. If the archive destination becomes full you can make room for archives either by deleting the archive log files after copying them to a different location, or by changing the parameter to point to a different archive location.


49What are the valid status codes in the V$LOGFILE view?

Ans:

Valid status codes V$LOGFILE views include STALE, INVALID, DELETED, or the status can be blank. STALE means the file contents are incomplete; INVALID means the file is not accessible; DELETED means the file is no longer used; and blank status means the file is in use.

50)If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?

Ans:

You should keep a minimum of two redo log groups, with a recommended two members in each group. Oracle recommends that you keep each member of a redo log group on a different disk. The maximum number of redo log groups is determined by the MAXLOGFILES database parameter. The MAXLOGMEMBERS database parameter specifies the maximum number of members per group.


51)When does the SMON process automatically coalesce the tablespaces?

Ans:

When the PCTINCREASE default storage of the tablespace is set to 0. You can manually coalesce a tablespace by using ALTER TABLESPACE COALESCE.


52)How would you drop a tablespace if the tablespace were not empty?

Ans:

Use DROP TABLESPACE INCLUDING CONTENTS.
The INCLUDING CONTENTS clause is used to drop a tablespace that is not empty. Oracle does not remove the data files that belong to the tablespace; you need to do it manually using an OS command. Oracle updates only the control file.


53)Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace?

Ans:

To enable auto=extension, use ALTER DATABASE DATAFILE AUTOEXTEND ON NEXT MAXSIZE .

54)How would you determine how much sort space is used by a user session?

Ans:

The V$SORT_USAGE shows the active sorts in the database; it shows the space used, username, SQL address, and hash value. It also provides the number of EXTENTS and number of BLOCKS used by each sort session, and the username. The V$SORT can be joined with V$SESSION or V$SQL to obtain more information on the session or the SQL statement causing the sort.

55)When a table is updated, where is the before image information (which can be used for undoing the changes) stored?

Ans:

Rollback segment. Before any DML operation, the undo information (before-image of data) is stored in the rollback segments. This information is used to undo the changes and to provide a read-consistent view of the data.

56)Which parameter specifies the number of transaction slots in a data block?
Ans:

INITRANS specifies the number of transaction slots in a data block. A transaction slot is used by Oracle when the data block is being modified. INITRANS reserves space for the transactions in the block.

57)Which data dictionary view would you query to see the free extents in a tablespace?

Ans:

DBA_FREE_SPACE shows the free extents in a tablespace. DBA_EXTENTS shows all the extents that are allocated to a segment.

58)Which portion of the data block stores information about the table having rows in this block?

Ans:

Row Data. The table directory portion of the block stores information about the table having rows in the block. The row directory stores information such as row address and size of the actual rows stored in the row data area.

26 August 2013

You don't have permission to access /pls/MUTHU/fnd_icx_launch.launch on this server

Error:-

Forbidden
You don't have permission to access /pls/MUTHU/fnd_icx_launch.launch on this server.


Investigation of the Apache log files shows the following entries:

    access_log_pls

    <server.domain> - - [11/Jan/2010:10:58:20 +0700] "GET /pls/xxx/fnd_icx_launch.launch?resp_app=SYSADMIN&resp_key=SYSTEM_ADMINISTRATOR&secgrp_key=STANDARD&start_func=FND_FNDSCMOU&other_params= HTTP/1.0" 403 223


    error_log_pls

    [Mon Jan 11 10:58:20 2010] [error] mod_plsql: /pls/xxx/fnd_icx_launch.launch HTTP-403 ORA-1017
   
   
Solution:-

In this case the errors were caused by the following entries in the $IAS_ORACLE_HOME/Apache/Apache/conf/apps.conf
   
        <Location ~ /(oa_servlets|servlets|servlet|jsp|configurator|mobile|forms|discoverer4i|emailcenter|soap/servlet|webservices|dmsOACore|dmsDisco|dmsForms|pricing)/framework>
         Order deny,allow
         Deny from all
         Allow from %oacore_fwk_nodes%
        </Location>
   
        <Location ~ /(oa_servlets|servlets|servlet|jsp|configurator|mobile|forms|discoverer4i|emailcenter|soap/servlet|webservices|dmsOACore|dmsDisco|dmsForms|pricing)/oracle.apps.fnd.framework.provider.OAFrameworkHttpProvider>
         Order deny,allow
         Deny from all
         Allow from %oacore_fwk_nodes%
        </Location>
   
For some reason the Autoconfig run did not replace the variable %oacore_fwk_nodes% with the list of servers granted access.

Reference:-

Forms Applet not Started From Homepage After Run of Autoconfig (Doc ID 989464.1)

Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError

Error:-

Request URI:/OA_HTML/AppsLocalLogin.jsp

Exception:
java.lang.NoClassDefFoundError


Solution :-


Step To clear the jsp & modplsql caches using below command:

1) shutdown apache server
2) verify ps ux | grep http -- should not return any process
3) rm -rf $OA_HTML/_pages/*
4) rm -rf $COMMON_TOP/_pages/*
5) rm -rf $IAS_ORACLE_HOME/Apache/modplsql/cache/*
6) start apache server

Example:-

[applmgr@test TEST_test]$./adapcctl.sh stop
[applmgr@test TEST_test]$ ps ux | grep http
[applmgr@test TEST_test]$ mv /ora/test/appl/testcomn/html/_pages/  $OA_HTML/_pages_old
[applmgr@test TEST_test]$ mv /ora/bovptch/appl/testcomn/_pages/ /ora/test/appl/testcomn/_pages_old

[applmgr@test TEST_test]$ mv /ora/test/appl/testora/iAS/Apache/modplsql/cache/ /ora/test/appl/testora/iAS/Apache/modplsql/cache_old
[applmgr@test TEST_test]$./adapcctl.sh start

16 August 2013

Step by Step Oracle Database 12c Release 1 Upgrade from 11.2.0.3


Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) [ID 1503653.1]

Minimum version of the database that can be directly upgraded to Oracle 12c Release 1 (12.1)

Source Database        Target Database
10.2.0.5        12.1.x
11.1.0.7        12.1.x
11.2.0.2 or higher    12.1.x

Requirements and recommendations for Source  database   

•    Either take a cold or hot backup of the source database (advisable to have cold backup).
a) Perform Cold Backup
             (or)
b) Take a backup using RMAN
Connect to RMAN:

rman "target / nocatalog"

RUN
{
ALLOCATE CHANNEL chan_name TYPE DISK;
BACKUP DATABASE FORMAT '<db_backup_directory>%U' TAG before_upgrade;
BACKUP CURRENT CONTROLFILE TO '<controlfile_backup_directory>';
}

Below is a SQL*Plus script that will list all objects that have been created in both the SYS and SYSTEM schema: 

SQL> column object_name format a30
select object_name, object_type
from dba_objects
where object_name||object_type in
   (select object_name||object_type
    from dba_objects
    where owner = 'SYS')
and owner = 'SYSTEM';

If the list of objects is large then you may want to use the following SQL*Plus script to automatically generate an SQL script that contains the appropriate DROP commands:

set pause off
set heading off
set pagesize 0
set feedback off
set verify off
spool dropsys.sql
select 'DROP ' || object_type || ' SYSTEM.' || object_name || ';'
from dba_objects
where object_name||object_type in
   (select object_name||object_type 
    from dba_objects
    where owner = 'SYS')
and owner = 'SYSTEM';
spool off
exit

ORA-1418 (specified index does not exist):
 This occurs because the table that the index was created on  has already been dropped which also drops the index. When the script tries to drop the index it is no longer there and thus the ORA-1418 error. You can safely ignore this error.

Install 12C software on different location

Check for the integrity of the source database.
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) [ID 556610.1]

Download and save the script as dbupgdiag.sql. The script needs no additional configuration

SQL> alter session set nls_language='American';

SQL> @dbupgdiag.sql

Enter location for Spooled output:

Enter value for 1: /tmp


SQL> @utrlrp.sql

#############Pre-Upgrade Steps################
How to Download and Run Oracle's Database Pre-Upgrade Utility [ID 884522.1]

Copy the Pre-Upgrade Information Tool script preupgrd.sql and utluppkg.sql from the Oracle Database 12c Release 1 (12.1)

Run the new Pre-Upgrade Information Tool. For example, if you copied preupgrd.sql to the /admin directory of the source Oracle Home:

SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/preupgrd.sql

SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/utluppkg.sql

SQL> ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE;

SQL> show processes parameter processes;

SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/emremove.sql

SQL> create pfile from spfile;

SQL> @/u01/oinstall/product/11.2.0/olap/admin/catnoamd.sql

SQL> EXECUTE dbms_stats.gather_dictionary_stats;

SQL> @/u01/oinstall/product/11.2.0/cfgtoollogs/MUTH/preupgrade/preupgrade_fixups.sql

##############Deprecated CONNECT Role#############
After upgrading to Oracle Database 12c Release 1 (12.1) from INDIRECT database upgrade release like  Oracle Database9i Release 2 (9.2) or Oracle Database 10g Release 1 (10.1), the CONNECT role has only the CREATE SESSION privilege; the other privileges granted to the CONNECT role in earlier releases are revoked during the upgrade. To identify which users and roles in your database are granted the CONNECT role, use the following query:

SQL> SELECT grantee FROM dba_role_privs
    WHERE granted_role = 'CONNECT' and
    grantee NOT IN (
    'SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP',
    'LOGSTDBY_ADMINISTRATOR', 'ORDSYS',
    'ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY',
    'WK_TEST', 'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS',
    'WMSYS', 'EXFSYS', 'SYSMAN', 'MDDATA',
    'SI_INFORMTN_SCHEMA', 'XDB', 'ODM');
   
SQL> SELECT GRANTEE,PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE ='CONNECT';

#################Dependencies on Network Utility Packages #############
Execute the following query

SQL> SELECT * FROM DBA_DEPENDENCIES
WHERE referenced_name IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_
INADDR','DBMS_LDAP')
AND owner NOT IN ('SYS','PUBLIC','ORDPLUGINS');

###########Database Links with Passwords from Earlier Releases#############

SQL> SELECT 'CREATE '||DECODE(U.NAME,'PUBLIC','public ')||'DATABASE LINK '||CHR(10)
    ||DECODE(U.NAME,'PUBLIC',Null, 'SYS','',U.NAME||'.')|| L.NAME||chr(10)
    ||'CONNECT TO ' || L.USERID || ' IDENTIFIED BY "'||L.PASSWORD||'" USING
    '''||L.HOST||''''
    ||chr(10)||';' TEXT
    FROM SYS.LINK$ L, SYS.USER$ U
    WHERE L.OWNER# = U.USER#;
   
###############Optimizer Statistics ###################
Oracle recommends collecting statistics the night before starting the upgrade to decrease the amount of downtime

To decrease the amount of downtime incurred when collecting statistics, Oracle recommends to collect statistics prior to performing the actual database upgrade.
As of Oracle Database 10g Release 1 (10.1), Oracle recommends that you use the DBMS_STATS.GATHER_DICTIONARY_STATS procedure to gather these statistics. For example, you can enter the following:

SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

Verify That Materialized View Refreshes Have Completed Before Upgrading
Before upgrading Oracle Database, you must wait until all materialized views have completed refreshing.
Run the following query to determine if there are any materialized view refreshes still in progress:
   
SQL> select s.obj#,o.obj#,s.containerobj#,lastrefreshdate,pflags,xpflags,o.name,o.owner#, bitand(s.mflags, 8) from obj$ o, sum$ s
where o.obj# = s.obj# and o.type# = 42 AND bitand(s.mflags, 8) = 8;

Ensure That No Files Need Media Recovery Before Upgrading
Make  ensure that there are no files requiring media recovery by executing the following query

SQL> SELECT * FROM v$recover_file;

no rows selected

Ensure That No Files Are in Backup Mode Before Upgrading
Execute the following query to verify that No Files in backup mode when upgrading Oracle Database

SQL> SELECT * FROM v$backup WHERE status != 'NOT ACTIVE';

no rows selected

Resolve Outstanding Distributed Transactions Before Upgrading
To resolve outstanding distributed transactions:
1. Issue the following statement:

SQL> SELECT * FROM dba_2pc_pending;

no rows selected

If the query in the previous step returns any rows, then issue the following
statements:
SQL> SELECT local_tran_id FROM dba_2pc_pending;
SQL> EXECUTE dbms_transaction.purge_lost_db_entry('');
SQL> COMMIT;

###########Purge the Database Recycle Bin Before Upgrading :#############
To empty the database recycle bin, issue the following command:

SQL> PURGE DBA_RECYCLEBIN;

DBA Recyclebin purged.

NOTE : The database recycle bin must be empty during the upgrade process to avoid possible ORA-00600 errors and to minimize the upgrade time.

##########Synchronize the Standby Database with the Primary Database When Upgrading ############
To check if a standby database exists and to synchronize it:


SQL> SELECT SUBSTR(value,INSTR(value,'=',INSTR(UPPER(value),'SERVICE'))+1)
FROM v$parameter
WHERE name LIKE 'log_archive_dest%' AND UPPER(value) LIKE 'SERVICE%';

Disable all batch and cron jobs
For jobs initiated by Oracle then packages DBMS_JOB, DBMS_SCHEDULER can be used.
For cron jobs (external jobs controlled at the OS level) then this is a task for your Unix administrator.
See also:
Note 404238.1 : How to Disable an Entry from DBMS_SCHEDULER
Note 1335741.1 : How To Stop A Running Job Using DBMS_JOB
Note 67695.1 : PROCEDURE DBMS_JOB.BROKEN Specification

############Verify SYS and SYSTEM Default tablespace ############

SQL> SELECT username, default_tablespace
     FROM dba_users
     WHERE username in ('SYS','SYSTEM');
    
 If DEFAULT_TABLESPACE is anything other than SYSTEM tablespace, modify the default tablespace for user SYS and SYSTEM to SYSTEM by using the command below:
 SQL> ALTER user SYS default tablespace SYSTEM;
 SQL> ALTER user SYSTEM default tablespace SYSTEM;

#############Verify the existance of the AUD$ tables################
Ensure that if the aud$ table exists that it is in the SYS schema and in the SYSTEM tablespace.
    
SQL> SELECT owner,tablespace_name
     FROM dba_tables
     WHERE table_name='AUD$';

############Check whether database has any externally authenticated SSL users###########
Execute the following query

    
SQL> SELECT name FROM sys.user$
     WHERE ext_username IS NOT NULL
     AND password = 'GLOBAL';
    
Location of datafiles, redo logs and control files
Note the location of datafiles, redo logs and control files. Also take a backup of all configuration files like listener.ora, tnsnames.ora, etc. from $ORACLE_HOME.
SQL> SELECT name FROM v$controlfile;
SQL> SELECT file_name FROM dba_data_files;
SQL> SELECT group#, member FROM v$logfile;

###########Remove Enterprise Manager  Database Control repository :#################
Enterprise Manager Database Control is superseded in 12c by Oracle Enterprise Manager Express .
     Therefore no repository is needed anymore .
     Remove  Enterprise Manager  Database Control  repository MANUALLY using the following command
     Note : You will get the emremove.sql script in the Oracle 12c home .
    Copy the emremove.sql script from the 12c $ORACLE_HOME/rdbms/admin to the source $ORALCE_HOME/rdbms/admin and then execute on the source database prior to upgrade.


SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/emremove.sql

################Run olspreupgrade.sql  :#################
If  OLS(Lable Security) and/or DV ( Database Vault) was already in the  database prior to the upgrade then execute the following steps on Source database prior to upgrade
Note : You will get the olspreupgrade.sql script in the Oracle 12c home .
Copy the olspreupgrde.sql script from the 12c $ORACLE_HOME/rdbms/admin to the source $ORALCE_HOME/rdbms/admin and then execute on the source database prior to upgrade.

SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/olspreupgrade.sql

##########Copy Pfile from 11.2.0.3 oracle home to 12c Oracle home###############

[oinstall@arjun dbs]$ cd /u01/oinstall/product/12.1.1/dbs
[oinstall@arjun dbs]$ cp ../../11.2.0/dbs/initMUTH.ora .
[oinstall@arjun dbs]$lsnrctl stop MUTH

##########Copy Tnsnames and Listner names from 11.2.0.3 Oracle Home###############

[oinstall@arjun admin]$ cp -r ../../../11.2.0/network/admin/tnsnames.ora .
[oinstall@arjun admin]$ cp -r ../../../11.2.0/network/admin/listener.ora  .
[oinstall@arjun admin]$ emctl stop dbconsole

######## Shut Down your database ##########

[oinstall@arjun admin]$ sqlplus "/as sysdba"

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

[oinstall@arjun admin]$export ORACLE_HOME=/u01/oinstall/product/12.1.1
[oinstall@arjun admin]$export ORACLE_SID=MUTH
[oinstall@arjun admin]$export PATH=$ORACLE_HOME/bin:$PATH

######### Listener Configuration #########

[oinstall@arjun admin]$vi /u01/oinstall/product/12.1.1/network/admin/listener.ora    # Change Oracle Home location

[oinstall@arjun admin]$ lsnrctl start MUTH

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 16-JUL-2013 09:28:43

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Starting /u01/oinstall/product/12.1.1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /u01/oinstall/product/12.1.1/network/admin/listener.ora
Log messages written to /u01/oinstall/diag/tnslsnr/arjun/muth/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arjun.bangalore.bedford.local)(PORT=1550)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1550)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=arjun.bangalore.bedford.local)(PORT=1550)))
STATUS of the LISTENER
------------------------
Alias                     MUTH
Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date                16-JUL-2013 09:28:43
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oinstall/product/12.1.1/network/admin/listener.ora
Listener Log File         /u01/oinstall/diag/tnslsnr/arjun/muth/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arjun.bangalore.bedford.local)(PORT=1550)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1550)))
Services Summary...
Service "MUTH" has 1 instance(s).
  Instance "MUTH", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oinstall@arjun admin]$ orabase
/u01/oinstall

########Upgrading Database to 12cR1##########

[oinstall@arjun admin]$ sqlplus "/as syss dba"

SQL*Plus: Release 12.1.0.1.0 Production on Tue Jul 16 09:31:38 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size            2289064 bytes
Variable Size          570425944 bytes
Database Buffers     1090519040 bytes
Redo Buffers            6987776 bytes
Database mounted.
Database opened.
SQL> exit

[oinstall@arjun admin]$ cd $ORACLE_HOME/rdbms/admin

[oinstall@arjun admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n  6 -l $ORACLE_HOME/diagnostics catupgrd.sql

Analyzing file catupgrd.sql
Log files in /u01/oinstall/product/12.1.1/diagnostics
14 scripts found in file catupgrd.sql
Next path: catalog.sql
32 scripts found in file catalog.sql
Next path: catproc.sql
37 scripts found in file catproc.sql
Next path: catptabs.sql
61 scripts found in file catptabs.sql
Next path: catpdbms.sql
205 scripts found in file catpdbms.sql
Next path: catpdeps.sql
77 scripts found in file catpdeps.sql
Next path: catpprvt.sql
260 scripts found in file catpprvt.sql
Next path: catpexec.sql
26 scripts found in file catpexec.sql
Next path: cmpupgrd.sql
16 scripts found in file cmpupgrd.sql

[Phase 0] type is 1 with 1 Files
catupstr.sql    

[Phase 1] type is 1 with 3 Files
cdstrt.sql       cdfixed.sql      cdcore.sql      

[Phase 2] type is 1 with 1 Files
ora_restart.sql 

[Phase 3] type is 2 with 18 Files
cdplsql.sql      cdsqlddl.sql     cdmanage.sql     cdtxnspc.sql
cdenv.sql        cdrac.sql        cdsec.sql        cdobj.sql
cdjava.sql       cdpart.sql       cdrep.sql        cdaw.sql
cdsummgt.sql     cdtools.sql      cdexttab.sql     cddm.sql
catldr.sql       cdclst.sql      

[Phase 4] type is 1 with 1 Files
ora_restart.sql 

[Phase 5] type is 1 with 5 Files
cdoptim.sql      catsum.sql       catexp.sql       cddst.sql
cdend.sql       

[Phase 6] type is 1 with 1 Files
catpstrt.sql    

[Phase 7] type is 1 with 3 Files
catptyps.sql     catpgrants.sql   catgwm.sql      

[Phase 8] type is 1 with 1 Files
ora_restart.sql 

[Phase 9] type is 2 with 60 Files
catnodpt.sql     catbac.sql       prvtrctv.plb     catactx.sql
prvtuttv.plb     catsvrmg.sql     prvtlsis.plb     prvtlsss.plb
cattrans.sql     catrule.sql      catsnap.sql      catpitr.sql
catdip.sql       catrls.sql       catar.sql        catfga.sql
catamgt.sql      catidxu.sql      cattsm.sql       catchnf.sql
catodm.sql       catkppls.sql     catsscr.sql      catqueue.sql
cathae.sql       catadvtb.sql     catrm.sql        catsch.sql
catol.sql        catdpb.sql       catcrc.sql       dbmscr.sql
dbmsutil.sql     catdbfus.sql     catalrt.sql      catatsk.sql
catmntr.sql      catsqlt.sql      catawrtv.sql     catsmbvw.sql
catwrrtb.sql     catsumat.sql     catrep.sql       catlmnr.sql
catdef.sql       catadrvw.sql     catrepv.sql      catpexe.sql
cattlog.sql      catcapi.sql      catpspi.sql      catts.sql
catnacl.sql      catredact.sql    catproftab.sql   catpstdy.sql
catrupg.sql      catratmask.sql   catqitab.sql     catappcont.sql


[Phase 10] type is 1 with 1 Files
ora_restart.sql 

[Phase 11] type is 1 with 1 Files
catpspec.sql    

[Phase 12] type is 1 with 1 Files
ora_restart.sql 

[Phase 13] type is 2 with 199 Files
utlinad.sql      utlsmtp.sql      utlurl.sql       utlenc.sql
utlgdk.sql       utlcstk.sql      utlcomp.sql      utli18n.sql
utllms.sql       dbmsplsw.sql     utlnla.sql       dbmspdb.sql
dbmstrns.sql     dbmsrwid.sql     dbmspclx.sql     dbmserlg.sql
dbmsspu.sql      dbmsapin.sql     dbmssyer.sql     dbmspipe.sql
dbmsalrt.sql     dbmsdesc.sql     dbmspexp.sql     dbmsjob.sql
dbmsstat.sql     dbmsstts.sql     dbmsddl.sql      dbmsedu.sql
dbmspp.sql       prvthddl.plb     prvthjob.plb     prvthsye.plb
prvtzhlp.plb     dbmsidxu.sql     prvthidx.plb     dbmspsp.sql
dbmstran.sql     dbmsxa.sql       dbmstxfm.sql     dbmsread.sql
prvtreut.plb     dbmspb.sql       dbmspbt.sql      dbmsplts.sql
dbmspitr.sql     utlrefld.sql     utlcoll.plb      dbmstrst.sql
dbmsrlsa.sql     dbmsrpr.sql      dbmsobtk.sql     dbmshtdb.sql
dbmslm.sql       dbmslmd.sql      prvtlmes.plb     utlcxml.sql
dbmsfga.sql      dbmsamgt.sql     dbmstypu.sql     dbmsres.sql
dbmstxin.sql     dbmsdrs.sql      dbmsdg.sql       dbmssum.sql
dbmshord.sql     dbmsxfr.sql      dbmsmap.sql      dbmsfi.sql
dbmsdbv.sql      dbmstcv.sql      dbmscoll.sql     dbmscdcu.sql
dbmscdcp.sql     dbmscdcs.sql     dbmspbp.sql      dbmshpro.sql
dbmssrv.sql      dbmschnf.sql     dbmsxpln.sql     utlmatch.sql
dbmsdbvn.sql     dbmspool.sql     dbmsrcad.sql     prvthcrc.plb
prvtkpps.plb     dbmsaq.plb       dbmsaqad.sql     dbmsaq8x.plb
dbmsaqem.plb     prvtaqxi.plb     dbmsslrt.sql     dbmsmntr.sql
dbmshm.sql       catsqltk.sql     dbmsir.sql       prvtsss.plb
dbmsocm.sql      dbmslobu.sql     dbmsmp.sql       dbmsaddm.sql
prvttxfs.plb     dbmsrmin.plb     dbmsrmad.sql     dbmsrmpr.sql
dbmsrmpe.plb     dbmsrmge.plb     dbmsrmpa.plb     prvtrmie.plb
prvthjob.plb     prvthesh.plb     dbmsol.sql       prvtdputh.plb
dbmsmeta.sql     dbmsmetb.sql     dbmsmetd.sql     dbmsmet2.sql
dbmsdp.sql       prvthpp.plb      prvthpd.plb      prvthpdi.plb
prvthpvi.plb     prvtdtde.plb     prvtsum.plb      prvtjdbs.plb
dbmsslxp.sql     prvssmgu.plb     dbmsawr.sql      prvsemxi.plb
prvsemx_admin.plb prvsemx_dbhome.plb prvsemx_memory.plb prvsemx_perf.plb
dbmsperf.sql     prvsrept.plb     prvsrepr.plb     prvshdm.plb
prvsrtaddm.plb   prvs_awr_data_cp.plb prvscpaddm.plb   prvsadv.plb
prvsawr.plb      prvsawri.plb     prvsawrs.plb     prvsash.plb
prvsawrv.plb     dbmssqlu.sql     prvssqlf.plb     dbmswrr.sql
dbmsfus.sql      prvsfus.plb      dbmsuadv.sql     dbmsrepl.sql
dbmsspm.sql      prvsspmi.plb     prvssmb.plb      prvssmbi.plb
dbmsstr.sql      dbmssqlt.sql     dbmsspa.sql      prvsautorepi.plb
dbmsautorep.sql  dbmsratmask.sql  dbmsdiag.sql     dbmsobj.sql
dbmskzxp.sql     dbmscu.sql       dbmsdst.sql      dbmscomp.sql
dbmsilm.sql      dbmspexe.sql     prvthpexei.plb   dbmscapi.sql
dbmsfuse.sql     dbmsfspi.sql     dbmspspi.sql     dbmsdnfs.sql
dbmsadr.sql      dbmsadra.sql     prvsadri.plb     xsrs.sql
xssc.sql         xsacl.sql        xsds.sql         xsns.sql
xsdiag.sql       xssess.sql       dbmsredacta.sql  dbmssqll.sql
dbmsgwm.sql      dbmsappcont.sql  dbmsspd.sql      prvsspdi.plb
dbmsfs.sql       dbmssqlm.sql     catprofp.sql     prvtsys.plb
dbmspart.sql     dbmsrupg.sql     dbmstsdp.sql    

[Phase 14] type is 1 with 1 Files
ora_restart.sql 

[Phase 15] type is 1 with 3 Files
dbmsmeti.sql     dbmsmetu.sql     dbmsqopi.sql    

[Phase 16] type is 1 with 1 Files
ora_restart.sql 

[Phase 17] type is 2 with 33 Files
catmettypes.sql  prvthdbu.plb     catost.sql       dbmshae.sql
catxpend.sql     prvtotpt.plb     prvthlut.plb     prvthlin.plb
prvthsdp.plb     dbmsrman.sql     dbmsbkrs.sql     dbmstrig.sql
dbmsrand.sql     dbmsjdwp.sql     catxs.sql        dbmssnap.sql
prvtxrmv.plb     depsaq.sql       prvthlrt.plb     catadv.sql
dbmscred.sql     catcredv.sql     cataqsch.sql     catrssch.sql
catplug.sql      prvtsql.plb      prvtssql.plb     prvtlmd.plb
prvtlmcs.plb     prvtlmrs.plb     dbmslms.sql      prvthpu.plb
prvthpv.plb     

[Phase 18] type is 1 with 1 Files
ora_restart.sql 

[Phase 19] type is 1 with 3 Files
prvtkupc.plb     prvtaqiu.plb     catlsby.sql     

[Phase 20] type is 1 with 1 Files
ora_restart.sql 

[Phase 21] type is 2 with 23 Files
catmetviews.sql  prvthpw.plb      prvthpm.plb      prvthpfi.plb
prvthpf.plb      dbmsodm.sql      prvtitrg.plb     prvtsms.plb
depssvrm.sql     deptxn.sql       catstr.sql       prvthsts.plb
prvthfgr.plb     prvthfie.plb     prvthcmp.plb     catpexev.sql
depscapi.sql     depspspi.sql     catwrrvw.sql     dbmsjdcu.sql
dbmsjdmp.sql     prvthpc.plb      prvt_awr_data.plb

[Phase 22] type is 1 with 1 Files
ora_restart.sql 

[Phase 23] type is 2 with 11 Files
catmetgrant1.sql catldap.sql      prvtocm.sql      prvtrepl.sql
catpstr.sql      prvthpci.plb     catilm.sql       catemxv.sql
catnaclv.sql     dbmsnacl.sql     dbmswlm.sql     

[Phase 24] type is 1 with 1 Files
ora_restart.sql 

[Phase 25] type is 1 with 1 Files
catcdbviews.sql 

[Phase 26] type is 1 with 1 Files
ora_restart.sql 

[Phase 27] type is 2 with 0 Files

[Phase 28] type is 1 with 1 Files
ora_load_without_comp.sql

[Phase 29] type is 2 with 130 Files
prvtfile.plb     prvtrawb.plb     prvttcp.plb      prvtinad.plb
prvtsmtp.plb     prvthttp.plb     prvturl.plb      prvtenc.plb
prvtgdk.plb      prvtlob.plb      prvtlobu.plb     prvtcstk.plb
prvtcomp.plb     prvti18n.plb     prvtlms2.plb     prvtnla.plb
prvttrns.plb     prvtsess.plb     prvtrwid.plb     prvtpclx.plb
prvterlg.plb     prvtapin.plb     prvtsyer.plb     prvtlock.plb
prvtpipe.plb     prvtalrt.plb     prvtdesc.plb     prvtpexp.plb
prvtzexp.plb     prvtstts.plb     prvtddl.plb      prvtpp.plb
prvtscrp.plb     prvtkppb.plb     prvtutil.plb     prvtpsp.plb
prvttran.plb     prvtxa.plb       prvtany.plb      prvtread.plb
prvtpb.plb       prvtpbt.plb      prvtxpsw.plb     prvtcoll.plb
prvttrst.plb     prvtrlsa.plb     prvtodci.plb     prvtrpr.plb
prvtobtk.plb     prvthtdb.plb     prvtxmlt.plb     prvturi.plb
prvtxml.plb      prvtcxml.plb     prvtemxi.plb     prvtemx_admin.plb
prvtemx_dbhome.plb prvtemx_memory.plb prvtemx_perf.plb prvtperf.plb
prvtrep.plb      prvtrept.plb     prvtrepr.plb     prvtfga.plb
prvtamgt.plb     prvttypu.plb     prvtjdwp.plb     prvtjdmp.plb
prvtres.plb      prvtcr.plb       prvttxin.plb     prvtdrs.plb
prvtdg.plb       prvtfi.plb       prvtmap.plb      prvthpui.plb
prvtdbv.plb      prvttcv.plb      prvtpbp.plb      prvthpro.plb
prvtbdbu.plb     prvtsrv.plb      prvtpool.plb     prvtkzxs.plb
prvtkzxp.plb     prvtcrc.plb      prvtrc.plb       prvtaq.plb
prvtaqdi.plb     prvtaqxe.plb     prvtaqis.plb     prvtaqim.plb
prvtaqad.plb     prvtaq8x.plb     prvtaqin.plb     prvtaqal.plb
prvtaqjm.plb     prvtaqmi.plb     prvtaqme.plb     prvtaqem.plb
prvtaqip.plb     prvtaqds.plb     prvtsqdi.plb     prvtsqds.plb
prvtsqis.plb     prvthm.plb       prvtwlm.plb      prvtsqtk.plb
prvtkjhn.plb     prvtir.plb       prvtssb.plb      prvttxfm.plb
prvtrmin.plb     prvtrmad.plb     prvtrmpr.plb     prvtrmpe.plb
prvtrmge.plb     prvtrmpa.plb     prvtjob.plb      prvtbsch.plb
prvtesch.plb     prvtcred.plb     prvtol.plb       prvtlm.plb
prvtlmcb.plb     prvtlmrb.plb     prvtlms.plb      prvtlmeb.plb
prvtbpu.plb      prvtwrr.plb     

[Phase 30] type is 1 with 1 Files
ora_load_with_comp.sql

[Phase 31] type is 1 with 1 Files
ora_restart.sql 

[Phase 32] type is 1 with 1 Files
ora_load_without_comp.sql

[Phase 33] type is 2 with 122 Files
prvtbpui.plb     prvtdput.plb     prvtmeta.plb     prvtmeti.plb
prvtmetu.plb     prvtmetb.plb     prvtmetd.plb     prvtmet2.plb
prvtdp.plb       prvtbpc.plb      prvtbpci.plb     prvtbpw.plb
prvtbpm.plb      prvtbpfi.plb     prvtbpf.plb      prvtbpp.plb
prvtbpd.plb      prvtbpdi.plb     prvtbpv.plb      prvtbpvi.plb
prvtdpcr.plb     prvtplts.plb     prvtpitr.plb     prvtreie.plb
prvtrwee.plb     prvtidxu.plb     prvtrcmp.plb     prvtchnf.plb
prvtedu.plb      prvtlsby.plb     prvtlsib.plb     prvtlssb.plb
prvtsmv.plb      prvtsma.plb      prvtbxfr.plb     prvtbord.plb
prvtjdbb.plb     prvtslrt.plb     prvtslxp.plb     prvtatsk.plb
prvtmntr.plb     prvtsmgu.plb     prvtdadv.plb     prvtadv.plb
prvtawr.plb      prvtawrs.plb     prvtawri.plb     prvtash.plb
prvtawrv.plb     prvtsqlf.plb     prvtsqli.plb     prvtsqlt.plb
prvtautorepi.plb prvtautorep.plb  prvtfus.plb      prvtmp.plb
prvthdm.plb      prvtaddm.plb     prvtrtaddm.plb   prvt_awr_data_cp.plb
prvtcpaddm.plb   prvtuadv.plb     prvtsqlu.plb     prvtspai.plb
prvtspa.plb      prvtratmask.plb  prvtspmi.plb     prvtspm.plb
prvtsmbi.plb     prvtsmb.plb      prvtfus.plb      catfusrg.sql
prvtwrk.plb      prvtsmaa.plb     prvtxpln.plb     prvtstat.plb
prvtstai.plb     prvtsqld.plb     prvtspcu.plb     prvtodm.plb
prvtkcl.plb      prvtdst.plb      prvtcmpr.plb     prvtilm.plb
prvtpexei.plb    prvtpexe.plb     prvtcapi.plb     prvtfuse.plb
prvtfspi.plb     prvtpspi.plb     prvtdnfs.plb     prvtfs.plb
prvtadri.plb     prvtadr.plb      prvtadra.plb     prvtadmi.plb
prvtutils.plb    prvtxsrs.plb     prvtsc.plb       prvtacl.plb
prvtds.plb       prvtns.plb       prvtdiag.plb     prvtkzrxu.plb
prvtnacl.plb     prvtredacta.plb  prvtpdb.plb      prvttlog.plb
prvtsqll.plb     prvtappcont.plb  prvtspd.plb      prvtspdi.plb
prvtpprof.plb    prvtsqlm.plb     prvtpart.plb     prvtrupg.plb
prvtrupgis.plb   prvtrupgib.plb   prvtpstdy.plb    prvttsdp.plb
prvtqopi.plb     prvtlog.plb     

[Phase 34] type is 1 with 1 Files
ora_load_with_comp.sql

[Phase 35] type is 1 with 1 Files
ora_restart.sql 

[Phase 36] type is 1 with 4 Files
catmetinsert.sql catpcnfg.sql     utluppkg.sql     catdph.sql


[Phase 37] type is 1 with 1 Files
ora_restart.sql 

[Phase 38] type is 2 with 13 Files
catmetgrant2.sql execemx.sql      execcr.sql       caths.sql
catemini.sql     execaq.sql       execsvrm.sql     exechae.sql
execsec.sql      execbsln.sql     dbmspump.sql     olappl.sql
execrep.sql     

[Phase 39] type is 1 with 1 Files
ora_restart.sql 

[Phase 40] type is 2 with 10 Files
execstr.sql      execsvr.sql      execstat.sql     catsnmp.sql
wpiutil.sql      owainst.sql      catilmini.sql    execocm.sql
exectsdp.sql     execqopi.sql    

[Phase 41] type is 1 with 1 Files
ora_restart.sql 

[Phase 42] type is 1 with 1 Files
catpend.sql     

[Phase 43] type is 1 with 1 Files
ora_restart.sql 

[Phase 44] type is 1 with 1 Files
catupprc.sql    

[Phase 45] type is 1 with 1 Files
cmpupstr.sql    

[Phase 46] type is 1 with 1 Files
ora_restart.sql 

[Phase 47] type is 1 with 2 Files
cmpupjav.sql     cmpupnjv.sql    

[Phase 48] type is 1 with 1 Files
ora_restart.sql 

[Phase 49] type is 1 with 2 Files
cmpupxdb.sql     cmpupnxb.sql    

[Phase 50] type is 1 with 1 Files
ora_restart.sql 

[Phase 51] type is 1 with 2 Files
cmpupord.sql     cmpupmsc.sql    

[Phase 52] type is 1 with 1 Files
ora_restart.sql 

[Phase 53] type is 1 with 1 Files
cmpupend.sql    

[Phase 54] type is 1 with 1 Files
catupend.sql    

[Phase 55] type is 1 with 1 Files
catuppst.sql    

[Phase 56] type is 1 with 1 Files
catshutdown.sql 

Using 6 processes.
Serial   Phase #: 0 Files: 1
     Time: 118s
Serial   Phase #: 1 Files: 3      Time: 29s
Restart  Phase #: 2 Files: 1      Time: 1s
Parallel Phase #: 3 Files: 18     Time: 6s
Restart  Phase #: 4 Files: 1      Time: 0s
Serial   Phase #: 5 Files: 5      Time: 15s
Serial   Phase #: 6 Files: 1      Time: 14s
Serial   Phase #: 7 Files: 3      Time: 6s
Restart  Phase #: 8 Files: 1      Time: 1s
Parallel Phase #: 9 Files: 60     Time: 24s
Restart  Phase #:10 Files: 1      Time: 1s
Serial   Phase #:11 Files: 1      Time: 14s
Restart  Phase #:12 Files: 1      Time: 0s
Parallel Phase #:13 Files: 199    Time: 52s
Restart  Phase #:14 Files: 1      Time: 1s
Serial   Phase #:15 Files: 3      Time: 1s
Restart  Phase #:16 Files: 1      Time: 0s
Parallel Phase #:17 Files: 33     Time: 31s
Restart  Phase #:18 Files: 1      Time: 1s
Serial   Phase #:19 Files: 3      Time: 5s
Restart  Phase #:20 Files: 1      Time: 0s
Parallel Phase #:21 Files: 23     Time: 52s
Restart  Phase #:22 Files: 1      Time: 1s
Parallel Phase #:23 Files: 11     Time: 22s
Restart  Phase #:24 Files: 1      Time: 1s
Serial   Phase #:25 Files: 1      Time: 24s
Restart  Phase #:26 Files: 1      Time: 0s
Parallel Phase #:27 Files: 0      Time: 1s
Serial   Phase #:28 Files: 1      Time: 0s
Parallel Phase #:29 Files: 130    Time: 11s
Serial   Phase #:30 Files: 1      Time: 0s
Restart  Phase #:31 Files: 1      Time: 0s
Serial   Phase #:32 Files: 1      Time: 0s
Parallel Phase #:33 Files: 122    Time: 12s
Serial   Phase #:34 Files: 1      Time: 0s
Restart  Phase #:35 Files: 1      Time: 1s
Serial   Phase #:36 Files: 4      Time: 48s
Restart  Phase #:37 Files: 1      Time: 0s
Parallel Phase #:38 Files: 13     Time: 29s
Restart  Phase #:39 Files: 1      Time: 1s
Parallel Phase #:40 Files: 10     Time: 8s
Restart  Phase #:41 Files: 1      Time: 1s
Serial   Phase #:42 Files: 1      Time: 5s
Restart  Phase #:43 Files: 1      Time: 0s
Serial   Phase #:44 Files: 1      Time: 7s
Serial   Phase #:45 Files: 1      Time: 0s
Restart  Phase #:46 Files: 1      Time: 0s
Serial   Phase #:47 Files: 2      Time: 340s
Restart  Phase #:48 Files: 1      Time: 0s
Serial   Phase #:49 Files: 2      Time: 278s
Restart  Phase #:50 Files: 1      Time: 0s
Serial   Phase #:51 Files: 2       Time: 1167s
Restart  Phase #:52 Files: 1      Time: 1s
Serial   Phase #:53 Files: 1      Time: 1s
Serial   Phase #:54 Files: 1

*** WARNING: ERRORS FOUND DURING UPGRADE ***

Due to errors found during the upgrade process, the post
upgrade actions in catuppst.sql have not been automatically run.

 *** THEREFORE THE DATABASE UPGRADE IS NOT YET COMPLETE ***

 1. Evaluate the errors found in the upgrade logs (*.log) and determine the proper action.
 2. Execute the post upgrade script as described in Chapter 3 of the Database Upgrade Guide.

     Time: 110s
Grand Total Time: 2441s
[oinstall@arjun admin]$
[oinstall@arjun admin]$ ls -lrt *.log
[00mls: *.log: No such file or directory
[oinstall@arjun admin]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.1.0 Production on Tue Jul 16 10:22:15 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.
   
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size            2289064 bytes
Variable Size          570425944 bytes
Database Buffers     1090519040 bytes
Redo Buffers            6987776 bytes
Database mounted.
Database opened.
SQL> @$ORACLE_HOME/rdbms/admin/utlu121s.sql
.
Oracle Database 12.1 Post-Upgrade Status Tool           07-16-2013 10:24:24
.
Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS
.
Oracle Server
.                                      UPGRADED      12.1.0.1.0  00:09:02
JServer JAVA Virtual Machine
.                                         VALID      12.1.0.1.0  00:04:08
Oracle Workspace Manager
.                                         VALID      12.1.0.1.0  00:00:45
OLAP Analytic Workspace
.                                         VALID      12.1.0.1.0  00:00:54
Oracle OLAP API
.   ORA-00942: table or view does not exist
.   ORA-00942: table or view does not exist
.   ORA-00942: table or view does not exist
.   ORA-00942: table or view does not exist
.   ORA-00942: table or view does not exist
.                                         VALID      12.1.0.1.0  00:00:12
Oracle XDK
.                                         VALID      12.1.0.1.0  00:00:36
Oracle Text
.                                         VALID      12.1.0.1.0  00:01:02
Oracle XML Database
.                                         VALID      12.1.0.1.0  00:02:38
Oracle Database Java Packages
.                                         VALID      12.1.0.1.0  00:00:10
Oracle Multimedia
.                                         VALID      12.1.0.1.0  00:01:40
Spatial
.                                         VALID      12.1.0.1.0  00:04:08
Oracle Application Express
.                                         VALID     4.2.0.00.27  00:13:10
Final Actions
.                                                                00:01:14
Total Upgrade Time: 00:40:03

PL/SQL procedure successfully completed.

SQL>

SQL> @$ORACLE_HOME/rdbms/admin/catuppst.sql

Session altered.


Session altered.


Session altered.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP POSTUP_BGN 2013-07-16 10:25:24


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP CATREQ_BGN 2013-07-16 10:25:24


PL/SQL procedure successfully completed.

catrequtlmg: b_StatEvt     = TRUE
catrequtlmg: b_SelProps    = FALSE
catrequtlmg: b_UpgradeMode = FALSE
catrequtlmg: b_InUtlMig    = FALSE

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP CATREQ_END 2013-07-16 10:25:24

catuppst: Dropping library DBMS_DDL_INTERNAL_LIB

PL/SQL procedure successfully completed.

catuppst: Dropping view _CURRENT_EDITION_OBJ_MIG

PL/SQL procedure successfully completed.

catuppst: Dropping view _ACTUAL_EDITION_OBJ_MIG

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


This script will migrate the Baseline data on a pre-11g database
to the 11g database.

...                                       ...
... Completed Moving the Baseline Data    ...
...                                       ...
... If there are no Move BL Data messages ...
... above, then there are no renamed      ...
... baseline tables in the system.        ...
...                                       ...
...                                       ...
... Completed the Dropping of the         ...
... Renamed Baseline Tables               ...
...                                       ...
... If there are no Drop Table messages   ...
... above, then there are no renamed      ...
... baseline tables in the system.        ...
...                                       ...

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


0 rows created.


Commit complete.


Table created.


2 rows created.


1 row updated.


2 rows updated.


0 rows updated.


Table dropped.


Commit complete.


0 rows updated.


Commit complete.


0 rows updated.


Commit complete.


0 rows updated.


Commit complete.


0 rows created.


Commit complete.


0 rows created.


Commit complete.


PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

catuppst: Gathering fixed objects stats now...
catuppst: Gathering fixed objects stats done.

PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP POSTUP_END 2013-07-16 10:26:41


PL/SQL procedure successfully completed.

Session altered.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Generating apply and rollback scripts...
Check the following file for errors:
/u01/oinstall/cfgtoollogs/catbundle/catbundle_PSU_MUTH_GENERATE_2013Jul16_10_26_44.log
Apply script: /u01/oinstall/product/12.1.1/rdbms/admin/catbundle_PSU_MUTH_APPLY.sql
Rollback script: /u01/oinstall/product/12.1.1/rdbms/admin/catbundle_PSU_MUTH_ROLLBACK.sql

PL/SQL procedure successfully completed.

Executing script file...

SQL> alter session set "_ORACLE_SCRIPT" = true;

Session altered.

SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/u01/oinstall/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;

SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')

PL/SQL procedure successfully completed.

SQL> ALTER SESSION SET current_schema = SYS;

Session altered.

SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
  2    (action_time, action,
  3     namespace, version, id,
  4     bundle_series, comments)
  5  VALUES
  6    (SYSTIMESTAMP, 'APPLY',
  7     SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  8     '12.1.0.1',
  9     0,
 10     'PSU',
 11     'Patchset 12.1.0.0.0');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/oinstall/cfgtoollogs/catbundle/catbundle_PSU_MUTH_APPLY_2013Jul16_10_26_45.log

Session altered.


Session altered.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oinstall@arjun admin]$ vi /u01/oinstall/cfgtoollogs/catbundle/catbundle_PSU_MUTH_APPLY_2013Jul16_10_26_45.log

############Compile Invalid Objects#########
[oinstall@arjun admin]$sqlplus "/as sysdba"

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

SQL> @/usr/tmp/dbupgdiag.sql

###########Post Upgrade Steps################

Make sure the following environment variables point to the Oracle 12c Release 1 (12.1) directories            
               - ORACLE_BASE
               - ORACLE_HOME
               - PATH, LD_LIBRARY_PATH and SHLIB_PATH
Ensure that your oratab file and any client scripts that set the value of ORACLE_HOME point to the new Oracle home that is created for the new Oracle Database 12c release,

############Initialization parameter file##########
Edit init.ora
If you changed the CLUSTER_DATABASE parameter prior the upgrade set it back to TRUE
Migrate your initialization parameter file to a server parameter file.
Create a server parameter file with an initialization parameter file.
SQL> create spfile from pfile;

###############Password File###################

If the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to either exclusive or shared, create a password file with ORAPWD.

#############COMPATIBLE Initialization Parameter#############

The COMPATIBLE initialization parameter controls the compatibility level of your database.
When you are certain that you no longer need the ability to downgrade your database to its original release
Perform a backup of your database before you raise the COMPATIBLE initialization parameter (optional).
If you are using a server parameter file, then complete the following steps:
              a. Update the server parameter file to set or change the value of the COMPATIBLE initialization parameter.
                 For example, to set the COMPATIBLE initialization parameter to 12.0.0, enter the following statement:
SQL> ALTER SYSTEM SET COMPATIBLE = '12.0.0' SCOPE=SPFILE;
              b. Shut down and restart the instance.
If you are using an initialization parameter file, then complete the following steps:
              a. Shut down the instance if it is running:
SQL> SHUTDOWN IMMEDIATE
              b. Edit the initialization parameter file to set or change the value of the COMPATIBLE initialization parameter.
                 For example, to set the COMPATIBLE initialization parameter to for Oracle Database release 12.1, enter the following in the initialization parameter file:
                 COMPATIBLE = 12.1.0
              c. Start the instance using STARTUP.
             
Change passwords for Oracle-Supplied Accounts.

SQL> SELECT username, account_status FROM dba_users ORDER BY username;

To lock and expire passwords, issue the following SQL statement:

SQL> ALTER USER username PASSWORD EXPIRE ACCOUNT LOCK;

Upgrade the Recovery Catalog After Upgrading Oracle Database

You can upgrade the Recovery catalog by executing the  UPGRADE CATALOG command

Upgrade the Time Zone File Version After Upgrading Oracle Database

Identify Invalid Objects With the utluiobj Script

SQL> @$ORACLE_HOME/rdbms/admin/utluiobj.sql

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE    12.1.0.1.0      Production
TNS for Linux: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production

SQL>