OPP is not getting UP and All XML report is giving Error in apps R12

Issue: OPP is not getting UP. XML Reports are going in Error.

Solutions:

This is process how to purge the FND_CP_GSM_OPP_AQTBL manually to clean up the table:

1. Shut down the concurrent managers cleanly.

2. Check the number of records in the table :

SQL> select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ;

Output: Millions of rows.

3. Run the following as SYS:

DECLARE
po dbms_aqadm.aq$_purge_options_t;
BEGIN
po.block := FALSE;
DBMS_AQADM.PURGE_QUEUE_TABLE(
queue_table => 'APPLSYS.FND_CP_GSM_OPP_AQTBL',
purge_condition => NULL,
purge_options => po);
END;
/

4. Re-check again the number of records in the table:

SQL> select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ;

5. Run the script $FND_TOP/patch/115/sql/afopp001.sql as the SYSTEM user.

SQL> @$FND_TOP/patch/115/sql/afopp001.sql
Enter value for 1: SYSTEM
Enter value for 2: manager
Connected.

PL/SQL procedure successfully completed.

Grant succeeded.

Commit complete.

6. Run the script $FND_TOP/patch/115/sql/afopp002.sql as the APPLSYS user.

SQL> @$FND_TOP/patch/115/sql/afopp002.sql
Enter value for 1: applsys
Enter value for 2: appssup
Connected.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Commit complete.

7. Restart the concurrent manager and retest.

In case the purge did not complete successfully after the second time, or did not purge all the queues,
then you would have to recreate the queue. Recreate the queue using $FND_TOP/patch/115/sql/afopp002.sql file as 'APPLSYS' user.
On running the script you will be prompted for username and password. Please note that this may take a longer length of time to complete.

8. Run cmclean twice ensuring commit after each run - the script is available in note 134007.1

9. Start up the application services and retest.

*********************************************************************************

Check Locked Session and Concurrent Request in EBS R12

                  /* Use the below query to check Locked Sessions and Concurrent Request */

SQL>select
b.process " Process id ",
b.osuser,
b.machine,
b.sid,
b.serial#,
b.schemaname,
b.module,
b.action,
trunc(b.SECONDS_IN_WAIT/60/60,3) " Waiting Time in H ",
blocking_session,
'*** KILL ONLY IF BLOCKING_SESSION IS NULL, otherwise trace that blocking session till has null *** -- alter system kill session '''||b.sid||','||b.SERIAL#||''' immediate;' " SQL kill session statement" ,
'*** KILL ONLY IF BLOCKING_SESSION IS NULL, otherwise trace that blocking session till has null --- kill -9 '||b.process " OS kill process command",
b.PADDR,
p.SPID,
b.PROCESS
from v$session b , v$process p
where b.PADDR=p.ADDR and b.sid in (select BLOCKING_SESSION from v$session s where  BLOCKING_SESSION is not null);

*********************************************************************************

Check FND User Password in EBS R12

      /*Use the below query to check FND password in ERP R12*/

SQL>SELECT usr.user_name,
       get_pwd.decrypt
          ((SELECT (SELECT get_pwd.decrypt
                              (fnd_web_sec.get_guest_username_pwd,
                               usertable.encrypted_foundation_password
                              )
                      FROM DUAL) AS apps_password
              FROM fnd_user usertable
             WHERE usertable.user_name =
                      (SELECT SUBSTR
                                  (fnd_web_sec.get_guest_username_pwd,
                                   1,
                                     INSTR
                                          (fnd_web_sec.get_guest_username_pwd,
                                           '/'
                                          )
                                   - 1
                                  )
                         FROM DUAL)),
           usr.encrypted_user_password
          ) PASSWORD
  FROM fnd_user usr
 WHERE usr.user_name = '&USER_NAME';

***********************************************************************************************

How to ADD DISK GROUP in ORACLE ASM

How to ADD DISK GROUP in ORACLE ASM

Step.1  System Admin will add the disk on the server which should be visible on all the database nodes.

DBA can check using the below command on the path.

Example:  DISK PATH

/dev/oracleasmdisk

bash-4.3# ll

crwxrwxrwx   1 oragrid    oinstall    13 0x000011 Mar 29 11:31 archivdisk

crwxrwxrwx   1 oragrid    oinstall    13 0x000012 Mar 27 17:05 prddata1disk

crwxrwxrwx   1 oragrid    oinstall    13 0x000027 Mar 23 07:11 prddata2disk

crwxrwxrwx   1 oragrid    oinstall    13 0x00002f Mar 29 08:24 prddata3disk   >>> New Added Disk

crwxrwxrwx   1 oragrid    oinstall    13 0x000026 May  1  2014 prdflash

crwxrwxrwx   1 oragrid    oinstall    13 0x000014 Mar 20 21:02 prdinfradisk

