Sending An Attachment Via Unix

mutt -s "Test Mail" -a /home/applprod/doganay.zip doganayn@yahoo.com < /home/applprod/n.txt




Note:/home/applprod/n.txt is dummy txt.It can use for not opening the MUTT emulator

There Are No Active Responsibilities Available For This User

Problem:

While you are configuring DMZ Server on EBS you can some harmful changing
like 'Responsibility Trust Level’ profile
If  'Responsibility Trust Level’ status changed to 'external' from 'normal'
you may get this error below:

There are no active responsibilities available for this user


Solution:

1)

Run this procedure below with apps user:
--------------------------------------------------------------------
DECLARE
stat boolean;
BEGIN
stat := FND_PROFILE.SAVE('APPL_SERVER_TRUST_LEVEL', '2', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
--------------------------------------------------------------------

2)Then shutdown application(adstpall.sh)

3)Then run autoconfig(autocfg.sh)

4)Finally startup your application(adstrtall.sh)

Login ebs and see your success:)


Pray and Tray:))

ORA-01565: error in identifying file

we get errors below while doing adcfgclone in test environment.

Problem:

ORA-01565: error in identifying file '/test1_db/sys/system11.dbf'
ORA-27048: skgfifi: file header information is invalid



Solution:

Resize dbfs which are full.


How to detect and fix a corruption in the datafile OS header/Block Zero - ORA-27047 (Doc ID 360032.1)
So please run the following command on the source database
dbfsize /test1_db/sys/system11.dbf

Done relinking module WSCMTM in product wsm

Problem:

While applying patch 12603409

Done relinking module WSCMTM in product wsm
Done with link of product 'wsm' on Fri Mar 29 19:34:26 EET 2013
adrelink is exiting with status 1


via adadmin relink WSM WSCMTI then 'An error occurred while relinking application programs.
Continue as if it were successful [No] :


Solution:

via adadmin relink WSM WSCMTI then 'An error occurred while relinking application programs.
Continue as if it were successful [No] :

adadmin-------->choose 2----->choose 1---->relink

Continue as if it were successful [No] :

Choose 'yes'

ORA-27048 skgfifi: file header information is invalid

Problem:

We got this error while running adcfgclone.pl

ORA-27048 skgfifi: file header information is invalid

Solution:

Check all the dbfs like this below:

dbfsize /test_db/sys/system01.dbf

If the output is 'Bad block'.This is dbf corruption.But don't worry.

You try to resize this dbf,then run see the dbsize again.

Ref:

R12: Rapidclone fails with error 'ORA-27048 skgfifi: file header information is invalid' [ID 1406053.1]

FRM-40735 On-Insert Trigger Raised Unhandled Exception ORA-04063

Problem:


FRM-40735 On-Insert Trigger Raised Unhandled Exception ORA-04063

Solution:

Apply the patch 13017245
Set ICX: Numeric characters = 10.000,00

Retest the issue

LsInventory: OPatch Exception while accessing O2O

Problem:

bash-4.2$ opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.57
Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /appdata/data_appl/apps/tech_st/10.1.2
Oracle Home Inventory : /appdata/data_appl/apps/tech_st/10.1.2/inventory
Central Inventory     : /appdata/data_appl/inst/apps/BRLTEST_testburlaapp/admin/oraInventory
   from               : /etc/oraInst.loc
OUI location          : /appdata/data_appl/apps/tech_st/10.1.2/oui
OUI shared library    : /appdata/data_appl/apps/tech_st/10.1.2/oui/lib/ibm_aix/liboraInstaller.so
Java location         : /appdata/data_appl/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /appdata/data_appl/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Creating log file "/appdata/data_appl/apps/tech_st/10.1.2/.patch_storage/LsInventory__03-07-2013_10-27-38.log"

Result:

LsInventory: OPatch Exception while accessing O2O


OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred:
OPatch Exception:
  OUI found no such ORACLE_HOME set in the environment
  Can not get details for given Oracle Home
  An exception occurs
  null


There is no Interim Patch



OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred:
Can not get a list of inventory on this home.

ERROR: OPatch failed because of Inventory problem.


Solution:


cd $ORACLE_HOME/appsutil/clone
perl ouicli.pl

Then OPatch succeeded.

Ref:
How To Create, Update or Rebuild The Central Inventory For Oracle Applications EBS R12 [ID 742477.1]