Enable Trace in Oracle E-Business Suite R12

Debugging tool for HTTP, OC4J and OPMN in E-Business Suite R12

How To Enable and Collect Debug for HTTP, OC4J and OPMN

Shutdown the http server, oc4j and opmn services

adapcctl.sh stop
adoacorectl.sh stop
adformsctl.sh stop
adoafmctl.sh stop
adopmnctl.sh stop

Enable http ODL logging
-----------------------
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf

OraLogMode oracle
OraLogSeverity TRACE:32
OraLogDir $LOG_HOME/ora/10.1.3/Apache/oracle


Please use the full path to $LOG_HOME e.g. OraLogDir /u01/inst/apps/JCB_atg/logs/ora/10.1.3/Apache/oracle

mkdir $LOG_HOME/ora/10.1.3/Apache/oracle

Increase OC4J logging for oacore
-------------------------------
edit j2ee-logging.xml adjust the following in file:

$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/j2ee-logging.xml




Increase OC4J logging for forms
------------------------------
edit j2ee-logging.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/forms/config/j2ee-logging.xml


edit orion-web.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml


debug_mode
true

Increase OPMN Logging
-------------------------------
edit opmn.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml



Note : Check log Location /u01/inst/apps/JB_atg/logs/ora/10.1.3/opmn/opmn.dbg

Startup the http server, oc4j and opmn (reverse the startup sequence above)

ORA-29540: class oracle/CDC/PublishApi does not exist

ORA-29540: class oracle/CDC/PublishApi does not exist

SQL> BEGIN
2 DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE(
3 owner => 'cdcpub',
4 change_table_name => 'products_ct',
5 change_set_name => 'PRODUCTS_CS',
6 source_schema => 'MFCAMS',
7 source_table => 'PRODUCTS',
8 column_type_list => 'PROD_ID NUMBER(6), PROD_NAME VARCHAR2(50),PROD_LIST_PRICE NUMBER(8,2),JOB_ID VARCHAR2(10), DEPARTMENT_ID NUMBER(4)',
9 capture_values => 'both',
10 rs_id => 'y',
11 row_id => 'y',
12 user_id => 'y',
13 timestamp => 'y',
14 object_id => 'n',
15 source_colmap => 'n',
16 target_colmap => 'y',
17 options_string => 'TABLESPACE USER_DATA');
18 END;
19 /
BEGIN
*
ERROR at line 1:
ORA-29540: class oracle/CDC/PublishApi does not exist
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 611
ORA-06512: at line 2

Solutions

1.Run the sql rmcdc.sql

SQL>$ORACLE_HOMErdbms/admin/rmcdc.sql

2. Run the sql initcdc.sql

SQL>$ORACLE_HOME/rdbms/admin/initcdc.sql

ORA-29538: Java not installed

ORA-29538: Java not installed

ERROR at line 1:
ORA-29538: Java not installed
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 611
ORA-06512: at line 2

Solutions


$ORACLE_HOME/javavm/install

To load this package into the database, go to the directory location and login to SQL*Plus as the "SYS" user. Then, type the following:

SQL> spool initjvm.log
SQL> @initjvm.sql

ORA-29341: The transportable set is not self-contained

Transportable tablespace using export of index tablespace given error

H:\oracle\oradata\doyen\back_test_tt>exp "'/ as sysdba'" file=TT_INDEX.dmp
log=TT_INDEX.log transport_tablespace=y tablespaces=TT_INDEX statistics=none

Export: Release 10.2.0.3.0 - Production on Wed Oct 21 12:24:06 2009

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 29341 encountered
ORA-29341: The transportable set is not self-contained
ORA-06512: at "SYS.DBMS_PLUGTS", line 1387
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully


Solutions:


SQL> execute dbms_tts.transport_set_check('TT_INDEX', TRUE);

PL/SQL procedure successfully completed.

SQL> select * from transport_set_violations;

ORA-27054: NFS file system where the file is created or resides

Starting backup at 21-OCT-09
no parent backup or copy of datafile 18 found
channel c1: starting datafile copy
input datafile fno=00018 name=/home/oracle/product/10.2.0/oradata/orcl/kkk.dbf
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 10/21/2009 21:26:48
ORA-19504: failed to create file "/data/files/kkk.dbf"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3


Solutions

Linux

Add the following entry in /etc/fstab

hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3

Enabling frmservlet R12 direct login

Enabling f60cgi direct login
Enabling frmservlet R12.0.6 direct login

Enable Method:

java oracle.apps.fnd.security.AdminAppServer apps_username/apps_password AUTHENTICATION OFF DBC={dbc_file_name}

java oracle.apps.fnd.security.AdminAppServer apps/xxxxxx AUTHENTICATION OFF DBC=VIS.dbc

Disable Method:
1.To activate basic server security, from the command line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps_username/apps_password AUTHENTICATION ON DBC={dbc file path}

2.To activate full server security (SECURE mode), from the command line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps_username/apps_password AUTHENTICATION SECURE DBC={dbc file path}

Check the status:

java oracle.apps.fnd.security.AdminAppServer apps_username/apps_password STATUS DBC={dbc_file_name}

java oracle.apps.fnd.security.AdminAppServer apps/xxxxxx STATUS DBC=VIS.dbc

Database Server
---------------
DATABASE_ID: VIS
AUTHENTICATION: SECURE

Application Server
------------------
APPL_SERVER_STATUS: VALID
APPL_SERVER_ID: 61753FFF2F867C9CEE040A8C00B0000328F16873181892135982523005112239

APP-FND-01542

Error Message

APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator.





Solution:

1. Backup context file .

2. Update the context variable:
s_appserverid_authentication

By default in 11.5.10, this is set to SECURE.
In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF.

Modes:
- ON : Partial
- SECURE : activates full server security (SECURE mode)
- OFF : deactivates server security

3. Run Autoconfig to instantiate the change.

Creating LVM(Logical Volume Manager) on Redhat Linux

Creating LVM(Logical Volume Manager) on Redhat Linux

