Oracle Apps Administration

How to check database is running with spfile or pfile | In oracle database there is couple of way to find out whether database is running with spfile or pfile. Parameter File How to check database is running with spfile or pfile. 1.SQL> show parameter spfile;   After executing above returns blank then database was … Read more

Difference between physical and logical backup in oracle | In this post, we will discuss the about differences between physical (RMAN) and logical backup(expdp). Difference between physical and logical backup. Physical backup is backup of the physical files such as datafiles, control files, and archived redo logs. Ultimately, every physical backup is a copy of files … Read more

Introduction: – Here will cover to fix POCFH Fill Employee Hierarchy. The file poxpofeh.sql appear to be missing. To resolve it we need to apply the required patch. Error:-Routine fdpsql cannot read the file /data01/apps/apps_st/appl/po/12.0.0/sql/poxpofeh.sql.   How to POCFH Fill Employee Hierarchy?   Check if the file exists under correct product directory. Check if the … Read more

Here we will discuss ‘what is control file in oracle’ and ‘how to multiplex control files on separate disk’.       What is control file in oracle.     Control file is a binary file which stores Database name, associated data files, redo files, DB creation time and current log sequence number. Without control … Read more

In this post we will covers ‘How to resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. How to fix ORA-12514 TNSlistener does not currently know of service? ERROR DESCRIPTION:(*******FATAL ERROR*******PROGRAM : (*******/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkPrepareACTables.pl)TIME    : Sat Sep  8 10:25:42 2018FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]MESSAGES:Invalid Connect string – cannot connect to … Read more

How do you switch and create spfile from pfile| In this article we will discuss ‘how to create pfile from spfile’. Spfile is a binary file.  By default, a new Oracle database will be working on a pfile,  so the spfile must be created from the pfile using SQL command. URL:- https://youtu.be/G5eE79poQzU   How do you … Read more

Below is useful configuration files and directories in Linux. Every DBA must be aware for daily operation.     File Name Description /etc/passwd /etc/passwd file is used to keep track of every registered user that has access to a system. File that contains the following information: Username. Encrypted password. User ID number (UID)  /etc/hosts hosts … Read more

Difference between hot backup and cold backup | I n Oracle database we are doing either hot (inconsistent) or cold (consistent) backup. Suppose we have requirement to do the backup in working hours. In this situation we have to plan hot backup. For cold or consistent backup, we have to plan it in night because … Read more

AutoPatch error the worker should not have status Running or Restarted | ADOP Patch Session got terminated abnormally due to network issue or patch hung or lost connectivity after that we are facing the error when restart adop patch. AutoPatch error the worker should not have status Running or Restarted at this point.   Error: … Read more