Oracle Apps DBA

Managing an Automatic Storage Management Instance:

2011-02-22T14:57:00.004+05:30

Managing an Automatic Storage Management Instance:
Startup and shutdown ASM Instance:

Starting Up ASM Instance:

An ASM instance is managed in much the same way as a database instance, with a few exceptions. The major difference is that an ASM instance is never opened like a regular Oracle instance is opened, only mounted; therefore, we can issue the STARTUP NOMOUNT; command to start just the ASM instance's memory processes, and then finish mounting the database with the ALTER DATABASE MOUNT; command. We can also open the ASM instance immediately by issuing the STARTUP MOUNT; command

$> export ORACLE_SID=+ASM
$> sqlplus "sys as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Dec 13 16:58:17 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup mount;
ASM instance started
Total System Global Area 100663296 bytes
Fixed Size 787648 bytes
Variable Size 99875648 bytes
Database Buffers 0 bytes
Redo Buffers 0 bytes
ASM diskgroups mounted.

Shutdown ASM Instance:

To shut down this ASM instance, Set the ORACLE_SID environment variable and then simply issue the SHUTDOWN IMMEDIATE; command:
$> export ORACLE_SID=+ASM
$> sqlplus "sys as sysdba"
SQL> Connected.
SQL> shutdown immediate;
ASM diskgroups dismounted
ASM instance shutdown
SQL>

Implications of Shutting Down an Active ASM Instance: When an ASM instance is shut down, it is important to be aware of the implications for any regular Oracle database instance that is using ASM files stored on that ASM instance. The ASM files will not be accessible to those regular Oracle databases until the ASM instance is restarted.

Create Disk Group:
NORMAL REDUNDANCY: (Two – Way Mirroring)
create diskgroup +DATA normal redundancy
2 failgroup f1 disk '/dev/raw/raw5' name disk5
3 failgroup f2 disk '/dev/raw/raw6' name disk6;
HIGH REDUNDANCY: (Three – Way Mirroring)
create diskgroup +DATA normal redundancy
2 failgroup f1 disk '/dev/raw/raw5' name disk5
3 failgroup f2 disk '/dev/raw/raw6' name disk6;
4 failgroup f2 disk '/dev/raw/raw6' name disk7;

EXTERNAL REDUNDANCY: (If we want no mirroring by ASM)
CREATE DISKGROUP +DATA EXTERNAL REDUNDANCY DISK '/dev/raw/raw1','/dev/raw/raw2';

Adding Disks into Disk Group:

alter diskgroup +DATA add disk '/dev/raw/raw7' name disk7;

Dropping Disk

alter diskgroup +DATA drop disk disk7;
Note:
When we drop the last disk from the FAILGROUPS, the FAILGROUP automatically drops.

Resize Disk Group:

alter diskgroup +DATA resize disk raw5 size 800M;
Mounting and Dismounting Disk Groups
Disk groups that are specified in the ASM_DISKGROUPS initialization parameter are mounted automatically at ASM instance startup. We can do this manually using below.

Mounting Disk Group:

ALTER DISKGROUP +DATA MOUNT;

Dismounting Disk Group:

ALTER DISKGROUP +DATA DISMOUNT;

Create Tablespace with ASM:
Create tablespace TBS_NAME datafile ‘+DATA’ Size 1024m;

Viewing ASM Instance Information Via SQL Queries:

There are several dynamic and data dictionary views available to view an ASM configuration from within the ASM instance itself:

V$ASM_ALIAS - Shows every alias for every disk group mounted by the ASM instance
V$ASM_CLIENT - Shows which database instance(s) are using any ASM disk groups that are being mounted by this ASM instance
V$ASM_DISK - Lists each disk discovered by the ASM instance, including disks that are not part of any ASM disk group
V$ASM_DISKGROUP - Describes information about ASM disk groups mounted by the ASM instance
V$ASM_FILE - Lists each ASM file in every ASM disk group mounted by the ASM instance
V$ASM_OPERATION - Like its counterpart, V$SESSION_LONGOPS, it shows each long-running ASM operation in the ASM instance
V$ASM_TEMPLATE - Lists each template present in every ASM disk group mounted by the ASM instance

We can also able to query the following dynamic views against database instance to view the related ASM storage components of that instance:

V$ASM_DISKGROUP - Shows one row per each ASM disk group that's mounted by the local ASM instance
V$ASM_DISK - Displays one row per each disk in each ASM disk group that are in use by the database instance
V$ASM_CLIENT - Lists one row per each ASM instance for which the database instance has any open ASM files

The benefits of ASM:
• Provides automatic load balancing over all the available disks, thus reducing hot spots in the file system
• Prevents fragmentation of disks, so you don't need to manually relocate data to tune I/O performance
• Adding disks is straight forward - ASM automatically performs online disk reorganization when you add or remove storage
• Uses redundancy features available in intelligent storage arrays
• The storage system can store all types of database files
• Using disk group makes configuration easier, as files are placed into disk groups
• ASM provides stripping and mirroring
• ASM and non-ASM oracle files can coexist

ASM Operations

2011-02-22T14:34:00.003+05:30

ASM Operations

1. Instance name
select instance_name from v$instance;

2. Create disk group

create diskgroup +DATA normal redundancy
2 failgroup f1 disk '/dev/raw/raw5' name disk5
3 failgroup f2 disk '/dev/raw/raw6' name disk6;
4 failgroup f2 disk '/dev/raw/raw6' name disk7;
CREATE DISKGROUP +DATA EXTERNAL REDUNDANCY DISK '/dev/raw/raw1','/dev/raw/raw2';
Note: force is used if disk has been in a previous diskgroup, external redundancy uses third party mirroring i.e SAN

3. Add disks to a group alter diskgroup +DATA add disk

'/dev/raw/raw7' name disk7;
/dev/raw/raw8' name disk8;

4. Remove disks from a group

alter diskgroup diskgrpA drop disk disk6;

5. Remove disk group

drop diskgroup diskgrpA including contents

6. Resizing disk group

alter diskgroup diskgrpA resize disk 'disk3' size 500M;

7. Undo remove disk group

alter database diskgrpA undrop disks;

8. Display diskgroup info
select name, group_number, name, type, state, total_mb, free_mb from v$asm_diskgroup;
select group_number, disk_number, name, failgroup, create_date, path, total_mb from v$asm_disk;
select group_number, operation, state, power, actual, sofar, est_work, est_rate, est_minutes from v$asm_operation;

9. Rebalance a diskgroup
(after disk failure and disk has been replaced)
alter diskgroup diskgrpA rebalance power 8;
Note: to speed up rebalancing increase the level upto 11, remember that this will also decrease performance, you can also use the wait parameter this will hold the commandline until it is finished.

10. Dismount or mount a diskgroup
alter diskgroup diskgrpA dismount;
alter diskgroup diskgrpA mount;

11. Check a diskgroups integrity
alter diskgroup diskgrpA check all;

12. Diskgroup Directory
alter diskgroup diskgrpA add directory '+diskgrpA/dir1'
Note: this is required if you use aliases when creating databse files
i.e '+diskgrpA/dir/control_file1'

13. Adding and drop aliases

alter diskgroup diskgrpA add alias '+diskgrpA/dir/second.dbf' for '+diskgrpB/datafile/table.763.1';
alter diskgroup diskgrpA drop alias '+diskgrpA/dir/second.dbf'

14. Drop files from a diskgroup
alter diskgroup diskgrpA drop file '+diskgrpA/payroll/payroll.dbf';

15. Using ASM Disks
Examples of using ASM disks
create tablespace test datafile ‘+diskgrpA’ size 100m;
alter tablespace test add datafile ‘+diskgrpA’ size 100m;
alter database add logfile group 4 ‘+dg_log1’,’+dg_log2’ size 100m;
alter system set log_archive_dest_1=’location=+dg_arch1’;
alter system set db_recovery_file_dest=’+dg_flash’;

16. Display performance.
select path, reads, writes, read_time, write_time,
read_time/decode(reads,0,1,reads) "AVGRDTIME",
write_time/decode(writes,0,1,writes) "AVGWRTIME"
from v$asm_disk_stat;

Migrate Non-ASM to ASM

2011-02-22T14:23:00.003+05:30

Creating ASM Instance

1. Check CSS must be running before any ASM Instance
Check CSS Running or Not?
cd $ORACLE_HOME/bin
crsctl check css
2. If its not running, you should configure CSS process by running $ORACLE_HOME/bin/localconfig script:
login as a root
$ORACLE_HOME/bin/localconfig add
Sample Output:

/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 90 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.

CSS is active on these nodes.
DEV1
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)

# Default asm_diskstring values for supported platforms:
# Solaris (32/64 bit) /dev/rdsk/*
# Windows NT/XP \\.\orcldisk*
# Linux (32/64 bit) /dev/raw/*
# HPUX /dev/rdsk/*
# HPUX(Tru 64) /dev/rdisk/*
# AIX /dev/rhdisk/*

ASM_DISKSTRING=/dev/raw
INSTANCE_TYPE='ASM'
LARGE_POOL_SIZE=40M
REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
USER_DUMP_DEST=$ORACLE_HOME/admin/+ASM/udump
BACKGROUND_DUMP_DEST=$ORACLE_HOME/admin/+ASM/bdump
CORE_DUMP_DEST=$ORACLE_HOME/admin/+ASM/cdump

3. Create the init+ASM.ora file in $ORACLE_HOME/dbs

# Default asm_diskstring values for supported platforms:
# Solaris (32/64 bit) /dev/rdsk/*
# Windows NT/XP \\.\orcldisk*
# Linux (32/64 bit) /dev/raw/*
# HPUX /dev/rdsk/*
# HPUX(Tru 64) /dev/rdisk/*
# AIX /dev/rhdisk/*

ASM_DISKSTRING=/dev/raw
INSTANCE_TYPE='ASM'
LARGE_POOL_SIZE=40M
REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
USER_DUMP_DEST=$ORACLE_HOME/admin/+ASM/udump
BACKGROUND_DUMP_DEST=$ORACLE_HOME/admin/+ASM/bdump
CORE_DUMP_DEST=$ORACLE_HOME/admin/+ASM/cdump

4. Creating ADMIN directories

set ASM instance ORACLE_HOME

mkdir -p $ORACLE_HOME/admin/+ASM/bdump
mkdir -p $ORACLE_HOME/admin/+ASM/cdump
mkdir -p $ORACLE_HOME/admin/+ASM/hdump
mkdir -p $ORACLE_HOME/admin/+ASM/pfile
mkdir -p $ORACLE_HOME/admin/+ASM/udump

mkdir $ORACLE_HOME/dbs

5. Starting the ASM Instance

Starting ASM Instance

# su - oracle
$ ORACLE_SID=+ASM; export ORACLE_SID
$ sqlplus "/ as sysdba"
SQL> startup

6. Create SPFILE from PFILE

create spfile='+ASM' from pfile;

7. For Unix platform, put an entry in the oratab file for the ASM intance

ORATAB

+ASM::Y

You may get the following error on first start:

ORA-15110: no diskgroups mounted
This error can be safely ignored, when creating a new diskgroup, the diskgroup name will be
added automatically to the asm_diskgroups parameter and you will not get this error again.

Create ASM Disk group

SQL> shutdown
ASM instance shutdown
SQL> startup
ASM instance started
SQL> alter system set asm_diskstring = '/dev/raw/raw1', '/dev/raw/raw2', '/dev/raw/raw3', '/dev/raw/raw4';
System altered.

SQL> alter system set asm_diskgroups = 'DATA';
System altered.

To get started, create 2 disk groups - one for data and one for recovery files. Here is an example:

CREATE DISKGROUP data EXTERNAL REDUNDANCY DISK '/dev/d1', '/dev/d2', '/dev/d3', ....;
CREATE DISKGROUP recover EXTERNAL REDUNDANCY DISK '/dev/d10', '/dev/d11', '/dev/d12', ....;

Here is an example how you can enable automatic file management with such a setup:

ALTER SYSTEM SET db_create_file_dest = '+DATA' SCOPE=SPFILE;
ALTER SYSTEM SET db_recovery_file_dest = '+RECOVER' SCOPE=SPFILE;

Steps To Migrate/Move a Database From Non-ASM to ASM

1. Edit the pfile/spfile of DB to point the new control_file location on ASM
if your disk group name is '+DATA'
control_files='+DATA//control01.ctl'

2. Startup the database in nomount state
SQL> Startup nomount

3. From RMAN session, copy the control file from old location to new location
Restore the controlfile from old location to new location:

RMAN> CONNECT TARGET
RMAN> RESTORE CONTROLFILE FROM '/u01/TST/control01.ctl';
Here /u01/TST/control01.ctl is the old location of control file.

4. From SQL session, mount the database

SQL> ALTER DATABASE MOUNT;

5. Using RMAN, copy the datafile from NON-ASM to ASM

Copy the controlfile from Non-ASM to ASM:
RMAN>BACKUP AS COPY DATABASE FORMAT '+DATA';

run {
allocate channel dev1 type disk;
allocate channel dev2 type disk;
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE
FORMAT '+DISK' TAG 'ORA_ASM_MIGRATION;
}

Using RMAN, rename the datafile , using the following command
Rename the datafile using the following command:

RMAN> SWITCH DATABASE TO COPY
Switch tempfile and open database.

6. Switch tempfile and open database:

RMAN> run {
set newname for tempfile 1 to '+DATA';
set newname for tempfile 2 to '+DATA';
...
switch tempfile all;
}

RMAN> ALTER DATABASE OPEN;

7. Do the following maintenance

SQL> SELECT a.group#, b.member, a.status FROM v$log a, v$logfile b WHERE a.group#=b.group#;
SQL> ALTER DATABASE ADD LOGFILE MEMBER '+ASM_Disk_group' TO GROUP 1;
SQL> ALTER DATABASE ADD LOGFILE MEMBER '+ASM_Disk_group' TO GROUP 2;
SQL> ALTER DATABASE DROP LOGFILE MEMBER '';
SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> ALTER DATABASE DROP LOGFILE MEMBER '';
SQL> ALTER SYSTEM SWITCH LOGFILE;

How to Check if a Patch requires Downtime

2009-09-08T17:18:00.003+05:30

Solution

1. Download the particular patch file
2. Check the file ..\\etc\config\inventory
3. If the following entry is present
(instance_shutdown) true (/instance_shutdown)

then it requires downtime.

Kill Linux Process

2009-08-17T16:04:00.000+05:30

Kill -9 `ps –u applmgr –o “pid=”`

Find Workflow Notification Mailer

2009-08-13T18:00:00.002+05:30

SQL> SELECT email_address,name, nvl(WF_PREF.get_pref(name, 'MAILTYPE'),notification_preference)FROM wf_rolesWHERE name like upper('%xxx%');

SQL> select NOTIFICATION_ID,STATUS,MAIL_STATUS from WF_NOTIFICATIONS where TO_USER='UserName';

SQL> SELECT status,mail_status,MESSAGE_TYPE,MESSAGE_NAME,ITEM_KEY from WF_NOTIFICATIONS WHERE notification_id='2732013';

SQL> select mail_status,count(*) from WF_NOTIFICATIONS group by mail_status;

COLUMN CORRID FORMAT A55;
COLUMN STATE FORMAT A14;
SELECT CORRID,DECODE(STATE, 0, '0 = READY', 1, '1 = DELAYED', 2, '2 = PROCESSED', 3, '3 = EXCEPTION',TO_CHAR(STATE)) STATE, COUNT(*) COUNT
FROM WF_DEFERRED
GROUP BY CORRID, STATE;

SET LINES 150
COLUMN CORRID FORMAT A55;
COLUMN STATE FORMAT A14;
SELECT CORRID,DECODE(STATE, 0, '0 = READY', 1, '1 = DELAYED', 2, '2 = PROCESSED', 3, '3 =
EXCEPTION',TO_CHAR(STATE)) STATE, COUNT(*) COUNT
FROM WF_NOTIFICATION_OUT
GROUP BY CORRID, STATE;

COL COMPONENT_NAME FORMAT A60
COL COMPONENT_STATUS FORMAT A20
COL STARTUP_MODE FORMAT A20
SET LINES 120
SET PAGES 1000
SELECT COMPONENT_NAME, COMPONENT_STATUS, STARTUP_MODE FROM FND_SVC_COMPONENTS;

SET LINES 160
COL COMPONENT_NAME FORMAT A30
COL PARAMETER_NAME FORMAT A40
COL PARAMETER_VALUE FORMAT A40
SELECT A.COMPONENT_ID, A.COMPONENT_NAME, B.PARAMETER_ID, C.PARAMETER_NAME, B.PARAMETER_VALUE
FROM FND_SVC_COMPONENTS A, FND_SVC_COMP_PARAM_VALS B, FND_SVC_COMP_PARAMS_B C
WHERE A.COMPONENT_ID = B.COMPONENT_ID AND B.PARAMETER_ID = C.PARAMETER_ID
AND UPPER(A.COMPONENT_NAME) LIKE '%MAILER%'
ORDER BY A.COMPONENT_ID, A.COMPONENT_NAME, C.PARAMETER_NAME;

How to change Apps 11i form color change after cloning

2009-07-01T19:55:00.001+05:30

To differentiate dev/test from prod, we can change the form color by changing some profile options.

Profile option change to be done:

1. Set the Java Look and Feel profile option value to oracle. If you set it to generic, it will take the default values and you wont be able to set your own color.
2. Then set Java Color Scheme profile option value to any of the LOVs as per your choice.

Remember to set this at site level

NOTE: It won't get effect immediately, you have to log out from
application and again you have to relogin to view color change effect

Rolling Oracle Clusterware Upgrade 10.2.0.3 to 10.2.0.4

2009-06-24T17:17:00.011+05:30

1. Stop both DB nodes
2. Shut down all listeners
3. Log in as the root user Shutdown the CRS crsctl stop crs

Go to following location and check the current CRS version.
cd /CRS/app/10.2.0/bin
./crsctl query crs softwareversion
./crsctl query crs activeversion

Unzip 10.2.0.4 patchset 6810189
Run ./runInstaller

WelcomeScreen

choose the CRS_home and Click Next

selection the CRS_home will automatically select and upgrade the CRS software

Click Next

Click Next

Click Install

10.2.0.4 binaries automatically installed in all nodes. So please run the root102.sh in all the database nodes.

The following instructions are displayed on the Oracle Universal Installer screen:
To complete the installation of this patch set, perform the following tasks on each node:

Log in as the root user and enter the following command to shut down the Oracle Clusterware:
# CRS_home/bin/crsctl stop crs
Run the root102.sh script to automatically start the Oracle Clusterware on the patched node:
# CRS_home/install/root102.sh
Database Node 1

Please follow the same steps to rest of the all nodes.

The following instructions are displayed on the Oracle Universal Installer screen:
To complete the installation of this patch set, perform the following tasks on each node:

Log in as the root user and enter the following command to shut down the Oracle Clusterware:
# CRS_home/bin/crsctl stop crs
Run the root102.sh script to automatically start the Oracle Clusterware on the patched node:
# CRS_home/install/root102.sh

Database Node 2

After completing the above steps, please check the CRS version.
./crsctl query crs softwareversion
CRS software version on node [oradbtest1] is [10.2.0.4.0]
./crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.3.0]

Notifications Not Being Received After Autoconfig Is Run

2009-05-28T18:24:00.003+05:30

SolutionTo implement the solution, please execute the following steps:

1. Log into the Oracle Applications Manager.
2. Click on Site Map.
3. Click on Notification Mailer under Workflow.
4. Click on the Edit button for the active mailer.
5. Click Next to step 3 that lists the Inbound EMail Account and Outbound EMail Account.
6. Confirm that the servers names are correct with the IMAP and SMTP servers and change as needed.
7. Click Next and then Click on Finish.
8. Stop and re-start the workflow mailer services within OAM and test.
9. If the issue is resolved, please migrate the solution as appropriate to other environments.

Permanent solutions:

Autoconfig Overwriting The SMTP Server Name For The Java Mailer

[applmgr@test]$ cat UAT_test.xmlgrep s_smtphost

hostname oa_var= s_smtphost test hostname

[applmgr@test]$ cat UAT_test.xmlgrep s_smtpdomainname

domain oa_var=s_smtpdomainname doyen.com domain

1. Update the following parameters in context file on the Concurrent Manager Application Tier node under oa_smtp_server in OAM to the correct Outbound Server Name assigned to the Workflow Mailer.

Example

SMTP Server Host (s_smtphost)
hostname oa_var= s_smtphost mailtest hostname

Email Server Domain (s_smtpdomainname)
domain oa_var=s_smtpdomainname doyen.com domain

2. The next time autoconfig runs on the node it will contain correct setting.

Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i

2009-04-30T17:29:00.002+05:30

1. Download the JRE Plug-in interoperability patch - 6863618

2. Download the Sun JRE Plug-in -

1. jre-1_5_0_17-windows-i586-p.exe to j2se15017.exe

or

2. jre-6u12-windows-i586-p.exe

3. Rename the JRE Plug-in and Place it on Webserver

jre-1_5_0_17-windows-i586-p.exe

X means current updated version,

Example

jre-1_5_0_17-windows-i586-p.exe to j2se15017.exe

If you have more then one apps node, need to place all nodes.

4. Shutdown Apps tier

5. Place the JRE 5 Plug-in on the Web Application Tier

Use FTP or WINSCP Tool

Move the jre-1_5_0_17-windows-i586-p.exe to j2se15017.exe file to the web application tier and place it in all apps nodes

$COMMON_TOP/util/jinitiator

6. Enable Maintenance Mode

We have forms 18 patchset, so that i applied following patch for JRE upgrade, If you have less then forms patch 18, first you should upgrade forms 18 or later. If you have forms 19 or later please follow the metalink note id: 290807.1

Developer 6i Patchset 18 Users

Developer 6i Patchset 18 (6.0.8.27.x) users must apply the forms focus fix patches 7362389 and 5884875.

7. Apply Prerequisite Patche 7362389

Note: Just follow the patch readme.

8. Apply Prerequisite Patch 5884875

Note: Just follow the patch readme.

8. Apply JRE Interoperability Patch - 6863618 - Use adpatch

Apply the Patch Driver

If you are upgrading to the JRE native plug-in for the first time, please apply the interop patch using AutoPatch.

Multiple Application-Tier Web Server Nodes

If you have multiple web application tier server nodes, repeat the steps above to apply the patch driver in the JRE Interoperability Patch against all other web application tier server nodes.

9 . Run below script on command prompt

Run the txkSetPlugin.sh script from the //fnd/bin/ directory, against the web node of your middle tier, where is the directory in which you unzipped this patch.

Run the txkSetPlugin.sh Script

$txkSetPlugin.sh 15017
It will ask following input from you, please provide right path.

/u01/oracle/appltestAPPSORA.env
/u01/oracle/appltest/admin/DBA_oraappsdba.xml
Password for the APPS user in the database :apps

Example:
[applmgr@testoraapps bin]$ txkSetPlugin.sh 15017
/u01/oracle/testappl/fnd/11.5.0/bin

Starting interoperability upgrade script...

Sending logfile output to:
/u01/oracle/testappl/admin/log/txkSetPlugin.log
Using the context file:
/u01/oracle/testappl/admin/u01_oraappsu01.xml
Using APPLSYS file:
/u01/oracle/testappl/APPSu01_oraappsu01.env
Enter the password for the Oracle database APPS user [APPS] : apps

Using /u01/oracle/u01comn/util/java/1.5/jdk1.5.0_11/bin/java to execute java programs

Getting J2SE parameter values...

Copy oaj2se.exe to html dir...

Copying /u01/oracle/u01comn/util/jinitiator/j2se15017.exe to /u01/oracle/u01comn/html/oaj2se.exe ...

Backing up the Application Context File...

Backing up /u01/oracle/testappl/admin/u01_oraappsu01.xml to /u01/oracle/testappl/admin/u01_oraappsu01.xml.prej2se15017
Using APPSWEB file /u01/oracle/u01comn/html/bin/appsweb_u01_oraappsu01.cfg
Backing up the appsweb file...
Backing up /u01/oracle/u01comn/html/bin/appsweb_u01_oraappsu01.cfg to /u01/oracle/u01comn/html/bin/appsweb_u01_oraappsu01.cfg.prej2se15017
Updating XML context file with new parameters...
Updated Plug-in type to jdk
Updated JInitiator version name to 1.5.0_17
Updated JInitiator mimetype to 1.5.0_17
Updated JInitiator classid to CAFEEFAC-0015-0000-0017-ABCDEFFEDCBA
Updated J2SE mimetype to 1.5.0_17
Updated J2SE Classid to CAFEEFAC-0015-0000-0017-ABCDEFFEDCBA

The log file for this session is located at: /u01/oracle/testappl/admin/u01_oraappsu01/log/04280720/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using APPL_TOP location : /u01/oracle/testappl
Classpath : /u01/oracle/u01comn/util/java/1.5/jdk1.5.0_11/jre/lib/rt.jar:/u01/oracle/u01comn/util/java/1.5/jdk1.5.0_11/lib/dt.jar:/u01/oracle/u01comn/util/java/1.5/jdk1.5.0_11/lib/tools.jar:/u01/oracle/u01comn/java/appsborg2.zip:/u01/oracle/u01comn/java

Using Context file : /u01/oracle/testappl/admin/u01_oraappsu01.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring ABM_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
Upgrading j2se15017 for Oracle Workflow...
Oracle Workflow upgraded successfully...
Done

10. Disable Maintenance Mode

11. Startup your apps nodes

11. Login apps, first it will take time to download for JRE.

Reverting to a Previous JRE Plug-in/JInitiator Version

If you wish to revert back to previously installed version of JRE to be used in your Application, please re-install the required version by re-running the txkSetPlugin script with the appropriate parameters. This will automatically overwrite the JRE parameters in the configuration files.

To revert back to a version of JInitiator, you must also run the txkSetPlugin script with the appropriate parameters and not the old jinit.sh or jinit.cmd scripts that were used for JInitiator upgrades previously. Using JInitiator 1.3.1.28 as an example the command would be;

UNIX Users

$ txkSetPlugin.sh 13121

Reference:

Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
Doc ID: 290807.1

After Cloning DB Tier Service Name Shows PROD Name

2009-04-08T16:16:00.003+05:30

After Cloning DB Tier, Service Name shows like this. This wrong, So we need do the folloing steps.

Error Message:

sql > show parameter service

service_names string UAT, SYS$APPLSYS.WF_CONTROL.PROD.DOYENSYS.COM

Solutions:

Step 1: Bounce the Apps Tier.

Then Go to respective Directory.

/UAT/oracle/uatappl/fnd/11.5.0/patch/115/sql

$ ls -lrt wfctqrec.sql

-----wfctqrec.sql

step 2:
SQL> sqlplus apps/passwd

SQL> @wfctqrec.sql applsys passwd

Step 3: Bounce the DB and Listener in Both RAC Nodes

Setp 4: Start Both Nodes and Listener

Step 5: Now check the show parameter service, It shows

After finishing above tasks, its changed.

sql > show parameter service
service_names string UAT, SYS$APPLSYS.WF_CONTROL.UAT.DOYENSYS.COM

OR

sql > show parameter service
service_names string UAT

The listener failed to spawn the Service Manager process.

2009-04-01T18:32:00.003+05:30

Error:

Concurrent Manager Output Post Processor unable to UP

The following error shows the ICM.log

Could not contact Service Manager FNDSM_orauat2_UAT. The TNS alias could not be located, the listener process on orauat2 could not be contacted, or the listener failed to spawn the Service Manager process.

Process monitor session started : 01-APR-2009 05:39:38Could not contact Service Manager FNDSM_orauat2_UAT. The TNS alias could not be located, the listener process on orauat2 could not be contacted, or the listener failed to spawn the Service Manager process.

Cause:

Here my one of the db instance is down(UAT1), so apps listener is try to check the UAT1 instacne. Buit its not able to connect that database. so that it will throug like this error.

UAT=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=orauat1.doyensys.com)(POR1521)) (CONNECT_DATA=
(SERVICE_NAME=UAT)
(INSTANCE_NAME=UAT1)
)
)

UAT1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=orauat1.doyensys.com)(PORT1521)) (
CONNECT_DATA=
(SERVICE_NAME=UAT)
(INSTANCE_NAME=UAT1)
)
)

UAT1_FO=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=orauat1.doyensys.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=UAT) (INSTANCE_NAME=UAT1) ) )

UAT2= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=orauat2.doyensys.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=UAT) (INSTANCE_NAME=UAT2) ) )

Solutions

If its PCP enable node, please check the TNS entry.

So, Please chenge the instacne name UAT1 to UAT2. Then try to check the Concurrent Manager.

UAT= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=orauat2.doyensys.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=UAT) (INSTANCE_NAME=UAT2) ) )

UAT1= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=orauat2.doyensys.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=UAT) (INSTANCE_NAME=UAT2) ) )

UAT1_FO= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=orauat1.doyensys.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=UAT) (INSTANCE_NAME=UAT1) ) )

UAT2= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=orauat2.doyensys.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=UAT) (INSTANCE_NAME=UAT2)

Now, Ping the all the tns names
tnsping UAT
tnsping UAT2
tnsping FNDSM_orauat2.doyensys.com_DEV
tnsping FNDSM_orauat1.doyensys.com_DEV
tnsping FNDSM_orauat1_DEV

Moving Oracle DataBase Control files

2009-04-01T16:36:00.003+05:30

Change the Control file Location of current palce to another place.

Existing initTEST.ora file Location.

SQL>select name from v$controlfile;

/oracle/product/10.1.4/oradata/control01.ctl,
/oracle/product/10.1.4/oradata/control02.ctl,
/oracle/product/10.1.4/oradata/control03.ctl

Note:
Change the control file to following order to existing initTEST.ora file.
If you using spfile, just create the init file and change the controlfile patch and shutdown the database.

cd $ORACLE_HOME/dbs/initTEST.ora

/oracle/product/10.1.4/oradata/control01.ctl,
/oracle/product/10.1.4/oradata/controlfile/controlfile
/ctlbkp/oracle/controlfile/control03.ctl

1. Bounce the Database
2. Change the controlfile new path in inittest.ora
3. Now move all the controlfile form respective place to new place, use MV command.
4. Now startup the Database
5. SQL> show parameter control or put below sql query.
6. Again create the spfile from pfile.

SQL> select name from v$controlfile;

/oracle/product/10.1.4/oradata/control01.ctl
/oracle/product/10.1.4/oradata/controlfile/control02.ctl
/ctlbkp/oracle/controlfile/control03.ctl

How to Migrate Oracle 10.2 32bit to 10.2 64bit on Microsoft Windows

2009-03-27T11:13:00.003+05:30

Action Plan for Migrate.

1 Take a cold backup and export full db or important schema
2 Take a backup of 10g binaries (Oracle Home)
3 Take a control file backup using command
Alter database backup controlfile to trace;
4 Take a backup of init.ora file
5 Prepare the current oracle directory structure
6 Clone Prod to Prod (32 bit O/S)
7 Install 64 bit Win O/S
8 Create existing oracle directory structure
9 Install 10g (10.2.0.1 Base) oracle binaries(Software Only),Upgrade 10.2.0.4 If you use exp/imp install with database
10 Please follow the Scenario 1 or 2 or 3

Scenario 1:

Oracle 10.2.0.1(32 Bit) to Oracle 10.2.0.1(64 Bit)

1. Install Oracle 10.2.0.1.0 64bit, on Windows 2003 64bit (either AMD64 or EM64T processors).
2. The same directory structure was used for both machines.
NOTE: If a different directory structure will be used, then you will need to recreate the controlfiles, before starting the migration process.

Alter database backup controlfiles to trace;

3. Copy the Database files from the 32bit machine, to the 64bit machine.
(Datafiles, Logfiles, Controlfiles, init.ora, tnsnames.ora, listener.ora, etc...)

4. Create the Oracle service on the 64bit system, using the ORADIM command.