crwxrwxrwx   1 oragrid    oinstall    13 0x000013 Mar 27 17:05 proddatadisk

We check the same disk on all database instance.
Step.2 Login on any database instance using grid user and connect in ASM using SQLPLUS.

Example:-

bash-4.3$ id

uid=112(oragrid) gid=107(oinstall) groups=503(asmadmin),504(asmdba),505(asmoper)

bash-4.3$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 29 11:56:33 2016

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options              

SQL> select name, path, header_status from v$asm_disk;

NAME	PATH	HEADER_STATUS
PRODARCH_0000	/dev/oracleasmdisk/prddata3disk	CANDIDATE	After add disk Header status
PRODDATA1_0000	/dev/oracleasmdisk/archivdisk	MEMBER
PRODINFRA_0000	/dev/oracleasmdisk/prddata1disk	MEMBER
PRODDATA_0000	/dev/oracleasmdisk/prdinfradisk	MEMBER
PRODFLASH1	/dev/oracleasmdisk/prdflash	MEMBER
PRODDATA_0001	/dev/oracleasmdisk/prddata2disk	MEMBER

Step.3 Login using oragrid user and connect through sqlplus / as sysasm . Please follow the below steps.

Example:

SQL> CREATE DISKGROUP PRODDATA2 EXTERNAL REDUNDANCY DISK '/dev/oracleasmdisk/prddata3disk';

 >>>>>.. Execute it on one node

SQL>ALTER DISKGROUP PRODDATA2 mount;

<< Run the mount command in the other remaining two nodes.

Step.4 After add the disk in ASM check the header status result should be like below example.

SQL> select name, path, header_status from v$asm_disk;

NAME	PATH	HEADER_STATUS
PRODARCH_0000	/dev/oracleasmdisk/prddata3disk	MEMBER	Now header status should be member
PRODDATA1_0000	/dev/oracleasmdisk/archivdisk	MEMBER
PRODINFRA_0000	/dev/oracleasmdisk/prddata1disk	MEMBER
PRODDATA_0000	/dev/oracleasmdisk/prdinfradisk	MEMBER
PRODFLASH1	/dev/oracleasmdisk/prdflash	MEMBER
PRODDATA_0001	/dev/oracleasmdisk/prddata2disk	MEMBER

Step.5 Check the added disk in ASM is it mounted or not. You need to check on all 3 nodes.

bash-4.3$ asmcmd lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N        1024   4096  1048576    819200   353910                0          353910              0             N  PRODARCH/

MOUNTED  EXTERN  N        1024   4096  1048576   2099200    63706                0           63706              0             N  PRODDATA/

MOUNTED  EXTERN  N        1024   4096  1048576   1740800     5276                0            5276              0             N  PRODDATA1/

MOUNTED  EXTERN  N        1024   4096  1048576    307200   228184                0          228184              0             N  PRODDATA2/

MOUNTED  EXTERN  N        1024   4096  1048576    512000   511852                0          511852              0             N  PRODFLASH/

MOUNTED  EXTERN  N        1024   4096  4194304    204800   204248                0          204248              0             Y  PRODINFRA/

Now you can add new datafiles or tablespace according your requirements.

If your database connected with other OEM application then disk group status will be show mounted until you do not add datafiles in the added disk.

Check the FND Sessions In Oracle APPS R12

Please use the below query to check Number of sessions in Oracle APPS R12.


