Ora Training Blog

Solution for ORA-04023 error:

Some times you may notice that after recreation of some views or procedures, you may start getting ORA-04023 errors.

ORA-04023: Object could not be validated or authorized

You may also see ORA-00001 errors in your alert log file during the same time.

If you have RAC database and if you are getting ORA-04023 error only on one of the nodes then it is very clear that the issue is related to specific “instance” and not the “database“.

This error means that the shared pool is corrupt. You can try to flush the shared pool so that it may populate the fresh objects again in the shared pool. This should resolve the problem.

SQL> alter system flush shared_pool;

If this does not solve the issue, you need to contact Oracle Support for further details.

Important note: This post is applicable only for Oracle Databases 11gR2 onwards. The steps for 11gR1 and earlier versions are different. Also these steps are for OCR and Voting disks hosted on a certified cluster file system. If you are using ASM or Raw devices to store these files then the initial preparation tasks might differ

Please note that Oracle Cluster requires to remain up during this operation. For safer side we had shut down the databases during this but this is not required. The cluster was up and running during this operation.

 

Move OCR (Oracle Cluster Registry) Disks

1) Check existing OCR disks

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrcheck -config

Oracle Cluster Registry configuration is :

Device/File Name : /u01/racfiles/ocr

Device/File Name : /u02/racfiles/ocr

Device/File Name : /u03/racfiles/ocr

 

2) Prepare new disks

root@rachost1 # mkdir /u04/racfiles

root@rachost1 # chown root:dba /u04/racfiles/

root@rachost1 # touch /u04/racfiles/ocr

root@rachost1 # chown root:dba /u04/racfiles/ocr

root@rachost1 # chmod 640 /u04/racfiles/ocr

 

3) Check current backups for OCR

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -showbackup

rachost1 2014/04/16 11:26:48 /app/oracle/11.2.0/grid/cdata/cluster/backup00.ocr

rachost1 2014/04/16 07:26:47 /app/oracle/11.2.0/grid/cdata/cluster/backup01.ocr

rachost1 2014/04/16 03:26:46 /app/oracle/11.2.0/grid/cdata/cluster/backup02.ocr

rachost1 2014/04/15 03:26:41 /app/oracle/11.2.0/grid/cdata/cluster/day.ocr

rachost1 2014/04/03 03:25:47 /app/oracle/11.2.0/grid/cdata/cluster/week.ocr

PROT-25: Manual backups for the Oracle Cluster Registry are not available

 

4) Take one manual backup if required

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -manualbackup

rachost1 2014/04/16 11:40:47 /app/oracle/11.2.0/grid/cdata/cluster/backup_20140416_114047.ocr

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -showbackup

rachost1 2014/04/16 11:26:48 /app/oracle/11.2.0/grid/cdata/cluster/backup00.ocr

rachost1 2014/04/16 07:26:47 /app/oracle/11.2.0/grid/cdata/cluster/backup01.ocr

rachost1 2014/04/16 03:26:46 /app/oracle/11.2.0/grid/cdata/cluster/backup02.ocr

rachost1 2014/04/15 03:26:41 /app/oracle/11.2.0/grid/cdata/cluster/day.ocr

rachost1 2014/04/03 03:25:47 /app/oracle/11.2.0/grid/cdata/cluster/week.ocr

rachost1 2014/04/16 11:40:47 /app/oracle/11.2.0/grid/cdata/cluster/backup_20140416_114047.ocr

 

5) Add new OCR disks

Note: Since OCR allows 1+4 OCR mirror files and we already have 3 existing OCR files, so we will add 2 new disks now and then later add 3^rd one after removing existing disks

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -add /u04/racfiles/ocr

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrcheck -config

Oracle Cluster Registry configuration is :

Device/File Name : /u01/racfiles/ocr

Device/File Name : /u02/racfiles/ocr

Device/File Name : /u03/racfiles/ocr

Device/File Name : /u04/racfiles/ocr

 

root@rachost1 # mkdir /u05/racfiles

root@rachost1 # chown root:dba /u05/racfiles

root@rachost1 # touch /u05/racfiles/ocr

root@rachost1 # chown root:dba /u05/racfiles/ocr

root@rachost1 # chmod 640 /u05/racfiles/ocr

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -add /u05/racfiles/ocr

 

6) Check new OCR configuration

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrcheck -config

Oracle Cluster Registry configuration is :

Device/File Name : /u01/racfiles/ocr

Device/File Name : /u02/racfiles/ocr

Device/File Name : /u03/racfiles/ocr

Device/File Name : /u04/racfiles/ocr

Device/File Name : /u05/racfiles/ocr

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrcheck

Status of Oracle Cluster Registry is as follows :

Version : 3

Total space (kbytes) : 262120

Used space (kbytes) : 2632

Available space (kbytes) : 259488

ID : 1510948299

Device/File Name : /u01/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u02/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u03/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u04/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u05/racfiles/ocr

Device/File integrity check succeeded

Cluster registry integrity check succeeded

Logical corruption check succeeded

 

7) Delete existing OCR file

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -delete /u03/racfiles/ocr

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrcheck

Status of Oracle Cluster Registry is as follows :

Version : 3

Total space (kbytes) : 262120

Used space (kbytes) : 2632

Available space (kbytes) : 259488

ID : 1510948299

Device/File Name : /u01/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u02/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u04/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u05/racfiles/ocr

Device/File integrity check succeeded

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

 

8) Add new OCR files and delete remaining OCR files (if required)

root@rachost1 # mkdir /u06/racfiles

root@rachost1 # chown root:dba /u06/racfiles

root@rachost1 # touch /u06/racfiles/ocr

root@rachost1 # chown root:dba /u06/racfiles/ocr

root@rachost1 # chmod 640 /u06/racfiles/ocr

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -add /u06/racfiles/ocr

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -delete /u02/racfiles/ocr

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -delete /u01/racfiles/ocr

 

I) Check final OCR configuration after the addition and deletion

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrcheck -config

Oracle Cluster Registry configuration is :

Device/File Name : /u04/racfiles/ocr

Device/File Name : /u05/racfiles/ocr

Device/File Name : /u06/racfiles/ocr

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrcheck

Status of Oracle Cluster Registry is as follows :

Version : 3

Total space (kbytes) : 262120

Used space (kbytes) : 2632

Available space (kbytes) : 259488

ID : 1510948299

Device/File Name : /u04/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u05/racfiles/ocr

Device/File integrity check succeeded

Device/File Name : /u06/racfiles/ocr

Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

 

9) Take another manual backup if required

root@rachost1 # /app/oracle/11.2.0/grid/bin/ocrconfig -manualbackup

 

rachost1 2014/04/16 12:04:10 /app/oracle/11.2.0/grid/cdata/cluster/backup_20140416_120410.ocr

rachost1 2014/04/16 11:40:47 /app/oracle/11.2.0/grid/cdata/cluster/backup_20140416_114047.ocr

 

 

Move Voting disks

 

For Voting disks (11gR2 onwards), we do not need to take backup since the backup is automatically taken during OCR backup and also during any add/delete operations for Voting disks. Also we do not need to prepare the disks in advance as we did for OCR disks

 

1) Check existing Voting Disks

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl query css votedisk

## STATE File Universal Id File Name Disk group

— —– —————– ——— ———

1. ONLINE a6b7e116f7fd4f7abfd1b85386655bde (/u01/racfiles/vdisk) []

2. ONLINE 627187c834d64fc0bf8bf27290054c13 (/u02/racfiles/vdisk) []

3. ONLINE 5242884e87334f58bf536e322ba9d557 (/u03/racfiles/vdisk) []

Located 3 voting disk(s).

 

2) Add new Voting Disks

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl add css votedisk /u04/racfiles/vdisk

Now formatting voting disk: /u04/racfiles/vdisk.

CRS-4603: Successful addition of voting disk /u04/racfiles/vdisk.

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl add css votedisk /u05/racfiles/vdisk

Now formatting voting disk: /u05/racfiles/vdisk.

CRS-4603: Successful addition of voting disk /u05/racfiles/vdisk.

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl add css votedisk /u06/racfiles/vdisk

Now formatting voting disk: /u06/racfiles/vdisk.

CRS-4603: Successful addition of voting disk /u06/racfiles/vdisk.

 

3) Check the new Voting disks configuration

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl query css votedisk

## STATE File Universal Id File Name Disk group

— —– —————– ——— ———

1. ONLINE a6b7e116f7fd4f7abfd1b85386655bde (/u01/racfiles/vdisk) []

2. ONLINE 627187c834d64fc0bf8bf27290054c13 (/u02/racfiles/vdisk) []

3. ONLINE 5242884e87334f58bf536e322ba9d557 (/u03/racfiles/vdisk) []

4. ONLINE 5e842268d1f34fd5bf2eee25a7529233 (/u04/racfiles/vdisk) []

5. ONLINE aa02617e01804fe7bf5cd40d5da6bc8e (/u05/racfiles/vdisk) []

6. ONLINE 0ac52c14753e4ff7bf79e8e013e530b6 (/u06/racfiles/vdisk) []

Located 6 voting disk(s).