(Eg, oradim –new –sid orcl –startmode auto –pfile

6.Run Sqlplus

sqlplus '/as sysdba'

SQL> startup upgrade

SQL>@$Oracle_Home\rdbms\admin\utlip.sql

SQL>@$Oracle_Home\rdbms\admin\utlrp.sql

SQL> shut immediate

SQL>startup

SQL>select name,platform_name,open_mode from v$database;

Scenario 2:

Oracle 10.2.0.1(32 Bit) to Oracle 10.2.0.4(64 Bit)

1. Install Oracle 10.2.0.1.0 64bit, on Windows 2003 64bit (either AMD64 or EM64T processors).

2. If you wish to apply a patchset, you can do that now. For this test, the 10.2.0.4 patchset was applied to the 64bit installation.

3. The same directory structure was used for both machines.
NOTE: If a different directory structure will be used, then you will need to recreate the controlfiles, before starting the migration process.

Alter database backup controlfile to trace;

4. Copy the Database files from the 32bit machine, to the 64bit machine.
(Datafiles, Logfiles, Controlfiles, init.ora, tnsnames.ora, listener.ora, etc..)

5. Create the Oracle service on the 64bit system, using the ORADIM command.
(Eg, oradim –new –sid orcl –startmode auto –pfile
6.Run Sqlplus

sqlplus '/as sysdba'

SQL> startup upgrade

SQL>@$Oracle_Home\rdbms\admin\utlip.sql

SQL>@$Oracle_Home\rdbms\admin\catupgrd.sql

SQL>@$Oracle_Home\rdbms\admin\utlrp.sql

SQL> shut immediate

SQL>startup

SQL>select name,platform_name,open_mode from v$database;

Note: 403522.1:- How to Migrate Oracle 10.2 32bit to 10.2 64bit on Microsoft Windows

Scenario 3:

Steps to migrate 32 bit oracle 9i database to 64 bit 10g database:

1, Make backups of 32 bit 10g database.
Cold backup, export.

You need to have export file for migration. You can use user system to export entire database.

2, Install 64 bit Oracle 10g.

3, Create required tablespace, users etc.

4, Import 10g export dump file to 10g (from user=user1 to user=user1).

Steps

CONN sys/password@SID_NAME AS SYSDBA

1. Create Schema Name

2. ALTER USER U_NAME IDENTIFIED BY PASSWD ACCOUNT UNLOCK;
GRANT CREATE ANY DIRECTORY TO ;

3. CREATE OR REPLACE DIRECTORY DIR_NAME AS '/u05/oradata/';

4. GRANT READ, WRITE ON DIRECTORY DIR_NAME TO SCHEMA_NAME;

step:2

Schema Exports/Imports

expdp USER_NAME/PASSWD@SID_NAME schemas=SCHEMA_NAME directory=DIR_NAME dumpfile=INV.dmp logfile=EXPINV.log

impdp USER_NAME/PASSWD@SID_NAME schemas=SCHEMA_NAME directory=DIR_NAME dumpfile=INV.dmp logfile=IMPINV.log

Full Database Exports/Imports

expdp sys/password@SID_NAME full=Y directory=DIR_NAME dumpfile=FULLDB.dmp logfile=FULLDB10G.log

impdp sys/password@SID_NAME full=Y directory=DIR_NAME dumpfile=FULLDB.dmp logfile=FULLDB10G.log

Enterprise Manager DST Problem

2009-03-18T14:58:00.003+05:30

Purpose

OEM agent suddently not running for daylight saving time changes.

Problem:

$ ./emctl start agent

Oracle Enterprise Manager 10g Release 10.2.0.1.0.

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

Starting agent ..... failed.

The agentTZRegion value in /oracle/app/em/agent10g/sysman/config/emd.properties is not in agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed since the last start of the agent.

If you modified the timezone setting in the environment, please stop the agent and exectute 'emctl resetTZ agent' and also execute the script mgmt_target.set_agent_tzrgn(, ) to get the value propagated to repository.

Consult the log files in: /oracle/app/em/agent10g/sysman/log

Solutions:

Download the Patch 5632264 for the latest version for your platform, DO NOT APPLY IT with opatch but:

Manually replace the oracore [/zoneinfo/timez*.dat] files in the Central Agent ORACLE_HOME:
Agent ORACLE_HOME

- backup the initial oracore files $ORACLE_HOME/oracore/[/zoneinfo/timez*.dat]

- replace the oracore [/zoneinfo/timez*.dat] files in the Central Agent ORACLE_HOME with the oracore [/zoneinfo/timez*.dat] files extracted from the patch

- ./emctl resetTZ agent

Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Updating /oracle/oracle/agent10g/sysman/config/emd.properties...
Successfully updated /oracle/oracle/agent10g/sysman/config/emd.properties.
Login as the em repository user and run the script:
exec mgmt_target.set_agent_tzrgn('oradiscprod.amestruetemper.com:3872','US/Eastern')
This can be done for example by logging into sqlplus and doing
SQL> exec mgmt_target.set_agent_tzrgn('oradiscprod.amestruetemper.com:3872','US/Eastern')

- start the Central Agent

./emctl start agent
./emctl status agent

Reference:
Enterprise Manager DST Quick Fix Guide: 418792.1

Oracle Apps DBA: Using srvctl to Manage your 10g RAC Database

2009-03-09T14:15:00.000+05:30

Oracle Apps DBA: Using srvctl to Manage your 10g RAC Database

index is in unusable state

2009-02-20T11:56:00.004+05:30

Error Messsage

While compiling the flexfields, the procedure wf_event.raise failed with following
parameters:
event_name = oracle.apps.fnd.flex.dff.compiled
event_key = FND.$SRS$.FNDSCURS

The error raised is:
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'APPLSYS.SYS_C00169351' or partition of such index is in unusable state

Check the Unstale index

select index_name, status from dba_indexes where tablespace_name='APPS_TS_QUEUES' and STATUS != 'VALID';

WF_JAVA_DEFERRED_N1 UNUSABLE
SYS_C00169351 UNUSABLE
WF_DEFERRED_N1 UNUSABLE
SYS_C00105999 UNUSABLE

Solution:

Rebuild Unstale index.

select 'alter index 'owner'.'index_name' rebuild;' from dba_indexes where tablespace_name='APPS_TS_QUEUES' and STATUS != 'VALID';

SQL*Plus Command Reference

2009-02-20T10:37:00.002+05:30

SQL*PLUS - SET Statement

http://www.ss64.com/orasyntax/plus_set.html

SQL*Plus FAQ
http://www.orafaq.com/wiki/SQL*Plus_FAQ

SQL*Plus Command Reference
http://download-west.oracle.com/docs/cd/B10500_01/server.920/a90842/ch13.htm

How to Restart The Concurrent Manager in Unix.

2009-02-19T15:44:00.001+05:30

goal: How to restart the concurrent manager in Unix
goal: How to bounce the concurrent manager in Unix
fact: Oracle Application Object Library

fix:

1. At the command line issue the following shutdown command:

CONCSUB apps/apps sysadmin 'System Administrator' SYSADMIN CONCURRENT FND SHUTDOWN

Note: There are 3 options which can be used for controlling the Internal
Manager from the OS as follows:

SHUTDOWN = Standard, non-invasive shutdown.

DEACTIVATE = Will not allow further Requests to Process once Issued.

ABORT = Terminate Requests and Deactivate the Internal Manager.

2. At the command line, issue the following Start Up command:

startmgr sysmgr="[fnd_usernamd/fnd_password]" mgrname="[mgrname]" printer="[printername]"
mailto="[userid userid2...]" restart="[Nminutes]" logfile="[log_file_name]" sleep="
[new_check]" pmon="[manager_check]" quesiz="[number_check]" diag="[YN]"

ExAMPLE:

startmgr sysmgr="applsys/apps" mgrname="std" printer="localprint"
mailto="Ramesh Mani" restart="N" logfile="mgrlog" sleep="90"
pmon="5" quesiz="10" diag="N"

Note: a space is required between arguments and the "diag" parameter
may be omitted if desired.

Reference: 147449.1

The field PARAMETER.CONFIG could not be located or read

2009-02-19T15:26:00.002+05:30

Symptoms

You are encountering the following error while trying to start/stop the apache
using adapcctl.sh

"The field PARAMETER.CONFIG could not be located or read."

The adapcctl.log carries the following errors:

Cannot read value from field PARAMETER.CONFIG

Cause: The field PARAMETER.CONFIG could not be located or read.

Changes

You upgraded to RDBMS 9.2.0.4 from RDBMS 8.0.6, but the instance was fine for a couple of days after the upgrade. This problem suddenly cropped up.

Cause

Your guest user is end-dated
That is the sole reason you are getting this error.

Fix

Back up your FND_USER TABLE

Run the following command update fnd_user set end_date=null where user_name='GUEST';

Retest with adapcctl.sh

Reference: 298143.1

Diagnostic Script for Concurrent Manager

2009-02-19T14:27:00.003+05:30

- - - - - - - - - - - - - - - - Code begins here - - - - - - - - - - - - - - -

spool ccm.lst
prompt Step 1 Checking how many rows in FND_CONCURRENT_REQUEST.

select count(*) from fnd_concurrent_requests;
prompt
-----------------------------------------

prompt Step 2 Checking how many rows in FND_CONCURRENT_PROCESSES table.

select count(*) from fnd_concurrent_processes;
prompt
-----------------------------------------------

prompt Step 3 Checking sys.dual table which should have one and only one row.
select count(*) from sys.dual;

prompt If you have more than one row in sys.dual, please delete it

prompt sql> delete rownum from SYS.DUAL;
Prompt rownum= the row number to delete
prompt
prompt
prompt
---------------------------------------------

prompt Step 4 Checking fnd_dual. There must be at lest one row:

select count(*) from fnd_dual;

prompt If there are no record selected,
prompt Update fnd_dual table to have at lest one record
prompt
----------------------------------------------

prompt Step 5 Checking the Internal Manager queue name "FNDICM" which should be=1

select concurrent_queue_id from fnd_concurrent_queues
where concurrent_queue_name='FNDICM';

prompt
----------------------------------------------

prompt Step 6 Checking for Active processes under the Internal Manager queue
prompt in fnd_concurrent_proceses table:
prompt

select a.concurrent_queue_name
, substr(b.os_process_id,0,10) "OS Proc"
, b.oracle_process_id "Oracle ID"
, b.process_status_code
from fnd_concurrent_queues a
, fnd_concurrent_processes b
where a.concurrent_queue_id=b.concurrent_queue_id
and a.concurrent_queue_name='FNDICM'
and b.process_status_code='A'
order by b.process_status_code;

prompt If any rows found with process_status_code with value = 'A' (= Active)
prompt The internal Manager will not start up ,so to avoide this issue
prompt update these rows to have process_status_code value ='K'(terminated)
prompt
prompt
-----------------------------------------
prompt Step 7 Checking for Active processes under the Standard Manager queue
prompt in fnd_concurrent_proceses table:
prompt

select a.concurrent_queue_name
, substr(b.os_process_id,0,10) "OS Proc"
, b.oracle_process_id "Oracle ID"
, b.process_status_code
from fnd_concurrent_queues a
, fnd_concurrent_processes b
where a.concurrent_queue_id=b.concurrent_queue_id
and a.concurrent_queue_name='STANDARD'
and b.process_status_code='A'
order by b.process_status_code;

prompt If any rows found with process_status_code with value = 'A' (= Active)
prompt The internal Manager will not start up ,so to avoide this issue
prompt update these rows to have process_status_code value ='K'(terminated)
prompt
prompt
------------------------------------------
prompt Step 8 Checking for Active processes under the Conflict Manager queue
prompt in fnd_concurrent_proceses table:
prompt

select a.concurrent_queue_name
, substr(b.os_process_id,0,10) "OS Proc"
, b.oracle_process_id "Oracle ID"
, b.process_status_code
from fnd_concurrent_queues a
, fnd_concurrent_processes b
where a.concurrent_queue_id=b.concurrent_queue_id
and a.concurrent_queue_name='FNDCRM'
and b.process_status_code='A'
order by b.process_status_code;

prompt If any rows found with process_status_code with value = 'A' (= Active)
prompt The internal Manager will not start up ,so to avoide this issue
prompt update these rows to have process_status_code value ='K'(terminated)
prompt
prompt
---------------------------------------------------
prompt Step 9 Checking Actual and Target Processes for Internal Manager:

select MAX_PROCESSES,RUNNING_PROCESSES
from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME='FNDICM';

prompt If the MAX_PROCESSES=RUNNING_PROCESSES that means the manager is UP.
prompt
prompt
--------------------------------------------------------

prompt Step 10 Checking Actual and Target Processes for the Standard Manager:

select MAX_PROCESSES,RUNNING_PROCESSES
from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME='STANDARD';

prompt If the MAX_PROCESSES=RUNNING_PROCESSES that means the manager is UP.
prompt
prompt
---------------------------------------------------------
prompt Step 11 Checking Actual and Target Processes for Conflict Resolution Manager:

select MAX_PROCESSES,RUNNING_PROCESSES
from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME='FNDCRM';

prompt If the MAX_PROCESSES=RUNNING_PROCESSES that means the manager is UP.
prompt
prompt
---------------------------------------------------------

Prompt Step 12 Checking if the control_code set to 'N':

select control_code from fnd_concurrent_queues
where control_code='N';
prompt
prompt If any rows selected, please update the table fnd_concurrent_queues:
prompt Update fnd_concurrent_queues set control_code = null
prompt where control_code ='N';
PROMPT Update fnd_concurrent_queues set target_node = null;
PROMPT commit;
prompt
prompt
--------------------------------

PROMPT Step 13 Checking terminated processes:
PROMPT
select count (*) from fnd_concurrent_requests
where status_code='T';
prompt
prompt If you have terminated processes run the following sql statement:
prompt
prompt SQL> Update fnd_concurrent_requests
prompt set status_code = 'E', phase_code = 'C'
prompt where status_code = 'T';
prompt
------------------------------------------

prompt Step 14 Checking pending requests:

select count(*) from fnd_concurrent_requests
where status_code='P';
prompt If any rows selected please run the following sql statement:

prompt SQL> Update fnd_concurrent_requests
prompt set status_code = 'E', phase_code = 'C'
prompt where status_code = 'P';
prompt
------------------------------------------------------
prompt Step 15 Checking Running processes:
prompt
select count (*) from fnd_concurrent_requests
where status_code='R';
prompt
prompt If you have Running processes run the following sql statement
prompt SQL> Update fnd_concurrent_requests
prompt set status_code = 'E', phase_code = 'C'
prompt where status_code = 'R';
prompt
------------------------------------------

prompt Step 16 Checking the PMON method, which should be set to LOCK:
prompt
select profile_option_id , profile_option_value
from FND_PROFILE_OPTION_VALUES
where profile_option_id= (select profile_option_id
from FND_PROFILE_OPTIONS
where profile_option_name='CONC_PMON_METHOD');
prompt
prompt If the PROFILE_OPTION_VALUE was't LOCK please
prompt Reset PMON to LOCK by running afimpmon.sql script(The manager should be down)

prompt 1-At UNIX command prompt:

prompt 2-cd $FND_TOP/sql

prompt 3-Log into SQLPLUS as apps/

prompt SQL> @afimpmon.sql
prompt prompt1:dual
prompt prompt2:LOCK (LOCK MUST BE ALL UPPERCASE)

prompt For Oracle Applications Release 11.5, when you check the PMON
prompt Method you may get no rows selected which is normal,
prompt because in apps 11.5 the Pmon Method is hard coded to Lock at
prompt the Operating System level.
prompt
prompt
-------------------------------------------------------

prompt Step-17 Checking how many FNDLIBR processes are running:
prompt -For Unix :From unix command prompt $ ps -ef grep -i fndlibr
prompt If you have any FNDLIBR processes running,please kill them before
prompt starting or shuting down the internal manager
prompt
prompt
prompt -For NT, through Task Manager, check the entries under the Processes tab
for FNDLIBR.exe processes.
prompt If there are any, Highlight and click [End Process] button to kill processes

prompt
----------------------------------------------------------

prompt Step-18 Checking how many "FND_%"invalid objects:

select substr(owner,1, 12) owner, substr(object_type,1,12) type,
substr(status,1,8) status, substr(object_name, 1, 25) name
from dba_objects
where object_name like 'FND_%'
and status='INVALID';

prompt If you have any invalied objects please see note#113947.1 via Metalink

prompt
--------------------------------------------------------------

prompt Step-19-How to find the PID in the O/S for request_id:
prompt If you do not like to check this enter any number then click Enter to Exit

select r.request_id, p.os_process_id
from FND_CONCURRENT_REQUESTS r,FND_CONCURRENT_PROCESSES p
where r.controlling_manager = p.concurrent_process_id
and request_id=&request_id;

prompt
prompt Please upload the "ccm.lst" output to Support, Thanks.
prompt
spool off
- - - - - - - - - - - - - - - - Code ends here - - - - - - - - - - - - - - - -

How To Trace a Concurrent Request And Generate TKPROF File

2009-02-19T11:22:00.002+05:30

https://metalink2.oracle.com/metalink/plsql/f?p=130:14:9891571609150575875::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,453527.1,1,1,1,helvetica

Reference:

Metalink Note ID: 453527.1

Organization Setup Frequently Asked Questions - FAQ
https://metalink2.oracle.com/metalink/plsql/f?p=130:14:6356763575233978369::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,109665.1,1,1,1,helvetica
Doc ID:
109665.1

FNDFS Fails to Relink on Red Hat 4.0 - Undefined Reference to dl_iterate_phdr@GLIBC_2.2.4

2009-02-17T17:22:00.004+05:30

Starting link of fnd executable 'FNDFS' on Mon Feb 16 23:26:17 EST 2009
gcc -s -L/U01/oracle/U01ora/8.0.6/lib -L/U01/oracle/U01ora/8.0.6/lib/stubs -ldl -o /U01/oracle/U01appl/fnd/11.5.0/bin/FNDFS

/U01/oracle/U01appl/fnd/11.5.0/lib/afpfss.o \
/U01/oracle/U01appl/fnd/11.5.0/lib/libfnd.a -lsql /U01/oracle/U01ora/8.0.6/lib/nautab.o /U01/oracle/U01ora/8.0.6/lib/naeet.o

/U01/oracle/U01ora/8.0.6/lib/naect.o /U01/oracle/U01ora/8.0.6/lib/naedhs.o `cat /U01/oracle/U01ora/8.0.6/lib/naldflgs` -lnetv2 -lnttcp

-lnetwork -lncr -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr

-lclient -lvsn -lcommon -lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -lcommon -lgeneric -lnlsrtl3 -lcore4

-lnlsrtl3 -lcore4 -lnlsrtl3 `cat /U01/oracle/U01ora/8.0.6/lib/sysliblist` -ldl -lpthread -lm /U01/oracle/U01ora/8.0.6/rdbms/lib/defopt.o

/U01/oracle/U01ora/8.0.6/rdbms/lib/ssbbded.o

/usr/lib/gcc/i386-redhat-linux/3.4.6/libgcc_s.so: undefined reference to `dl_iterate_phdr@GLIBC_2.2.4'
collect2: ld returned 1 exit status

make: *** [/U01/oracle/U01appl/fnd/11.5.0/bin/FNDFS] Error 1
Done with link of fnd executable 'FNDFS' on Mon Feb 16 23:26:19 EST 2009

Relink of module "FNDFS" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure. Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /U01/oracle/U01appl/fnd/11.5.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Done with link of product 'fnd' on Mon Feb 16 23:26:19 EST 2009

adrelink is exiting with status 1

End of adrelink session

Solutions:
For Red Hat 4.0, re-apply Patch 4198954 by doing the following:

1. Verify the package has already been installed by running the following command:

#rpm -qs compat-oracle-rhel4
package compat-oracle-rhel4 is not installed

#rpm -qs compat-libcwait-2
package compat-libcwait-2 is not installed

2. Use the following command to apply the patch 4198954:
# rpm -Uvh compat-oracle-rhel4-1.0-5.i386.rpm

Preparing... ########################################### [100%]1:compat-oracle-rhel4 ########################################### [100%]

# rpm -Uvh compat-libcwait-2.1-1.i386.rpm
Preparing... ########################################### [100%]
1:compat-libcwait ########################################### [100%]

3. Verify the file sizes are now correct by running the following command again:

ls -l /usr/bin/gcc*
The correct file sizes are as follows:
[root@vision]# ls -l /usr/bin/gcc*
-rwxr-xr-x 1 root root 914 Feb 23 2005 /usr/bin/gcc
-rwxr-xr-x 2 root root 84780 Dec 1 2004 /usr/bin/gcc32
-rwxr-xr-x 1 root root 93120 Sep 26 10:28 /usr/bin/gcc.orig

4. Re-link the FNDFS executable using adadmin

Refered ID:

Doc ID: 464519.1

How To Configure RMAN Backups To Tape via Oracle Enterprise Manager

2009-02-16T12:19:00.010+05:30

Solution

+ Log in to Oracle Enterprise Manager Database Control

+ Navigate to: Maintenance -> Backup Settings -> Device

If grid control is used, we need to first select the appropriate database from Targets.

+ Now, under Tape Settings, specify the number of Tape Drives that will be available for this backup schedule/policy. RMAN will allocate that many simultaneous channels as many Tape Drives are specified.

+ On the same screen, specify the MML specific parameters under "Media Management Vendor Library Parameters" which as per our example above are:

ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)

Refer to the example script above and the screen shot below:

+ Specify preferred credentials on the same page if they are not configured already. Additionally, also configure advanced settings such as CONTROLFILE AUTOBACKUP or the backup Retention Policy under the Policy sub-tab of the Backup Settings page. Click OK to save your settings.

+ Now, navigate to: Maintenance -> Schedule Backup.

+ Select Whole Database under Customized Backup and click Schedule Customized Backup. In the screen that follows, accept the defaults though you may like to tinker with some of the settings i.e. to delete obsolete backups etc under Advanced as per your requirement. click Next.

+ In this screen, select Tape to make backups to TAPE. Notice that the MML parameters that we saved earlier are shown here:

+ Click Next.On the new page you can specify Job Name, Job Description and the job schedule. Make appropriate changes and click Next.

+ Click Next

+ This last page now summarizes the configuration we have specified for our backup job and the EM generated script. You might want to edit the EM generated backup script for customized tags or format (backup-piece handle). After you have ensured all settings are appropriate, click Submit Job to complete the setup.

Refference: 735953.1

Create Document in R12 Web ADI Menu Generates HTTP 404 File Not Found Error

2009-02-12T17:13:00.001+05:30

Symptoms

When trying to use the function Create Document the following error is displayed:

HTTP 404 File Not Found Error

Steps To Reproduce:
===================

Navigation -

1. Log onto a Release 12 instance with WEB ADI Installed
2. Seleft Responsibility Oracle Web ADI
3. Select Create Document

Solution

1. Go into the responsibility System Administrator.

2. Navigate to System Administrator > Security > Responsibility > Define > Oracle web ADI Responsibility

3. Set the menu to Desktop Integration Menu and save

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.

Crontab - Quick reference

2009-01-28T14:44:00.001+05:30

http://www.adminschoice.com/docs/crontab.htm

Oracle Release/Version Number for Apps/ Forms/ Jinitiator/ OID/ SSO/ Portal/ iAS/ OC4J/ Unix/ xxxx ….

2009-01-05T16:57:00.001+05:30

Oracle Release/Version Number for Apps/ Forms/ Jinitiator/ OID/ SSO/ Portal/ iAS/ OC4J/ Unix/ xxxx ….

http://onlineappsdba.com/index.php/2008/08/17/oracle-releaseversion-number-for-apps-forms-jinitiator-oid-sso-portal-ias-oc4j-unix-xxxx/

OEM DBConsole startup issues on 10g R2 database for 11i/R12

2009-01-03T09:49:00.001+05:30

http://onlineappsdba.com/index.php/2009/01/02/oem-dbconsole-startup-issues-on-10g-r2-database-for-11ir12/

OPatch Apply In database Level

2009-01-02T15:16:00.003+05:30

OPatch is a Database patch.

Please download latest OPatch Tool and extract the RDBMS Oracle home.

1. Check the OPatch already installed or not

cd $ORACLE_HOME/OPatch

$opatch -lsinventory

This is command will show existing patch

Then Export the following environmet file

$ export ORACLE_HOME=/UAT/app/oracle
$ export PATH=$PATH:$ORACLE_HOME/OPatch:$ORACLE_HOME/bin
$ export OBJECT_MODE=32_64

$ cd patch/

Extract the Following OPatch.
p5246372_10203_LINUX.zip
p5965763_10203_LINUX.zip

5246372
5965763

Then Go to patch Directory and apply the Opatch.
$ cd 5965763/

$ opatch apply

Reference:
OPatch documentation list
Doc ID: 293369.1

How to Change the System Name in Workflow

2008-12-29T14:41:00.003+05:30

After Cloning required to change workflow system name.

Change the service name in TEST:

In apps node

SQL> select NAME from wf_systems;

NAME
--------
PROD.DOYENSYS.COM

SQL> select GUID from wf_systems;

GUID
--------------------------------
3CA4A184BD2C99FFE040500A1F033CD9

SQL> select NAME, SYSTEM_GUID from wf_agents;

Go to bellow path and run the following scripts txkWfClone.sh .

$ cd /TEST/apps/testcomn/admin/install/TEST_oratest2

$ sh txkWfClone.sh apps apps

txkWfClone.sh started at Mon Dec 29 03:49:05 EST 2008
The environment settings are as follows ...
apps_HOME : /TEST/apps/testora/8.0.6
apps_SID :
TWO_TASK : TEST_806_BALANCE
PATH : /TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testappl/fnd/11.5.0/bin:/TEST/apps/testappl/ad/11.5.0/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50::/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50:/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/applmgr/bin
LD_LIBRARY_PATH : /TEST/apps/testora/8.0.6/network/jre11/lib/i686/native_threads:/TEST/apps/testora/8.0.6/network/jre11/lib/linux/native_threads:/TEST/apps/testappl/cz/11.5.0/bin:/TEST/apps/testora/8.0.6/lib:/usr/X11R6/lib:/usr/openwin/lib

Executable : /TEST/apps/testora/8.0.6/bin/sqlplus

SQL*Plus: Release 8.0.6.0.0 - Production on Mon Dec 29 03:49:05 2008

(c) Copyright 1999 apps Corporation. All rights reserved.

Connected.

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from apps Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ERRORCODE = 0 ERRORCODE_END

After completing this scripts, now check againg the following query.
Now its changed the service name PROD to TEST.

SQL> show parameter service

NAME TYPE VALUE
---------------------------
service_names string TEST

SQL> select NAME from wf_systems;

NAME
------------------------------
TEST.DOYENSYS.COM

SQL> select GUID from wf_systems;

GUID
--------------------------------
5F2BB84D418D8F79E040500A0B02363F

SQL> select NAME, SYSTEM_GUID from wf_agents;

Refered Notes:

The agent could not be found: WF_CONTROL post-clone
Doc ID: 374529.1

How to Change the System Name in Workflow?
Doc ID: 387337.1

O/S-Error: (OS 8) Not enough storage is available to process this command

2008-12-26T15:15:00.003+05:30

After increasing SGA_TARGET=2GB, We got following Error Message.

SQL> startup

ORA-27102: out of memory

OSD-00022: additional error information

O/S-Error: (OS 8) Not enough storage is available to process this command

C:\boot.ini old value

Old File:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect

Solutions:

Modified Boot.ini File:

Note: In the boot.ini file we changed following parameter /3GB and /PAE

After Changing that parameter, we can able to increase UPTO 2.7GB sga target.

[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect /3GB /PAE

SQL> startup
ORACLE instance started.
Total System Global Area 2726297600 bytes
Fixed Size 1254760 bytes
Variable Size 553650840 bytes
Database Buffers 2164260864 bytes
Redo Buffers 7131136 bytes
Database mounted.
Database opened.

SQL> show parameter sga

NAME TYPE VALUE
------------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 2784M
sga_target big integer 2784M

Reference:
Note 225349.1 - Implementing Address Windowing Extensions (AWE) or VLM on Windows Platforms

Note 46053.1 - Windows NT Memory Architecture Overview

ORA-00439: feature not enabled: Real Application Clusters

2008-12-15T15:30:00.000+05:30

SQL> startup

ORA-00439: feature not enabled: Real Application Clusters

Turn on RAC (In All nodes)

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk rac_on

If this step did not work, please go ahead below step.

make -f ins_rdbms.mk ioracle

Then Change cluster_name=true, and try to startup the both database.

Metalink Note ID : 211177.1

Using srvctl to Manage your 10g RAC Database

2008-12-15T14:57:00.005+05:30

Oracle recommends that RAC databases be managed with srvctl, an Oracle-supplied tool that was first introduced with 9i RAC. The 10g version of srvctl is slightly different from the 9i implementation. In this article.

How and why -- to manage your 10g databases with srvctl.

RAC Architecture Overview

Brief overview of RAC architecture.

1. A cluster is a set of 2 or more nodes that share or coordinate resources to perform the same task.

2. A RAC database is 2 or more instances running on a set of clustered nodes, with all instances accessing a shared set of database files.

3. Depending on the O/S platform, a RAC database may be deployed on a cluster that uses vendor clusterware plus Oracle's own clusterware (Cluster Ready Services), or on a cluster that solely uses Oracle's own clusterware.

Thus, every RAC sits on a cluster that is running Cluster Ready Services. srvctl is the primary tool DBAs use to configure CRS for their RAC database and processes.

Cluster Ready Services and the OCR

Cluster Ready Services, or CRS, is a new feature for 10g RAC. Essentially, it is Oracle's own clusterware. On most platforms, Oracle supports vendor clusterware; in these cases, CRS interoperates with the vendor clusterware, providing high availability support and service and workload management. On Linux and Windows clusters, CRS serves as the sole clusterware. In all cases, CRS provides a standard cluster interface that is consistent across all
platforms.

CRS consists of four processes (crsd, occsd, evmd, and evmlogger) and two disks: the Oracle Cluster Registry (OCR), and the voting disk.

CRS manages the following resources:

1. The ASM instances on each node
2. Databases
3. The instances on each node
4. Oracle Services on each node
5. The cluster nodes themselves, including the following processes:

1. VIP
2. GSD
3. The listener
4. The ONS daemon

CRS stores information about these resources in the OCR. If the information in the OCR for one of these resources becomes damaged or inconsistent, then CRS is no longer able to manage that resource. Fortunately, the OCR automatically backs itself up regularly and frequently.

Interacting with CRS and the OCR: srvctl

srvctl is the tool Oracle recommends that DBAs use to interact with CRS and the cluster registry. Oracle does provide several tools to interface with the cluster registry and CRS more directly, at a lower level, but these tools are deliberately undocumented and intended only for use by Oracle Support. srvctl, in contrast, is well documented and easy to use. Using other tools to modify the OCR or manage CRS without the assistance of Oracle Support runs the risk of damaging the OCR.

Using srvctl

Even if you are experienced with 9i srvctl, it's worth taking a look at this section; 9i and 10g srvctl commands are slightly different.

srvctl must be run from the $ORACLE_HOME/bin of the RAC you are administering. The basic format of a srvctl command is

$ ./srvctl
Usage: srvctl
[]
command:
enabledisablestartstoprelocatestatusaddremovemodifygetenvsetenvunsetenvconfig
objects: databaseinstanceservicenodeappsasmlistener
For detailed help on each command and object and its options use:
srvctl -h
Examples of starting and stopping RAC follow:-

$ gsdctl stat
GSD is running on local node

$ gsdctl stop

$ gsdctl start

Start all its instances and all its services, on all nodes.
$ srvctl start database -d test

Stop all its instances and all its services, on all nodes.
$ srvctl stop database -d test

Startup up the TEST1 instance of the TEST database
$ srvctl start instance -d test -i test1

Bounce the TEST1 instance of the TEST database
$ srvctl stop instance -d test -i test2

To check the CRS status.

# ./crs_stat -t

Name Type Target State Host
------------------------------------------------------------
ora....D1.inst application OFFLINE OFFLINE
ora....D2.inst application OFFLINE OFFLINE
ora.test.db application OFFLINE OFFLINE
ora....od1.gsd application ONLINE ONLINE test1
ora....od1.ons application ONLINE ONLINE test1
ora....od1.vip application ONLINE ONLINE test2
ora....od2.gsd application ONLINE ONLINE test2
ora....od2.ons application ONLINE ONLINE test2
ora....od2.vip application ONLINE ONLINE test1

After db upgrade, Here some crs services are went OFFLINE.

Solution:

Please remove the DBSID from srvctl and add again, just follow the bellow steps.

su - oracle

$ cd $ORACLE_HOME/bin

$ ./srvctl remove database -d test

Remove the database test? (y/[n]) y

$ ./srvctl add database -d test -o /10.2.0/test/app/oracle
$ ./srvctl add instance -d test -i test1 -n test1
$ ./srvctl add instance -d test -i test2 -n test2
$ ./srvctl start database -d test

# ./crs_stat -t

Name Type Target State Host
------------------------------------------------------------
ora....D1.inst application ONLINE ONLINE test1
ora....D2.inst application ONLINE ONLINE test2
ora.test.db application ONLINE ONLINE test1
ora....od1.gsd application ONLINE ONLINE test1
ora....od1.ons application ONLINE ONLINE test1
ora....od1.vip application ONLINE ONLINE test1
ora....od2.gsd application ONLINE ONLINE test2
ora....od2.ons application ONLINE ONLINE test2
ora....od2.vip application ONLINE ONLINE test2

http://www.orafaq.com/node/70

http://www.oracledba.org/11g/rac/11g_RAC_Admin_Utilities.html

perform the following to change the database ID:

2008-12-11T11:26:00.003+05:30

a. shutdown immediate;
b. change the initSID.ora (Cluster_database = FALSE)
c. startup pfile=$ORACLE_HOME/dbs/initSID.ora mount;
d. nid target=sys/password

Old ID TEST1:

SQL> select DBID,name from v$database;

DBID NAME
---------- ---------
13455769 TEST

Old ID TEST2:

SQL> select DBID,name from v$database;

DBID NAME
---------- ---------
13455769 TEST

Database ID for database TEST changed to 1969630541.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.

SQL> startup mount pfile=/TEST/oracle/10.2.0/dbs/initTEST1.ora

[oracle@oratest1 dbs]$ nid target=sys/password
DBNEWID: Release 10.1.0.4.0 - Production
Copyright (c) 2001, 2004, Oracle. All rights reserved.

Connected to database TEST (DBID=13455769)

Connected to server version 10.1.0

Control Files in database:
/u01/oradata/controlfiles/cntrl01.ctl
/u01/oradata/controlfiles/cntrl02.ctl
/u01/oradata/controlfiles/cntrl03.ctl

Change database ID of database TEST? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 14213988 to 1969630541
Control File /u01/oradata/controlfiles/cntrl01.ctl - modified
Control File /u01/oradata/controlfiles/cntrl02.ctl - modified
Control File /u01/oradata/controlfiles/cntrl03.ctl - modified
Datafile /u01/oradata/system01.dbf - dbid changed
Datafile /u01/oradata/system02.dbf - dbid changed
Datafile /u01/oradata/system03.dbf - dbid changed
Datafile /u01/oradata/system04.dbf - dbid changed
Datafile /u01/oradata/system05.dbf - dbid changed
.
.
.
.
.
.
Datafile /u01/oradata/apps_ts_tx_idx04.dbf - dbid changed
Datafile /u01/oradata/apps_ts_seed02.dbf - dbid changed
Datafile /u01/oradata/temp01.dbf - dbid changed
Control File /u01/oradata/controlfiles/cntrl01.ctl - dbid changed
Control File /u01/oradata/controlfiles/cntrl02.ctl - dbid changed
Control File /u01/oradata/controlfiles/cntrl03.ctl - dbid changed
Instance shut down

Database ID for database TEST changed to 1969630541.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.

[oracle@oratest1 dbs]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.1.0.4.0 - Production on Sun Nov 23 07:25:47 2008

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

Connected to an idle instance.

SQL> startup mount pfile=/TEST/oracle/10.2.0/dbs/initTEST1.ora
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 782584 bytes
Variable Size 341053192 bytes
Database Buffers 721420288 bytes
Redo Buffers 10485760 bytes
Database mounted.

SQL> alter database open resetlogs;

Database altered.

SQL> select dbid,name from v$database;

DBID NAME
---------- ---------
1896547098 TEST

Stale Statistics Operations

2008-12-11T11:01:00.002+05:30

-- PURPOSE: CHECK_STALE_STATS.SQL
-- This script is an automated way to deal with stale statistics operations that are
-- required to be done as part of manual upgrade OR when reported by DBUA.
--
-- This script will work in both Windows and Unix platforms from database
-- version 9.2 or higher.
-- ------------------------------------------------------------------------
-- DISCLAIMER:
-- This script is provided for educational purposes only. It is NOT
-- supported by Oracle World Wide Technical Support.
-- The script has been tested and appears to work as intended.
-- You should always run new scripts on a test instance initially.
-- ------------------------------------------------------------------------
--
SET FEEDBACK OFF
SET LINESIZE 250
SET SERVEROUTPUT ON

DECLARE
-- Variables declared
P_OTAB DBMS_STATS.OBJECTTAB;
MCOUNT NUMBER := 0;
P_VERSION VARCHAR2(10);
-- Cursor defined
CURSOR c1
IS
SELECT distinct schema
FROM dba_registry
ORDER by 1;

-- Beginning of the anonymous block
BEGIN
-- Verifying version from v$instance
SELECT version INTO p_version FROM v$instance;
DBMS_OUTPUT.PUT_LINE(chr(13));
-- Defining Loop 1 for listing schema which have stale stats
FOR x in c1
LOOP
DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME=>x.schema,OPTIONS=>'LIST AUTO',OBJLIST=>p_otab);

-- Defining Loop 2 to find number of objects containing stale stats
FOR i in 1 .. p_otab.count
LOOP
IF p_otab(i).objname NOT LIKE 'SYS_%'
AND p_otab(i).objname NOT IN ('CLU$','COL_USAGE$','FET$','INDPART$',
'MON_MODS$','TABPART$','HISTGRM$',
'MON_MODS_ALL$',
'HIST_HEAD$','IN $','TAB$',
'WRI$_OPTSTAT_OPR','PUIU$DATA',
'XDB$NLOCKS_CHILD_NAME_IDX',
'XDB$NLOCKS_PARENT_OID_IDX',
'XDB$NLOCKS_RAW OKEN_IDX', 'XDB$SCHEMA_URL',
'XDBHI_IDX', 'XDB_PK_H_LINK')
THEN
-- Incrementing count for each object found with statle stats
mcount := mcount + 1;
END IF;
-- End of Loop 2
END LOOP;

-- Displays no stale statistics, if coun is 0
IF mcount!=0
THEN
-- Displays Schema with stale stats if count is greater than 0
DBMS_OUTPUT.PUT_LINE('-------------------------------------------------------------------------------------------------------');
DBMS_OUTPUT.PUT_LINE('-- ' x.schema ' schema contains stale statistics use the following to gather the statistics ''--');
DBMS_OUTPUT.PUT_LINE('-------------------------------------------------------------------------------------------------------');
--DBMS_OUTPUT.PUT_LINE('');

-- Displays Command to be executed if schema with stale statistics is found depending on the version.
IF SUBSTR(p_version,1,5) in ('8.1.7','9.0.1','9.2.0')
THEN
DBMS_OUTPUT.PUT_LINE(chr(13));
DBMS_OUTPUT.PUT_LINE('EXEC DBMS_STATS.GATHER_SCHEMA_STATS('''x.schema''',OPTIONS=>''''GATHER'''', ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE, METHOD_OPT => ''''FOR ALL COLUMNS SIZE AUTO'''', CASCADE => TRUE);');
ELSIF SUBSTR(p_version,1,6) in ('10.1.0','10.2.0','11.1.0')
THEN
DBMS_OUTPUT.PUT_LINE(chr(13));
DBMS_OUTPUT.PUT_LINE('EXEC DBMS_STATS.GATHER_DICTIONARY_STATS('''x.schema''',OPTIONS=>''''GATHER'''', ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE, METHOD_OPT => ''''FOR ALL COLUMNS SIZE AUTO'''', CASCADE => TRUE);');
ELSE
DBMS_OUTPUT.PUT_LINE(chr(13));
DBMS_OUTPUT.PUT_LINE('Version is 'p_version);
END IF;
ELSE
DBMS_OUTPUT.PUT_LINE('-- There are no stale statistics in ' x.schema ' schema.');
DBMS_OUTPUT.PUT_LINE(chr(13));
END IF;
-- Reset count to 0.
mcount := 0;
-- End of Loop 1
END LOOP;
END;
/

SET FEEDBACK ON
-- - - - - - - - - - - - - - - - Script ends here - - - - - - - - - - - - - - - -

ORA-01115 ORA-01110 ORA-27091 ORA-27072 Error: 5: I/O error

2008-12-06T01:19:00.002+05:30

Symptoms

ORA-01115: IO error reading block from file 393 (block# 2959)
ORA-01110: data file 393: '/u01/proddata/data/ard01.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27027: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5 I/O error

- The errors are not reported in the alert log file.
- Running dbv against datafiles from the error messages shows no errors.
- All the mandatory OS patches are applied.
- Oracle patch for Bug 5496862 - IO READING PROBLEMS AFTER INSTALLING IBM TECHNOLOGY LEVEL 5 (5300-05) was installed before patching the OS.

Solutions

Increase maxreqs from 8192 to 12288.

Steps:

1. run aioo -a command to double check current setting for aioo device
2. run aioo -o maxreqs=12288 to set maxreqs dynamically
3. chdev -l aioo -a maxreqs=12288 to set the value of maxreqs permanently for next reboot
4. run aioo -a to confirm change
5. restart oracle

Metalink Note:559697.1

Find the Meanings of Various Status Codes

2008-12-05T22:47:00.007+05:30

Applications maintains this type of information in FND_LOOKUPS view.

The following query would provide you the information regarding the status_code and its meaning for fnd_concurrent_processes.

SQL> select lookup_code, meaning from fnd_lookups where lookup_type='CP_PROCESS_STATUS_CODE'

LOOKUP_CODE ----- MEANING
----------------- ------------
A -------------------> Active
C -------------------> Connecting
D -------------------> Deactiviating
G -------------------> Awaiting Discovery
K ------------------->Terminated
M ------------------>Migrating
P ------------------>Suspended
R ------------------>Running
S ------------------>Deactivated
T ------------------>Terminating
Z ------------------>Initializing

Here are the status_codes for fnd_concurrent_requests and their meanings :-

PROCESS_STATUS_CODE ------- Column:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
A ------------------------------------>Waiting
B ------------------------------------>Resuming
C ------------------------------------>Normal
D ------------------------------------>Cancelled
E ------------------------------------>Error
F ------------------------------------>Scheduled
G ------------------------------------>Warning
H ------------------------------------>On Hold
I ------------------------------------->Normal
M ------------------------------------>No Manager
Q ------------------------------------>Standby
R ------------------------------------>Normal
S ------------------------------------>Suspended
T ------------------------------------>Terminating
U ------------------------------------>Disabled
W ----------------------------------->Paused
X ------------------------------------>Terminated
Z ------------------------------------>Waiting

PHASE_CODE -----------column
----------------------- ---------------
C ------------------------->Completed
I ------------------------->Inactive
P ------------------------->Pending
R ------------------------->Running

Performence Tuning Scripts List

2008-12-05T19:12:00.002+05:30

All related COE, BDE, TRCA, SQLT and PROF scripts can be downloaded from MetaLink or directly from Oracle's external FTP server

ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE

MetaLink
Script from FTP server
Title

224270.1
TRCANLZR.SQL
Trace Analyzer (8.1.6+)

215187.1
SQLTXPLAIN.SQL
Enhanced Explain Plan and related info for one SQL statement (8.1+)

243755.1
profiler.sql
Implementing and Using the PL/SQL Profiler (8.1+)

156959.1
coe_xplain_80.sql
Enhanced Explain Plan for given SQL Statement (8.0)

156960.1
coe_xplain_73.sql
Enhanced Explain Plan for given SQL Statement (7.3)

174603.1
bde_x.sql
Simple Explain Plan for given SQL Statement (8.1+)

156972.1
coe_view.sql
Clones views across instances for SQL tuning exercises (8.0+)

238684.1
SQLAREAT.SQL
Top 10 Expensive SQL from SQL Area (8.1+)

163209.1
coe_sqlarea_80.sql
Top 10 Expensive SQL from SQL Area (8.0)

169630.1
bde_session.sql
Expensive SQL and resources utilization for given Session ID (8.1+)

174605.1
bde_chk_cbo.sql
Current, required and recommended Apps 11i init.ora params (11i)

163208.1
bde_last_analyzed.sql
Verifies Statistics for all installed Apps modules (11i)

156968.1
coe_stats.sql
Automates CBO Stats Gathering using FND_STATS and Table sizes (11i)

156969.1
coe_trace.sql
SQL Tracing Apps online transactions with Event 10046 (11i)

156970.1
coe_trace_11.sql
SQL Tracing Apps online transactions with Event 10046 (11.0)

156971.1
coe_trace_all.sql
Turns SQL Trace ON for all open DB Sessions (8.0+)

156965.1
coe_locks.sql
Session and serial# for locked Rows (7.3+)

Templates
MetaLink
Apps Performance Bug Template

169937.1
Transaction Tuning

169938.1
Back-End Tuning

169939.1
Tech-Stack Tuning

Memory Notification: Library Cache Object loaded into SGA

2008-12-02T17:41:00.002+05:30

alert_SID.log Error.

Memory Notification: Library Cache Object loaded into SGA
Heap size 2550K exceeds notification threshold (2048K)
KGL object name :select t1.owner, t1.name, t1.queue_table, t1.queue_type, t1.max_retries, t1.retry_delay, t1.retention, t1.user_comment, t2.type, t2.object_type from all_queues t1, all_queue_tables t2 where t1.owner=:1 and t1.name=:2 and t2.owner=:3 and t1.queue_table=t2.queue_table
Sat Nov 8 03:36:15 2008
Memory Notification: Library Cache Object loaded into SGA
Heap size 2546K exceeds notification threshold (2048K)
Details in trace file /u01/11i/oracle/upgdb/10.2.0.1/admin/upg_zeus/udump/upg_ora_268966.trc

ORA-00060: Deadlock detected. More info in file /u01/11i/oracle/upgdb/10.2.0.1/admin/upg_zeus/udump/upg_ora_302372.trc.
Fri Oct 31 15:08:04 2008
ORA-00060: Deadlock detected. More info in file /u01/11i/oracle/upgdb/10.2.0.1/admin/upg_zeus/udump/upg_ora_129790.trc.
Fri Oct 31 15:08:35 2008
ORA-00060: Deadlock detected. More info in file /u01/11i/oracle/upgdb/10.2.0.1/admin/upg_zeus/udump/upg_ora_66976.trc.
Fri Oct 31 15:08:35 2008
ORA-00060: Deadlock detected. More info in file /u01/11i/oracle/upgdb/10.2.0.1/admin/upg_zeus/udump/upg_ora_196730.trc.
Fri Oct 31 15:08:37 2008
ORA-00060: Deadlock detected. More info in file /u01/11i/oracle/upgdb/10.2.0.1/admin/upg_zeus/udump/upg_ora_129790.trc.

Solutions:

SQL> SELECT a.ksppinm "Parameter",
2 b.ksppstvl "Session Value",
3 c.ksppstvl "Instance Value"
4 FROM x$ksppi a, x$ksppcv b, x$ksppsv c
5 WHERE a.indx = b.indx AND
6 a.indx = c.indx AND
7 a.ksppinm LIKE '%kgl_large_heap%';

Parameter Session Value Instance Value
--------------------------------------------------------------------------------

_kgl_large_heap_warning_threshold 2097152 2097152

Above parameter is hidden parameter. We have to change that hidden parameter.

If we using spfile, just login sql and change that parameter or Bounce the database and change the initSID.ora file.

$ sqlplus "/as sysdba"

SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;

System altered.

OR

Bounce the DB and edit the init parameter file and startup.

Then, edit the initialization parameter file and add the below line.

_kgl_large_heap_warning_threshold=8388608

Shut down and re-start the database after changes
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
SQL> show parameter _kgl_large_heap_warning_threshold
NAME TYPE VALUE
------------------------------------ -----------
_kgl_large_heap_warning_threshold integer 8388608

To perform cancel-based recovery

2008-12-01T03:22:00.002+05:30

RMAN> rman target / auxiliary sys/oracle@ROJA nocatalog

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Nov 30 23:12:56 2008

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

connected to target database: PROD (DBID=78671012)
using target database control file instead of recovery catalog
connected to auxiliary database: ROJA (not mounted)

RMAN> @/u02/oracle/visarch/clone.rcv

RMAN> run
2> {
3> allocate auxiliary channel aux1 device type disk format '/u02/oracle/visarch';
4> allocate auxiliary channel aux2 device type disk format '/u02/oracle/visarch';
5> allocate auxiliary channel aux3 device type disk format '/u02/oracle/visarch';
6> allocate auxiliary channel aux4 device type disk format '/u02/oracle/visarch';
7> duplicate target database to "ROJA";
8> }
allocated channel: aux1
channel aux1: sid=386 devtype=DISK

allocated channel: aux2
channel aux2: sid=385 devtype=DISK

allocated channel: aux3
channel aux3: sid=384 devtype=DISK

allocated channel: aux4
channel aux4: sid=383 devtype=DISK

Starting Duplicate Db at 30-NOV-08

contents of Memory Script:

{
set until scn 5965096246191;
set newname for datafile 1 to
"/u01/oramgr/PROD/db/rojadata/system01.dbf";
set newname for datafile 2 to
"/u01/oramgr/PROD/db/rojadata/system02.dbf";
set newname for datafile 3 to
"/u01/oramgr/PROD/db/rojadata/system03.dbf";
set newname for datafile 4 to
"/u01/oramgr/PROD/db/rojadata/system04.dbf";
set newname for datafile 5 to
"/u01/oramgr/PROD/db/rojadata/system05.dbf";

.
.
.
.
.
.
.
.
.

"/u01/oramgr/PROD/db/rojadata/a_txn_ind04.dbf";
set newname for datafile 406 to
"/u01/oramgr/PROD/db/rojadata/a_txn_ind05.dbf";
set newname for datafile 407 to
"/u01/oramgr/PROD/db/rojadata/a_ref02.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME
.
.
.
.
.
.
.

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 30-NOV-08

channel aux1: starting datafile backupset restore
channel aux1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oramgr/PROD/db/rojadata/system01.dbf
restoring datafile 00002 to /u01/oramgr/PROD/db/rojadata/system02.dbf
restoring datafile 00003 to /u01/oramgr/PROD/db/rojadata/system03.dbf
restoring datafile 00004 to /u01/oramgr/PROD/db/rojadata/system04.dbf
.
.
.
.
.
.

restoring datafile 00406 to /u01/oramgr/PROD/db/rojadata/a_txn_ind05.dbf
restoring datafile 00407 to /u01/oramgr/PROD/db/rojadata/a_ref02.dbf
channel aux1: reading from backup piece /u02/oracle/visarch/datafile_t672174776_s1_p1
channel aux1: restored backup piece 1
piece handle=/u02/oracle/visarch/datafile_t672174776_s1_p1 tag=TAG20081130T191256
channel aux1: restore complete, elapsed time: 00:24:57
Finished restore at 30-NOV-08
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ROJA" RESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 512
MAXINSTANCES 8
MAXLOGHISTORY 14607
LOGFILE
GROUP 1 ( '/u01/oramgr/PROD/db/rojadata/log01a.dbf', '/u01/oramgr/PROD/db/rojadata/log01b.dbf' ) SIZE 1000 M REUSE,
GROUP 2 ( '/u01/oramgr/PROD/db/rojadata/log02a.dbf', '/u01/oramgr/PROD/db/rojadata/log02b.dbf' ) SIZE 1000 M REUSE
DATAFILE
'/u01/oramgr/PROD/db/rojadata/system01.dbf'
CHARACTER SET US7ASCII

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=672190745 filename=/u01/oramgr/PROD/db/rojadata/system02.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=672190745 filename=/u01/oramgr/PROD/db/rojadata/system03.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=672190745 filename=/u01/oramgr/PROD/db/rojadata/system04.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=672190745 filename=/u01/oramgr/PROD/db/rojadata/system05.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=672190745 filename=/u01/oramgr/PROD/db/rojadata/ctxd01.dbf
.

.
.
.
.
.

datafile 406 switched to datafile copy
input datafile copy recid=41 stamp=672190747 filename=/u01/oramgr/PROD/db/rojadata/a_txn_ind05.dbf
datafile 407 switched to datafile copy
input datafile copy recid=42 stamp=672190747 filename=/u01/oramgr/PROD/db/rojadata/a_ref02.dbf

contents of Memory Script:
{
set until scn 5965096246191;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 30-NOV-08

starting media recovery

channel aux1: starting archive log restore to default destination
channel aux1: restoring archive log
archive log thread=1 sequence=6
channel aux1: restoring archive log
archive log thread=1 sequence=7
channel aux1: reading from backup piece /u02/oracle/backup/VIS_arch_3_672176329_%r.arc
ORA-19870: error reading backup piece /u02/oracle/backup/VIS_arch_3_672176329_%r.arc
ORA-19505: failed to identify file "/u02/oracle/backup/VIS_arch_3_672176329_%r.arc"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/oramgr/PROD/db/rojadata/system01.dbf'

released channel: aux1
released channel: aux2
released channel: aux3
released channel: aux4
RMAN-00571: ===========================================================
RMAN-00569: ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/30/2008 23:40:08
RMAN-03015: error occurred in stored script Memory Script
RMAN-20506: no backup of archivelog found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 7 lowscn 5965096246186 found to restore
RMAN-06025: no backup of log thread 1 seq 6 lowscn 5965096244536 found to restore

RMAN>
RMAN> **end-of-file**

RMAN> exit

Recovery Manager complete.

*********************************************************************
To perform cancel-based recovery:

1. Start SQL*Plus and connect to Oracle with administrator privileges. For example, enter:
sqlplus '/ AS SYSDBA'

2. Start a new instance and mount the database:

STARTUP MOUNT

3. Begin cancel-based recovery by issuing the following command:

If you are using a backup control file with this incomplete recovery, then specify the USING BACKUP CONTROLFILE option in the RECOVER command.

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE

--------------------------------------------------------------------------------
Note:
If you fail to specify the UNTIL clause on the RECOVER command, then you will not be able to open the database until a complete recovery is done.

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

4. Oracle applies the necessary redo log files to reconstruct the restored datafiles. Oracle supplies the name it expects to find from LOG_ARCHIVE_DEST_1 and requests you to stop or proceed with applying the log file. Note that if the control file is a backup, then you must supply the names of the online logs if you want to apply the changes in these logs.

--------------------------------------------------------------------------------
Note:
If you use an Oracle Real Application Clusters configuration, and you are performing incomplete recovery or using a backup control file, then Oracle can only compute the name of the first archived redo log file from the first thread. The first redo log file from the other threads must be supplied by the user. After the first log file in a given thread has been supplied, Oracle can suggest the names of the subsequent log files in this thread.

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

5. Continue applying redo log files until the last log has been applied to the restored datafiles, then cancel recovery by executing the following command:
CANCEL

Oracle returns a message indicating whether recovery is successful. Note that if you cancel recovery before all the datafiles have been recovered to a consistent SCN and then t rtry to open the database, you will get an ORA-1113 error if more recovery is necessary for the file. You can query V$RECOVER_FILE to determine whether more recovery is needed, or if a backup of a datafile was not restored prior to starting incomplete recovery.

6. Open the database in RESETLOGS mode. You must always reset the online logs after incomplete recovery or recovery with a backup control file. For example, enter:
ALTER DATABASE OPEN RESETLOGS;"

You copy that archivelog and change log name and apply it

cp PROD_arch_6_1_666832683.arc5 /u01/oramgr/PROD/db/tech_st/10.2.0/dbs/arch1_6_666832683.dbf
cp PROD_arch_7_1_666832683.arc6 /u01/oramgr/PROD/db/tech_st/10.2.0/dbs/arch1_7_666832683.dbf

Database is now mount stage, so controlfile created sucessfully, but database unable to open.
So we need to apply the archivelog files, you just apply two or more archive log and type cancel.

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE

ORA-00279: change 5965096245461 generated at 11/30/2008 19:12:57 needed for
thread 1
ORA-00289: suggestion :
/u01/oramgr/PROD/db/tech_st/10.2.0/dbs/arch1_6_666832683.dbf
ORA-00280: change 5965096245461 for thread 1 is in sequence #6

Specify log: {=suggested filename AUTO CANCEL}
arch1_6_666832683.dbf
ORA-00279: change 5965096246186 generated at 11/30/2008 19:38:46 needed for
thread 1
ORA-00289: suggestion :
/u01/oramgr/PROD/db/tech_st/10.2.0/dbs/arch1_7_666832683.dbf
ORA-00280: change 5965096246186 for thread 1 is in sequence #7
ORA-00278: log file 'arch1_6_666832683.dbf' no longer needed for this recovery

Specify log: {=suggested filename AUTO CANCEL}
arch1_7_666832683.dbf
ORA-00279: change 5965096246191 generated at 11/30/2008 19:38:47 needed for
thread 1
ORA-00289: suggestion :
/u01/oramgr/PROD/db/tech_st/10.2.0/dbs/arch1_8_666832683.dbf
ORA-00280: change 5965096246191 for thread 1 is in sequence #8
ORA-00278: log file 'arch1_7_666832683.dbf' no longer needed for this recovery

Specify log: {=suggested filename AUTO CANCEL}
CANCEL (Here i typed Cancel), Now recovery is canceld and Database is now consistent stage.
Then try resetlogs.
Media recovery cancelled.

SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

Finally bounce and startup the database.

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

SQL> startup

ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1264892 bytes
Variable Size 427819780 bytes
Database Buffers 633339904 bytes
Redo Buffers 11317248 bytes
Database mounted.
Database opened.

Enabling ARCHIVELOG Mode

2008-11-30T19:28:00.005+05:30

Check Archive is enabled or not

SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE
------------
NOARCHIVELOG

Set InitSID.ora on following parameter

remote_login_passwordfile=EXCLUSIVE
log_archive_dest='/u02/oracle/backup'
log_archive_format='PROD_arch_%s_%t_%r.arc'

Create Password File

orapwd file=/u01/oramgr/PROD/db/tech_st/10.2.0/dbs/orapwPROD entries=1 password=oracle

SQL> alter database archivelog;
Database altered.

SQL> alter database open;
Database altered.

V$DATABASE

Identifies whether the database is in ARCHIVELOG or NOARCHIVELOG mode and whether MANUAL (archiving mode) has been specified.

V$ARCHIVED_LOG

Displays historical archived log information from the control file. If you use a recovery catalog, the RC_ARCHIVED_LOG view contains similar information.

V$ARCHIVE_DEST

Describes the current instance, all archive destinations, and the current value, mode, and status of these destinations.

V$ARCHIVE_PROCESSES

Displays information about the state of the various archive processes for an instance.

V$BACKUP_REDOLOG

Contains information about any backups of archived logs. If you use a recovery catalog, the
RC_BACKUP_REDOLOG contains similar information.

V$LOG

Displays all redo log groups for the database and indicates which need to be archived.

V$LOG_HISTORY

Contains log history information such as which logs have been archived and the SCN range for each archived log.

Using these tables we can verify that we are infact in ARCHIVELOG mode:

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> select DEST_NAME,STATUS,DESTINATION from V$ARCHIVE_DEST;

In Oracle 10.2 and above RMAN is supported by a number of new dynamic performance views including:

V$BACKUP_ARCHIVELOG_DETAILS

V$BACKUP_ARCHIVELOG_SUMMARY

V$BACKUP_CONTROLFILE_DETAILS

V$BACKUP_CONTROLFILE_SUMMARY

V$BACKUP_COPY_DETAILS

V$BACKUP_COPY_SUMMARY

V$BACKUP_DATAFILE_DETAILS

V$BACKUP_DATAFILES_SUMMARY

V$BACKUP_PIECE_DETAILS

V$BACKUP_SET_DETAILS

V$BACKUP_SET_SUMMARY

V$BACKUP_SPFILE_DETAILS

V$BACKUP_SPFILE_SUMMARY
v$archived_log
v$archived_log

RMAN> list backup summary;
list backup by datafile;
list backup of database;
list backup of archivelog all;
list backup of controlfile;

2008-11-20T23:13:00.001+05:30

PatchSet:

1. 11i.ATG_PF.H.delta.6 (RUP 5) or above.

2. 6117031 - 11i.ATG_PF.H RUP6 SSO 10g Integration,

Check and apply all the prerequisites.
Using OracleAS 10g with the Oracle E-Business Suite
Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On

Go to FND_TOP/bin

[applmgr@sys4 bin]$ txkrun.pl -script=SetSSOReg
Enter the host name where Oracle iAS Infrastructure database is installed ? sys38.doyen.in
Enter the Oracle iAS Infrastructure database port number ? 1521
Enter the Oracle iAS Infrastructure database SID ? test
Enter the LDAP Port on Oracle Internet Directory server ? 389
Enter Oracle E-Business apps database user password ? apps
Enter Oracle iAS Infrastructure database ORASSO schema password ? orasso
Enter Oracle E-Business SYSTEM database user password ? oracle
Enter E-Business Suite existing SSOSDK schema password or choose a password to use with the new SSOSDK schema if the schema does not exist ? SSOSDK
Enter the Oracle Internet Directory Administrator (orcladmin) Bind password ? welcome99
Enter the instance password that you would like to register this application instance with ? welcome99
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /oracle/app/apps/viscomn/rgf/VIS_sys4/sso/txkSetSSOReg_Fri_Jan_4_16_00_37_2008.log
Program : /oracle/app/apps/visappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl started @ Fri Jan 4 16:01:22 2008

*** Log File = /oracle/app/apps/viscomn/rgf/VIS_sys4/sso/txkSetSSOReg_Fri_Jan_4_16_00_37_2008.log

######################## WARNING
This application works with SSOSDK version 9.0.2 or higher. If lower version
(3.0.9) of SSOSDK was installed in your system and you have a registered
partner application, this process will remove the 3.0.9 version of the SSOSDK
schema and install the 9.0.2 version.
######################## WARNING

Beginning input parameter validation for SSO registration.
Beginning loading SSO SDK into database if necessary.
Loading of SSO SDK into database completed successfully.
Input parameters validation for OID registration completed.

BEGIN SSO REGISTRATION:

Beginning to register partner application.
Partner application has been registered successfully.
Single Sign-On partner application registered successfully.

BEGIN OID REGISTRATION:

Beginning to register Application and Service containers if necessary.
Application and Service containers were created successfully.
Beginning to register application in Oracle Internet Directory.
Registration of application in Oracle Internet Directory completed successfully.
Beginning to register instance password in Oracle Internet Directory.
Registration of instance password in Oracle Internet Directory completed successfully.
Beginning to test application registration in Oracle Internet Directory.
Testing of application registration in Oracle Internet Directory completed successfully.
Beginning to register provisioning profile in Oracle Internet Directory.
Registration of provisioning profile in Oracle Internet Directory completed successfully.
Application is now registered successfully with provisioning in Oracle Internet Directory.
End of /oracle/app/apps/visappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered

[applmgr@sys4 bin]$

a. do an anonymous bind...

ldapbind -h sys38.doyen.in -p 389

b. do a superuser bind....

ldapbind -h sys38.doyen.in -p 389 -D "cn=orcladmin" -w welcome99

c. do an encrypted super user bind...

ldapbind -h sys38.doyen.in -p 389 -U 1 -D cn=orcladmin -w welcome99

d. do a specific user bind....for example:

ldapbind -h sys38.doyen.in -p 389 -D "cn=orcladmin,cn=users,dc=doyen,dc=in" -w welcome99

Exporting Application Accounts into Intermediate LDIF File

Determine which accounts to migrate

􀂃 Applications SSO Login Types (APPS_SSO_LOCAL_LOGIN) – An account will not be migrated if the user level profile value of the account is ‘LOCAL’, i.e. the account is a local account.

􀂃 Applications SSO LDAP Synchronization (APPS_SSO_LDAP_SYNC) -- An account will not be migrated if the user level profile value of the account is ‘N’, i.e. the account is marked to not to synchronize with Oracle Internet Directory.

Note: The site level profile value will be used in the cases where the user level profile value is not set.

Oracle E-Business Suite ships a number of standard accounts, such as SYSADMIN and GUEST. These accounts should not be migrated. To enforce this, the SYSADMIN and GUEST accounts are pre-seeded with Applications SSO Login Types (APPS_SSO_LOCAL_LOGIN) set to ‘LOCAL’ and Applications SSO LDAP Synchronization (APPS_SSO_LDAP_SYNC) set to ‘N’.

Administrators should check whether there are any additional accounts that should not be migrated, especially accounts with user_id less than 10 (check with: select user_name from FND_USER where user_id<10). These standard accounts can only be used for local login and cannot be used to log into Single Sign-On. Use AppsUserExport to extract user information For

example:
java oracle.apps.fnd.oid.AppsUserExport \ -v \ -dbc $FND_TOP/secure/myebiz.dbc \ -o users.txt \ -pwd welcome \ -g \ -l users.log The resulting data file and log file may contain confidential information, such as the start and end dates for a user’s account, and should therefore be secured appropriately. java oracle.apps.fnd.oid.AppsUserExport -dbc /oracle/app/apps/visappl/fnd/11.5.0/secure/VIS_sys4/vis.dbc -o /oracle/app/apps/visappl/fnd/11.5.0/secure/VIS_sys4/vis01.out -pwd apps User Export to /oracle/app/apps/visappl/fnd/11.5.0/secure/VIS_sys4/vis01.out User Export to /oracle/app/apps/visappl/fnd/11.5.0/secure/VIS_sys4/vis01.out started.. User Export completed successfully. For further details please refer to log file at: /oracle/app/apps/visappl/fnd/11.5.0/secure/VIS_sys4/vis01.out.log [oracle@sys38 ~]$ $ORACLE_HOME/bin/ldapsearch -h sys38 -p 389 -D "cn=orcladmin" -w welcome99 -b "cn=Provisioning Profiles, cn=Changelog Subscriber, cn=Oracle Internet Directory" -s sub "objectclass=*" > profiles.ldif

[oracle@sys38 ~]$ $ORACLE_HOME/bin/ldapsearch -h sys38 -p 389 -D "cn=orcladmin" -w welcome99 -s sub "orclguid=42E42E799F8C50F5E040A8C0260051FA" -b "" dn
orclApplicationCommonName=VIS,cn=EBusiness,cn=Products,cn=OracleContext,dc=doyen,dc=in

[oracle@sys38 ~]$ oidprovtool operation=disable ldap_host=sys38.doyen.in ldap_port=389 ldap_user_dn=cn=orcladmin ldap_user_password=welcome99 application_dn=orclApplicationCommonName=VIS,cn=EBusiness,cn=Products,cn=OracleContext,dc=doyen,dc=in profile_mode=BOTH

This Provisioning Profile is disabled.

Task 2: Converting Intermediate LDIF File to Final LDIF File

Before performing loading data into Oracle Internet Directory, the Oracle Internet Directory administrator needs to ensure that:

􀂃 The extracted data file is copied from the Oracle E-Business Suite instance to Oracle Internet Directory.

􀂃 If the provisioning profile has been set up for the Oracle E-Business Suite instance and the profile mode is either OUTBOUND or BOTH

To convert the intermediate LDIF file to the final LDIF format:
. Use oidprovtool with operation=DISABLE to disable the profile before the migration is started.

For example:

oidprovtool operation=disable ldap_host=sys38.doyen.in ldap_port=389 ldap_user_dn=cn=orcladmin ldap_user_password=welcome99 application_dn=orclApplicationCommonName=VIS,cn=EBusiness,cn=Products,cn=OracleContext,dc=doyen,dc=in profile_mode=BOTH

After migration is complete, update the lastchangenumber attribute of the profile:

First, find the current last change number in Oracle Internet Directory with the ldapsearch command:

ldapsearch –h sys38.doyen.in -p welcome99 -D cn=oracladmin -w welcome99 -s base -b "" "objectclass=*" lastchangenumber=2623

Next, use the following command to update the lastchangenumber attribute to the number n that was discovered in the last step:

[oracle@sys38 bin]$ oidprovtool operation=MODIFY ldap_host=sys38.doyen.in ldap_port=389 ldap_user_dn=cn=orcladmin ldap_user_password=welcome99 application_dn=orclApplicationCommonName=VIS,cn=EBusiness,cn=Products,cn=OracleContext,dc=doyen,dc=in orclLastAppliedChangeNumber=2623
The Provisioning Profile for the Application has been modified.

3. Use oidprovtool with operation=ENABLE to enable the profile.

[oracle@sys38 bin]$ oidprovtool operation=enable ldap_host=sys38.doyen.in ldap_port=389 ldap_user_dn=cn=orcladmin ldap_user_password=welcome99 application_dn=orclApplicationCommonName=VIS,cn=EBusiness,cn=Products,cn=OracleContext,dc=doyen,dc=in profile_mode=BOTH

This Provisioning Profile is enabled.

4. The intermediate LDIF file created by AppsUserExport has two variables that an Oracle Internet Directory administrator needs to instantiate using the Oracle Internet Directory ldifmigrator utility:

[oracle@sys38 bin]$ ldifmigrator "input_file=/home/oracle/mig_user/vis01.out" "output_file=data.ldif" "s_UserContainerDN=cn=users,dc=doyen,dc=in" "s_UserNicknameAttribute=uid"

Migration of LDIF data completed. All the entries are successfully migrated

Task 3: Loading Final LDIF file into Oracle Internet Directory

Once the final LDIF file has been generated, the user data is ready to be loaded into Oracle Internet Directory using the Oracle Internet Directory bulkload tool.

Before performing a bulk load:

1. Stop all OID processes before using the bulkload utility to load the LDIF file:

$ORACLE_HOME/opmn/bin/opmnctl stopall

Note the OID password, which should be the same as the instance and orcladmin passwords. You will be prompted for this when running the utility.

2. In case the oidmon or oidctl commands were used to manually start the oid proceses, you must make sure that they have stopped:

On Unix Run: $ORACLE_HOME/ldap/bin/ldapcheck

[oracle@sys38 bin]$ ./ldapcheck

Checking Oracle Internet Directory Processes ...ALL

Not Running ---- Process oidmon
Not Running ---- Process oidldapd
Not Running ---- Process oidrepld
Not Running ---- Process odisrv
No LDAP Processes are Running

3. If any other OID processes such as odisrv are still running, you must stop them manually using:

oidctl connect=test server=oidsrv instance=1 stop

You must ensure that no OID processes are running before continuing with the bulkload.sh command.

1. Run the bulkload utility with the -check and –generate options to verify that there are no duplicate users.

For example:

bulkload.sh –connect -check –generate

[oracle@sys38 bin]$ ./bulkload.sh -connect "test" -check -generate /home/oracle/orainfra/opmn/bin/data.ldif

Verifying node "test"
-----------------------------
This tool can only be executed if you know database user password
for OiD on test
Enter OiD password ::

------------------------------------------------------------------
Checking Internet Directory current schema state
------------------------------------------------------------------

-------------------------------------------------------------------
Checking and Generating Internet Directory data for bulk loading
-------------------------------------------------------------------

Schema Check Errors are logged in : /home/oracle/orainfra/ldap/log/bulkload.log

Bad Entries are logged in : /home/oracle/orainfra/ldap/load/badentry.ldif

Non-Unique Distinguished Names are logged in : /home/oracle/orainfra/ldap/log/duplicateDN.log

-------------------------------------------------------------------
Data Generated for bulk loading
-------------------------------------------------------------------

Please Remove the errors

[oracle@sys38 bin]$ ./bulkload.sh -connect "test" -check -generate /home/oracle/orainfra/opmn/bin/data.ldif

Verifying node "test"
-----------------------------
This tool can only be executed if you know database user password
for OiD on test
Enter OiD password ::

------------------------------------------------------------------
Checking Internet Directory current schema state
------------------------------------------------------------------

-------------------------------------------------------------------
Checking and Generating Internet Directory data for bulk loading
-------------------------------------------------------------------

No Schema Check Errors.

No Bad Entries found.

No Duplicate DN Entries.

-------------------------------------------------------------------
Data Generated for bulk loading
-------------------------------------------------------------------

2. Check the log file for duplicate users

If you get any Bad Entries and Duplicate DN Entries, Just remove those entries and run again setp 1.

3. If the log file indicates duplicate users, manually remove these users from the LDIF file.

4. Rerun Step 1 to verify all duplicates have been successfully removed.

5. Once all duplicates are removed, run the bulkload utility with the –load option to load the users.

For example:

bulkload.sh –connect –load

[oracle@sys38 bin]$ ./bulkload.sh -connect "test" -load /home/oracle/orainfra/opmn/bin/data.ldif

Verifying node "test"
-----------------------------
This tool can only be executed if you know database user password
for OiD on test
Enter OiD password ::
It is recommended to use -check option before generating/loading data
Do you want to continue (y/n?) [n]
y
Loading data on : "test"
===============================

------------------------------------------------------------------
Preparing Internet Directory schema for bulk data loading
------------------------------------------------------------------

------------------------------------------------------------------
Initiating bulk load...
------------------------------------------------------------------

Loading Attribute Search Catalogs..
battr_store001..
battr_store002..
battr_store003..
attr_store001..
attr_store002..
attr_store003..
c..
cn..
ctcaladmd..
ctcalcountry..
ctcalhost..
ctcalmobiletelephonetype..
ctcalorganization..
ctcalorgunit1..
ctcalorgunit2..
ctcalorgunit3..
ctcalorgunit4..
ctcalprmd..
ctcalpublishedtype..
ctcalresourcecapacity..
ctcalresourcenumber..
ctcalxitemid..
dc..
description..
employeenumber..
facsimiletelephonenumber..
generationqualifier..
givenname..
homephone..
initials..
krbprincipalname..
labeleduri..
l..
mail..
manager..
member..
middlename..
mobile..
name..
objectclass..
o..
orclaci..
orclcalendarhost..
orclcalendarresourcecapacity..
orclcalendarresourcenumber..
orclcalendarstore..
orclcertificatehash..
orclcertificatematch..
orclcommonkrbprincipalattribute..
orcldasispersonal..
orcldassearchable..
orcldasvalidatepwdreset..
orcldasviewable..
orcldbaqgeneric..
orcldbaqobjname..
orcldbaqobjowner..
orcldbaqobjtype..
orcldbaqpointerattr..
orcldbaqreglocation..
orcldbaqregnamespace..
orcldbaqregrejected..
orcldbaqregservers..
orcldbaqregsubscription..
orcldbaqregunreachable..
orcldbaqreguser..
orcldbdistinguishedname..
orcldbentroleassigned..
orcldbentuser..
orcldbglobalname..
orcldblscolumnname..
orcldblsfullname..
orcldblsgroupparent..
orcldblsnumerictag..
orcldbnativeuser..
orcldbroleoccupant..
orcldbservermember..
orcldbserverrole..
orcldbtargetuser..
orcldbtrusteddomain..
orcldbtrusteduser..
orclentrylevelaci..
orcleventtime..
orcleventtype..
orclglobalid..
orclguid..
orclhostname..
orclipaddress..
orclisenabled..
orclisvisible..
orcljazncodebase..
orcljaznjavaclass..
orcljaznpermissionactions..
orcljaznpermissiontarget..
orcljaznprincipal..
orcljaznrealmisexternal..
orcljaznsigner..
orcljaznsubscriberdn..
orclldapinstanceid..
orclldapprocessid..
orclmailaci..
orclmailaddresscategory..
orclmailemail..
orclmailfolderdn..
orclmailgroupadminmailid..
orclmailgrouphasarchive..
orclmailgroupisexternal..
orclmaillistsuspendedmember..
orclmailnewsfoldercreatetime..
orclmailnntpactivegroup..
orclmailnntplocalgroup..
orclmailnntpmoderatedgroup..
orclmailowner..
orclmailpublicdisplayname..
orclmailrenamedsharedfolder..
orclmailrulescope..
orclmailstore..
orclmailstoredn..
orclmailuserdldn..
orclnethostname..
orclnetservicename..
orclnewsgroupdn..
orclnormdn..
orclobjectguid..
orclodipagentname..
orclodipprofileexecgroupid..
orclodipprofilename..
orclownerguid..
orclrealmname..
orclreplicadn..
orclresourcename..
orclresourcetypename..
orclsamaccountname..
orclsecondaryuid..
orclservicemember..
orclservicesubtype..
orclservicetype..
orclstatus..
orclsuitetype..
orclumattendantextension..
orclumdeviceaddress..
orclumlocale..
orclumnamehash..
orcluserapplnprovstatus..
orcluserdn..
orclwirelessaccountnumber..
ou..
owner..
pager..
personalmobile..
personalpager..
postalcode..
pwdaccountlockedtime..
sn..
st..
street..
targetdn..
telephonenumber..
title..
uid..
uniquemember..
vpimmail..
x509issuer..

Loading Distinguished Name Catalog..
------------------------------------------------------------------
Performing post bulk load processing for Internet Directory schema
------------------------------------------------------------------

------------------------------------------------------------------
Creating Indexes ...
------------------------------------------------------------------

-------------------------------------------------------------
Verifying Index creation ...
-------------------------------------------------------------

All indexes created successfully

-------------------------------------------------------------
Index creation verification Done ...
-------------------------------------------------------------

-------------------------------------------------------------
Altering Index ...
-------------------------------------------------------------

-------------------------------------------------------------
Altering Index Done ...
-------------------------------------------------------------

------------------------------------------------------------------
Generating Database Statistics ...
------------------------------------------------------------------

-------------------------------------------------------------
Done.
-------------------------------------------------------------

Migrating Existing Accounts from Oracle Internet Directory to Oracle E-Business Suite Release 11i

The LDAPUserImport command-line utility takes an LDIF file generated from Oracle Internet Directory, and inserts appropriate data into the E-Business Suite schema. It can be used for bulk migration of existing accounts from Oracle Internet Directory to Oracle E-Business Suite. LDAPUserImport updates both FND and TCA schema.

Task 1: Export Oracle Internet Directory users into LDIF file Using ldifwrite

The Oracle Internet Directory ldifWrite command-line utility is used to create an LDIF file that can be loaded into the E-Business Suite schema via the LDAPUserImport command-line utility.

General Syntax:

ldifwrite –c -b -f

Example:

ldifwrite -c test -b "cn=Users,dc=doyen,dc=in" -f output.ldif

[oracle@sys38 bin]$ ldifwrite -c test -b "cn=Users,dc=doyen,dc=in" -f output.ldif
This tool can only be executed if you know database user password for OiD
Enter OiD Password ::

------------------------------------------------------------
Reading entries under BaseDN "cn=users,dc=doyen,dc=in"...
-------------------------------------------------------------

------------------------------------------------------------
1872 Entries are written to "output.ldif".
------------------------------------------------------------
There is no need to modify the output file output.ldif in any way before proceeding with Task 2.
Task 2: Import LDAP Users into Oracle E-Business Suite using LDAPUserImport

The LDAPUserImport tool is invoked from the command line.

1. Ensure the environment is set up properly: $APPL_TOP/java must be in the CLASSPATH environment variable),

2. Invoke the LDAPUserImport tool with the following syntax:

java oracle.apps.fnd.oid.LDAPUserImport \
-v \
-dbc $FND_TOP/secure/myebiz.dbc \
-f users.ldif \
-n uid \
-l users.log

For example:

[applmgr@sys4 VIS_sys4]$ java oracle.apps.fnd.oid.LDAPUserImport -v -dbc /oracle/app/apps/visappl/fnd/11.5.0/secure/VIS_sys4/vis.dbc -f /oracle/app/apps/visappl/fnd/11.5.0/secure/VIS_sys4/output.ldif -n uid -l ouput.log
LDAP user import from /oracle/app/apps/visappl/fnd/11.5.0/secure/VIS_sys4/output.ldif started..
LDAP user import completed sucessfully. For further details refer to log file at ouput.log

DBCONSOLE STATUS PENDING

2008-11-03T20:31:00.003+05:30

PROBLEM
========

-- Problem Statement:Enterprise Manager 10g - Database Control monitoring a Infrastructure Database installed with Oracle Application Server shows the database instance in Pending Status
/11i/disco10g/infraas/10.1.0.3/zeus.fti-intra.com_blinfra/sysman/recv/errors
the above path, keep on errors generated

SOLUTION
=========

-- To implement the solution, please execute the following steps::

export ORACLE_HOME=/11i/disco10g/infraas/10.1.0.3

1. Stop the EM Console and DB Control:
$ORACLE_HOME/bin/emctl stop iasconsole$ORACLE_HOME/bin/emctl stop dbconsole

2. Take backup of $ORACLE_HOME/sysman/jlib/emCORE.jar file
cd $ORACLE_HOME/sysman/jlibcp emCORE.jar emCORE.jar.orig

3. Replace the $ORACLE_HOME/sysman/jlib/emCORE.jar file in the 10.1.4.0.1 home with a $ORACLE_HOME/sysman/jlib/emCORE.jar file from a standalone 10.1.0.5.0 database home file.
Download the file from: https://metalink2.oracle.com/cgi-bin/cr/getfile.cgi?p_attid=469050.1:1
4. Remove the log files from $OH/sysman/logs and $OH/sysman/recv/errors directories

5. Make a copy of $ORACLE_HOME/bin/emctl.pl
cd $ORACLE_HOME/bincp emctl.pl emctl.pl.orig

6. Edit $ORACLE_HOME/bin/emctl.pl and change references to 10.1.0.3.0 to 10.1.0.5.0; there are three places that the 10.1.0.3.0 reference must be changed to 10.1.0.5.0 as follows:

Metalink Note Id: 469050.1

output is in pdf format the following error is encountered.

2008-10-22T00:46:00.003+05:30

REP-3000: Internal error starting Oracle Toolkit
Xlib: No protocol specified
ERROR ENCOUNTERED :

While Running the report ex :Doyen Ennore Activity Report (Daily) and the output is in pdf format the following error is encountered.

Error in the log file:

Xlib: connection to "dbserv2:0.0" refused by server
Xlib: No protocol specified
Xlib: connection to "dbserv2:0.0" refused by server
Xlib: No protocol specified
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit

Solution:

Enter in to the Node where the Report is Running and can also done in all the nodes

Please check VNC server start or not. If down, start vnc and let try.

STEP 1 : Login as user root.
STEP 2 : export DISPLAY=localhost:0.0
STEP 3 : xhost +
STEP 4 : To Check the Display put the following : echo $DISPLAY
STEP 5 : We can also check by entering in as any other user

Note :Before settting the DISPLAY check the XML file in APPL_TOP/ADMIN and inside the xml file see the parameter DISPLAY = "hostname:0.0" or some thing . this shold be same as when we give echo $DISPLAY

Then try
1. xhost +
2. xclock

IZU_TOP GONE/LOST AFTER AUTOCONFIG UPGRADE

2008-10-20T21:50:00.001+05:30

Txk Rollup Patch S (Patch 6372396) Removes Izu_top From Context File

Solution

If you forget to apply this 7126196 before applying this patch 6372396 or TXK-S.
The IZU_TOP will not be there.

To implement the solution, please execute the following steps:

- Try to apply patch 7126196 before applying patch TXK-S, if TXK-S is already applied then

1. add entry to $APPL_TOP/admin/topfile.txt
izu

2. Apply patch 7126196

Note:

Customers who are planning to apply patch TXK AUTOCONFIG AND TEMPLATES ROLLUP
PATCH S (6372396) and have manually added product tops should apply this patch
(7126196) before applying patch 6372396 to preserve their manually added
product tops.

eulapi -CONNECT EUL_US/EUL_US@upg -AUTO_UPGRADE

2008-10-15T00:23:00.003+05:30

Database Error - ORA-02289: sequence does not exist

eulapi -CONNECT EUL_US/EUL_US@upg -AUTO_UPGRADE
-connect <**********>
-auto_upgrade
Database Error - ORA-02289: sequence does not exist

I recommend you to clean up the failed upgraded user because unnecessary object
s might remains.

Drop eul schema and import from your exported backup.

1) drop user eul_us cascade
2) Create eul_us again
3) Asign the access to eul_us (connect access, create table, etc)
4) Import the file you generated using imp command

imp EUL_US/EUL_US file=pre_10g_upgrade_eul_backup.dmp

Also, please consider the following:
Can you please make sure that EULowner in your new database has the following
privileges (before the import of the data from old database):

create procedure
create session
create table
create view
create sequence

grant create procedure, create session, create table, create view, create sequence to EUL_US;

Then run the -AUTPUPGRADE

bash-2.05b$ eulapi -CONNECT EUL_US/EUL_US@upg -AUTO_UPGRADE
-connect <**********>
-auto_upgrade
Command completed.

Discoverer 10g Installation and Migration Plan

2008-10-12T11:14:00.003+05:30

Oracle Apps DBA: Discoverer 10g Installation and Migration Plan

http://www.oracle.com/technology/documentation/discoverer.html

How To Setup Web Services Integration with BI Publisher and Discoverer Doc ID: Note:459853.1

Troubleshooting Login Problems in Oracle Applications 11i RDBMS Checks

2008-09-12T19:43:00.004+05:30

1. Check the GUEST user information.

a. Run following SQL:

select user_name, start_date, end_date
from fnd_user
where user_name = 'GUEST';

This should return one row, end_date should be NULL or in advance of today's date, and start_date should be before today's date.

b. Validate the GUEST username/password combinations from the DBC file.

Using the GUEST_USER_PWD value in the DBC file (see step 2) run the following sql:

select fnd_web_sec.validate_login('GUEST',' ') from dual ;

This should return Yes

If this returns N, then do:

select fnd_message.get from dual;

This should give a reason why the validation failed, or an error message.
If this fails with a database error, confirm the problem is not specific to the GUEST user.

Redo the SQL command with a different userid (like sysadmin)

select fnd_web_sec.validate_login('SYSADMIN','') from dual;

Again, this command should return 'Y' if it is working OK.

If not, you should reload the jar files to the database using adadmin.

2. Run the following script to ensure there are no invalid objects:

select owner, object_name, object_type
from all_objects
where status != 'VALID'
order by owner, object_type, object_name;

Ideally, this should return no rows, but some invalid objects may be acceptable, depending on what they are.

3. Check Tablespace free space:

Ensure that the database tablespaces have not run out of room. This can result in '-1' errors and/or 'Session expired' errors if the system cannot add data to the ICX tables. To test that rows can be succesfully inserted, you can run the script below:

REM Start of script
insert into icx_sessions (session_id, user_id, created_by, creation_date,last_updated_by,last_update_date)
values (-99999, -99, -1, sysdate, -1, sysdate)
/

insert into icx_failures (created_by, creation_date,last_updated_by, last_update_date) values (-1, sysdate, -1, sysdate)
/

rollback
/

REM - End of script

Note - ensure these two insert statements are rolled back - you do not want these dummy records saved.

4. Review your Alert.log.

Does the RDBMS alert log show any errors? What are they? Report them in a TAR.

5. Review any database trace files.

cd to the directory specified by user_dump_dest in the init.ora file.&nbttempt at login may create a .trc file

6. Validate the FND_NODES table:

Run the following sql:

select NODE_NAME, NODE_ID , SERVER_ID , SERVER_ADDRESS from FND_NODES;

Each SERVER_ID and NODE_ID should be unique.

The Node Name for all servers involved for the instance should appear here. We typically expect this to be e hostname or virtual hostname (alias), not the IP address. If the servers do not appear, use OAM to register them.

The SERVER_ADDRESS is optional, but if present should reflect the IP of the host. If necessary, update the IP using the system administrator responsibility.

For 11.5.2 – 11.5.9 this should return 56 rows.
For 11.5.10 this should return 131 rows.
(11.5.10+) Note: in 11.5.10 the required plsql patckages can be quickly enabled

using the script: $FND_TOP/patch/sql/txkDisableModPLSQL.sql Y

7. Validate the FND_ENABLED_PLSQL table Run the script in Appendix B. For 11.5.2 – 11.5.9 this should return 56 rows. For 11.5.10 this should return 131 rows. (11.5.10+)

Note: in 11.5.10 the required plsql packages can be quickly enabled using the script: $FND_TOP/patch/sql/txkDisableModPLSQL.sql Y :

8. Validate the 'ICX_SESSIONS_S' synonym

This should be shown as owned by ICX, if not, drop the synonym and run adadmin to regenerate grants and synonyms.

9. Ensure ICX module is showing as an "Installed" module.

Run "adutconf.sql" to check this, particularly important to check if migrating to 11i from previous release of Applications.

10. Validate the ICX_PARAMETERS table.

Run the following SQL:

select count(*) from icx_parameters;

This should only return one row.

11. Check for Bug 3275654

Run the following SQL:

SELECT c.function_id, nvl(b.prompt,c.user_function_name) prompt,c.TYPE,a.menu_id from
fnd_responsibility_vl a,
fnd_menu_entries_vl b,
fnd_form_functions_vl c
where a.responsibility_id=21584
and a.menu_id=b.menu_id
and b.function_id=c.function_id
and c.type in ('WWW','WWK','SERVLET','JSP','FORM','INTEROPJSP');

This should only return one row. If not, apply Patch 3275654

12. Oracle 8i ONLY do the following sql:

select fnd_crypto.SmallRandomNumber from dual;

If this errors with: ORA-28235: algorithm not available
Then make sure you have the file $ORACLE_HOME/lib/naeet.o (7112 bytes) in place.
If not, you need to get the file from a known good source (like another instance or from the CD). Again use the size of the file to validate.

Next relink the Oracle Executables:

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk install

$ORACLE_HOME/bin/genclntsh.sh

OA Framework Checks
These are only applicable to OA Framework 5.7 and above. (11.5.9+)

13. Disable all personalizations on the homepage

Run the following sql:

set serverout on;
exec jdr_utils.listcustomizations(‘/oracle/apps/fnd/framework/navigate/webui/HomePG’);

If this returns any rows then you have personalizations.
Disable your personalizations by logging into forms directly and setting the profile option:

Disable Self Service Personal = Yes.

Then retest the login.

If the homepage works, you need to remove your “bad” personalization.

See Note 304670.1

14. You can turn on OA Framework diagnostics logging in several ways Please refer to Note 139863.1, section 4 Profile Options Reference for more information, if required. Set the following profile options at USER level for one Applications user. It is important this is setup for one user only. You can launch Core Forms directly to gain access to the profile options, as you may not be able to login if you are reading this note!

Name Value
---------------------------------------------
FND: Debug Log Enabled Yes
FND: Debug Log Filename /tmp/OAF_Debug.txt
FND: Debug Log Module %
FND: Debug Log Level STATEMENT

Login to Applications using the Apps Username you specified above. Any error or problem you experiance will still occur, but the file /tmp/OAF_Debug.txt should be created with some diagnostics information. Please upload this file to Oracle Support for further analysis. After you have created this diagnostics file, you should disable logging by setting the USER level profile option listed below:

Name Value
---------------------------------------------
FND: Debug Log Enabled No

Detailed checks
==============

Note: It is recommended that you have a current backup your system and have no users on the system while performing these checks/tests.

15. Enable detailed logging in iAS

Follow the steps in Appendix C to enable detailed logging for iAS.
Review the logs for errors.

16.Temporarily enable iAS to use symbolic links.

Replace all occurrences of

'Option -FollowSymLinks'
for

'Option +FollowSymLinks'
in

$IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf
and

$IAS_ORACLE_HOME/Apache/Apache/conf/httpd_pls.conf

and bounce apache. If this is the issue, you should then go back and implement the changes via autoconfig. The value from this is controllable from your Apps Context, see s_options_symlinks .
17. Clear the iAS cache.

To clear the jsp & modplsql caches either rename or delete the sub-directories below following directories and restart apache. This will clear out the compiled JSP classes and cached modplsql modules causing them to be automatically recompiled next time they are accessed.

rm -Rf $OA_HTML/_pages/*
rm -Rf $COMMON_TOP/_pages/*
rm -Rf $IAS_ORACLE_HOME/Apache/modplsql/cache/*

Note: Depending on your configuration and patch level all directories may not exist.

18. Check the sqlnet.ora setup in the database Oracle Home.

Edit the

$ORACLE_HOME/network/admin/sqlnet.ora

Is tcp.validnode_checking enabled (i.e. = yes)? If so, make sure the parameter tcp.invited_nodes contains an entry for all the nodes involved in your configuration. This parameter, in conjunction with tcp.validnode_checking determines which clients can connect to the database.

Or you can temporarily disable node checking by removing the tcp.validnode_checking and retest. This is enabled for security reasons.

19. Modify AppsLocalLogin.jsp to trap exceptions.

If you get java error while using the login page like NoClassDefFound or NullPointerException, we need to trap the context of the message.

Backup and edit your:

$OA_HTML/AppsLocalLogin.jsp.

On the line that reads

} catch(Exception e) {}
Change to:

} catch(Exception e) {
} catch(Throwable t) {
System.err.println("OSS: Caught throwable in AppsLocalLogin.jsp : " +t.toString()); t.printStackTrace();
}

Then bounce Apache and reload the page and more detail should show up in the OACoreGroup.0.stderr file.

< dbc="

20. Check file permissions are not causing any problems.

Check file permissions are appropriate. In particular, the liboci806jdbc.so (.sl on HP, .DLL on NT) shared library should have read, write and execute permissions. It may be advisable to temporarily change all permissions in $JAVA_TOP to read, write and execute to see if it resolves the problem. On UNIX, you can use the command 'chmod -R 777 $JAVA_TOP', assuming $JAVA_TOP has been set correctly in your environment.

21. Regenerate JAVA_TOP:

Ensure you have a full backup of your system! To run this process, run adadmin and select Maintain Applications Files then Copy Files to Destinations.

22. Generate database trace and SQL*Net traces.

To set-up SQL*Net Trace on the Web Server set

TRACE_LEVEL_CLIENT = 16
in the

$TNS_ADMIN/SQLNET.ORA

file. This should be in the iAS file system and not in the 8.0.6. Oracle Home. By default the SQL*Net trace file will be called 'sqlnet.trc'.

Troubleshooting Login Problems IAS Checks

2008-09-10T23:51:00.005+05:30

You can check your version by doing:

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version

1. Validate TNS Connectivity

a. Make sure you can TNSPING and sqlplus the database alias used from the APPL_TOP (i.e. After running APPSORA.env). Do:

tnsping [sid]
sqlplus appsun/appspw
sqlplus appsun/appspw@[sid]

Also, validate that APPLSYSPUB/PUB can connect

b. Change to the $IAS_ORACLE_HOME, run the [sid]_[host].env file.

This will set the $ORACLE_HOME to be iAS.
Now check that you can TNSPING and sqlplus the database alias.

2. Determine the DBC file in use and make sure it is valid:

a. (11.5.9+) Run the profile option query provided in Appendix A when prompted for profile_option_name enter: APPS_DATABASE_ID.
If this returns a value, then this is the DBC file name that Apps is expecting to use.
Otherwise do:

select host_name'_'instance_name from v$instance;

b. Validate the OS location & permissions of the dbc file. Do:

ls –al $FND_SECURE/*.dbc (11.5.10+).

If $FND_SECURE is not set, then the dbc filebr> This should return the value from step 1ad.
The permissions on the file should be 644 and it should be owned my the “applmgr” user.

c. Verify the contents of the dbc file with the AdminAppServer utility. Do:

java oracle.apps.fnd.security.AdminAppServer appsun/appspw STATUS DBC=[path to dbc $FND_SECURE]/[dbc_name].dbc

This should return STATUS: VALID and the current status of AUTHENTICATION: [SECURE/ON/OFF/null] among other values.

d. Validate the autoconfig context file (11.5.8+) uses the correct dbc file.

Your context file is located in $APPL_TOP/admin and is typically named [SID]_[host].xml. Review the value for s_dbc_file_name, it should match the dbc just tested in 1c.

If any of this errors you should run autoconfig and/or $COMMON_TOP/admin/install/adgendbc.sh appsus appspw and retest (this will require iAS restart)

3. Is the web server running and able to render static html?

a. Are you able to access the page:

http:// :/aplogon.html

b. If not, then do:

ps –fu [applmgr] grep http
(or ps –fu [applmgr] grep http wc –l )

This should return at least 5 http processes running … otherwise you webserver may not be started…Make sure you are using the Oracle provided start script in:

$COMMON_TOP/admin/scripts/[SID]_[host]

If these tests fail you need to review your iAS installation and/or log a TAR.

4. (11.5.2-11.5.9) Check that the CGI environment and mod_plsql is functioning

a. Run the following URL:
http://:/pls//FND_WEB.PING

If you are unable to run the procedure below because of an 'internal error' or a 'cannot find host' or a similar error, then it could indicate that there is a problem with the PLSQL Configuration. Failures here may indicate problems with mod_plsql…Follow Note 116715.1 - How to Enable Logging for the PL/SQL Gateway. Redo the test and log a tar with the logs attached.

Or this may be a result of a RDBMS issue (For example - invalid packages, rdbms crashed)…See RDBMS section below.

b. Validate the APPS password used by the plsql gateway.

The password may be stored as clear text as a parameter (password= APPSpw) in
$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
If the password is encrypted in the file, update the parameter:

administrators = system
to be
administrators = all
Then navigate to:
http://:/pls//admin_/

Select the Gateway Database Access Descriptor Settings link
Select the Edit icon next to the Database Access Descriptor Name which matches your SID
Make sure the Oracle User Name = APPS
Enter the Apps user password in the Oracle Password field.
Make sure the Oracle Connect String is the SID for the instance.
If you made any changes here you will have to review your autoconfig context file to make sure the changes are permanent.

(11.5.10) After validating the above items, you may still get 'Forbidden - You don't have permission to access /pls//fnd_web.ping' on this server.” This may be by design for enhanced security. Please skip to the next test.

5. Ensure that JDK is installed correctly & is a certified version.

a. Get the value of wrapper.bin in:

$iAS_ORACLE_HOME/Apache/Jserv/etc
This will either point directly to the java executable in use or to $iAS_ORACLE_HOME/Apache/Apache/bin/java.sh.
If this points to the java.sh go to step 5b…otherwise skip to step 5c.

b.Open the java.sh File under $iAS_ORACLE_HOME/Apache/Apache/bin. In this file and you will find path to java executable in variable "JSERVJAVA"

c. Use the absolute path to the java executable and do:
/absolute/path/to/java –version

e. Check that the version returned is certified by using the certify website on Metalink.
Assuming this returns a supported version of JDK. Use the following notes to validate your JDK installation (i.e. that all required patches, autoconfig templates, etc have been completed):
Note 304099.1 => if using J2SE Version 5.0

Or

Note 246105.1 => if using J2SE 1.4

OR

Note 130091.1 => if using JDK 1.3

6. Use the following programs to verify the installation and check that the servlets are functioning.

a. http(s)://:/servlets/IsItWorking
(11.5.10) This may fail with:

Forbidden You don't have permission to access /servlets/IsItWorking on this server.
This is due to enhanced security delivered with the autoconfig templates.
Please try test 4b instead.

b.http(s)://:/servlets/Hello

If this one fails, this indicates an issue with your Jserv set-up. You then need to follow Note 230688.1 to drill down into this problem.

7. Validate that jsp work.

a. http(s)://:/OA_HTML/jsp/fnd/aoljtest.jsp

If this one fails to render, this indicates an issue with your Jserv set-up. You then need to follow Note 230688.1 to drill down into this problem.Otherwise you enter the values requested, and follow the link at the bottom of the first page to run through this set of diagnostic tests. Report all tests that fail in a TAR.

Note: The initial page of this test may show some "missing" files.
Depending on your configuration the following missing files are acceptable:

apps.zip (is normal to be missing since it has been exploded on $JAVA_TOP (ref : Note 220188.1 ))
iAS/mp/jlib/opreopi-rt.jar (Used for Oracle Personalization. Can be ignored if you are not using MP.)
iAS/mp/jlib/dmtutil.jar (Used for Data Mining)
iAS/dm/jlib/odmapi.jar (Used for Data Mining - If you are using Data Mining, and these are listed as missing, please see Note 281739.1 )
iAS/portal30/jpdk/lib/partnerApp.jar (If you are not using Portal, this can be ignored.)

8. Check the "session.topleveldomain" setting in the

$IAS_ORACLE_HOME/Apache/Jserv/etc/zone.properties
This should match the domain you are using as defined in the SESSION_COOKIE_DOMAIN column in ICX_PARAMETERS table.

From sqlplus do:

select SESSION_COOKIE_DOMAIN from ICX_PARAMETERS;

Notes: It is acceptable to have SESSION_COOKIE_DOMAIN set to null
You MUST have a valid domain that is composed of 2 or more components (see Bug 2510732). I.e: .oracle is an INVALID domain, but .oracle.com IS a valid domain.

adaimgr AutoUpgrade

2008-09-10T01:24:00.002+05:30

After 8i to 9i Migration, The steps to be followed.

************* Start of AutoUpgrade session *************

AutoUpgrade version: 11.5.0
AutoUpgrade started at: Thu Apr 10 2008 09:53:09

APPL_TOP is set to /u01/11i/uat/applmgr/uatappl

NLS_LANG value from the environment is : American_America.WE8ISO8859P1
NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.WE8ISO8859P1

It is critical that your Oracle Applications, RDBMS and related tools are
compatible and certified combinations. If you are uncertain whether a
combination is certified please contact Oracle Support Services.

Are you certain you are running a certified release combination [No] ? Yes

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ? No

Please enter the batchsize [1000] : 1000

Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [uat] : uat_zeus

NOTE: If you do not have or choose not to have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.

Do you currently have or want to install files used for installing or upgrading
the database in this APPL_TOP [YES] ? YES

Do you currently have or want to install Java and HTML files for HTML-based
functionality in this APPL_TOP [YES] ? YES

Do you currently have or want to install Oracle Applications forms files
in this APPL_TOP [YES] ? YES

Do you currently have or want to install concurrent program files
in this APPL_TOP [YES] ? YES

Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [zeus] : uat_zeus_appltop

You are about to install or upgrade Oracle Applications product tables
in your ORACLE database 'uat'
using ORACLE executables in '/u01/11i/uat/applmgr/uatora/8.0.6'.

Is this the correct database [Yes] ? Yes

AutoUpgrade needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema: *****

Connecting to SYSTEM......Connected successfully.

There exists one FND_PRODUCT_INSTALLATIONS table.
AutoUpgrade will upgrade the existing product group.

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] : *****

AutoUpgrade is verifying your username/password.
Connecting to APPLSYS......Connected successfully.

The status of various features in this run of AutoUpgrade is:

<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE No 1 -1 Y N N Y N N
PREREQ No 6 -1 Y N N Y N N
CONCURRENT_SESSIONS No 2 -1 Y Y N Y Y N
PATCH_TIMING No 2 -1 Y N N Y N N
PATCH_HIST_IN_DB No 6 -1 Y N N Y N N
SCHEMA_SWAP No 1 -1 Y N N Y Y N

Connecting to SYSTEM......Connected successfully.

Connecting to APPLSYS......Connected successfully.

Identifier for the current session is 1

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

Reading database to see what industry is currently installed.

Oracle Applications is currently installed for Commercial or for-profit use.

Do you wish to:
1) Continue to use Oracle Applications for Commercial or for-profit use.
2) Convert Oracle Applications to government, education or
not-for-profit use

Enter your choice [1] : 1

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following languages are installed:

Code Language Status
---- --------------------------------------- ---------
US American English Base
ESA Latin American Spanish Install

Reading language information from applESA.txt ...

Your base language will be AMERICAN.

Your other languages to install are: LATIN AMERICAN SPANISH

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Connecting to SYSTEM......Connected successfully.

Connecting to APPLSYS......Connected successfully.

Connecting to SYSTEM......Connected successfully.

Reading database for information about how products depend on each other.
Connecting to APPLSYS......Connected successfully.

Reading topfile.txt ...

Saving product information.
Connecting to SYSTEM......Connected successfully.

Connecting to APPLSYS......Connected successfully.

Connecting to APPS......Connected successfully.

Connecting to SYSTEM......Connected successfully.

Saving task information.

AutoUpgrade Main Menu
--------------------------------------------------

1. Choose database parameters

2. Choose overall tasks and their parameters

3. Run the selected tasks

4. Exit AutoUpgrade

* Please use License Manager to license additional
* products or modules after the upgrade is complete.

Enter your choice : 1

AutoUpgrade - Choose database parameters

- O - - S - --- M --- --- I --- --- D ---
Product Action ORACLE Sizing Main Index Default
# Name User ID Factor Tablespace Tablespace Tablespace
-- ---------------------- - ------- ------ ---------- ---------- ----------
1 Application Object Lib U APPLSYS 100 AOLD AOLX AOLD
2 Application Utilities U APPLSYS 0 AOLD AOLX AOLD
3 Applications DBA U APPLSYS 0 AOLD AOLX AOLD
4 Alert U APPLSYS 100 AOLD AOLX AOLD
5 Global Accounting Engi I AX 100 AXD AXX AXD
6 Common Modules-AK I AK 100 AKD AKX AKD
7 Subledger Accounting S XLA 100 XLAD XLAX XLAD
8 General Ledger U GL 100 GLD GLX GLD

There are 209 Oracle Applications. Enter U/D to scroll up/down.

Note: This will display all the tablespace

- To change a database parameter for a product;
INCLUDE the LETTER ABOVE the COLUMN you want to change
U / D / T / B - Press up/down/top/bottom to see other products
[Return] - To return to the AutoUpgrade Main Menu

Enter your choice (for example, 1M) :

AutoUpgrade error:

APPLSYSD
APPLSYSX

The above tablespaces do not exist in your database.
Please either create the missing tablespaces or change your
tablespace selection to exclude these tablespaces.

Review the messages above, then press [Return] to continue.

AutoUpgrade - Choose database parameters

- O - - S - --- M --- --- I --- --- D ---
Product Action ORACLE Sizing Main Index Default
# Name User ID Factor Tablespace Tablespace Tablespace
-- ---------------------- - ------- ------ ---------- ---------- ----------
39 Applications Shared Te S APPLSYS 100 APPLSYSD APPLSYSX AOLD
40 Enterprise Asset Manag EAM 100 EAMD EAMX EAMD
41 Transportation Executi FTE 100 FTED FTEX FTED
42 Public Sector Financia IGI 100 IGID IGIX IGID
43 Internet Procurement E ITG 100 ITGD ITGX ITGD
44 Inventory Optimization MSR 100 MSRD MSRX MSRD
45 Product Development IPD 100 IPDD IPDX IPDD
46 Product Development In ENI 100 ENID ENIX ENID

There are 209 Oracle Applications. Enter U/D to scroll up/down.

- To change a database parameter for a product;
INCLUDE the LETTER ABOVE the COLUMN you want to change
U / D / T / B - Press up/down/top/bottom to see other products
[Return] - To return to the AutoUpgrade Main Menu

Enter your choice (for example, 1M) : 39M

Enter the ORACLE tablespace name where you wish to store
Applications Shared Technology tables in ORACLE username APPLSYS [APPLSYSD] : AOLD

Connecting to APPLSYS......Connected successfully.

AutoUpgrade - Choose database parameters

- O - - S - --- M --- --- I --- --- D ---
Product Action ORACLE Sizing Main Index Default
# Name User ID Factor Tablespace Tablespace Tablespace
-- ---------------------- - ------- ------ ---------- ---------- ----------
33 Report Manager FRM 100 FRMD FRMX FRMD
34 Activity Based Managem ABM 100 ABMD ABMX ABMD
35 Balanced Scorecard BSC 100 BSCD BSCX BSCD
36 SEM Exchange EAA 100 EAAD EAAX EAAD
37 Value Based Management EVM 100 EVMD EVMX EVMD
38 Strategic Enterprise M FEM 100 FEMD FEMX FEMD
39 Applications Shared Te S APPLSYS 100 AOLD APPLSYSX AOLD
40 Enterprise Asset Manag EAM 100 EAMD EAMX EAMD

There are 209 Oracle Applications. Enter U/D to scroll up/down.

- To change a database parameter for a product;
INCLUDE the LETTER ABOVE the COLUMN you want to change
U / D / T / B - Press up/down/top/bottom to see other products
[Return] - To return to the AutoUpgrade Main Menu

Enter your choice (for example, 1M) : 39I

Enter the ORACLE tablespace name where you wish to store
Applications Shared Technology indexes in ORACLE username APPLSYS [APPLSYSX] : AOLX

Connecting to SYSTEM......Connected successfully.

Connecting to APPLSYS......Connected successfully.

AutoUpgrade - Choose database parameters

- O - - S - --- M --- --- I --- --- D ---
Product Action ORACLE Sizing Main Index Default
# Name User ID Factor Tablespace Tablespace Tablespace
-- ---------------------- - ------- ------ ---------- ---------- ----------
33 Report Manager FRM 100 FRMD FRMX FRMD
34 Activity Based Managem ABM 100 ABMD ABMX ABMD
35 Balanced Scorecard BSC 100 BSCD BSCX BSCD
36 SEM Exchange EAA 100 EAAD EAAX EAAD
37 Value Based Management EVM 100 EVMD EVMX EVMD
38 Strategic Enterprise M FEM 100 FEMD FEMX FEMD
39 Applications Shared Te S APPLSYS 100 AOLD AOLX AOLD
40 Enterprise Asset Manag EAM 100 EAMD EAMX EAMD

There are 209 Oracle Applications. Enter U/D to scroll up/down.

- To change a database parameter for a product;
INCLUDE the LETTER ABOVE the COLUMN you want to change
U / D / T / B - Press up/down/top/bottom to see other products
[Return] - To return to the AutoUpgrade Main Menu

Enter your choice (for example, 1M) :

Connecting to SYSTEM......Connected successfully.

Saving your choices...
Done.

Backing up restart files, if any......Done.

AutoUpgrade Main Menu
--------------------------------------------------

1. Choose database parameters

2. Choose overall tasks and their parameters

3. Run the selected tasks

4. Exit AutoUpgrade

* Please use License Manager to license additional
* products or modules after the upgrade is complete.

Enter your choice : 2

AutoUpgrade - Choose overall tasks and their parameters

# Task Do it? Parameters
-- ------------------------------------------ ------ --------------------
1 Verify files necessary for upgrade YES
2 Install or upgrade database objects YES

There are 2 tasks. Enter U/D to scroll up/down.

- To change YES to NO or NO to YES
(You cannot change a task marked with a *)
P - To change the parameters of a task
U / D - To page up/down to see other tasks
[Return] - To return to the AutoUpgrade Main Menu

Enter your choice (for example 2 or 2P) :

Saving your choices...
Done.

Backing up restart files, if any......Done.

AutoUpgrade Main Menu
--------------------------------------------------

1. Choose database parameters

2. Choose overall tasks and their parameters

3. Run the selected tasks

4. Exit AutoUpgrade

* Please use License Manager to license additional
* products or modules after the upgrade is complete.

Enter your choice : 3

Connecting to APPLSYS......Connected successfully.

Connecting to SYSTEM......Connected successfully.

Connecting to APPS......Connected successfully.

AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 992 workers.
Oracle recommends that you use between 24 and 48 workers.

Enter the number of workers [24] : 24

Now process will start

Complete Upgrade Steps on 11.0.3 to 11i Upgrade

2008-09-10T01:04:00.004+05:30

bash-2.05b$ echo $ORACLE_HOME
/u01/app/oracle/product/806

bash-2.05b$ echo $ORACLE_SID
dev

bash-2.05b$ echo $PATH
/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin:.:/u01/app/oracle/product/806/bin::/u01/app/oracle/product/806/bin:/u01/app/oracle/product/806/bin

b-2.05b$ echo $LD_LIBRARY_PATH
/u01/app/oracle/local/java/jre1.1.6/lib:/u01/app/oracle/product/806/lib:

bash-2.05b$ svrmgrl

Oracle Server Manager Release 3.0.6.0.0 - Production

(c) Copyright 1999, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.6.3.0 - Production
PL/SQL Release 8.0.6.3.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup nomount pfile=/u01/app/oracle/product/806/dbs/initdev.ora
ORACLE instance started.
Total System Global Area 1919251520 bytes
Fixed Size 50240 bytes
Variable Size 1069846528 bytes
Database Buffers 838860800 bytes
Redo Buffers 10493952 bytes
SVRMGR> @/u01/app/oracle/product/bmcntl.sql
Statement processed.

SVRMGR> ALTER DATABASE OPEN RESETLOGS;
Statement processed.

SVRMGR> SELECT STATUS,LOGINS,INSTANCE_NAME FROM V$INSTANCE;
STATUS LOGINS INSTANCE_NAME
------- ---------- ----------------
OPEN ALLOWED dev
1 row selected.

Sys Passwd Change
orapwd file=$ORACLE_HOME/dbs/orapwdev password=oracle entries=5

Configure Tnsnames and Listeners

Subject: Migrating Apps Release 11.0 from UNIX Host To A Second UNIX Host
Doc ID: Note:74838.1

select distinct LOGFILE_NODE_NAME from fnd_concurrent_requests;
select distinct OUTFILE_NODE_NAME from fnd_concurrent_requests;

SVRMGR> select distinct LOGFILE_NODE_NAME from fnd_concurrent_requests;
LOGFILE_NODE_NAME
------------------------------
Atlas

update fnd_concurrent_requests set LOGFILE_NODE_NAME='instancezu'
where LOGFILE_NODE_NAME='atlas'

SVRMGR> select distinct LOGFILE_NODE_NAME from fnd_concurrent_requests;
LOGFILE_NODE_NAME
------------------------------
instancezu

2 rows selected.

SVRMGR> select distinct OUTFILE_NODE_NAME from fnd_concurrent_requests;
OUTFILE_NODE_NAME
------------------------------
atlas

update fnd_concurrent_requests set OUTFILE_NODE_NAME='instancezu'
where OUTFILE_NODE_NAME='atlas'

SVRMGR> update fnd_concurrent_requests set OUTFILE_NODE_NAME='instancezu'
where OUTFILE_NODE_NAME='atlas';

18313 rows processed.

SVRMGR> select distinct OUTFILE_NODE_NAME from fnd_concurrent_requests;
OUTFILE_NODE_NAME
------------------------------
instancezu

OLD_HOST
/u01/app/applmgr/1103/prod/admin/logprod/l31706384.req
/u01/app/applmgr/1103/prod/admin/outprod/INVMANG.31706384

NEW_HOST
/u01/app/applmgr/1103/dev/admin/logdev
/u01/app/applmgr/1103/dev/admin/outdev

LOGFILE_NAME

update fnd_concurrent_requests set
LOGFILE_NAME=replace(LOGFILE_NAME,'/u01/app/applmgr/1103/prod/admin/logprod/','/u01/app/applmgr/1103/dev/admin/logdev')

OUTFILE_NAME

update fnd_concurrent_requests set
OUTFILE_NAME=replace(OUTFILE_NAME,'/u01/app/applmgr/1103/prod/admin/outprod','/u01/app/applmgr/1103/dev/admin/outdev')

FND_CONCURRENT_PROCESSES

The logfile name of the concurrent managers is stored in
fnd_concurrent_processes.LOGFILE_NAME

The nodename of the concurrent managers is stored in
FND_CONCURRENT_PROCESSES.NODE_NAME

select distinct(NODE_NAME) from fnd_concurrent_processes;

update fnd_concurrent_processes set NODE_NAME = 'instancezu';

SVRMGR> select distinct(NODE_NAME) from fnd_concurrent_processes;
NODE_NAME
------------------------------
Atlas

1 row selected.

SVRMGR> update fnd_concurrent_processes set NODE_NAME = 'instancezu';
63 rows processed.

SVRMGR> select distinct(NODE_NAME) from fnd_concurrent_processes;
NODE_NAME
------------------------------
instancezu
1 row selected.

update global_name set global_name='DEV.WORLD' where global_name='PROD.WORLD'

/u01/app/applmgr/1103/dev/html/html/US
Change PROD to DEV
ICXUDUL_DEV.htm

2.0 Pre Upg tasks on 11.0.3 instance

2.0.1. Apply the Patch 1268797
cd $FND_TOP/patch/110/sql
sqlplus / @afstatrn.sql True

1- sqlplus applsys/xxxx@afstatdr.sql applsys xxxx
2- sqlplus applsys/xxxxx @afstatsg.sql oracle apps
3- imp parfile=afstats2.dat userid=applsys/xxxxxx
Or
3-imp userid=applsys/xxxxxx file=afstats2.dmp ignore=y grants=n full=y commit=n buffer=8000000
4- sqlplus applsys/xxxxxx @afstatgt.sql applsys xxxxxx apps xxxxxx
5- sqlplus apps/xxxxxx @AFSTATSS.pls
6- sqlplus apps/xxxxxx @fndpker.sql apps xxxxxx PACKAGE FND_STATS
7- sqlplus apps/xxxxxx @AFSTATSB.pls
8- sqlplus apps/xxxxxx @fndpker.sql apps xxxxxx PACKAGE_BODY FND_STATS

2.0.2. Apply the TUMS patch 3422686

cd $AD_TOP/patch/110/sql
sqlplus apps/app @adtums.sql /u10/app/convr11/tmp

2.0.3 Set the File attachments

2.0.4 . Submit “Purge Concurrent
Requests” with a retention
period of 7 days

2.0.5. Check for rows in

ALR_ACTION_HISTORY Table
Select count(*) from apps. ALR_ACTION_HISTORY;

If No rows then Apply the Patch 451137

2.0.6. Disabled all the Custom Triggers and
Alerts

2.0.7 Disabled Database Audit trial in init.ora
file

Audit_trial= false or comment out the line.

2.0.8 Validate and Compile Apps Schema
Use adadmin Utility

2.0.9 Backup the INVALIDS in a Table

Create table BEFORE_PREUPG_INVALIDS as select * from dba_objects where status=’INVALID’;

2.0.10. Make a note of passwords for following
users

SYSADMIN
GUEST
Oracle user - APPS
Oracle user – SYSTEM

3.0 Pre Upgrade Tasks on 11i Instance

3.0.1. Run Rapid install on DB tier and Apps Tier
./rapidwiz

3.0.3 Apply the Forms Patch set 18

If Reuired will Apply
3.0.4 Install 9.2.0.7 software on DB tier (4163445)
./runInstaller

3.0.5 Install Latest Opatch 2617419 on DB Tier
Unzip *2617419*.zip in $OARCLE_HOME

3.0.6 Applied Database patch 4192148 for Import
Issue

3.0.7 Update the .profile in MT and DB Tiers .
On MT :
- /<>/applmgr/r11i<>appl/APPSORA.env
On DB
- $ORACLE_HOME/ R11i<> _ .env

3.0.8 InstallPrep.sh script as per Note 189256.1

3.0.9 Configured tnsnames.ora on MT to connect to 8.1.7 database of 11.0.3 instance

3.0.10. Login to MT tier and perform following pre
upgrade tasks

Verify custom index privileges

cd $APPL_TOP/admin/preupg
sqlplus apps/oracle11i afindxpr.sql applsys
sqlplus apps/oracle11i afpregdi.sql

Make sure orders are in a supported status

cd $ONT_TOP/patch/115/sql
sqlplus apps/oracle11i@ontexc07.sql

Review Item Validation Org settings

cd $ONT_TOP/patch/115/sql
sqlplus apps/oracle11i@ontexc05.sql

Close open pick slips/picking batches or open deliveries/departures

cd $WSH_TOP/patch/115/sql
sqlplus apps/oracle11i@wshbdord.sql

Validate inventory organization data

cd $WSH_TOP/patch/115/sql

sqlplus apps/oracle11i@wshpre00.sql

Review cycles that may not be upgraded

cd $ONT_TOP/patch/115/sql
sqlplus apps/oracle11i@ontexc08.sql

Clear open interface tables

cd $APPL_TOP/admin/preupg
sqlplus apps/oracle11i@
Run above sql for each of the following scripts:
Requisitions Open Interface (pocntreq.sql)
Purchasing Documents Open Interface (pocntpoh.sql)
Receiving Open Interface (pocntrcv.sql)

Import and purge Invoice Import Interface expense reports and invoices

cd $APPL_TOP/admin/preupg
sqlplus apps/oracle11i@apuinimp.sql

Diagnose problems in the data

cd $AR_TOP/patch/115/sql
sqlplus apps/oracle11i@ar115chk.sql

Identify potential ORACLE schema conflicts

cd $APPL_TOP/admin/preupg
sqlplus applsys/oracle11i@adpuver.sql

3.0.10 Apply Family Consolidated Upgrade Patch for Financials - 3993353 with preinstall

Please Find the 806 - 9i Upgrade Steps

Subject: Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0) Doc ID: Note: 159657.1

Setup the Enterprise Edition for Oracle 9i

These scripts create objects required by the RDBMS and other technology stack components on the database server Login to 11i Database Tier

Check for output of dba_registry is as given below

col comp_name for a40
col version for a15
select comp_name, version, status FROM dba_registry;

Created folder $ORACLE_HOME/appsutil/admin

Copied addb920.sql, adsy920.sql, adjv920.sql, admsc920.sql, and adgrants.sql from $APPL_TOP/admin to $ORACLE_HOME/appsutil/admin

sqlplus /nolog
connect SYSTEM/oracle11idev
@addb920.sql -- Sets up database SYS schema

sqlplus /nolog
connect SYSTEM/oracle11idev
@adsy920.sql -- Sets up database SYSTEM schema

sqlplus /nolog
connect SYSTEM/oracle11idev
@adjv920.sql - Installs Java Virtual Machine

sqlplus /nolog
connect SYSTEM/oracle11idev
@admsc920.sql FALSE CTXD TEMP $ORACLE_HOME/ctx/lib/libctxx9.so

Check for output of dba_registry is as given below

col comp_name for a40
col version for a15
select comp_name, version, status FROM dba_registry;

Change Roll Back to UNDO Tablespace

select segment_name,tablespace_name,status from dba_rollback_segs;

SEGMENT_NAME TABLESPACE_NAME
------------------------------ ------------------------------
SYSTEM SYSTEM
ROLL301 RBS3
ROLL302 RBS3

select file_name,tablespace_name, bytes from dba_data_files where tablespace_name = 'RBS3';

select 'alter rollback segment ' SEGMENT_NAME' offline;' from dba_rollback_segs;

SQL> select 'alter rollback segment ' SEGMENT_NAME' offline;' from dba_rollback_segs;

SEGMENT_NAME
=============

alter rollback segment ROLL301 offline;
alter rollback segment ROLL302 offline;

SQL> alter rollback segment ROLL302 offline;

alter rollback segment ROLL303 offline;

Rollback segment altered.

SQL> alter rollback segment ROLL304 offline;

alter rollback segment ROLL305 offline;
alter rollback segment ROLL306 offline;

Rollback segment altered.

SQL> alter rollback segment ROLL307 offline;

Rollback segment altered.

SQL> alter rollback segment ROLL308 offline;

Rollback segment altered.

SQL> drop rollback segment ;

select 'drop rollback segment ' SEGMENT_NAME';' FROM from dba_rollback_segs;

SQL> select 'drop rollback segment ' SEGMENT_NAME';' FROM dba_rollback_segs;

'DROPROLLBACKSEGMENT'SEGMENT_NAME';'
------------------------------------------------------

drop rollback segment ROLL301;
drop rollback segment ROLL302;

alter tablespace RBS3 offline;

SQL> alter tablespace RBS3 offline;
alter tablespace RBS2 offline;

drop tablespace RBS2;

Tablespace altered.

create undo tablespace

create undo tablespace APPS_UNDOTS1 datafile '/db2/oradata/dev/data/undodbs01.dbf' size 3000M reuse extent management local;

ALTER TABLESPACE APPS_UNDOTS1 ADD DATAFILE '/db2/oradata/dev/data/undodbs02.dbf' size 3000M;

create undo tablespace APPS_UNDOTS2 datafile '/db2/oradata/dev/data/undodbs04.dbf' size 3000M reuse extent management local;

ALTER TABLESPACE APPS_UNDOTS2 ADD DATAFILE '/db2/oradata/dev/data/undodbs05.dbf' size 2000M;

CREATE TEMPORARY TABLESPACE

alter tablespace temp offline;

SQL> alter tablespace temp offline;

SQL> drop tablespace temp;

CREATE TEMPORARY TABLESPACE temp
TEMPFILE '/db2/oradata/dev/data/temp01.dbf' SIZE 3000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;

ALTER TABLESPACE temp
ADD TEMPFILE '/db2/oradata/dev/data/temp02.dbf' SIZE 2000M REUSE;

select * from dba_temp_files;
SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

Set Default TEMP TBS

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

Convert existing tablespaces to local extent management

We recommend using local extent management to increase performance. To
convert all non-SYSTEM tablespaces from Data Dictionary extent management to
local extent management, run the following script:

UNIX:
$ cd $APPL_TOP/admin/preupg
$ sqlplus system/finalf @adtbscnv.pls finalf

SQL> desc dba_tablespaces;
SQL> select EXTENT_MANAGEMENT, count(*) from dba_tablespaces group by EXTENT_MANAGEMENT;

bash-2.05b$ pwd
/u012/11i/ora/oracle/devsappl/admin
adsysapp2.sql

bash-2.05b$ sqlplus system/finalf@dev

SQL> @adsysapp2.sql
Enter value for 1: finalf

alter database datafile '/db2/oradata/dev/data/system01.dbf' resize 10000M;

To continue to use the existing tablespace model (OFA-compliant):

Run adgnofa.sql as follows. On the command line, indicate the as
NEW to create new product tablespaces (tablespaces for existing products are
not affected), or ALL to create tablespaces for new products and resize existing
product tablespaces.

UNIX:
$ cd $AD_TOP/patch/115/sql
$ sqlplus apps/xxxxxx @adgnofa.sql ALL

$sqlplus "/as sysdba"
@/u012/11i/ora/oracle/devsappl/ad/11.5.0/patch/115/sql/adcrtbsp.sql

alter database datafile '/db2/oradata/dev/index/jax01.dbf' resize 50M;

CREATE TABLESPACE APPLSYSD
DATAFILE '/db2/oradata/dev/data/applsysd01.dbf' size 200M
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1M;

CREATE TABLESPACE APPLSYSX
DATAFILE '/db2/oradata/dev/data/applsysx01.dbf' size 200M
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1M;

CREATE TABLESPACE CTXD DATAFILE '/db2/oradata/dev/data/ctxd01.dbf' SIZE 100M; AUTOEXTEND ON NEXT 5 MAXSIZE 200m;.

Applied database patch to create / update OWS packages
Login to 11i Database Tier 3835781
mkdir $ORACLE_HOME/appsutil/admin/OWS
cd $ORACLE_HOME/appsutil/admin/OWS
cp /R11isit/staging/patches/*3835781* .
@patch.sql

Installed XML Parser for PL/SQL
Login to 11i Database Tier

mkdir $ORACLE_HOME/appsutil/admin/xmlparser

cd $ORACLE_HOME/appsutil/admin/xmlparser

cp $COMMON_TOP/util/plxmlparser_v1_0_2.zip .
unzip plxmlparser_v1_0_2.zip - This file creates several subdirectories in the current location
cp $COMMON_TOP/util/XSU12_ver1_2_1.zip .
unzip XSU12_ver1_2_1.zip - This file creates subdirectory - OracleXSU12
cd /R11idev/db/9.2.0/appsutil/admin/xmlparser/lib/java
loadjava -user apps/oracle11i-r -v xmlparserv2.jar
loadjava -user apps/oracle11i-r -v xmlplsql.jar
cd ../sql
cat load.sql sqlplus apps/cl_11i_gbook_sta
cd /R11idev/db/9.2.0/appsutil/admin/xmlparser/OracleXSU12/lib
sh oraclexmlsqlload.ksh
mkdir $ORACLE_HOME/appsutil/admin/java
cd $ORACLE_HOME/appsutil/admin/java
cp /R11idev/oradata/R11iEXP/applmgr/r11iexpcomn/java/xmlparserv2.zip .
loadjava -user apps/oracle11i-r -v xmlparserv2.zip

Gathered database information
Login to 11i Mid tier
cd $APPL_TOP/admin/preupg
sqlplus apps/oracle11i@adupinfo.sql

Re-compile Invalids
sqlplus “/ as sysdba”
@$ORACLE_HOME/rdbms/admin/utlrp.sql
create table invalids_after_db_backup as select * from dba_objects where status = ‘INVALID’;

6.0 Auto Upgrade Tasks
Login to 11i Application Tier
Run Autoupgrade using adaimgr

$ adaimgr consolidated_tablespace=N

6.0.1 Post-Autoupgrade tasks
Login to 11i Database Tier
Re-compile Invalids
sqlplus “/ as sysdba”
@$ORACLE_HOME/rdbms/admin/utlrp.sql
create table invalids_after_autoupgrade as select * from dba_objects where status = ‘INVALID’;

6.0.2 Performed cold Backup of
Database

7.0 Autopatch Tasks
Login to 11i Application Tier
Applied AD.I.4 (4712852)

Applied 11.5.10.2 maintenance pack
cd $AU_TOP/patch/115/driver
adpatch options=nocopyportion,nogenerateportion

APPS account was locked and expired

2008-09-10T00:46:00.002+05:30

bash-2.05b$ FNDCPASS apps/xxxxx 0 Y system/manager SYSTEM APPLSYS xxxx
APP-FND-01564: ORACLE error 28000 in AFPCOA

Cause: AFPCOA failed due to ORA-28000: the account is locked
.

The SQL statement being executed at the time of the error was: and was executed from the file .

So just unlock the password

SQL> alter user apps account unlock;

User altered.

SQL> conn apps/xxxxx
Connected.

Note 364614.1:Best Practices for Securing the E-Business Suite
Note 114930.1:Oracle Password Management Policy
Note 420001.1:adpatch Ora-28000 Account Locked apps

Upgrade to DB 10g fails with error - cannot generate contextfile

2008-09-07T20:43:00.003+05:30

After 9i to 10g upgrade, i am going to Implement and run Autoconfig on the new Database home.
When i was run adbldxml in database, i got following error message.

bash-2.05b$ perl adbldxml.pl tier=db appsuser=apps appspasswd=xxxxx

Starting context file generation for db tier..

JRE_TOP not found at its desired location /u01/11i/uat/oracle/uatdb/10.2.0/jre/1.1.8
Restart adbldxml.pl with value for jtop as an necessary arguement

Then i was try following command.....

bash-2.05b$ perl adbldxml.pl tier=db appsuser=apps appspasswd=xxxx jtop=/u01/11i/uat/oracle/uatdb/9.2.0/jre/1.4.2

Starting context file generation for db tier..
Using JVM from /u01/11i/uat/oracle/uatdb/9.2.0/jre/1.4.2/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/u01/11i/uat/oracle/uatdb/10.2.0/appsutil/log/adbldxml_09060216.log
UnsatisfiedLinkError exception loading native library: njni10

Could not Connect to the Database with the above parameters, Please answer the Questions below

Enter Hostname of Database server: zeus

Enter Port of Database server: 1521

Enter SID of Database server: uat

For errors, Check log file :/u01/11i/uat/oracle/uatdb/10.2.0/appsutil/log/adbldxml_09060216.log

Here i got following error message on logfile.
The Autoconfig log file reports following error :
StackTrace:
java.lang.ArrayIndexOutOfBoundsException: 3 >= 3
at java.util.Vector.setElementAt(Vector.java:543)
at oracle.apps.ad.context.GenerateContext.setJRETOP(GenerateContext.java:7483)
at oracle.apps.ad.context.GenerateContext.InstantiateRestForDB(GenerateContext.java:3057)
at oracle.apps.ad.context.GenerateContext.main(GenerateContext.java:8150)

Then i was applied latest AUTOCONFIG TEMPLATE ROLLUP PATCH. Then i resloved that problem.

Solution

To implement the solution, please execute the following steps :

1. Download and apply Patch 4709948 - 'TXK (FND) AUTOCONFIG TEMPLATE ROLLUP PATCH M (APRIL 2006)', which brings the latest Release of the GenerateContext.java used to build the context file

After Applied this patch, i was sucessfully created in XML file.

2. Synchronize the APPS-Tier files with the DB-Tier - appsutil directory

3. Execute Autoconfig on the DB-Tier

Result
bash-2.05b$ pwd
/u01/11i/uat/oracle/uatdb/10.2.0/appsutil/bin
bash-2.05b$ perl adbldxml.pl tier=db appsuser=apps appspasswd=xxxxxx

Starting context file generation for db tier..
Using JVM from /u01/11i/uat/oracle/uatdb/10.2.0/jdk/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/u01/11i/uat/oracle/uatdb/10.2.0/appsutil/log/adbldxml_09060343.log

Enter the value for Display Variable: zeus:0.0

The context file has been created at:
/u01/11i/uat/oracle/uatdb/10.2.0/appsutil/uat_zeus.xml

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

bash-2.05b$ adconfig.sh

Enter the full path to the Context file: /u01/11i/uat/oracle/uatdb/10.2.0/appsutil/uat_zeus.xml
Enter the APPS user password:
The log file for this session is located at: /u01/11i/uat/oracle/uatdb/10.2.0/appsutil/log/uat_zeus/09060347/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/11i/uat/oracle/uatdb/10.2.0
Classpath : :/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/charsets.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/core.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/graphics.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmcertpathprovider.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmjaaslm.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmjcefw.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmjgssprovider.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmjssefips.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmjsseprovider.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmorb.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmorbapi.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/ibmpkcs.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/javaplugin.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/security.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/server.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/jre/lib/xml.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/lib/dt.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdk/lib/tools.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jdbc/lib/ojdbc14.jar:/u01/11i/uat/oracle/uatdb/10.2.0/appsutil/java/xmlparserv2.zip:/u01/11i/uat/oracle/uatdb/10.2.0/appsutil/java:/u01/11i/uat/oracle/uatdb/10.2.0/jlib/netcfg.jar:/u01/11i/uat/oracle/uatdb/10.2.0/jlib/ldapjclnt10.jar

Using Context file : /u01/11i/uat/oracle/uatdb/10.2.0/appsutil/uat_zeus.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db102
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

Upgrade to DB 10g fails with error - cannot generate contextfile Doc ID: Note:369179.1

Oracle 10g Install Linking Fails with Error on Pw-Syscall.Exp File

2008-09-04T22:03:00.001+05:30

INFO: Start output from spawned process:INFO: ----------------------------------INFO:
INFO: Linking /progs2/11i/uat/oracle/uatdb/10.2.0/precomp/lib/proc
INFO: ld: 0706-003 Cannot find or read import file: /progs2/11i/uat/oracle/uatdb/10.2.0/lib/pw-syscall.exp ld:accessx(): A file or directory in the path name does not exist.
INFO: make: 1254-004 The error code from the last command is 255.
Stop.
INFO: End output from spawned process.INFO: ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'relink' of makefile '/progs2/11i/uat/oracle/uatdb/10.2.0/precomp/lib/ins_precomp.mk'. See '/etc/oraInventory/logs/installActions2008-09-04_10-43-33AM.log' for details.Exception Severity: 1INFO: Exception handling set to prompt user with options to Retry IgnoreUser Choice: RetryINFO: The output of this make operation is also available at: '/progs2/11i/uat/oracle/uatdb/10.2.0/install/make.log'INFO:
INFO: Start output from spawned process:INFO: ----------------------------------INFO:
INFO: Linking /progs2/11i/uat/oracle/uatdb/10.2.0/precomp/lib/proc
INFO: ld: 0706-003 Cannot find or read import file: /progs2/11i/uat/oracle/uatdb/10.2.0/lib/pw-syscall.exp
INFO: ld:accessx(): A file or directory in the path name does not exist.
INFO: make: 1254-004 The error code from the last command is 255.
Stop.
INFO: End output from spawned process.INFO: ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'relink' of makefile '/progs2/11i/uat/oracle/uatdb/10.2.0/precomp/lib/ins_precomp.mk'. See '/etc/oraInventory/logs/installActions2008-09-04_10-43-33AM.log' for details.Exception Severity: 1bash-2.05b$ pwd/etc/oraInventory/logs

Solutions:

1. Create an empty file pw-syscall.exp under Agent $ORACLE_HOME/lib.

2. Then Click Retry

Changing the Net Listener Port in Oracle Applications Server 10g

2008-09-03T23:37:00.008+05:30

Change port number 1521 to 1531 or anyone

Find the step by step that i performed to configure a new listener .

System Overview

10g Application server with infrastructure and middle tier installed on the same box.

Infrastructure Tier Services
OID
HTTP Server

Middle Tier Application
Portal

OS Users

Infrastructure OS user: oracle
Middle Tier OS user: oracle

Task
Current Listener running on port 1521.
Configuring a new listener on port 1531

Shutdown Services.

Shutdown all the infrastructure and middle tier services.

INFRA

$opmnctl stopall
$emctl stop iasconsole

MIDDLE TIER

$opmnctl stopall
$emctl stop iasconsole

Shutdown Your Infrastructure Listener

$lsnrctl stop

Change The Listener Configuration

Make the change to have the new post number in the lsitener.ora file on your infrastructure tier.
bash-2.05b$ more listener.ora
# listener.ora Network Configuration File: /u01/scr/disco10g/OraHome_10/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/scr/disco10g/OraHome_10)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apollo.doyen.com)(PORT = 1531))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1531))
)
)

)

Change Your TNSNAMES

After this you need to make the change reflecting the new port in your TNSNAMES.ora file on both the infrastructure tier and the middle tier.

bash-2.05b$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/scr/disco10g/OraHome_10/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

BLDISCO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = apollo.doyen.com)(PORT = 1531))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bldisco.doyen.com)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apollo.doyen.com)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

Also replicate this change in middle tier tnsnames.ora.

Start Your Listener
Start your infrastructure tier listener.

$lsnrctl start bldisco

Set The New Listener At The Database Level.

You must execute this command in your infrastructure database to have the parameter local_listener set to your new listener.

$sqlplus "/ as sysdba"
SQL> alter system set local_listener='bldisco';
system altered

Bounce The Database.

Stop and startup your meta data repository database to have it register the new listener name.

Start Your OID On The Infrastructure Tier
$opmnctl startproc ias-component=OID

Change The Port Number In OID.

Start the Oracle Directory Manager from your desktop if you have the client installed else you can use the one on the server at $ORACLE_HOME/bin/oidadmin

Click add button and provide 10g infra hostname

Provide infra username and password

UserName : orcladmin
Password : xxxxxxxx

Click Entry Management –> cn=OraleContext ->bldisco(SID NAME) -> orclnetdescstring chnage the value of the new port here

Change The Other Config Files.

Based on your installation you may need to change the following files also

/u01/scr/disco10g/OraHome_10/sysman/emd/targets.xml
/u01/scr/disco10g/OraHome_10/Apache/modplsql/conf/dads.conf

Managing Your 10g Application Server

2008-09-03T22:34:00.004+05:30

Managing the application server primarily the startup and shutdown procedures. I will discuss the opmn tool by Oracle and also the Enterprise Manager

The process described here also holds good for other Oracle products like Oracle Collaboration suite and Oracle SOA suite.

Any application server would necessarily consist of a infrastructure Tier, it may or may not have a middle tier associated.

Starting Application Server Services

Order of Startup

As the middle tier is dependent on your infrastructure it is important that the infrastructure should be up and running before you proceed with the middle tier services.

To start OracleAS Infrastructure:

1. If your OracleAS Infrastructure contains OracleAS Metadata Repository, start it as
follows:

a. Set the ORACLE_HOME environment variable to the OracleAS Infrastructure
Oracle home.

b. Set the ORACLE_SID environment variable to the OracleAS Metadata
Repository SID (default is orcl).

c. Start the Net Listener:

ORACLE_HOME/bin/lsnrctl start

d. Start the OracleAS Metadata Repository instance:

ORACLE_HOME/bin/sqlplus /nolog
SQL> connect SYS as SYSDBA
SQL> startup

SQL> quit

e. Start the Oracle Enterprise Manager 10g Database Control:

(UNIX)ORACLE_HOME/bin/emctl start dbconsole
(Windows)ORACLE_HOME\bin\emctl start idbconsole

Using runstartupconsole.sh

You can start up the infrastructure tier services using the runstartupconsole.sh script located at your $ORACLE_HOME/bin/ on the machine which contains your infrastructure.

$ cd $ORACLE_HOME/bin
$runstartupconsole.sh start

This command will startup

The AS Meta Data Repository Instance

The Listener

The Enterprise Manager Console

Infrastructure Process Such as OID,OC4J_security,SSO etc.

To startup the middle Tier Services you log in to your middle tier OS user and run the the runstartupconsole.sh from the middle tier ORACLE_HOME.

$ cd $ORACLE_HOME/bin
$runstartupconsole.sh start

This Command will start up

The 10g Enterprise Manager

All OPMN managed process for the middle tier like portal

Using Enterprise Manager Console

You can also use the 10g Enterprise Manager console to start up the infrastructure tier and middle tier services, however you must start up the enterprise manager explicitly before you can use it. The emctl command is used to startup the enterprise manager. The location is $ORACLE_HOME/bin

Start the Application Server Control Console:

(UNIX)ORACLE_HOME/bin/emctl start iasconsole

$emctl start iasconsole

Using OPMN

OPMN stands for the Oracle Process Manager and Notification, is a tool with you can manage the OPMN managed Infrastructure and Middle Tier Porcess. The opmnctl executable is located at the $ORACLE_HOME/opmn/bin.

opmnctl start

This command will start up your opmn process

opmnctl startall

This will start up the opmn process and all process managed by opmn

Start components:

(UNIX) ORACLE_HOME/opmn/bin/opmnctl startall
(Windows) ORACLE_HOME\opmn\bin\opmnctl startall

opmnctl startporc ias-component=component

This will start a specific opmn managed process like SSO
You can also start using the sub-porcess of a component using

opmnctl startproc process-type=process

You could also restart the processs using

opmnctl restartproc ias-component=component

opmnctl restartproc process-type=process

However before using OPMNCTL you must have started your Metadata Respositery Database Instance and the Listener manually.

Shutdown of Application Tier Services

Order Of Shutdown

Your Middle tier Services must be shutdown before you shutdown your infrastructure services.

Using runstartupconsole.sh

You can shutdown the infrastructure tier services using the runstartupconsole.sh script located at your $ORACLE_HOME/bin/ on the machine which contains your infrastructure.

$ cd $ORACLE_HOME/bin

$runstartupconsole.sh stop

This command will stop

All infrastructure tier services

The 10g EM console

The meta data repository instance

The listener

For middle Tier services you must run this command for the middle tier ORACLE_HOME.
Using Enterprise Manager Console

You can also use the 10g EM console to shutdown your middle tier and infrastructure services.

After that you must shutdown your EM console manually using the emctl command

emctl stop iasconsole

Stop the Application Server Control Console:

(UNIX)ORACLE_HOME/bin/emctl stop iasconsole
(Windows)ORACLE_HOME\bin\emctl stop iasconsole

You can also shutdown the Infrastructure services using the EM Console of the infrastructure tier after which you must manually shutdown the EM console manually using emctl at the infrastructure tier.

You must also remember to bring down your Meta Data Repository and Listener manually from the infrastructure home after all the services are brought down.

Using OPMN

Using opmnctl you can shutdown your middle tier services and infrastructure services.

opmnctl shutdown

This shutdown the opmn process and along with it all the managed opmn processes

opmnctl stopall

This command stops all opmn managed process for a particular tier.

Stop components:

(UNIX) ORACLE_HOME/opmn/bin/opmnctl stopall

(Windows) ORACLE_HOME\opmn\bin\opmnctl stopall

You can also stop a specify OPMN managed component using

opmnctl stopproc ias-component=component

or

opmnctl stopproc process-type=process

The EM console on the middle tier and the infrastructure tier needs to be brought down manually using emctl stop iasconsole.
Also the Meta Data Repository Instance and Listener need to be brought down manually.

If your OracleAS Infrastructure contains OracleAS Metadata Repository, stop it as
follows:

a. Set the ORACLE_HOME environment variable to the OracleAS Infrastructure
Oracle home.

b. Set the ORACLE_SID environment variable to the OracleAS Metadata
Repository SID (default is orcl).

c. Stop the OracleAS Metadata Repository instance:

ORACLE_HOME/bin/sqlplus /nolog
SQL> connect SYS as SYSDBA
SQL> shutdown

SQL> quit

d. Stop the Net Listener:

ORACLE_HOME/bin/lsnrctl stop

Managing Log Files on Oracle AS 10g

2008-09-03T20:55:00.002+05:30

Changing Schema Passwords Using the Application Server Control Console

2008-09-03T20:47:00.006+05:30

Oracle 10g AS default Password

Some schemas store their passwords in Oracle Internet Directory. You must change
their passwords using the Application Server Control Console so the password is
updated in both the database and Oracle Internet Directory.

1.0 To change a schema password using the Application Server Control Console:

1. Depending on the schema, navigate to the home page for the middle-tier instance
or the Infrastructure.
2. On the home page, click Infrastructure.
3. On the Infrastructure page, click Change Schema Password.
4. On the Change Schema Password page, select the schema. Enter the new
password in the Password and Confirm Password fields. Click OK.

1.1 Changing Schema Passwords Using SQL*Plus

You can change some schema passwords directly in the database using SQL*Plus. To
do so, connect to the database as a user with SYSDBA privileges and issue the
following command:

SQL> ALTER USER schema IDENTIFIED BY new_password;
For example, to change the DCM schema password to abc123:
SQL> ALTER USER DCM IDENTIFIED BY abc123;

1.2 Changing Schema Passwords in Oracle Internet Directory

A few schemas (DCM, B2B, OWF_MGR) require you to manually update the
password in the Metadata Repository and in Oracle Internet Directory. Use the
following procedure to change these passwords:

1. Start Oracle Directory Manager:
■ On UNIX, use the following command:
ORACLE_HOME/bin/oidadmin

■ On Windows, navigate to Oracle Directory Manager (Start, Programs, Oracle
Application Server Infrastructure - Oracle_Home, Integrated Management
Tools, Oracle Directory Manager)

2. Log in to Oracle Directory Manager as the orcladmin user.

3. In the System Objects frame, expand Entry Management, expand
cn=OracleContext, expand cn=Products, expand cn=IAS, expand cn=IAS
Infrastructure Databases, and expand orclReferenceName=dbname for the
Metadata Repository.

4. Select the OrclResourceName=schema_name entry for the schema whose
password you want to change.

5. In the Properties tab, update the password in the orclpasswordattribute field.

6. Click Apply.

How To Reset The SSO Application Entry Password Doc ID: Note:428134.1
SSO Change Password Will Fail if Number of Grace Logins is Set to One Doc ID: Note:278807.1
How To Change Passwords When OID Is Integrated with E-Business Suite Doc ID: Note:422731.1
Changing Single Sign-On(Orasso) schema Password Doc ID: Note:415753.1

AD ADMIN UTILITIES

2008-08-30T00:39:00.010+05:30

AdAdmin

Ad admin is a utility which is used to perform

Login as a Applmgr user:
[applmgr@apps ~]$ adadmin

Preliminary Tasks:

1. Running the environment file.
2. Verifying that ORACLE_HOME set properly.
3. Ensuring that ORACLE_HOME/bin and AD_TOP/bin are in your path.
4. Shutting down the concurrent managers when relinking certain files or performing certain database tasks.
5. Ensuring Sufficient temporary disk space.

Ad administration prompts:

Your default directory is '/u01/app/apps/uatappl'.
Is this the correct APPL_TOP [Yes]

Filename [adadmin.log] :

APPL_TOP is set to /u01/app/apps/uatappl

Please enter the batchsize [1000] :

Enter the password for your 'SYSTEM' ORACLE schema: manager

Enter the ORACLE password of Application Object Library [APPS] : apps

Ad admin Log files:

The main AD Administration log file is called adadmin.log by default. This name can be
Changed when starting up AD Administration.

Errors and warnings are listed in the log file
/u01/app/apps/uatappl/admin/UAT/log/adadmin.log

General Applications file menu

There are five functional choices in the generate applications file menu.

1. Generate Message Files:
This task generates message binary files in the $PROD_TOP/mesg directory from oracle application object library tables.

We generally perform this task only when instructed to do so in a readme file of a patch.

2. Generate Form Files:
This task generate binary oracle forms file for all installed languages from the form definition files. Extension (*.fmx)

Perform this task whenever we have issue with a form or set forms.

Oracle application uses these binary files to display the data entry forms.

When we choose Generate form files:
It prompts following:

Generate Report files:
This task generates binary report files for all installed languages. Extension of the file name like (*.rdf)

When we choose Generate report files menu, it prompts the following.

Generate Graphics files:
This task generates Oracle graphics files for all installed languages. Extension of the file name like (*.ogd)

The serious of prompts and actions in this task are very similar to the prompts and actions in the Generate form files task.

Generate Product JAR files:
This generate product jar files task prompts
Do you wish to force generation of all jar files? [No]
If we choose No, it only generates JAR (Jave Archive) files that are missing or out of date.
Choose yes for this option when generating JAR files after upgrading the developer technology stack or after updating your Java version.

Maintain Applications Files tasks

Relink Application programs:
This task relinks all your oracle applications binary executables.
Select this task after us:
1. Install new version of the database or a technology stack component.
2. Install an underlying technology component used with oracle applications.
3. Apply a patch to the application technology stack.
4. Apply a patch to the operating systems

These tasks execute AD relink utility. Use AD admin, not the AD relink utility directly, to relink non AD-executables.

Create Applications environment file:
Select this task when you want to:
1. Create an environment file with settings that are different from your current environment file.
2. Recreate an environment file that is missing or currept.

Copy files to destinations:
The copy files to destinations task copies files from each product area to central locations where they can easily referenced by oracle applications.

Use this option to update the java, HTML and media files in the common directories (such as JAVA_TOP, OA_TOP) when users have issues accessing them.

1. Java file are copied to JAVA_TOP
2. HTML files are copied to OAH_TOP
3. Media files are copied to OAM_TOP

Convert Character Set:

1. This task converts the character set of all translatable files in APPL_TOP.
2. You should select this task when changing the base language or adding additional languages to oracle applications
3. You may need to convert database character set and file system character set to one that will support the additional languages.

Maintain snapshot information:

1. This task record details for each file in the APPL_TOP (like file name and file version).
2. They also record summary information’s about patches that have been applied to the APPL_TOP.
3. The maintain snapshot information task stores information about files, file versions and bug fixes present in an APPL_TOP.
4. You must run Maintain snapshot information option once for each APPL_TOP before you apply any patch that contains a “compatible feature prereq” line on that APPL_TOP.

Check for Missing files:

1. The check for missing files task verifies files needed to install, upgrade, or run oracle applications for the current configuration are in the current APPL_TOP.
2. Choose this task if you suspect there are files missing in your APPL_TOP.

Maintain Database Entries tasks:

Validate Apps Schema:

Validate apps schema task run SQL script (advrfapp.sql) against the apps schema to verify the integrity of the schema.
It determines:

1. Problems you must fix(not specific to apps schema)
2. problems you must fix(specific to apps schema)
3. Issues you may want to address(specific to apps schema)

A report called APPSschemaname.lst is produced in APPL_TOP/admin//out.
This report contains information about how to fix the issues. We can find following things by running the Validate Apps schema.

1. Missing or invalid package.
2. Missing or invalid synonyms.
3. Invalid objects in apps schema.

This task is more effective if run:

1. Immediately after an upgrading or applying maintenance pack
2. After a patch is applied.
3. After performing export/import (migration)
4. When doing custom development in the apps schema.

Recreate Grants and Synonyms:

This task recreates grants and synonyms for oracle application public schema (applsyspub)
Recreate grants on some packages from system to apps

Run this task when grants and synonyms are missing from the database. This may occur as a result of
1. Custom development
2. Incomplete database migrations
3. Patches and administrative sessions that failed to run successfully to completion

Maintain multi-lingual tables:

MLS or multilingual support is oracle application’s ability to operate in a multi languages simultaneously. When running Maintain multi-lingual task you can select the number of parallel workers. In generally run during the NLS install and maintenance processes. This task runs the NLINS.sql script for every product. It invokes pl/sql routines that maintain multilingual tables and untranslated rows.

Check Dual Tables:

This task looks for a dual table accessible by oracle applications and ensures the correct grants are set up. If such table not exists or if an existing DUAL table has more than one row, AD administration displays error. If a DUAL table containing only one row exists, AD admin completes successfully.

Maintain multiple reporting currencies:

This option varies depending on whether you currently have multiple reporting currencies (MRC) enabled or not.
If MRC functionality is implemented in your database, the option reads maintain multiple reporting currencies.

Convert to multiple organizations:

To convert in to multiple-org does the following thing:

1. Confirms that you want to run the task
2. Asks for the number of parallel workers
3. Create script to disable and re-enable triggers in the APPS schema
4. Disable all triggers in the apps schema
5. Converts seed data and transaction data to multiple organizations in parallel.
6. Re-enable all previously disabled triggers in the apps schema.

Compile and Reload Database Entries tasks:

Compile Apps Schema:

This task compiles uncompiled program units (pl/sql and java) in the apps schema.
You can perform this task with multiple workers.
When running this task, AD administration prompts,
Run Invoker's Rights processing in incremental mode [No]?
Type Yes at this prompt to run Invoker Rights processing only on packages that have changed
Since Invoker Rights processing was last run or accept the default to run Invoker Rights
Processing on all packages.
During the upgrade progress.

Compile Menu Information:

This option compiles menu data structures.
Choose this task after uploading menu entries.

It asks if you want to force compilation for all menus,

1. If you choose the default [no] only menus with changes are saved
2. If you enter yes all menus are compiled

Compile flexfield:

Run this task if the readme of a patch indicates that this step should be performed.
Details of the task with a list of compilation status of every flexfield are written to a log file.
The name of the log file is in the format .req. The main AD Administration log file contains the exact name of this log file.

Reload JAR Files to Database:

This option runs the loadjava utility to reload all appropriate oracle applications
JAR files into the database.

Change Maintenance mode:

1. Must be enabled before patching oracle applications
2. Improves patching performance
3. Restricts users access to system
4. Is enabled and disabled using AD administration

Discoverer 10g Installation and Migration Plan

2008-08-29T22:18:00.025+05:30

10g Infra and AS with Discoverer 10g Installation and Migration Plan

Software:
Application Server:
1. Oracle Identity Management 10g (10.1.4.0.1)
Download URL http://www.oracle.com/technology/software/products/ias/htdocs/101401.html
2. Oracle Application Server 10g Release 2 (10.1.2.0.2)
Download URL
http://www.oracle.com/technology/software/products/ias/htdocs/101202.html

What is Discoverer
http://www.epa.gov/ttn/airs/airsaqs/manuals/AQSDiscManDraftChapters1-3-29May07.pdf

Enivironment:

AIX Version 5.3 - EBIZ 11i
AIX Version 5.3 - Application Server(Separate Machine)

Index

• Feasible Architectures
• Installation
• Configuration
• Connectivity to Apps DB
• Post Installation Tasks
• EUL Migration
• Discoverer clients on Windows PC
• JInitiator upgradation

Steps

• Application Unix Account
• Oracle Unix account
• 10gAS Server Installation with Discoverer Component on separate ORACLE_HOME on existing 11i environment on application tier or separate server.
• Installation of Infra metadata database (If required) on separate server
• Configuration of Portal setup (If required)

Change ownership on application user like oracle or applmgr, etc …

chown -R applmgr:dba /etc/oraInventory

Configuration

1. Establish Connectivity between Discoverer 10g and Apps Database
2. Discoverer integration with 11i through changes in XML.
3. Discoverer Profile changes in 11i to point new Discoverer 10g

Connectivity to Apps DB

• Update tnsnames.ora file to connect Oracle Apps 11i
• Enable sqlnet access
• Connectivity check through Discoverer Home

Post Installation Tasks

• Configuring Oracle 11i to use Discoverer 10g and to load Application specific content and workbooks into discoverer 10g EUL
• Latest AutoConfig patch
• AD Patch application
• ICX Patch application

EUL Migration

• Schema creation for EUL
• EUL Creation
• Database Parameter setting (Rollback segment)
• DBA setup to migrate $AU_TOP to 10gAS server
• Import Discoverer Content for release 11i
• Refresh Discoverer 10g EUL
• Check grant privileges (Responsibility, Users, Workbooks )

Discoverer clients on Windows PC

Install Internet Developer Suit 10g, this will install Admin edition

• Edit Microsoft windows registry
• FTP DBC file from 11i to D:\secure on Windows PC
• TNS Connectivity to 11i Database
• Install Discoverer Desktop

JInitiator Upgradation

• Change in config.xml on 10gAS env.
• JVM setting for JInitiator 1.3.1.24
• JInitiator upgrade on 11i env.
• Application JInitiator patches

Oracle Application Server 10g 10.1.4.0.1

Installation Screenshots

The following information is available in:
/u01/applmgr/disco10g/OraHome_10/install/setupinfo.txt

Oracle Application Server 10g 10.1.4.0.1 Usernames and Default password information:
Please refer to Oracle Application Server 10g Administrator Guide for more information.
Install Type: Identity Management and Metadata Repository

Configured Components: Oracle Application Server Metadata Repository Oracle HTTP Server Oracle Application Server Containers for J2EE Oracle Internet D
irectory Oracle Application Server Single Sign-On Oracle Application Server Delegated Administration Services Oracle Directory Integration Platform

New Database created with these properties:
Database File Location: /u01/applmgr/disco10g/oradata/
Database Global Name: bldisco.doyen-sys.com
Database SID:bldisco
Database Name:bldisco
Character Set: -characterset AL32UTF8

Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://doyen.doyen-sys.com:7777

Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://doyen.doyen-sys.com:1156

Instance Name: infra.doyen.doyen-sys.com

Oracle Application server 10g 10.1.2.0.2

Give the OID(10g Infra hostname and OID Port) hostname and port.

Provide the 10g Infra username (ias_admin) password : welcome1

Provide the below details

User Name : ias_admin
Instance name : disco
Password : welcome1

Oracle Application Server 10g 10.1.2.0.2 Usernames and Default password information:

Please refer to the Oracle Application Server 10g Administrator Guide for more information.

Install Type: All Services

Configured Components: Oracle HTTP Server, Oracle Application Server 10g Containers for J2EE, Oracle Application Server 10g Web Cache, Oracle Application Ser
ver 10g Portal, Oracle Application Server 10g Discoverer, Oracle Application Server 10g Personalization, Oracle Application Server 10g Reports Services, Orac
le Application Server 10g Forms Services,

Registered with Oracle Internet Directory: apollo:389

Use only SSL connections with this Oracle Internet Directory:No

Database Connection String: doyen.doyen-sys:1521:bldisco.doyen-sys:bldisco.doyen-sys

Use the following URL to access the Oracle HTTP Server and the Welcome Page:

http://doyen.doyen-sys:7778/

Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://doyen.doyen-sys:1810/

Instance Name: disco.doyen.doyen-sys.com

END OF INSTALLATION

1.1 Copy dbc file from 11i ebiz to 10g Discoverer Server

Oracle E-Business Suite 11.5.10 customers :

The default naming convention for the .dbc file for Oracle E-Business Suite Release 11.5.10 is .dbc.

Please copy the dbc file .dbc from your 11i instance, and save the file on your Discoverer 10.1.2 $ORACLE_HOME/discoverer/secure directory as .dbc.

$copy $FND_SECURE(11i) TO $ORACLE_HOME/discoverer/secure(10g Disco)

$cp $FND_SECURE $ORACLE_HOME/discoverer/secure

1.2 Update tnsnames.ora file

Copy $TNS_ADMIN/tnsnames.ora (11i) to ORACLE_HOME/network/admin/tnsnames.ora(Disco 10g)

dev=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=apollo.fti-intra.com)(PORT=1535))
(CONNECT_DATA=
(SID=dev)
)
)

Migrate your existing Discoverer End User Layers to Discoverer 10.1.2.

Upgrade your existing Discoverer 4i or Discoverer 9.0.4 End User Layer to Discoverer 10.1.2 by using the following command on the standalone application server where Oracle Business Intelligence Server 10g Release 2

Pre Upgrade steps

1. export ORACLE_HOME=/progs/scr/disco10g/OraHome_11
2. export TNS_ADMIN=/progs/scr/disco10g/OraHome_11/network/ADMIN
3. tnsping uat
4. export eul_us schema in 11i instance(Just backup)

Backup 11i ebiz eul_us schema

oracle doyen> exp EUL_US/EUL_US file=pre_10g_upgrade_eul_backup.dmp

Run the following command to migrate 4i disco to 10g disco

10g Disco oracle home (not infra oracle home)

bash-2.05b$ pwd
/u01/applmgr/disco10g/OraHome_11/bin

bash-2.05b$ eulapi -CONNECT EUL_US/EUL_US@uat -AUTO_UPGRADE
-connect <**********>
-auto_upgrade
Command completed.

Now try to open Discoverer viewer

End Of the Installation

If need any query, please post your comments

The field PARAMETER.CONFIG could not be located or read

2008-08-29T22:03:00.002+05:30

Problem Description:
================

"The field PARAMETER.CONFIG could not be located or read."
The adapcctl.log carries the following errors:
Cannot read value from field PARAMETER.CONFIG
Cause: The field PARAMETER.CONFIG could not be located or read.

Making AOL/J Test

ERROR:validateLogin returned false: failed to login as sysadmin, please try again.
AOLJ_JAVA_EXCEPTION (MESSAGE=Not able to create new database connection: FNDSECURITY_APPL_USERID_INVALID)
SECURITY_INVALID_DBC_PARAMETER (PARAMETER=GUEST_USER_PWD) (FILE=/progs/11i/prod/applmgr/prodappl/fnd/11.5.0/secure/prod_atlas/prod.dbc) (ROUTINE=AppsConnectionManager.makeGuestConnection)
FNDSECURITY_APPL_USERID_INVALID
SECURITY_APPL_USERID_INVALID
AOLJ_JAVA_EXCEPTION (MESSAGE=Profiles: getJDBCConnection() == null)
AOLJ_JAVA_EXCEPTION (MESSAGE=Not able to create new database connection: FNDSECURITY_APPL_USERID_INVALID)
SECURITY_INVALID_DBC_PARAMETER (PARAMETER=GUEST_USER_PWD) (FILE=/progs/11i/prod/applmgr/prodappl/fnd/11.5.0/secure/prod_atlas/prod.dbc) (ROUTINE=AppsConnectionManager.makeGuestConnection)
FNDSECURITY_APPL_USERID_INVALID
SECURITY_APPL_USERID_INVALID

Cause:

There is a problem with Guest user. So proceed checking Guest user.

Step 1 :

SQL> select fnd_web_sec.validate_login('GUEST','GUEST') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','GUEST')
--------------------------------------------------------------------------------
N

SQL> select profile_option_value from fnd_profile_option_values where profile_option_id = 3805;
PROFILE_OPTION_VALUE
--------------------------------------------------------------------------------
GUEST/GUEST

SQL> select USER_NAME, END_DATE from fnd_user where USER_NAME like '%GUEST%'

USER_NAME END_DATE
------------------ --------------
GUEST 27/08/08
GUEST2
IBEGUEST

Fix :

Check the FND_USER table and check the end_date column for the Guest user. It will be end dated. So to make it null do the following.

Login as apps user.

Back up your FND_USER TABLE

Run the following command
update fnd_user set end_date=null where user_name='GUEST';

Check Again below query, Now end date is null.

SQL> select USER_NAME, END_DATE from fnd_user where USER_NAME like '%GUEST%'

USER_NAME END_DATE
------------------ ---------------
GUEST
GUEST2
IBEGUEST

Now Run the autoconfig.

Start Apps.

R12 Login issue on target after cloning

2008-08-18T23:15:00.004+05:30

Symptoms

On 12.0 (Oracle Aplication R12 + RUP 1) in TEST:
Find when launching URL : http://host.domain:port
is redirected to
http://host.domain:port/OA_HTML/AppsLocalLogin.jsp
...
nothing happen , no error, ...

Solution

To implement the solution, please execute the following steps:

1. cd $FND_TOP/patch/115/bin
2. perl ojspCompile.pl --compile --flush -p 2
3. Bring up the services and test login

11i - perl ojspcompile.pl --compile -quiet

R12 Login issue on target after cloning Doc ID: Note:435550.1

How to use OS commands to diagnose Database Performance issues

2008-08-05T01:15:00.003+05:30

$ man vmstat

Here is some sample output from these commands:

$ prtconf |grep -i "Memory size"

Memory size: 4096 Megabytes

$ swap -s
total: 7443040k bytes allocated + 997240k reserved = 8440280k used, 2777096k available

$ df -k

...

$ top

$ vmstat 5 100

$ iostat -c 2 100

$ iostat -D 2 100

$ mpstat 2 100

HP-UX 11.0:
============

$ grep Physical /var/adm/syslog/syslog.log
$ df -k
$ sar -w 2 100
$ sar -u 2 100
$ /bin/top
$ vmstat -n 5 100
$ iostat 2 100
$ top

For example:

$ grep Physical /var/adm/syslog/syslog.log
Nov 13 17:43:28 rmtdchp5 vmunix: Physical: 16777216 Kbytes, lockable: 13405388 Kbytes, available: 15381944 Kbytes

$ sar -w 1 100

HP-UX rmtdchp5 B.11.00 A 9000/800 12/20/02

$ sar -u 2 100 # This command generates CPU % usage information.

HP-UX rmtdchp5 B.11.00 A 9000/800 12/20/02

$ iostat 2 100

AIX:
=======

$ /usr/sbin/lsattr -E -l sys0 -a realmem
$ /usr/sbin/lsps -s
$ vmstat 5 100
$ iostat 2 100
$ /usr/local/bin/top # May not be installed by default in the server

For example:

$ /usr/sbin/lsattr -E -l sys0 -a realmem

realmem 33554432 Amount of usable physical memory in Kbytes False

NOTE: This is the total Physical + Swap memory in the system.
Use top or monitor command to get better breakup of the memory.

$ /usr/sbin/lsps -s

Total Paging Space Percent Used
30528MB 1%

Linux [RedHat 7.1 and RedHat AS 2.1]:
=======================================

$ dmesg | grep Memory
$ vmstat 5 100
$ /usr/bin/top

For example:

$ dmesg | grep Memory
Memory: 1027812k/1048568k available (1500k kernel code, 20372k reserved, 103k d)$ /sbin/swapon -s

Tru64:
========
$ vmstat -P| grep -i "Total Physical Memory ="
$ /sbin/swapon -s
$ vmstat 5 100

For example:

$ vmstat -P| grep -i "Total Physical Memory ="

Total Physical Memory = 8192.00 M

$ /sbin/swapon -s

Swap partition /dev/disk/dsk1g (default swap):

Configuring Telnet/FTP to login as root (Linux)

2008-07-31T20:14:00.004+05:30

Red Hat Enterprise Linux: RHEL3 / RHEL4

Enabling Telnet and FTP Services

Linux is configured to run the Telnet and FTP server, but by default, these services are not enabled. To enable the telnet service, login to the server as the root user account and run the following commands:

# chkconfig telnet on
# service xinetd reload

Reloading configuration: [ OK ]

Starting with the Red Hat Enterprise Linux 3.0 release (and in CentOS Enterprise Linux), the FTP server (wu-ftpd) is no longer available with xinetd. It has been replaced with vsftp and can be started from /etc/init.d/vsftpd as in the following:

# /etc/init.d/vsftpd start

Starting vsftpd for vsftpd: [ OK ]

If you want the vsftpd service to start and stop when recycling (rebooting) the machine, you can create the following symbolic links:

# ln -s /etc/init.d/vsftpd /etc/rc3.d/S56vsftpd
# ln -s /etc/init.d/vsftpd /etc/rc4.d/S56vsftpd
# ln -s /etc/init.d/vsftpd /etc/rc5.d/S56vsftpd

Allowing Root Logins to Telnet and FTP Services
Now before getting into the details of how to configure Red Hat Linux for root logins, keep in mind that this is VERY BAD security. Make sure that you NEVER configure your production servers for this type of login.
Configure Telnet for root logins

Simply edit the file /etc/securetty and add the following to the end of the file:

pts/0
pts/1
pts/2
pts/3
pts/4
pts/5
pts/6
pts/7
pts/8
pts/9

This will allow up to 10 telnet sessions to the server as root.
Configure FTP for root logins
Edit the files /etc/vsftpd.ftpusers and /etc/vsftpd.user_list and remove the 'root' line from each file.

Disable Root SSH Login on Linux

vi /etc/ssh/sshd_config

Find this section in the file, containing the line with "PermitRootLogin" in it.

#LoginGraceTime 2m
#PermitRootLogin no
#StrictModes yes
#MaxAuthTries 6

Make the line look like this to disable logging in through ssh as root.

PermitRootLogin no

Now you'll need to restart the sshd service:

/etc/init.d/sshd restart

Task: Disable / Turn off Linux Firewall (Red hat/CentOS/Fedora Core)
Type the following two commands (you must login as the root user):

# /etc/init.d/iptables save# /etc/init.d/iptables stop

Howto disable the iptables firewall in Linux

Task: Enable / Turn on Linux Firewall (Red hat/CentOS/Fedora Core)

Type the following command to turn on iptables firewall:

# /etc/init.d/iptables startOther Linux distribution

If you are using other Linux distribution such as Debian / Ubuntu / Suse Linux etc, try following generic procedure.

Save firewall rules

# iptables-save > /root/firewall.rules
OR
$ sudo iptables-save > /root/firewall.rulesNow type the following commands (login as root):
# iptables -X
# iptables -t nat -F
# iptables -t nat -X
# iptables -t mangle -F
# iptables -t mangle -X
# iptables -P INPUT ACCEPT
# iptables -P FORWARD ACCEPT
# iptables -P OUTPUT ACCEPT

To restore or turn on firewall type the following command:

# iptables-restore < /root/firewall.rulesGUI tools

VNCserver Configure on Linux

2008-07-31T20:06:00.003+05:30

What is VNCserver?

VNC stands for Virtual Network Computing.

Why use VNCserver?

In Linux, everything can be done from a shell. However, there may be a time when you need to access the machine as if you were at the console.

Getting Started

You will need several things to get started:

root privledges
VNC client software (tightVNC)
A good password!

As I mentioned above, this example is done with RHEL, which comes standard with VNCserver installed. To start the vncserver simply invoke the following commands:

[root@eit etc]# service vncserver start
Starting VNC server: [ OK ]
[root@eit etc]#
[root@eit etc]# vncpasswd
Password:
Verify:
[root@eit etc]#
[root@eit etc]# vncserver
New 'eit:1 (root)' desktop is eit:1
Starting applications specified in /root/.vnc/xstartup
Log file is /root/.vnc/eit:1.log
[root@eit etc]#

[root@eit .vnc]# vi xstartup

Using vi (vim) to edit the xstartup file, make sure your file matches this one:
#!/bin/sh
# Uncomment the following two lines for normal desktop:

unset SESSION_MANAGER
exec /etc/X11/xinit/xinitrc
[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
twm &
OR
startx &