Oracle 12.1.0.2.0 - Applying Patch 21260431: GETTING ORA-4031 AFTER 12C UPGRADE

Oracle 12.1.0.2.0 - Applying Patch 21260431: GETTING ORA-4031 AFTER 12C UPGRADE

- Download Patch 21260431 (p21260431_121020_Linux-x86-64.zip)

- Ensure that Oracle home is Oracle Database 12c Release 12.1.0.2.0

Applying Patch 21260431

- Set environment variables

- Shutdown all services

- Unzip the patch

$ unzip p21260431_121020_Linux-x86-64.zip

$ cd <PATCH_TOP_DIR>/21260431

- Run opatch apply

$ opatch apply

- Verify patch

$ opatch lsinventory |grep 21260431

- Start all services

Rollback Patch 21260431

If any issues after applying the patch and rollback is required

- Stop the services

- Run opatch rollback

$ opatch rollback -id 21260431


- Restart all services

Related Posts:

Oracle Database 12.1.0.2.5 - Applying Patch 19509982: DISABLE FIX FOR RAISING ORA-1792 BY DEFAULT.

Installation of Oracle Database 12c R1 (12.1.0.1.0)

Installation of Oracle Database 12c R1 (12.1.0.1.0)

Run setup.exe from installer directory (This is on windows, similarly invoke installer on Linux environment)

Oracle Database 12c Release 1 Installer - Installing Database

Step 1: Configure security updates

Enter My Oracle Support Username / Password to receive security updates via My Oracle Support (optional)

Step 2: Download Software updates

Enter My Oracle Support credentials to download software updates for this installation (optional)

Step 3: Select Installation Option

i)  Create and configure a database (Select this option)
ii) Install database software only
iii)Upgrade an existing database 

Step 4: System Class

i) Desktop class (Choose this option)
ii)Server class

Step 5: Specify Oracle Home User

i) Use Existing Windows User
ii) Create New Windows USer 
iii)Use Windows Built-in account (Option chosen - No need to specify username or password)


Step 6: Typical Install Configuration

Enter Administrative password: 

Step 7: Prerequisite checks

Step 8: Summary

Step 9: Install

At the end of installation, you will see on screen 

The installation of Oracle Database was successful.

Your database configuration files have been installed in C:\app\ while other components selected for installation have been installed in C:\app\product\12.1.0\dbhome_1.  Be cautious not to accidentally delete these configuration files.

SQL> select instance_name, status, version, database_status from v$instance;

INSTANCE_NAME    STATUS       VERSION           DATABASE_STATUS
---------------- ------------ ----------------- -------------------------------------------------------

newdb12c         OPEN         12.1.0.1.0        ACTIVE


Deinstalling Oracle Database 12c:

Go to $DB_HOME/deinstall and execute deinstall script.

For eg:

C:\app\db12c\product\12.1.0\dbhome_1\deinstall>deinstall

Related:

Oracle Database 12c R1 New Features - Invisible columns

Oracle Database 12c R1 New Features - Multiple Indexes on the same column or set of columns