21 May 2012

Step by Step Enable or Disable the Oracle Triggers

Step by Step Enable or Disable the All Oracle Triggers in Single shot


Example:-

 BEGIN
   FOR i IN (SELECT trigger_name
               FROM all_triggers
              WHERE trigger_name LIKE 'JAI%' AND status = 'DISABLED')
   LOOP
     EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' DISABLE';  
  
     EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' ENABLE';
           
      END LOOP;
END;
/

14 May 2012

Function Not Available To This Responsibility” After Upgrading To Release 12.1.3

Error:-
When i am clicck Examine I am facing below issue:-

Function Not Available To This Responsibility


  This is standard functionality. The EBS instance was upgraded to R12.1.3.

Solution:-
Choose System Administrator, navigate to System > Profiles, and query the profile %Diagnostics% (“Utilities : Diagnostics”) . change the value to Yes.






Logout your instance.
Close all your Browser
Restart Apache Browser

Retest the issue.



Reference:
“Function Not Available To This Responsibility” After Upgrading To Release 12.1.3 [ID 1200743.1]

03 May 2012

Oracle Application R12.1.1 9239090 Patch adrelink failed

Oracle Application R12.1.1 9239090 Patch adrelink failed

[oracle@tigers scripts]$ grep failed /oracle/CBE/apps/apps_st/appl/admin/CBE/log/adrelink.log
Relink of module "FEMCCE" failed.
Relink of module "MSCCPP" failed.
Relink of module "MSCMON" failed.
Relink of module "MSCNEW" failed.
Relink of module "MSCNSP" failed.
Relink of module "MSCNSPNM" failed.
Relink of module "MSCPCL" failed.
Relink of module "MSCPDW" failed.
Relink of module "MSCPRG" failed.
Relink of module "MSCSDW" failed.
Relink of module "MSCSLD" failed.
Relink of module "MSCXGCAL" failed.
Relink of module "MSONEW" failed.
Relink of module "MSRNEW" failed.
Relink of module "MSCCPP" failed.
Relink of module "MSCMON" failed.
Relink of module "MSCNEW" failed.
Relink of module "MSCNSP" failed.
Relink of module "MSCNSPNM" failed.
Relink of module "MSCPCL" failed.
Relink of module "MSCPDW" failed.
Relink of module "MSCPRG" failed.
Relink of module "MSCSDW" failed.
Relink of module "MSCSLD" failed.
Relink of module "MSCXGCAL" failed.
[oracle@tigers scripts]$

Logfile Error :-

/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomitemorgbkt.o)
`.gnu.linkonce.t._ZN7OmValue3setEd' referenced in section `.rodata' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomprodresuse.o):
defined in discarded section `.gnu.linkonce.t._ZN7OmValue3setEd' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomprodresuse.o)
`.gnu.linkonce.t._ZN7OmValue3addEd' referenced in section `.rodata' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomprodresuse.o):
defined in discarded section `.gnu.linkonce.t._ZN7OmValue3addEd' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomprodresuse.o)
`.gnu.linkonce.t._ZN7OmValue3addEd' referenced in section `.rodata' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomresourcebkt.o):
defined in discarded section `.gnu.linkonce.t._ZN7OmValue3addEd' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomresourcebkt.o)
`.gnu.linkonce.t._ZN7OmValue3addEd' referenced in section `.rodata' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomsupplierbkt.o):
defined in discarded section `.gnu.linkonce.t._ZN7OmValue3addEd' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomsupplierbkt.o)
`.gnu.linkonce.t._ZN7OmValue3setEd' referenced in section `.rodata' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomdemandsatflow.o):
defined in discarded section `.gnu.linkonce.t._ZN7OmValue3setEd' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomdemandsatflow.o)
`.gnu.linkonce.t._ZN7OmValue3addEd' referenced in section `.rodata' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomresconsume.o):
defined in discarded section `.gnu.linkonce.t._ZN7OmValue3addEd' of
/oracle/CBE/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomresconsume.o)
collect2: ld returned 1 exit status
make: *** [/oracle/CBE/apps/apps_st/appl/msc/12.0.0/bin/MSCMON] Error 1
Done with link of msc executable 'MSCMON' on Thu May  3 17:02:57 IST 2012

Relink of module "MSCMON" 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 /oracle/CBE/apps/apps_st/appl/msc/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation

Solutions:-

We need to check the binutils version using below command

[root@tigers ~]# rpm -qa binutils
binutils-2.17.50.0.6-14.el5
[root@tigers ~]#

We need to Downgrade binutil version

we can get the source from below website  http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/

Package name is  binutils-2.17.50.0.6-6.0.1.el5.x86_64.rpm

[root@tigers oracle]# rpm -Uvh --oldpackage binutils-2.17.50.0.6-6.0.1.el5.x86_64.rpm
Preparing...                ########################################### [100%]
   1:binutils               ########################################### [100%]
[root@tigers oracle]#rpm -qa binutils
binutils-2.17.50.0.6-6.0.1.el5
[root@tigers oracle]#

Result :-

Swapping bintmp and binstage.
Stage preparation complete.

adrelink is exiting with status 0

End of adrelink session
Date/time is  Thu May 3 17:19:20 IST 2012

02 May 2012

How can I disable "Set as Desktop Background" as an option in Firefox

How can I disable "Set as Desktop Background" as an option in Firefox

You Need to Configure userChrome.css file  Click Here to Configure

Click Add to Firefox  then Click Install  Afer completing the installation restart Your browser

Then Click Tools --> ChromeEdit Plus --> ChromeEdit

You need to Add below line
#context-setDesktopBackground {display: none !important;}
 
 
Then Click restart.
 
Dont forget to remove ChromeEditor addon. 

Manual Method :-

You need to edit below File Open with as a NotePad
 
C:\Users\Administrator\AppData\Roaming\Mozilla\Firefox\Profiles\36xwzu03.default\chrome\userChrome.css
 
Clear all the data  
 
Add below Lines
 
 /*
 * Edit this file and copy it as userChrome.css into your
 * profile-directory/chrome/
 */

/*
 * This file can be used to customize the look of Mozilla's user interface
 * You should consider using !important on rules which you want to
 * override default settings.
 */

/*
 * Do not remove the @namespace line -- it's required for correct functioning
 */
@namespace url("http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul"); /* set default namespace to XUL */

#context-setDesktopBackground {display: none !important;}

/*
 * Some possible accessibility enhancements:
 */
/*
 * Make all the default font sizes 20 pt:
 *
 * * {
 *   font-size: 20pt !important
 * }
 */
/*
 * Make menu items in particular 15 pt instead of the default size:
 *
 * menupopup > * {
 *   font-size: 15pt !important
 * }
 */
/*
 * Give the Location (URL) Bar a fixed-width font
 *
 * #urlbar {
 *    font-family: monospace !important;
 * }
 */

/*
 * For more examples see http://www.mozilla.org/unix/customizing.html
 */
 
then save and restart your browser .