EBS Clone online procedure

Overview only :

Step 1:

Complete prerequisites on target server see my step by step document

Step 2 :

run adpreclone procedure on database tier and application tier

Step 3 :

copy db, apps, inst to target machine and also change ownership

db — database user

apps,inst — appl user

Step 4 :

take rman backup and copy to target machine

Step 5:

Restore database to target machine using rman

Step 6:

change database name

(more...)

User not authorized to execute service (SBL-EAI-04308)

When i try integrate EBS and Siebel, its getting below error in siebel

Error invoking service ‘XXACE_CREATE_RECEIPTS_SIEBEL_PortType_2′, method ‘XXACE_RECEIPTS’ at step ‘Transport’.(SBL-BPR-00162)

Operation ‘XXACE_RECEIPTS’ of Web Service ‘http://xmlns.oracle.com/apps/ar/soaprovider/plsql/xxace_create_receipts_siebel/.XXACE_CREATE_RECEIPTS_SIEBEL_Service’ at port ‘XXACE_CREATE_RECEIPTS_SIEBEL_Port’ failed with the following explanation: “User not authorized to execute service.”.(SBL-EAI-04308):

 

Solution : 

Go to EBS Integrated SOA –> Choose particular interface (Interface type — plsql — Receivable )

revoke sysadmin privilege and then (more...)

Oracle 12c (12.1.0.2.0) database step by step installation guide on redhat linux 5.6

 

Download Document here

Oracle 12c database installation guide on redhat linux 5.6


find out which device mapped with oracle asm disk

Step 1 :

 

[oracle@asmoracle ~]$ /etc/init.d/oracleasm listdisks

DISK1
DISK2
DISK3
DISK4

 

Step 2 :

[oracle@asmoracle ~]$ /etc/init.d/oracleasm querydisk -d DISK1
Disk “DISK1″ is a valid ASM disk on device /dev/sdc1[8,33]

The device noted here is (8,33), so go to

 

[root@asmoracle dev]# ls -l sd*
brw-r—– 1 root disk 8, 0 Aug 18 08:39 sda
brw-r—– 1 root disk 8, 1 Aug 18 08:39 sda1
brw-r—– 1 root disk 8, 2 (more...)

Support ID : How to enable and retrieve FND debug log messages

If you want to know about FND Debug log configuration in R12, this below document id is useful for you

How to enable and retrieve FND debug log messages (Doc ID 433199.1)


PERWSDOR form compile in r12

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US

cd $ORACLE_HOME/bin

[appltrng@ebsdev bin]$   frmcmp_batch module=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/PERWSDOR.fmb userid=apps/Ace321b output_file=/u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx module_type=form batch=no compile_all=yes

Compiling WHEN-BUTTON-PRESSED trigger on PREV_MONTH item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_MONTH item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_YEAR item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on PREV_YEAR item in CALENDAR data block…
No compilation errors.
Created form file /u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx


asm spfile

The below article useful to know about asm spfile and How asm instance started if spfile in diskgroup without mount.

http://asmsupportguy.blogspot.in/2014/03/asm-spfile-in-disk-group.html

This article he explained for  normal redundancy . If you want to find the spfile on external redundancy level, you can use below command

[oracle@asmoracle ~]$ asmcmd lsdsk -G DATA
Path
/dev/oracleasm/disks/DISK1
/dev/oracleasm/disks/DISK2


[oracle@asmoracle ~]$ kfed read /dev/oracleasm/disks/DISK1 | grep -E 'spf|ausize'
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.spfile: 1450 ;  (more...)

Force option in ASM

This below url is very useful to know about force option in asm

http://asmsupportguy.blogspot.com/2011/12/forcing-issue.html


Create diskgroup in ASM

Steps for creating diskgroup in ASM (Single Node)

 

Step 1: Add new HDD to server and done partition. Here I added two HDD

[root@asmoracle ~]# fdisk /dev/sde
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklab el
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

Warning: invalid flag 0x0000 of  (more...)

Patch applied or not in R12

you can get the patch applied details in EBS R12 from below command

 

select AP.PATCH_NAME, AP.PATCH_TYPE, AD.DRIVER_FILE_NAME, AD.CREATION_DATE, AD.PLATFORM,AL.LANGUAGE
from AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL
where AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID
and AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID and AP.PATCH_NAME='17627621'