SQL>select icx.node_id,fnd.node_name,'Number of user sessions : ' || count( distinct icx.session_id) How_many_user_sessions
from icx_sessions icx, fnd_nodes fnd where icx.disabled_flag != 'Y'
and icx.PSEUDO_FLAG = 'N'
and icx.node_id=fnd.node_id
and (icx.last_connect + decode(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'), NULL,icx.limit_time, 0,
icx.limit_time,FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24) > sysdate and counter < icx.limit_connects
group by icx.node_id,fnd.node_name;

*********************************************************************************

Check Long Running Request in Oracle ERP R12

Please use the below query to check long running request in Oracle ERP R12.

SELECT a.request_id
,a.oracle_process_id "SPID"
,frt.responsibility_name
,c.concurrent_program_name || ': ' || ctl.user_concurrent_program_name
,a.description
,a.ARGUMENT_TEXT
,b.node_name
,b.db_instance
,a.logfile_name
,a.logfile_node_name
,a.outfile_name
,q.concurrent_queue_name
,a.phase_code,a.status_code, a.completion_text
, actual_start_date
, actual_completion_date
, fu.user_name
,(nvl(actual_completion_date,sysdate)-actual_start_date)*1440 mins
,(SELECT avg(nvl(a2.actual_completion_date-a2.actual_start_date,0))*1440 avg_run_time
FROM APPLSYS.fnd_Concurrent_requests a2,
APPLSYS.fnd_concurrent_programs c2
WHERE c2.concurrent_program_id = c.concurrent_program_id
AND a2.concurrent_program_id = c2.concurrent_program_id
AND a2.program_application_id = c2.application_id
AND a2.phase_code || '' = 'C') avg_mins
,round((actual_completion_date - requested_start_date),2) * 24 duration_in_hours
FROM APPLSYS.fnd_Concurrent_requests a,APPLSYS.fnd_concurrent_processes b
,applsys.fnd_concurrent_queues q
,APPLSYS.fnd_concurrent_programs c
,APPLSYS.fnd_concurrent_programs_tl ctl
,apps.fnd_user fu
,apps.FND_RESPONSIBILITY_TL frt
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND a.phase_code = 'R'
AND a.status_code = 'R'
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND ctl.concurrent_program_id = c.concurrent_program_id
AND a.requested_by = fu.user_id
AND a.responsibility_id = frt.responsibility_id
ORDER BY a.actual_start_date DESC

START and STOP Local Listener and SCAN Listener in RAC Database.

How to Start and Stop Local Listener and SCAN Listener

First check which services are running from which nodes and users.

oragrid$ps -eaf|grep tns


\*-----How to set environment -----*/

bash-4.3$ which srvctl
/u02/grid/product/11.2.0/bin/srvctl
bash-4.3$ which lsnrctl


bash-4.3$ export PATH=$ORACLE_HOME/bin:$PATH


oragrid$/u02/grid/product/11.2.0/bin/lsnrctl

\*--How to STOP Local Listener----*/    :-Run this command from one by one from all nodes

oragrid$srvctl stop LISTENER -n adupgdb1
oragrid$srvctl stop LISTENER -n oracledb1
oragrid$srvctl stop LISTENER -n oracledb2

\*--How to STOP SCAN Listener----*/  :-Run from any one node

oragrid$srvctl stop scan_listener

\*----- How to START Local Listener------*/

oragrid$srvctl start LISTENER -n adupgdb1
oragrid$srvctl start LISTENER -n oracledb1
oragrid$srvctl start LISTENER -n oracledb2


\*-----How to start SCAN Listener------*/
oragrid$srvctl start scan_listener

********************************************************
\*******How to bounced Single SCAN Listener one by one on nodes*******/

Run from the grid user.

bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node adupgdb1

bash-4.3$ srvctl stop scan_listener -i 3

bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is not running

bash-4.3$ srvctl start scan_listener -i 3

bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node adupgdb1
*************************************************************

Listener Issue in RAC Environment (Services are not registerd in Listener)

If you are facing connection issue in RAC environment then check the both SID and service name is registered in database. Please follow the below steps.

Solution:

Node1 

alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=<vip of node1>)(PORT=1521))' scope=both SID='TEST1';
alter system register;

(Replace "<vip of node1>" with VIP of node1)

Node2

alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=<vip of node2>)(PORT=1521))' scope=both SID='TEST2';
alter system register;

(Replace "<vip of node2>" with VIP of node2)


Check the staus from one by one nodes.

Node1

$lsnrctl status LISTENER

Node2

$lsnrctl status LISTENER

**************************************************************************

Blank Page Issue In Oracle ERP R12

There are could be many reasons of the blank page issue. Recently, I faced below cause of this issue.

ERROR:1 -
Below error appeared in $LOG_HOME/ora/10.1.3/opmn/opmn/oafm_default_group_1/oafmstd.out

11/12/15 14:27:19.974 html: chain failed
javax.servlet.ServletException: java.lang.RuntimeException: ORA-04063: package body "APPS.FND_WEB_SEC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"
ORA-06512: at line 1

at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816)
at _AppsLocalLogin._jspService(_AppsLocalLogin.java:303)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.4.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

Cause: Due to FND_WEB_SEC package was corrupted.

