Monday, June 25, 2012

ORA-20002: 3207: User 'SYSADMIN' does not have access to notification 66758. ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line 84 ORA-06512: at line 1

›
Changed Workflow Administrator role from SYSADMIN to a user ABC. After this change the users started getting the following error in workflo...
15 comments:

FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, oXXXXXXXX.tmp in the directory, /usr/tmp

›
A TEST instance was already up and running and I created another production clone on the same server/machine. Once the services of both ...
8 comments:
Sunday, May 20, 2012

11gR1 Data Guard: Logs apply on standby is stoped due to currept or incomplete log

›
Check the logs apply status Login to standby database (Open read only if not already opened) SQL> select max(al.sequence#) "Last S...
3 comments:

R12 Web ADI: Make it work with MS Office 2010

›
In Excel 2010 Go to File > Options. Following screen will open Select Trust center Click on Trust c...
43 comments:

ORA-02303: cannot drop or replace a type with type or table dependents

›
Try to modify a type and CREATE OR REPLACE TYPE gives the error: ORA-02303: cannot drop or replace a type with type or table dependents ...
7 comments:

Check how many archive logs have been recieved and applied by standby database

›
Login to standby database (Open read only if not already opned) SQL> select max(al.sequence#) "Last Seq Recieved", max(lh.se...
6 comments:

Delete N number of lines from a file on Linux

›
$ sed -i 'starting_line_no, end_line_no d' file_name $ sed -i '1,5d' test.txt The above command will delete first 5 lin...
4 comments: