ORA-12514 TNSlistener does not currently know of service requested in connect descriptor

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 11g,12c,19c

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

Some useful configuration files and directories in linux

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

AutoPatch error the worker should not have status Running or Restarted at this point

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

How to drop XLA_GLT temporary Tables in EBS

Drop XLA_GLT temporary Tables| As an Oracle DBA we need to reclaim space in database. For this we need to clear all temporary tables in our instance, which is no longer required. Temporary tables used in the GL Transfer process are no longer cleared down once the transfer is complete. using program ‘Purge Temporary Journal … Read more

adoacorectl.sh adformsctl.sh adoafmctl.sh exiting with status 150 or unable to start oacore oc4j in r12

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

How to register custom top in oracle apps r12

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

Mount Windows share filesystem on linux using CISF

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