Action Plan:1 Try to compile the package. ( It's not resolved)

SQL> ALTER PACKAGE FND_WEB_SEC COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> SHOW ERROR
Errors for PACKAGE BODY FND_WEB_SEC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00753: malformed or corrupted wrapped unit

Solution:

Please execute the following steps:

1. Login to UNIX session of the EBS Apps Tier

2. Set the application environment file

3.  Validate the version of the package FND_WEB_SEC in database

select text from user_source
where NAME= 'FND_WEB_SEC'
and line = 2;

4. Validated the version of FND_WEB_SEC package in file system,

cd $FND_TOP/patch/115/sql

adident Header AFSCJAV8.pls
adident Header AFSCJAVB.pls
adident Header AFSCJAVS.pls

Note : FND_WEB_SEC version in DB and File system should match

5. Execute the below commands

sqlplus apps/<apps pw> $FND_TOP/patch/115/sql/AFSCJAVS.pls
sqlplus apps/<apps pw> $FND_TOP/patch/115/sql/AFSCJAVB.pls
sqlplus apps/<apps pw> $FND_TOP/patch/115/sql/AFSCJAV8.pls

4. Validate that FND_WEB_SEC the package is valid.

select OBJECT_NAME,OBJECT_TYPE,STATUS from all_objects where OBJECT_NAME='FND_WEB_SEC';


5. Retest the issue. 


Solution:2  Check your tablespace size, Might be full.

*********************************************************************************

Rename Datafiles in Oracle ASM RAC Database

I prepared below steps one by one how can rename the datafiles in ASM database with RAC environment. Below are the steps is implemented in production environment.

\*-------OLD FILES LOCATION--------*/
+PRODDATA2/prod/datafiles/a_media220.dbf => +PRODDATA2/prod/DATAFILE/APPS_TS_MEDIA.271.909047637

\*-------FILES LOCATIONS WITH NEW NAMES ------*/
+PRODDATA2/prod/datafiles/a_media231.dbf

                                  \*---------ACTION PLAN------------*/

1. SQL>Alter database datafile '+PRODDATA2/prod/datafiles/a_media220.dbf' offline;

2. RMAN>copy datafile '+PRODDATA2/prod/datafiles/a_media220.dbf' to '+PRODDATA2/prod/datafiles/a_media231.dbf';

Go to asmcmd and verify the datafile

3. SQL>Alter Database rename file '+PRODDATA2/prod/datafiles/a_media220.dbf' to '+PRODDATA2/prod/datafiles/a_media231.dbf';

4. RMAN>switch Datafile '+PRODDATA2/prod/datafiles/a_media231.dbf' to copy;

5. SQL>recover datafile '+PRODDATA2/prod/datafiles/a_media231.dbf';

6. SQL>Alter database datafile '+PRODDATA2/prod/datafiles/a_media231.dbf' online;

7. SQL>select * from dba_data_files where file_name='+PRODDATA2/prod/datafiles/a_media231.dbf';

*********************************************************************************
Note: Make sure the OLD file name before removing.

7. Remove OLD file from +PRODDATA2 Group.
Connect with Grid user in ASM to perform below activity.
ASMCMD> ls -l      -----> Check the file which exits in ASM
ASMCMD> pwd
+PRODDATA2/prod/datafiles
ASMCMD> rm a_media220.dbf              /*.... Remove OLD datafiles...*/
ASMCMD> ls

8. Bounced the RAC Database if it required.

$srvctl stop database -d PROD
*********************************************************************************

Oracle RAC

Enable License Product from Licensed to shared in EBS R12

Please find the step by step process how to change the product License from Licensed to Shared.

Step: 1
  
First connect to sqlplus by apps schema to check the current status of the product.
$sqlplus apps/apps

SQL>col a.application_name for a40
col a.application_short_name for a4
col b.status for a1
SELECT a.application_name,
a.application_id,
application_short_name,
DECODE(b.status,'I','I',
DECODE(b.status,'S','S',
DECODE(b.status,'N','N',b.status)))
FROM fnd_application_vl a, fnd_product_installations b
WHERE a.application_id = b.application_id and application_short_name='INV'
ORDER BY a.application_id;

Output:

Application_Id   Application_Name     Application_Short_Name     Status
    401                          Inventory                        INV                                 I               

Solution:SQL> update FND_PRODUCT_INSTALLATIONS
  2  set STATUS = 'S'
  3  where APPLICATION_ID=401;

1 row updated.

SQL> commit;
Commit complete.

Step: 3

SQL>col a.application_name for a40
col a.application_short_name for a4
col b.status for a1
SELECT a.application_name,
a.application_id,
application_short_name,
DECODE(b.status,'I','I',
DECODE(b.status,'S','S',
DECODE(b.status,'N','N',b.status)))
FROM fnd_application_vl a, fnd_product_installations b
WHERE a.application_id = b.application_id and application_short_name='INV'
ORDER BY a.application_id;

Outut:-
Application_Id Application_Name, Application_Short_Name,     Status
    401    Inventory        INV            S

Once done the above.Check the updated status on the application level.

Useful Metalink Note ID's

Useful Metalink Note ID's

Useful Metalink Note ID's

==========================

Below are the metalink (support.oracle.com) note id's usefull for DBA's.

Please note to access them you need to have support.oracle.com login account.

Physical Standby

----------------

Note:180031.1 Creating a Data Guard physical standby

Note:214071.1 Creating a Data Guard physical standby with Data Guard Manager

Note:232649.1 Configuring gap resolution

Note:232240.1 Performing a switchover

Note:227196.1 Performing a failover

Note:187242.1 Applying Patchsets with Physical Standby in Place

Logical Standby

--------------

Note:186150.1 Creating a logical standby

Note:214071.1 Creating a logical standby with Data Guard Manager

Note:232240.1 Performing a switchover

Note:227196.1 Performing a failover

Note:233261.1 Tuning Log Apply Services

Note:215020.1 Troubleshooting Logical Standbys

Note:210989.1 Applying Patchsets with Logical Standby in Place

Note:233519.1 Known Issues with Logical Standby

Dataguard General Information

-----------------------------

Note:205637.1 Configuring Transparent Application Failover with Data Guard

Note:233509.1 Data Guard Frequently Asked Questions

Note:225633.1 Using SSH with 9i Data Guard

Note:233425.1 Top Data Guard Bugs

Note:219344.1 Usage, Benefits and Limitations of Standby RedoLogs

Note:201669.1 Setup and maintenance of Data Guard Broker using DGMGRL

Note:203326.1 Data Guard 9i Log Transportation on RAC

Note:239100.1 Data Guard Protection Modes Explained

Dataguard Configuration Best Practices

--------------------------------------

Note:240874.1 Primary Site and Network Configuration Best Practices

Note:240875.1 9i Media Recovery Best Practices

RMAN and Backup & Restore

-------------------------

60545.1 How to Extract Controlfiles, Datafiles, and Archived Logs from RMAN Backupsets

10gR2 Setup Installation, ASM,CRS, RAC , Troubleshooting

---------------------------------------------------------

471165.1 Additional steps to install 10gR2 RAC on IBM zSeries Based Linux (SLES10)

407086.1 USING CLONING IN CRS/RAC WINDOWS ENVIRONMENTS TO ADD A NODE

414163.1 10gR2 RAC Install issues on Oracle EL5 or RHEL5 or SLES10 (VIPCA Failures)

467753.1 Veritas clusterware 5.0 not recognized by Oracle due to the fact that Veritas

467176.1 RAC: Installing RDBMS Oracle Home Hangs The Oui

466975.1 Step to remove node from Cluster when the node crashes due to OS or H/w

330358.1 CRS 10g R2 Diagnostic Collection Guide

401132.1 How to install Oracle Clusterware with shared storage on block devices

392207.1 CSSD Startup fails with NSerr (12532,12560) transport:(502,0,0) during Install

333166.1 CSSD Startup Fails with NSerr (12546,12560) transport:(516,0,0) During install

330929.1 CRS Stack Fails to Start After Reboot ORA-29702 CRS-0184

463255.1 Enable trace for gsd issues on 10gR2 RAC

338924.1 CLUVFY Fails With Error: Could not find a suitable set of interfaces for VIPs

462616.1 Reconfiguring the CSS disktimeout of 10gR2 Clusterware for Proper LUN Failover

461884.1 How To Disable Fatal Mode Oprocd On HP-UX Itanium 10gR2

404474.1 Status of Certification of Oracle Clusterware with HACMP 5.3 & 5.4

329530.1 Using Redhat Global File System (GFS) as shared storage for RAC

458324.1 Increased 'Log File Sync' waits in 10gR2

341214.1 How To clean up after a Failed (or successful) Oracle Clusterware Installation

454638.1 srvctl command failed - An unexpected exception has been detected in native

276434.1 Modifying the VIP or VIP Hostname of a 10g Oracle Clusterware Node

383123.1 PRKP-1001 CRS-215 srvctl Can not Start 2nd Instance

358620.1 How To Recreate Voting And OCR Disk In 10gR1/2 RAC

200346.1 RAC: Frequently Asked Questions

220970.1 RAC: Frequently Asked Questions

269320.1 Removing a Node from a 10g RAC Cluster

430266.1 How to install 10gR2 and 9iR2 on the same node with different UDLM requirement

283684.1 How to Change Interconnect/Public Interface IP Subnet in a 10g Cluster

391790.1 Unable To Connect To Cluster Manager Ora-29701

294430.1 CSS Timeout Computation in RAC 10g (10g Release 1 and 10g Release 2)

316583.1 VIPCA FAILS COMPLAINING THAT INTERFACE IS NOT PUBLIC

416868.1 CDMP DIRECTORIES AND TRW FILES ON RAC

414177.1 Executing root.sh errors with "Failed To Upg Oracle Cluster Registry Config

390483.1 DRM - Dynamic Resource management

390880.1 OCR Corruption after Adding/Removing voting disk to a cluster when CRS stack

309542.1 How to start/stop the 10g CRS ClusterWare

396643.1 CVU HAS INCORRECT ORA_CRS_HOME VARIABLE AFTER APPLYING CRS BUNDLE II

387205.1 The 10.1.0.4 DB Cannot Start With 10.2.0.2.0 CRS And ASM

270512.1 Adding a Node to a 10g RAC Cluster

395156.1 Startup (mount) of 2nd RAC instance fails with ORA-00600 [kccsbck_first]

363777.1 How to Completely Remove a Service so that its Service_id Can Be Reused

391112.1 Database Resource Manager Spins Lmon To 100% Of Cpu

365530.1 Permissions not set correctly after 10gR2 installation

357808.1 Diagnosability for CRS / EVM / RACG

284752.1 10g RAC: Steps To Increase CSS Misscount, Reboottime and Disktimeout

332180.1 ASMCMD - ASM command line utility

371434.1 Using Openfiler iSCSI with an Oracle database

338047.1 cluvfy ERROR: Unable to retrieve database release version

183408.1 Raw Devices and Cluster Filesystems With Real Application Clusters

367564.1 Server Reboots When Rolling Upgrading CRS(10gr1 -> 10gr2)

358545.1 Root.sh is failing with CORE dumps, during CRS installation

343092.1 How to setup Linux md devices for CRS and ASM

295871.1 How to verify if CRS install is Valid

331934.1 RAC Single Instance (ASM) startup fails with ORA-27300/ORA-27301/ORA-27302

341974.1 10gR2 RAC Scheduling and Process Prioritization

341971.1 10gR2 RAC GES Statistics

341969.1 10gR2 RAC OS Best Practices

341965.1 10gR2 RAC Reference

341963.1 10gR2 RAC Best Practices

313540.1 Manually running cvu to verify stages during a CRS/RAC installation

331168.1 Oracle Clusterware consolidated logging in 10gR2

339710.1 Abnormal Program Termination When Installing 10gR2 on RHAS 4.0

339383.1 CSSD FAILURE DOES NOT REBOOT THE NODE

337937.1 Step By Step - 10gR2 RAC with ASM install on Linux(x86) - Demo

280209.1 10g RAC Performance Best Practices

Real Application Clusters(RAC)

-----------------------------

181503.1 Real Application Clusters Whitepapers (OTN)

280209.1 10g RAC Performance Best Practices (INTERNAL ONLY)

302806.1 IBM General Parallel File System (GPFS) and Oracle RAC on AIX 5L and IBM eServer pSeries

270512.1 Adding a Node to a 10g RAC Cluster

137288.1 Manual Database Creation in Oracle9i (Single Instance and RAC)

292776.1 10g RAC Lessons Learned

280216.1 10g RAC Reference (INTERNAL ONLY)

269320.1 Removing a Node from a 10g RAC Cluster

226561.1 9iRAC Tuning Best Practices (INTERNAL ONLY)

220178.1 Installing and setting up ocfs on Linux - Basic Guide

208375.1 How To Convert A Single Instance Database To RAC In A Cluster File System Configuration

255359.1 Automatic Storage Management (ASM) and Oracle Cluster File System (OCFS) in Oracle10g

341963.1 10gR2 RAC Best Practices (INTERNAL ONLY)

273015.1 Migrating to RAC using Data Guard

329530.1 Using Redhat Global File System (GFS) as shared storage for RAC

270901.1 How to Dynamically Add a New Node to an Existing 9.2.0 RAC Cluster

203326.1 Data Guard 9i Log Transportation on RAC

169539.1 A Short Description of HA Options Available in 9i

160120.1 Oracle Real Application Clusters on Sun Cluster v3

226569.1 9iRAC Most Common Performance Problem Areas (INTERNAL ONLY)

251578.1 Step-By-Step Upgrade of Oracle Cluster File System (OCFS v1) on Linux

247135.1 How to Implement Load Balancing With RAC Configured System Using JDBC

139436.1 Understanding 9i Real Application Clusters Cache Fusion

285358.1 Creating a Logical Standby from a RAC Primary Using a Hot Backup

222288.1 9i Rel 2 RAC Running on IBM’s General Parallel File System

226567.1 9iRAC Related Init.ora Parameters (INTERNAL ONLY)

210889.1 RAC Installation with a NetApp Filer in Red Hat Linux Environment

341965.1 10gR2 RAC Reference (INTERNAL ONLY)

341969.1 10gR2 RAC OS Best Practices (INTERNAL ONLY)

226566.1 9iRAC Related Latches (INTERNAL ONLY)

220970.1 RAC: Frequently Asked Questions

268202.1 Dynamic node addition in a Linux cluster

285455.1 HOW TO MAKE AN EXCLUSIVE INSTANCE AVAILABLE ON MULTIPLE CLUSTER NODES.

332257.1 Using Oracle Clusterware with Vendor Clusterware FAQ

245079.1 Steps to clone a 11i RAC environment to a non-RAC environment

235158.1 How To Enable/Disbale Archive Log Mode on Oracle9i Real Application Cluster

210022.1 How To Add A New Instance To The Existing Two Nodes RAC Database Manually

317516.1 Adding and Deleting a Cluster Node on 10gR2 / Linux

271685.1 How to Run Autoconfig for RAC Environment on Apps Tier Only

278816.1 How to Setup Parallel Concurrent Processing using Shared APPL_TOP for RAC Environment

334459.1 How to change hostname in RAC environment

250378.1 Migrating Applications 11i to use Oracle9i RAC (Real Application Clusters).

295998.1 How to solve corruptions on OCFS file system

345081.1 How to Rename a RAC Database in a 10g Real Application Clusters Environment

312051.1 How To Remove Ocfs From Linux Box.

EXPORT / IMPORT

---------------

Note 230627.1 - 9i Export/Import Process for Oracle Applications Release 11i

Note 331221.1 - 10g Export/Import Process for Oracle Applications Release 11i

Note 362205.1 - 10g Release 2 Export/Import Process for Oracle Applications Release 11i

Note 277650.1 - How to Use Export and Import when Transferring Data Across Platforms or Acros...

Note 243304.1 - 10g: Transportable Tablespaces Across Different Platforms

Note 341733.1 - Export/Import DataPump Parameters INCLUDE and EXCLUDE - How to Load and Unload..

RDBMS and E-Business Suite Installation and Configuration

---------------------------------------------------------

118218.1 11i. Installing a Digital Cerificate on both the Server and Client.

252217.1 Requirements for Installing Oracle 9iR2 on RHEL3

146469.1 Installation & Configuration of Oracle Login server & Portal3i

146468.1 Installation of Oracle9i Application Server(9iAS)

152775.1 XML gateway installation

165700.1 Multiple Jserv configuration

207159.1 Documentation of 9iAS

210514.1 Express Server WebIV Note numbers

170931.1 Notes on Motif troubleshooting

177610.1 Oracle Forms in Applications FAQ

258021.1 How to monitor the progress of a materialized view refresh (MVIEW)

330250.1 Tips & Tricks To Make Apache Work With Jserv

139684.1 Oracle Applications Current Patchset Comparison Utility - patchsets.sh

236469.1 Using Distributed AD in Applications Release 11.5.

96630.1 Cash Management Overview

233428.1 Sharing the Application Tier File System in Oracle Applications 11i

243880.1 Shared APPL_TOP FAQ

330250.1 Tips & Tricks To Make Apache Work With Jserv

241370.1 Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment

209721.1 How to Change the Port Number on one Machine, When we Use Multiple Collaboration Suite Tiers

177377.1 How to change passwords in Portal (Database and lightweight user passwords)

304748.1 Internal: E-Business Suite 11i with Database FAQ

166213.1 SPFILE internals ** INTERNAL ONLY **

216208.1 Oracle9i Application Server (9iAS) with Oracle E-Business Suite Release

UPGRADES

--------

125767.1 Upgrading Devloper6i with Oracle Applications 11i

216550.1 RDBMS upgrade to 9.2.0

161779.1 Upgradation of HTTP Server

212005.1 Upgrade Oracle Applications to 11.5.8

139863.1 Self Servie Framework Upgrade

112867.1 Express Server & OFA upgrade

124606.1 Jinitiator upgrade

130091.1 JDK upgrade to 1.3

130091.1 Upgrading Oracle Applications 11i to use JDK 1.3

144069.1 Upgrading to Workflow 2.6 with Oracle Applications 11i

159657.1 Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9i

CLONING

---------

216664.1 FAQ: Cloning Oracle Applications Release 11i

230672.1 Cloning Oracle Applications Release 11i with Rapid Clone

135792.1 Cloning Oracle Applications Release 11i

Discoverer

-------------

139516.1 Discoverer 4i with Oracle Applications 11i

257798.1 Discoverer 10g (9.0.4) with Oracle Applications 11i

139516.1 Installation of Discoverer 4i

AutoConfig

-----------

165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i

218089.1 Autoconfig FAQ

Frequently Asked Questions

--------------------------

68993.1 Concurrent Managers on NT

1013526.102 Changing and Resetting Release 11 Applications Passwords

130608.1 ADPATCH BASICS

74924.1 ADI (Applications Desktop Integrator) Installation

61552.1 DIAGNOSING DATABASE HANGING ISSUES

114226.1 How to Set Up Apache and JSERV w/ Oracle XSQL, JSP, and Developer

146469.1 Installing and Configuring Oracle Login Server and Oracle Portal 3i with Oracle Applications 11i

146468.1 Installing Oracle9i Application Server 1.0.2.2.2 with Oracle Applications 11i

62463.1 Detailed Guide on How the Intelligent Agent Works

104452.1 Troubleshooting (Concurrent Manager Unix specific)

122662.1 How to change the hostname or domainname of your portal

231286.1 Configuring the Oracle Workflow 2.6 Java-based Notification Mailer with Oracle Applications 11i

230688.1 Basic ApacheJServ Troubleshooting with IsItWorking.class

204015.1 Export/Import Process for Oracle Applications Release 11i Database Instances Using Oracle8i EE

158818.1 Migrating the Workflow Mailer to the APPLMGR Account

185431.1 Troubleshooting Oracle Applications Manager OAM 2.0 for 11i

177089.1 OAM11i Standalone Mode Setup and Configuration

172174.1 WF 2.6: Oracle Workflow Notification Mailer Architecture in Release 11i

166021.1 Oracle Applications Manager 11i - Pre-requisite Patches

166115.1 Oracle Applications Manager 11i integrated with Oracle Applications 11i

165041.1 Generic Service Management Functionality

204090.1 Generic Service Management Configuration using Applications Context Files

139863.1 Configuring and Troubleshooting the Self Service Framework with Oracle Applications (latest version)

187735.1 Workflow FAQ - All Versions

166830.1 Setting up Real Application Cluster (RAC) environment on Linux - Single node

158868.1 Step by Step, Oracle 9iAS Installation Process

123243.1 Scheduling Web Reports Via Oracle Reports Server CGI

165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i

IMP Note ID's

--------------

233428.1 Sharing the Application Tier File System in Oracle Applications 11i

243880.1 Shared APPL_TOP FAQ

313418.1 Using Discoverer 10.1.2 with the E-Business Suite

287176.1 DMZ Configuration with Oracle E-Business Suite 11i

241015.1 Configuring Applications 11i for use with Reverse Proxy and DMZ

1025288.6 How to Diagnose and Resolve ORA-01650,ORA-01652,ORA-01653,ORA-01654,ORA-01688 :

1035935.6 Example of How To Resize the Online Redo Logfiles

133062.1 ORA-25150 Altering Of Extent Parameters Not Permitted While Applying Patch

139516.1 Discoveaer 4i with Oracle Applications 11i

15476.1 FAQ about Detecting and Resolving Locking Conflicts

177240.1 Supported 11i Login URLs - using Dev60cgi / f60cgi to Access Applications is Unsupported

207959.1 All About Security: User, Privilege, Role, SYSDBA, O/S Authentication, Audit, Encryption, OLS

216205.1 Database Initialization Parameters for Oracle Applications 11i

216550.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)

