skip to main | skip to sidebar

Oracle Apps DBA OceanOfKnowledge

Sunday, August 15, 2010

Apps dba related issues

Login as “apps” user via sql*plus and run delete SQL below to remove the values for profile %SignOn%Passwo%, otherwise the FNDCPASS command will fail: (should delete 4 rows only)
SQL> delete from FND_PROFILE_OPTION_VALUES
where profile_option_id in (5792,3844,2027,4524 )
and level_id = 10001
Posted by Raghavendra Lakshmipathy at 5:13 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2011 (1)
    • ►  October (1)
  • ▼  2010 (36)
    • ►  December (1)
    • ►  September (12)
    • ▼  August (23)
      • Version related commands/scripts on appln side
      • TEMP tablespace droping and recreating
      • Tkprof and Explain plan and traceanalyzer
      • Form
      • Tablespace, datafiles, tables, index related scripts
      • Statspack
      • Issues
      • Apache or web service
      • Steps for dropping and creating undo tablespace:
      • Procedure to drop and recreate log files
      • RAC
      • stats, reorg, index rebuild
      • RMAN
      • WORKFLOW
      • Application commands
      • Apps dba related issues
      • LOCK, performance realated scripts
      • Create read only user like apps
      • PATCH related scripts
      • DATABASE scripts
      • Version related scripts from database
      • Concurrent Manager and program related scripts
      • CLONE related scripts
  • ►  2009 (4)
    • ►  July (4)
  • ►  2007 (2)
    • ►  November (1)
    • ►  September (1)

Apps DBA Knowledge

My photo
Raghavendra Lakshmipathy
View my complete profile