LVM(Logical Volume Manager) is a method of allocating hard drive space into logical volumes that can be easily resized instead of partitions.



1.Create a partition Linux LVM type.
2.Inform the OS of partition table changes.
3.Create a Physical Volume (LMV).
4.Create a Volume Group using these Physical Volumes.
5.Create a Logical Volume from this Volume Group.
6.Format Volume Group.
7.Mount Volume Group.



1.Create a partition Linux LVM type.

[root@sys80 ~]# fdisk /dev/sda

The number of cylinders for this disk is set to 60801.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): p

Disk /dev/sda: 500.1 GB, 500107862016 bytes
255 heads, 63 sectors/track, 60801 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 6374 51199123+ 83 Linux
/dev/sda2 6375 6948 4610655 82 Linux swap
/dev/sda3 6949 13028 48837600 83 Linux
/dev/sda4 13029 19108 48837600 5 Extended
/dev/sda5 13029 19108 48837568+ 8e Linux LVM

[root@sys80 ~]# fdisk /dev/sdb
The number of cylinders for this disk is set to 19457.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): p

Disk /dev/sdb: 160.0 GB, 160041885696 bytes
255 heads, 63 sectors/track, 19457 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-19457, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-19457, default 19457): +50G

Command (m for help): p

Disk /dev/sdb: 160.0 GB, 160041885696 bytes
255 heads, 63 sectors/track, 19457 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 6080 48837568+ 83 Linux

Command (m for help): t
Selected partition 1
Hex code (type L to list codes): 8e
Changed system type of partition 1 to 8e (Linux LVM)

Command (m for help): p

Disk /dev/sdb: 160.0 GB, 160041885696 bytes
255 heads, 63 sectors/track, 19457 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 6080 48837568+ 8e Linux LVM

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.


2.Inform the OS of partition table changes.
[root@sys80 ~]# partprobe
[root@sys80 ~]# cat /proc/partitions
major minor #blocks name

8 0 488386584 sda
8 1 51199123 sda1
8 2 4610655 sda2
8 3 48837600 sda3
8 4 0 sda4
8 5 48837568 sda5
8 16 156290904 sdb
8 17 48837568 sdb1


3.Create a Physical Volume (LMV).
[root@sys80 ~]# pvcreate /dev/sdb1
Physical volume "/dev/sdb1" successfully created

[root@sys80 ~]# pvcreate /dev/sda5
Physical volume "/dev/sda5" successfully created

4.Create a Volume Group using these Physical Volumes.
[root@sys80 ~]# vgcreate vg0 /dev/sdb1 /dev/sda5
Volume group "vg0" successfully created

5.Create a Logical Volume from this Volume Group.
[root@sys80 ~]# lvcreate -L 3048M -n data vg0
Logical volume "data" created

[root@sys80 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 49G 7.8G 38G 18% /
none 1.5G 0 1.5G 0% /dev/shm
/dev/sda3 46G 32M 43G 1% /db

6.Format Volume Group.
[root@sys80 ~]# mkfs.ext3 /dev/vg0/data
mke2fs 1.35 (28-Feb-2004)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
390144 inodes, 780288 blocks
39014 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=801112064
24 block groups
32768 blocks per group, 32768 fragments per group
16256 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912

Writing inode tables: done
Creating journal (8192 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 29 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.

7.Mount Volume Group.
[root@sys80 ~]# mkdir /oracle
[root@sys80 ~]# mount /dev/vg0/data /oracle
[root@sys80 ~]# mount
/dev/sda1 on / type ext3 (rw)
none on /proc type proc (rw)
none on /sys type sysfs (rw)
none on /dev/pts type devpts (rw,gid=5,mode=620)
usbfs on /proc/bus/usb type usbfs (rw)
none on /dev/shm type tmpfs (rw)
/dev/sda3 on /db type ext3 (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
/dev/mapper/vg0-data on /oracle type ext3 (rw)

[root@sys80 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 49G 7.8G 38G 18% /
none 1.5G 0 1.5G 0% /dev/shm
/dev/sda3 46G 32M 43G 1% /db
/dev/mapper/vg0-data 3.0G 37M 2.8G 2% /oracle

Creating New Partition on Redhat Linux

Creating New Partition on Redhat Linux

1.Create New Primary Partition
2.Inform the OS of partition table changes
3.Create an ext3 filesystem
4.Mount the File System
5.Configuration in /etc/fstab


1.Create New Primary Partition

[root@sys80 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 49G 6.8G 39G 15% /
none 1.5G 0 1.5G 0% /dev/shm
[root@sys80 ~]# fdisk /dev/sda
The number of cylinders for this disk is set to 60801.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): p

Disk /dev/sda: 500.1 GB, 500107862016 bytes
255 heads, 63 sectors/track, 60801 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 6374 51199123+ 83 Linux
/dev/sda2 6375 6948 4610655 82 Linux swap

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 3
First cylinder (6949-60801, default 6949):
Using default value 6949
Last cylinder or +size or +sizeM or +sizeK (6949-60801, default 60801): +50G

Command (m for help): p

Disk /dev/sda: 500.1 GB, 500107862016 bytes
255 heads, 63 sectors/track, 60801 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 6374 51199123+ 83 Linux
/dev/sda2 6375 6948 4610655 82 Linux swap
/dev/sda3 6949 13028 48837600 83 Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.

WARNING: Re-reading the partition table failed with error 16: Device or resource busy.
The kernel still uses the old table.
The new table will be used at the next reboot.
Syncing disks.

2.Inform the OS of partition table changes

[root@sys80 ~]# cat /proc/partitions
major minor #blocks name

8 0 488386584 sda
8 1 51199123 sda1
8 2 4610655 sda2
8 16 156290904 sdb
[root@sys80 ~]# partprobe
[root@sys80 ~]# cat /proc/partitions
major minor #blocks name

8 0 488386584 sda
8 1 51199123 sda1
8 2 4610655 sda2
8 3 48837600 sda3
8 16 156290904 sdb

3.Create an ext3 filesystem


[root@sys80 ~]# mkfs.ext3 -b 2048 -i 4096 -L /db /dev/sda3
mke2fs 1.35 (28-Feb-2004)
Filesystem label=/db
OS type: Linux
Block size=2048 (log=1)
Fragment size=2048 (log=1)
12214272 inodes, 24418800 blocks
1220940 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=562036736
1491 block groups
16384 blocks per group, 16384 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
16384, 49152, 81920, 114688, 147456, 409600, 442368, 802816, 1327104,
2048000, 3981312, 5619712, 10240000, 11943936

Writing inode tables: done
Creating journal (8192 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 33 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.

4.Mount the File System

[root@sys80 ~]# mount
/dev/sda1 on / type ext3 (rw)
none on /proc type proc (rw)
none on /sys type sysfs (rw)
none on /dev/pts type devpts (rw,gid=5,mode=620)
usbfs on /proc/bus/usb type usbfs (rw)
none on /dev/shm type tmpfs (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
[root@sys80 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 49G 6.8G 39G 15% /
none 1.5G 0 1.5G 0% /dev/shm
[root@sys80 ~]# mkdir /db
[root@sys80 ~]# mount /dev/sda3 /db (or) mount -a
[root@sys80 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 49G 6.8G 39G 15% /
none 1.5G 0 1.5G 0% /dev/shm
/dev/sda3 46G 32M 43G 1% /db
[root@sys80 ~]# mount
/dev/sda1 on / type ext3 (rw)
none on /proc type proc (rw)
none on /sys type sysfs (rw)
none on /dev/pts type devpts (rw,gid=5,mode=620)
usbfs on /proc/bus/usb type usbfs (rw)
none on /dev/shm type tmpfs (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
/dev/sda3 on /db type ext3 (rw)

5.Configuration in /etc/fstab

[root@sys80 ~]# cat /etc/fstab
# This file is edited by fstab-sync - see 'man fstab-sync' for details
LABEL=/ / ext3 defaults 1 1
none /dev/pts devpts gid=5,mode=620 0 0
none /dev/shm tmpfs defaults 0 0
none /proc proc defaults 0 0
none /sys sysfs defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
/dev/hda /media/cdrecorder auto pamconsole,exec,noauto,managed 0 0

Please Add the below entry in /etc/fstab
LABEL=/db /db ext3 defaults 0 0

[root@sys80 ~]# cat /etc/fstab
# This file is edited by fstab-sync - see 'man fstab-sync' for details
LABEL=/ / ext3 defaults 1 1
none /dev/pts devpts gid=5,mode=620 0 0
none /dev/shm tmpfs defaults 0 0
none /proc proc defaults 0 0
none /sys sysfs defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
/dev/hda /media/cdrecorder auto pamconsole,exec,noauto,managed 0 0
LABEL=/db /db ext3 defaults 0 0

Setting Up Swap Space on Redhat Linux

Setting Up Swap Space on Redhat Linux

There might be times when you've run out of swap space and it is not practical to repartition a drive or add a new one. In this case, you can use a regular file in an ordinary partition. All you have to do is create a file of the size you want

[root@sys80 ~]# cat /proc/meminfo grep SwapTotal
SwapTotal: 4610644 kB

su - root
dd if=/dev/zero of=tmpswap bs=1k count=900000
chmod 600 tmpswap
mkswap tmpswap
swapon tmpswap

#su - root
[root@sys80 ~]# dd if=/dev/zero of=tmpswap bs=1024 count=1048576
1048576+0 records in
1048576+0 records out
[root@sys80 ~]# chmod 600 tmpswap
[root@sys80 ~]# mkswap tmpswap
Setting up swapspace version 1, size = 1073737 kB
[root@sys80 ~]# swapon tmpswap
[root@sys80 ~]# cat /proc/meminfo grep SwapTotal
SwapTotal: 5659212 kB
[root@sys80 ~]# free -m
total used free shared buffers cached
Mem: 3030 1333 1696 0 25 1157
-/+ buffers/cache: 150 2879
Swap: 5526 0 5526

To disable the temporary swap space execute the following commands:
su - root
swapoff tmpswap
rm tmpswap

Oracle Job Schedules with samples

Creates a job in a single call without using an existing program or schedule:

DBMS_SCHEDULER.CREATE_JOB (
job_name IN VARCHAR2,
job_type IN VARCHAR2,
job_action IN VARCHAR2,
number_of_arguments IN PLS_INTEGER DEFAULT 0,
start_date IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
repeat_interval IN VARCHAR2 DEFAULT NULL,
end_date IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
job_class IN VARCHAR2 DEFAULT 'DEFAULT_JOB_CLASS',
enabled IN BOOLEAN DEFAULT FALSE,
auto_drop IN BOOLEAN DEFAULT TRUE,
comments IN VARCHAR2 DEFAULT NULL);



Run every Friday. (All three examples are equivalent.)
FREQ=DAILY; BYDAY=FRI;
FREQ=WEEKLY; BYDAY=FRI;
FREQ=YEARLY; BYDAY=FRI;

Run every other Friday.
FREQ=WEEKLY; INTERVAL=2; BYDAY=FRI;

Run on the last day of every month.
FREQ=MONTHLY; BYMONTHDAY=-1;

Run on the next to last day of every month.
FREQ=MONTHLY; BYMONTHDAY=-2;

Run on March 10th. (Both examples are equivalent)
FREQ=YEARLY; BYMONTH=MAR; BYMONTHDAY=10;
FREQ=YEARLY; BYDATE=0310;

Run every 10 days.
FREQ=DAILY; INTERVAL=10;

Run daily at 4, 5, and 6PM.
FREQ=DAILY; BYHOUR=16,17,18;

Run on the 15th day of every other month.
FREQ=MONTHLY; INTERVAL=2; BYMONTHDAY=15;

Run on the 29th day of every month.
FREQ=MONTHLY; BYMONTHDAY=29;

Run on the second Wednesday of each month.
FREQ=MONTHLY; BYDAY=2WED;

Run on the last Friday of the year.
FREQ=YEARLY; BYDAY=-1FRI;

Run every 50 hours.
FREQ=HOURLY; INTERVAL=50;

Run on the last day of every other month.
FREQ=MONTHLY; INTERVAL=2; BYMONTHDAY=-1;

Run hourly for the first three days of every month.
FREQ=HOURLY; BYMONTHDAY=1,2,3;

Here are some more complex repeat intervals:
Run on the last workday of every month (assuming that workdays are Monday through Friday).
FREQ=MONTHLY; BYDAY=MON,TUE,WED,THU,FRI; BYSETPOS=-1

Run on the last workday of every month, excluding company holidays. (This example references an existing named schedule called Company_Holidays.)
FREQ=MONTHLY; BYDAY=MON,TUE,WED,THU,FRI; EXCLUDE=Company_Holidays; BYSETPOS=-1

Run at noon every Friday and on company holidays.
FREQ=YEARLY;BYDAY=FRI;BYHOUR=12;INCLUDE=Company_Holidays

A repeat interval of "FREQ=MINUTELY;INTERVAL=2;BYHOUR=17; BYMINUTE=2,4,5,50,51,7;" with a start date of 28-FEB-2004 23:00:00 will generate the following schedule:

SUN 29-FEB-2004 17:02:00
SUN 29-FEB-2004 17:04:00
SUN 29-FEB-2004 17:50:00
MON 01-MAR-2004 17:02:00
MON 01-MAR-2004 17:04:00
MON 01-MAR-2004 17:50:00


A repeat interval of "FREQ=MONTHLY;BYMONTHDAY=15,-1" with a start date of 29-DEC-2003 9:00:00 will generate the following schedule:

WED 31-DEC-2003 09:00:00
THU 15-JAN-2004 09:00:00
SAT 31-JAN-2004 09:00:00
SUN 15-FEB-2004 09:00:00
SUN 29-FEB-2004 09:00:00
MON 15-MAR-2004 09:00:00
WED 31-MAR-2004 09:00:00

Create Sample schedule job,Check invaild objects and write alert log eveny 30 Minutes.

create or replace procedure proc_dba_check2
is
ls_msg varchar2(4000);
kcount number;
BEGIN
select count(*) INTO kcount from dba_objects where status='INVALID';
if kcount=0 then
ls_msg := 'No Invalid objects';
else
ls_msg := 'Invaild Objects Count : ' kcount;
sys.dbms_system.ksdwrt(2, 'ORA- 'ls_msg);
--dbms_output.put_line(ls_msg);
end if;
--END;
--dbms_output.put_line(ls_msg);
end;
/

BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'Invalid_object_job',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN sys.proc_dba_check2; END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=MINUTELY;INTERVAL=30',
end_date => NULL,
enabled => TRUE,
comments => 'Invalid Objects write Alert log ');
End;

BEGIN
DBMS_SCHEDULER.DISABLE('Invalid_object_job');
-- and then
DBMS_SCHEDULER.ENABLE('Invalid_object_job');
END;

SQL> SELECT owner, job_name, enabled FROM dba_scheduler_jobs;

Windows Oracle Apps monitor Command Line Process Viewer and Killer

Windows Oracle Apps monitor Command Line Process Viewer and Killer

Download file process.exe

Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP V2.03
Copyright(C) 2002-2003 Craig.Peacock@beyondlogic.org
Usage: process [-v] [-t] [-c]
process [-q] [Process Name/PID] [timeout sec(optional)]
process [-k] [-s] [-r] [Process Name/PID]
process [-p] [Process Name/PID] {RealTimeHighAboveNormal
NormalBelowNormalLow}
process [-a] [Process Name/PID] [Mask(To Set)]
-v View Processes.
-t View Kernel and User CPU Times.
-c View Process Creation Times.
-q Send WM_CLOSE Message. Default timeout is 60 Sec
-k Kill Process. (Terminate)
-s Suspend Process.
-r Resume Suspended Process.
-p Set Process Priority.
-a Get/Set Affinity Mask of Process.

FND Check
D:\>process grep FND
FNDLIBR.exe 7020 1 8 0 NT AUTHORITY\SYSTEM
FNDSM.exe 636 1 8 0 NT AUTHORITY\SYSTEM
FNDCRM.exe 6500 1 8 0 NT AUTHORITY\SYSTEM
FNDSCH.exe 7176 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6288 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6656 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 1456 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7908 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6156 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7936 1 8 0 NT AUTHORITY\SYSTEM

Forms Check
D:\>process grep frm
frmweb.exe 6956 2 8 0 NT AUTHORITY\SYSTEM
frmweb.exe 6100 2 8 0 NT AUTHORITY\SYSTEM

Killing Process ID
Killing Process ID in Windows
D:\>process grep not
notepad.exe 6168 1 8 0 ARTHA\Administrator
D:\>process -k 6168
Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP V2.03
Copyright(C) 2002-2003 Craig.Peacock@beyondlogic.org
Killing PID 6168 'notepad.exe'

Kill FNDLIBR.exe

D:\>process -k FNDLIBR.exe

Kill frmweb.exe

D:\>process -k frmweb.exe

All Process
D:\>process

Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP V2.03
Copyright(C) 2002-2003 Craig.Peacock@beyondlogic.org

ImageName PID Threads Priority CPU Owner
Idle 0 8 0 5 Error 0x6 : The handle is invalid.
System 4 109 8 0 Error 0x5 : Access is denied.
smss.exe 336 2 11 0 NT AUTHORITY\SYSTEM
csrss.exe 384 15 13 0 NT AUTHORITY\SYSTEM
winlogon.exe 412 18 13 0 NT AUTHORITY\SYSTEM
OAMKSVC.exe 1704 2 8 0 NT AUTHORITY\SYSTEM
tnslsnr.exe 1724 3 8 0 NT AUTHORITY\SYSTEM
opmn.exe 1764 1 8 0 NT AUTHORITY\SYSTEM
opmn.exe 1784 19 8 0 NT AUTHORITY\SYSTEM
isqlplussvc.exe 1832 2 8 0 NT AUTHORITY\SYSTEM
TNSLSNR.EXE 1912 3 8 0 NT AUTHORITY\SYSTEM
oracle.exe 1932 58 8 0 NT AUTHORITY\SYSTEM
java.exe 1940 10 8 0 NT AUTHORITY\SYSTEM
svchost.exe 1968 3 8 0 Error 0x5 : Access is denied.
TeamViewer_Service.exe 2060 4 8 0 NT AUTHORITY\SYSTEM
tlntsvr.exe 2076 4 8 0 Error 0x5 : Access is denied.
TeamViewer.exe 2296 7 8 0 NT AUTHORITY\SYSTEM
java.exe 3280 55 8 0 NT AUTHORITY\SYSTEM
Apache.exe 3568 516 8 0 NT AUTHORITY\SYSTEM
cmd.exe 3600 1 8 0 NT AUTHORITY\SYSTEM
cmd.exe 3608 1 8 0 NT AUTHORITY\SYSTEM
cmd.exe 3616 1 8 0 NT AUTHORITY\SYSTEM
rotatelogs.exe 3624 1 8 0 NT AUTHORITY\SYSTEM
rotatelogs.exe 3632 1 8 0 NT AUTHORITY\SYSTEM
rotatelogs.exe 3640 1 8 0 NT AUTHORITY\SYSTEM
cmd.exe 3648 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7020 1 8 0 NT AUTHORITY\SYSTEM
FNDSM.exe 636 1 8 0 NT AUTHORITY\SYSTEM
RCVOLTM.exe 6092 1 8 0 NT AUTHORITY\SYSTEM
POXCON.exe 3088 1 8 0 NT AUTHORITY\SYSTEM
INCTM.exe 8148 1 8 0 NT AUTHORITY\SYSTEM
java.exe 5600 26 8 0 NT AUTHORITY\SYSTEM
FNDCRM.exe 6500 1 8 0 NT AUTHORITY\SYSTEM
FNDSCH.exe 7176 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6288 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6656 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 1456 1 8 0 NT AUTHORITY\SYSTEM
INVLIBR.exe 7704 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7908 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6156 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7936 1 8 0 NT AUTHORITY\SYSTEM
PALIBR.exe 440 1 8 0 NT AUTHORITY\SYSTEM
Process.exe 7928 1 13 0 ARTHA\Administrator

ORA-04030: out of process memory

SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 4108 bytes (PLS
non-lib hp,pdzgM64_New_Link)

Solution
1.SQL>select object_name,object_type from dba_objects where status='INVALID';
OBJECT_NAME OBJECT_TYPE
----------------------------------- -------------------
XLA_00200_AAD_S_000010_PKG PACKAGE BODY
XLA_00200_AAD_S_000011_PKG PACKAGE BODY

2. SQL> alter system set plsql_optimize_level =0;
System altered.

3.SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
Package body altered.

4.SQL> alter package apps.XLA_00200_AAD_S_0000011_PKG COMPILE BODY;
Package body altered.

5.SQL> alter system set plsql_optimize_level =2;
System altered.

Oracle Application R12.0.4 missing oraInventory Create oraInventory

Oracle Application R12.0.4 missing oraInventory Create oraInventory

I have Install Oracle Application R12.0.4 after i will see oraInventory missing

I will Create oraInventory

Solutions

1.cp /etc/oraInst.loc /etc/oraInst.loc.bak

2.cp $ORACLE_HOME/oraInst.loc $ORACLE_HOME/oraInst.loc.bak

3../runInstaller -silent -attachHome ORACLE_HOME="Oracle_Home_Location" ORACLE_HOME_NAME="Oracle_Home_Name"

4. Check $ORACLE_HOME/OPatch/opatch lsinventory

Steps

[oracle@194150-web1 bin]$ ./runInstaller -silent -attachHome ORACLE_HOME="/db01/oracle/VIS/db/tech_st/10.2.0" ORACLE_HOME_NAME="VIS_DB__db01_oracle_VIS_db_tech_st_10_2_0"
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /home/oracle/oraInventory
/home/oracle/oraInventory/orainstRoot.sh

[root@194150-web1 10.2.0]# /home/oracle/oraInventory/orainstRoot.sh
Changing permissions of /home/oracle/oraInventory to 770.
Changing groupname of /home/oracle/oraInventory to oinstall.
The execution of the script is complete


[oracle@194150-web1 bin]$ $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.3.4

Oracle Interim Patch Installer version 10.2.0.3.4
Copyright (c) 2007, Oracle Corporation. All rights reserved.


Oracle Home : /db01/oracle/VIS/db/tech_st/10.2.0
Central Inventory : /home/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.4
OUI version : 10.2.0.3.0
OUI location : /db01/oracle/VIS/db/tech_st/10.2.0/oui
Log file location : /db01/oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/opatch/opatch2008-11-21_18-10-37PM.log

Lsinventory Output file location : /db01/oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2008-11-21_18-10-37PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (4):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Products 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 4 products installed in this Oracle Home.


Interim patches (41) :

Patch 6317866 : applied on Wed Jan 16 12:57:15 CST 2008
Created on 20 Aug 2007, 05:13:31 hrs US/Pacific
Bugs fixed:
5254539, 5842961, 5893501, 6041535, 4587572, 5908594, 6167999, 6317851
5084757, 5095815, 5199213, 4686006, 6317866, 5382842, 5302124, 5119354
5073249, 5371149, 5385629, 5960707

Patch 4932527 : applied on Wed Jan 16 12:56:00 CST 2008
Created on 1 Apr 2007, 22:18:45 hrs US/Pacific
Bugs fixed:
4932527

Patch 4882839 : applied on Wed Jan 16 12:54:16 CST 2008
Created on 10 Sep 2007, 06:25:08 hrs US/Pacific
Bugs fixed:
4882839

Patch 5889331 : applied on Wed Jan 16 12:54:06 CST 2008
Created on 6 Jun 2007, 00:33:12 hrs PST8PDT
Bugs fixed:
5889331

Patch 5959099 : applied on Wed Jan 16 12:53:36 CST 2008
Created on 16 Apr 2007, 05:22:53 hrs US/Pacific
Bugs fixed:
5491132, 5694997, 5959099, 5667235, 5253806

Patch 5746153 : applied on Wed Jan 16 12:51:43 CST 2008
Created on 16 Feb 2007, 10:26:31 hrs US/Eastern
Bugs fixed:
5746153

Patch 5668025 : applied on Wed Jan 16 12:51:12 CST 2008
Created on 2 Apr 2007, 06:21:55 hrs US/Pacific
Bugs fixed:
5668025

Patch 5477912 : applied on Wed Jan 16 12:50:41 CST 2008
Created on 14 May 2007, 04:01:25 hrs US/Pacific
Bugs fixed:
5477912

Patch 5392772 : applied on Wed Jan 16 12:50:31 CST 2008
Created on 2 Apr 2007, 06:32:24 hrs US/Pacific
Bugs fixed:
5392772

Patch 5066528 : applied on Wed Jan 16 12:50:00 CST 2008
Created on 2 Apr 2007, 07:30:03 hrs US/Pacific
Bugs fixed:
5066528

Patch 4967236 : applied on Wed Jan 16 12:49:20 CST 2008
Created on 2 Apr 2007, 05:32:08 hrs US/Pacific
Bugs fixed:
4967236

Patch 5206570 : applied on Wed Jan 16 12:47:37 CST 2008
Created on 19 Jan 2007, 05:54:29 hrs US/Pacific
Bugs fixed:
5206570

Patch 4966417 : applied on Wed Jan 16 12:47:01 CST 2008
Created on 2 Mar 2007, 00:58:29 hrs US/Pacific
Bugs fixed:
4966417

Patch 4733582 : applied on Wed Jan 16 12:46:27 CST 2008
Created on 2 Apr 2007, 02:21:29 hrs US/Pacific
Bugs fixed:
4733582

Patch 4054238 : applied on Wed Jan 16 12:46:17 CST 2008
Created on 5 Mar 2007, 23:15:31 hrs US/Pacific
Bugs fixed:
4054238

Patch 4898580 : applied on Wed Jan 16 12:45:47 CST 2008
Created on 8 Nov 2007, 08:42:45 hrs US/Pacific
Bugs fixed:
4898580

Patch 4592596 : applied on Wed Jan 16 12:45:34 CST 2008
Created on 21 Jan 2007, 22:23:42 hrs US/Pacific
Bugs fixed:
4592596

Patch 6121268 : applied on Wed Jan 16 12:43:31 CST 2008
Created on 17 Jun 2007, 02:48:13 hrs PST8PDT
Bugs fixed:
6121268

Patch 6121267 : applied on Wed Jan 16 12:43:26 CST 2008
Created on 17 Jun 2007, 02:26:19 hrs PST8PDT
Bugs fixed:
6121267

Patch 6121266 : applied on Wed Jan 16 12:43:22 CST 2008
Created on 17 Jun 2007, 02:16:12 hrs PST8PDT
Bugs fixed:
6121266

Patch 6121264 : applied on Wed Jan 16 12:43:18 CST 2008
Created on 17 Jun 2007, 02:11:41 hrs PST8PDT
Bugs fixed:
6121264

Patch 6121263 : applied on Wed Jan 16 12:43:10 CST 2008
Created on 17 Jun 2007, 02:11:04 hrs PST8PDT
Bugs fixed:
6121263

Patch 6121261 : applied on Wed Jan 16 12:43:02 CST 2008
Created on 17 Jun 2007, 01:57:24 hrs PST8PDT
Bugs fixed:
6121261

Patch 6121260 : applied on Wed Jan 16 12:42:58 CST 2008
Created on 17 Jun 2007, 01:50:40 hrs PST8PDT
Bugs fixed:
6121260

Patch 6121258 : applied on Wed Jan 16 12:42:47 CST 2008
Created on 17 Jun 2007, 01:47:05 hrs PST8PDT
Bugs fixed:
6121258

Patch 6121257 : applied on Wed Jan 16 12:42:44 CST 2008
Created on 17 Jun 2007, 01:45:01 hrs PST8PDT
Bugs fixed:
6121257

Patch 6121250 : applied on Wed Jan 16 12:42:35 CST 2008
Created on 17 Jun 2007, 03:08:07 hrs PST8PDT
Bugs fixed:
6121250

Patch 6121249 : applied on Wed Jan 16 12:42:22 CST 2008
Created on 17 Jun 2007, 01:37:51 hrs PST8PDT
Bugs fixed:
6121249

Patch 6121248 : applied on Wed Jan 16 12:42:19 CST 2008
Created on 17 Jun 2007, 01:37:06 hrs PST8PDT
Bugs fixed:
6121248

Patch 6121247 : applied on Wed Jan 16 12:42:08 CST 2008
Created on 17 Jun 2007, 01:27:10 hrs PST8PDT
Bugs fixed:
6121247

Patch 6121246 : applied on Wed Jan 16 12:42:00 CST 2008
Created on 17 Jun 2007, 01:24:45 hrs PST8PDT
Bugs fixed:
6121246

Patch 6121245 : applied on Wed Jan 16 12:41:15 CST 2008
Created on 17 Jun 2007, 01:22:56 hrs PST8PDT
Bugs fixed:
6121245

Patch 6121244 : applied on Wed Jan 16 12:41:05 CST 2008
Created on 17 Jun 2007, 01:21:05 hrs PST8PDT
Bugs fixed:
6121244

Patch 6121243 : applied on Wed Jan 16 12:40:54 CST 2008
Created on 17 Jun 2007, 01:18:48 hrs PST8PDT
Bugs fixed:
6121243

Patch 6121242 : applied on Wed Jan 16 12:40:50 CST 2008
Created on 17 Jun 2007, 01:12:31 hrs PST8PDT
Bugs fixed:
6121242

Patch 6121183 : applied on Wed Jan 16 12:40:42 CST 2008
Created on 17 Jun 2007, 01:43:54 hrs PST8PDT
Bugs fixed:
6121183

Patch 6079591 : applied on Wed Jan 16 12:40:38 CST 2008
Created on 17 Jun 2007, 02:51:31 hrs PST8PDT
Bugs fixed:
6079591

Patch 5240469 : applied on Wed Jan 16 12:39:44 CST 2008
Created on 13 Feb 2007, 01:18:47 hrs US/Eastern
Bugs fixed:
5240469

Patch 4247037 : applied on Wed Jan 16 12:38:08 CST 2008
Created on 08 JAN 2008, 14:14:14 hrs US/Pacific
Bugs fixed:
4247037

Patch 5556081 : applied on Fri Oct 26 01:24:56 CDT 2007
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081

Patch 5557962 : applied on Fri Oct 26 01:24:49 CDT 2007
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974



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

OPatch succeeded.

Oracle Application Upgrade 12.0.6 (6728000) Patch Error for Demantra

Oracle E-Business Suite R12 Upgrade 12.0.6 (6728000) Patch Error for Demantra

Error

/u02/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

The following Oracle Forms objects did not generate successfully:

au resource MSCDSPOP.pll
au resource MSCFNORD.pll
au resource MSCFPPSC.pll
au resource MSCIOPOP.pll

An error occurred while generating Oracle Forms library files.
Continue as if it were successful [No] :

Case:

Dermatra db link not working ..

Solutions

Fix the Dermantra db link

After run

frmcmp_batch module=$AU_TOP/resource/MSCDSPOP.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCDSPOP.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCFNORD.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCFNORD.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCFPPSC.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCFPPSC.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCIOPOP.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCIOPOP.plx module_type=library batch=no compile_all=special

Continue as if it were successful [No] : Yes

Report Builder:Warning: REP-0004: Unable to open user preference file.

Oracle E-Business Suite R12 Report Builder:Release 10.1.2.2.0 Warning: REP-0004: Unable to open user preference file.

Error:

REP-0004: Warning: Unable to open user preference file.

Report Builder: Release 10.1.2.2.0 - Production on Mon Nov 17 14:43:42 2008


Solution

Copy prefs.ora from $ORACLE_HOME/tools/admin to $HOME

cp $ORACLE_HOME/tools/admin/prefs.ora $HOME/prefs.ora

ORA-12705: Cannot access NLS data files or invalid environment specified

Upgare Oracle E-Business Suite R12.0.0 to R12.0.4 After runing adautocfg.sh geting Error ORA-12705: Cannot access NLS data files or invalid environment specified

Autoconfig Log

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:


[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/VIS/db/tech_st/10.2.0/appsutil/install/VIS_sys38
afdbprf.sh INSTE8_PRF 1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/VIS/db/tech_st/10.2.0/appsutil/install/VIS_sys38
adcrobj.sh INSTE8_APPLY 1


AutoConfig is exiting with status 2


adcrobj.sh started at Sun Nov 16 02:21:23 IST 2008

Parameters passed are : -nopromptmsg

The environment settings are as follows ...

ORACLE_HOME : /u01/oracle/VIS/db/tech_st/10.2.0
ORACLE_SID : VIS
TWO_TASK :
PATH : /u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/VIS/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/VIS/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin
Library Path : /u01/oracle/VIS/db/tech_st/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/VIS/db/tech_st/10.2.0/lib:/usr/dt/lib:/u01/oracle/VIS/db/tech_st/10.2.0/ctx/lib

SQLPLUS Executable : /u01/oracle/VIS/db/tech_st/10.2.0/bin/sqlplus


SQL*Plus: Release 10.2.0.2.0 - Production on Sun Nov 16 02:21:23 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.


Solution:


1.Check $ORA_NLS10
2.Check ORACLE_HOME/nls/data/9idata
3.Check xml file in the Parameter s_db_oranls
/u01/oracle/VIS/db/tech_st/10.2.0/ocommon/nls/admin/data
Change $ORA_NLS10 Path
/u01/oracle/VIS/db/tech_st/10.2.0/nls/data/9idata

or

Create $ORACLE_HOME/nls/data/old/cr9idata.pl

Create nls/data/9idata directory

cd $ORACLE_HOME/nls/data/old

perl cr9idata.pl

Creating directory /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata ...
Copying files to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata!

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

Oracle R12 Installing Error Part-I

Oracle R12 Installing Error
Error:

$./rapidwiz

I found this error " Exception in thread "main" java.lang.UnsatisfiedLinkError:

/app03/StageR12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory".

Workaround:

Run ldd libmawt.so

[root@194150-web1 xawt]# ldd libmawt.so
linux-gate.so.1 => (0xffffe000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0xf7fa4000)
libm.so.6 => /lib/tls/libm.so.6 (0xf7f81000)
libmlib_image.so => not found
libawt.so => not found
libXext.so.6 => not found
libX11.so.6 => not found
libdl.so.2 => /lib/libdl.so.2 (0xf7f7c000)
libjava.so => not found
libjvm.so => not found
libc.so.6 => /lib/tls/libc.so.6 (0xf7e4d000)
/lib/ld-linux.so.2 (0x56555000)

Solution:

Install X11 packages and Install Below all the RPMS WITH THEIR PREQUISTIES for Oracle R12.

binutils-2.15.92.0.2-21.x86_64.rpm
compat-db-4.1.25-9.i386.rpm (32-bit)
compat-db-4.1.25-9.x86_64.rpm
control-center-2.8.0-12.rhel4.5.x86_64.rpm
gcc-3.4.6-3.x86_64.rpm
gcc-c++-3.4.6-3.x86_64.rpm
glibc-2.3.4-2.25.i686.rpm (32-bit)
glibc-2.3.4-2.25.x86_64.rpm
glibc-devel-2.3.4-2.25.i386.rpm (32-bit)
glibc-devel-2.3.4-2.25.x86_64.rpm
glibc-common-2.3.4-2.25.x86_64.rpm
gnome-libs-1.4.1.2.90-44.1.x86_64.rpm
libstdc++-3.4.6-3.i386.rpm (32-bit)
libstdc++-3.4.6-3.x86_64.rpm
libstdc++-devel-3.4.6-3.i386.rpm (32-bit)
libstdc++-devel-3.4.6-3.x86_64.rpm
libgcc-3.4.6-3.i386.rpm (32-bit)
libgcc-3.4.6-3.x86_64.rpm
make-3.80-6.EL4.x86_64.rpm
pdksh-5.2.14-30.3.x86_64.rpm
setarch-1.6-1.x86_64.rpm
sysstat-5.0.5-11.rhel4.x86_64.rpm
xscreensaver-4.18-5.rhel4.11.x86_64.rpm
openmotif21-2.1.30-11.RHEL4.6.i386.rpm**
libaio-0.3.105-2.x86_64.rpm
libaio-0.3.105-2.i386.rpm (32-bit)
libaio-devel-0.3.105-2.x86_64.rpm

After Installed Check

ldd libmawt.so
[root@sys38 xawt]# ldd libmawt.so
/usr/lib/libcwait.so (0x001dd000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x0055d000)
libm.so.6 => /lib/tls/libm.so.6 (0x00915000)
libmlib_image.so => not found
libawt.so => not found
libXext.so.6 => /usr/X11R6/lib/libXext.so.6 (0x002db000)
libX11.so.6 => /usr/X11R6/lib/libX11.so.6 (0x001df000)
libdl.so.2 => /lib/libdl.so.2 (0x00f78000)
libjava.so => not found
libjvm.so => not found
libc.so.6 => /lib/tls/libc.so.6 (0x002e9000)
/lib/ld-linux.so.2 (0x00456000)

After IP Change Oracle APPS R12 Web Application Services Failed

After IP Change Oracle APPS R12 Web Application Services Failed

oafm,forms,oacore status down

ERROR Message...

Oracle Apps stratup Log

Root Service Oracle Process Manager for VIS_sys38 adopmnctl.sh Started
Web Entry Point Services Oracle HTTP Server VIS_sys38 adapcctl.sh Failed
Web Application Services OACORE OC4J Instance VIS_sys38 adoacorectl.sh Failed
Web Application Services FORMS OC4J Instance VIS_sys38 adformsctl.sh Failed
Web Application Services OAFM OC4J Instance VIS_sys38 adoafmctl.sh Failed
Batch Processing Services OracleTNSListenerAPPS_VIS_sys38 adalnctl.sh Started
Batch Processing Services OracleConcMgrVIS_sys38 adcmctl.sh Started
Batch Processing Services Oracle ICSM VIS_sys38 ieoicsm.sh Disabled
Batch Processing Services Oracle Fulfillment Server VIS_sys38 jtffmctl.sh Started
Other Services Disabled
Other Services OracleFormsServer-Forms VIS_sys38 adformsrvctl.sh Disabled
Other Services Oracle Metrics Client VIS_sys38 adfmcctl.sh Disabled
Other Services Oracle Metrics Server VIS_sys38 adfmsctl.sh Disabled
Other Services Oracle MWA Service VIS_sys38 mwactlwrpr.sh Disabled


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

APPS R12 Web Application Services Logs..

11/10/08-19:18:43 :: adoacorectl.sh version 120.11.12000000.2


11/10/08-19:18:43 :: adoacorectl.sh: starting OPMN if it is not running

opmnctl: opmn is already running.

11/10/08-19:18:43 :: adoacorectl.sh: Starting OPMN managed OACORE OC4J instance

opmnctl: starting opmn managed processes...
================================================================================
opmn id=sys38.doyen.in:6200
0 of 1 processes started.

ias-instance id=VIS_sys38.sys38.doyen.in
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
OC4J/oacore/default_group/

Error
--> Process (index=1,uid=1832654593,pid=29902)
failed to start a managed process after the maximum retry limit
Log:
/u02/oracle/VIS/inst/apps/VIS_sys38/logs/ora/10.1.3/opmn/OC4J~oacore~default_group~1


11/10/08-19:19:14 :: adoacorectl.sh: exiting with status 204


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

OPMN managed OACORE OC4J instance Logs..


[applmgr@sys38 ~]$ sh /u02/oracle/VIS/inst/apps/VIS_sys38/admin/scripts/adoacorectl.sh status

You are running adoacorectl.sh version 120.11.12000000.2

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: VIS_sys38.sys38.doyen.in
-------------------+--------------------+---------+---------
ias-component process-type pid status
-------------------+--------------------+---------+---------
OC4J oafm N/A Down
OC4J forms N/A Down
OC4J oacore N/A Down
HTTP_Server HTTP_Server 29760 Alive


adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /u02/oracle/VIS/inst/apps/VIS_sys38/logs/appl/admin/log/adoacorectl.txt for more information ...


Solution


1.Stop Oracle Apps Tier (Stop Oracle Apps Servies)

2. cd $INST_TOP/ora/10.1.3/j2ee

rm -fr oacore/persistence/*
rm -fr oafm/persistence/*
rm -fr forms/persistence/*

3.Start Oracle Apps Tier (Start Oracle Apps Servies)

4.adoacorectl.sh status

[applmgr@sys38 persistence]$ sh /u02/oracle/VIS/inst/apps/VIS_sys38/admin/scripts/adoacorectl.sh status

You are running adoacorectl.sh version 120.11.12000000.2

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: VIS_sys38.sys38.doyen.in
-------------------+--------------------+---------+---------
ias-component process-type pid status
-------------------+--------------------+---------+---------
OC4J oafm 31945 Alive
OC4J forms 31874 Alive
OC4J oacore 31780 Alive
HTTP_Server HTTP_Server 29760 Alive


adoacorectl.sh: exiting with status 0