218089.1 Autoconfig FAQ

230672.1 Cloning Oracle Applications Release 11i with Rapid Clone

233428.1 Sharing the Application Tier File System in Oracle Applications 11i

236247.1 Transferring Archive Logs to the Standby Database Disconnects

242941.1 How To Troubleshoot Java-based Workflow Notification Mailer In 11.5.9 and OWF.G

260676.1 When Applying Patch 2644375 Worker Is Prompting For Parameter 5 In The Worker Log

277710.1 Ora-00600: Internal Error Code, Arguments: [1236], [], ... Ora-600

282234.1 Error "java.lang.NullPointerException" In Step 3 Of Configuring WF Java Mailer In Applications 11i

268085.1 Configuring the Oracle Workflow 2.6/11i.OWF.H Java-based Notification Mailer with Oracle Applications 11i

164871.1 Configuring the Workflow Notification Mailer in Oracle Applications Manager 11i

172174.1 WF 2.6: Oracle Workflow Notification Mailer Architecture in Release 11i

ERROR: RC-50013: Fatal: Failed to instantiate driver /u01/appl/trn/apps/tech_st/10.1.2/appsutil/driver/regclone.drv

$adcfgclone.pl appsTier 


ERROR:

The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
 <filename>  <phase>  <return code where appropriate>

[APPLY PHASE]

AutoConfig could not successfully execute the following scripts:
Directory: /u01/appl/trn/apps/tech_st/10.1.3/perl/bin/perl -I /u01/appl/trn/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /u01/appl/trn/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /u01/appl/trn/apps/apps_st/appl/au/12.0.0/perl -I /u01/appl/trn/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi /u01/appl/trn/apps/tech_st/10.1.2/appsutil/clone
      ouicli.pl               INSTE8_APPLY       -1

AutoConfig is exiting with status 1

RC-50013: Fatal: Instantiate driver did not complete successfully.
/u01/appl/trn/apps/tech_st/10.1.2/appsutil/driver/regclone.drv

Solutions:

export ORACLE_HOME=/u01/app/oracle/oas_home/10.1.3

export PERL5LIB=$ORACLE_HOME/perl/lib/5.8.3:$ORACLE_HOME/perl/lib/site_perl/5.8.3:

export PERL5LIB=$PERL5LIB:$ORACLE_HOME/perl/lib/site_perl/5.8.3/i686-linux-thread-multi:$PERL5LIB

export PATH=$ORACLE_HOME/perl/bin:$PATH

 

Now again you can execute same above command.