Readmeout Oracle DBA Blog

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

adoacorectl.sh adformsctl.sh adoafmctl.sh exiting with status 150| Sometimes application services not brought down gracefully and don’t delete the .lock file. Later we bring up the application then these .lock file causing an issue for OC4J instance.   How to fix adoacorectl.sh adformsctl.sh adoafmctl.sh exiting with status 150? To fix this error adoacorectl.sh exiting with status … Read more

Here we going to discuss ‘How to register custom top in oracle apps r12‘. Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will use “xxcustomzprod.txt”. How to register custom top in oracle apps r12. We will follow below steps to register/create custom top in r12.2. Step 1: – Creating Custom TOP/Application using AD Splice … Read more

ALECDC Program was terminated by signal 11 for all oracle alerts. | Due to this issue all oracle alerts terminated with signal 11. Signal 11 is a generic error, the likely cause of this issue is lack of OS resources. How to fix ALECDC Program was terminated by signal 11 We are also showing error … Read more

Mount Windows share filesystem on linux using CISF|Common Internet File System(CISF) is file sharing network protocol mainly used to provide shared access to files, printers, serial ports, and miscellaneous communications between nodes on a network. You can easily access CIFS share from Linux and mount them as a regular filesystem.       Examples:-      #mount … Read more