4) Delete existing Voting Disks which were required to be moved

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl delete css votedisk /u03/racfiles/vdisk

CRS-4611: Successful deletion of voting disk /u03/racfiles/vdisk.

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl delete css votedisk /u02/racfiles/vdisk

CRS-4611: Successful deletion of voting disk /u02/racfiles/vdisk.

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl delete css votedisk /u01/racfiles/vdisk

CRS-4611: Successful deletion of voting disk /u01/racfiles/vdisk.

 

5) Check the new Voting disks configuration

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl query css votedisk

## STATE File Universal Id File Name Disk group

— —– —————– ——— ———

1. ONLINE 5e842268d1f34fd5bf2eee25a7529233 (/u04/racfiles/vdisk) []

2. ONLINE aa02617e01804fe7bf5cd40d5da6bc8e (/u05/racfiles/vdisk) []

3. ONLINE 0ac52c14753e4ff7bf79e8e013e530b6 (/u06/racfiles/vdisk) []

Located 3 voting disk(s).

 

6) Restart Cluster services to make sure that everything is fine after this movement

root@rachost1 # /app/oracle/11.2.0/grid/bin/crs_stop -all

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl stop crs

root@rachost2 # /app/oracle/11.2.0/grid/bin/crsctl stop crs

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/crsctl start crs

root@rachost2 # /app/oracle/11.2.0/grid/bin/crsctl start crs

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/crs_stat -t

Name Type Target State Host

————————————————————

ora….ER.lsnr ora….er.type OFFLINE OFFLINE

ora….N1.lsnr ora….er.type OFFLINE OFFLINE

ora….SM1.asm application OFFLINE OFFLINE

ora….01.lsnr application OFFLINE OFFLINE

ora….h01.gsd application OFFLINE OFFLINE

ora….h01.ons application ONLINE ONLINE rachost1

ora….h01.vip ora….t1.type OFFLINE OFFLINE

ora….SM2.asm application OFFLINE OFFLINE

ora….02.lsnr application OFFLINE OFFLINE

ora….h02.gsd application OFFLINE OFFLINE

ora….h02.ons application ONLINE ONLINE rachost2

ora….h02.vip ora….t1.type OFFLINE OFFLINE

ora.asm ora.asm.type OFFLINE OFFLINE

ora.eons ora.eons.type ONLINE ONLINE rachost1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora….network ora….rk.type ONLINE ONLINE rachost1

ora.oc4j ora.oc4j.type OFFLINE OFFLINE

ora.ons ora.ons.type ONLINE ONLINE rachost1

ora.scan1.vip ora….ip.type OFFLINE OFFLINE

 

root@rachost1 # /app/oracle/11.2.0/grid/bin/crs_start -all

root@rachost1 # /app/oracle/11.2.0/grid/bin/crs_stat -t

Name Type Target State Host

————————————————————

ora….ER.lsnr ora….er.type ONLINE ONLINE rachost1

ora….N1.lsnr ora….er.type ONLINE ONLINE rachost1

ora….SM1.asm application ONLINE ONLINE rachost1

ora….01.lsnr application ONLINE ONLINE rachost1

ora….h01.gsd application OFFLINE OFFLINE

ora….h01.ons application ONLINE ONLINE rachost1

ora….h01.vip ora….t1.type ONLINE ONLINE rachost1

ora….SM2.asm application ONLINE ONLINE rachost2

ora….02.lsnr application ONLINE ONLINE rachost2

ora….h02.gsd application OFFLINE OFFLINE

ora….h02.ons application ONLINE ONLINE rachost2

ora….h02.vip ora….t1.type ONLINE ONLINE rachost2

ora.asm ora.asm.type ONLINE ONLINE rachost1

ora.eons ora.eons.type ONLINE ONLINE rachost1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora….network ora….rk.type ONLINE ONLINE rachost1

ora.oc4j ora.oc4j.type OFFLINE OFFLINE

ora.ons ora.ons.type ONLINE ONLINE rachost1

ora.scan1.vip ora….ip.type ONLINE ONLINE rachost1

 

-bash-3.2$ srvctl status database -d dbname

Instance dbname1 is running on node rachost1

Instance dbname2 is running on node rachost2

Pro Oracle Fusion Applications – Installation and Administration

Now you can buy the first and only comprehensive book on Oracle Fusion Applications Installation and Administration which covers end to end information on introduction, planning, installation and troubleshooting guides for implementing Fusion Applications on premise. Buy it now from any of the following stores.

http://www.amazon.com/Pro-Oracle-Fusion-Applications-Administration/dp/1484209842

http://www.barnesandnoble.com/w/pro-oracle-fusion-applications-tushar-thakker/1121094340

http://www.apress.com/9781484209844

http://www.springer.com/us/book/9781484209844

Fusion Applications 11.1.8 installation is not straightforward unlike E-Business Suite 11i/R12 installation. So we need to divide the installation into a number of steps. Please note that 11.1.8 release provisioning is almost identical to 11.1.7 counterpart. At the same time the steps and a few components differ when compared to 11.1.6 and 11.1.5 . Here we have actually used the same 11.1.7 steps here for 11.1.8 guide and will mention wherever we see a difference compared to 11.1.7 steps.

Note: If you are looking for Fusion Applications 11.1.6 installation steps then you can refer to following link.

http://www.oratraining.com/blog/2013/03/oracle-fusion-applications-installation-step-by-step-guide-11-1-6/

If you are looking for Fusion Applications 11.1.5 installation steps then you can refer to following link.

http://www.oratraining.com/blog/2012/12/oracle-fusion-applications-installation-step-by-step-guide-11-1-5/

Following is our previous post which shows a few of the differences. More will be added soon.

http://www.oratraining.com/blog/2013/10/whats-new-in-fusion-applications-11-1-8-installationprovisioning/

In terms of architecture also there are a few changes which are already covered in the above link. Following is our previous post which shows different type of setups which we can choose for learning purpose.

http://www.oratraining.com/blog/2013/10/fusion-applications-architecture-for-2-or-3-nodes-setup-updated-for-11-1-8/

Here we will install Fusion Apps 11.1.8 in 2 nodes setup only for learning purpose but you can follow the same guide even for 3 nodes or 4 nodes setup since we have used hostname aliases for both database hosts including in the configuration so any point of time you can move databases across to separate node(s).

Following diagram shows the components in each host.

We are using following configuration for our installation.

Node 1
Hostname: idmhost
OS: Oracle Linux x86-64
Disk size: 300 GB
Memory: Minimum 8+ GB (Recommended 16+ GB)

Node 2
Hostname: fahost
OS: Oracle Linux x86-64
Disk size: 500 GB
Memory:

• Option 1. For single product (except Financials, CRM or SCM) : Minimum 64+ GB (Recommended 96+ GB)
• Option 2: For Financials or CRM or SCM: Minimum 88+ GB (Recommended 128 GB)
• Option 3: For all products selected: Minimum 144+ GB

Fusion Application Installations can be largely divided into following steps.

Preparing for Oracle Fusion Applications installation

1. Downloading Oracle Fusion Applications media

2. Creating Oracle Fusion Applications provisioning repository / Staging directory

3. Installing OS (here Oracle Linux x86-64) on physical machine or Virtual machine (here Oracle VirtualBox VM)

Installing Oracle Fusion Applications – steps

A. Setting up Identity and Access Management Node

    1. Install Fusion Applications Provisioning Framework

    2. Install Oracle 11g Database (Identity management database)

    3. Run Repository Creation Utility (RCU) for Oracle Identity Management components

    4. Install Identity Management Provisioning Wizard

    5. Create IDM provisioning Response File

    6. Provision Identity Management

    7. Perform Post-Provisioning Configuration

B. Setting up Fusion Applications Node

    1. Install Fusion Applications Provisioning Framework

    2. Install Oracle 11g Database (Fusion Apps Database)

    3. Run Oracle Fusion Applications Repository Creation Utility (Applications RCU)

    4. Create new Applications Provisioning Response File

    5. Provision an Applications Environment

We are going to install Fusion Applications 11.1.8 for Oracle Linux x86-64 Operating system. So we will download the installation media for Oracle Fusion Applications 11.1.8 for Linux x86-64 from http://edelivery.oracle.com

Preparing for Oracle Fusion Applications installation

1. Downloading Oracle Fusion Applications media

Login to http://edelivery.oracle.com to access the following screen.

Select “Oracle Fusion Applications” and required platform from the list. Click Go. Open the first pack.

Download the first 17 media files (excluding README and documentation library). We will not need rest of the media for this installation.

2. Creating Oracle Fusion Applications provisioning repository / Staging directory

Unzip all these files into one Stage directory on your host OS.

Important Note: Since some of the files have very long directory path (very close to 255 characters), please unzip these files into stage folder name to keep short name. At least 2 files have very long path so let us try to avoid this.

For example, if you are creating the stage directory on Windows then try to unzip into c:\stage or e:\stage etc

3. Install OS on physical machine or Virtual Machine

We have installed the OS on Oracle VirtualBox VM with Oracle Linux x86-64 OS as guest and Windows 2008 as host OS.

Next: Install Fusion Applications Provisioning Framework on IDM Host