Oracle Apps Administration

In this post we will discuss what is oracle database. Here we will learn it in detail related to oracle database. We already know that database is very important to store any data into database. We must have aware about database and its characteristics. Let’s start about what is oracle database. Introduction to oracle database We … Read more

How to run SQL tuning advisor manually in Oracle Database| In Oracle Database, the SQL Tuning Advisor is a powerful tool that helps optimize the performance of SQL queries. It analyzes SQL statements and provides recommendations to improve their execution plans. Here’s a step-by-step guide on how to run the SQL Tuning Advisor manually: Run … Read more

Finding the WebLogic URL and Port from Oracle E-Business Suite. | In Oracle E-Business Suite (EBS) Release 12.2, the context file plays a crucial role in configuring various parameters for the application, including the Oracle WebLogic Server. For administrators and developers, accessing the WebLogic URL and port information is essential for managing the EBS instance … Read more

How to Resolve ORA-01153 an incompatible media recovery is active. | ORA-01153 “an incompatible media recovery is active” is an error message that occurs when attempting to perform certain operations on an Oracle database while a media recovery process is running in an incompatible mode. This error typically happens when you try to open the … Read more

Here we will see how to resolve ora-12353. The Oracle error ORA-12353 indicates that there is a problem with a database link. This error occurs when an attempt is made to create, drop, or alter a database link, but the operation fails due to insufficient privileges or other issues related to the database link configuration. … Read more

We can use the below command to accomplish the action. If you want to know how to start and shutdown oracle database, first of all we should login into database server using putty as below. Steps to start and shutdown oracle database. Once login on database server. We will login in database as below and … Read more

TNS-12560: TNS:protocol adapter error, TNS 00583 Valid node checking unable to parse configuration parameters facing error while trying to start listener. Fixing TNS 00583 configuration parameters. Error: – dbuatsrv$ lsnrctl start DBUAT TNSLSNR for Linux: Version 19.0.0.0.0 – Production System parameter file is /dbuat/oracle/DBUAT/db/tech_st/19.3.0/network/admin/listener.ora Log messages written to /dbuat/oracle/DBUAT/db/tech_st/19.3.0/log/diag/tnslsnr/dbuatsrv/dbuatc/alert/log.xml Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbuatsrv)(PORT=1590))) TNS-12560: TNS: … Read more

PRCR-1001 Resource does not exist while recreating password during cloning database. How to fix PRCR-1001 Resource does not exist. Error:- [dbqc@dbsqcsvr]$ orapwd file=’+DATANC1/DBQCC/orapwdbqcc’ asm=y force=y entries=12 format=12 Enter password for SYS: KGFCHECK kgfnStmtExecute01c: (ret == OCI_SUCCESS): FAILED at kgfn.c:3698 [dbqc@dbsqcsvr .rman]$ srvctl modify database -db DBQCC -pwfile ‘+DATANC1/DBQCC/orapwdbqcc’ PRCD-1120 The resource for database DBQCC could … Read more

Here will discuss how to Synchronize FND_NODES ADOP_VALID_NODES FND_OAM_CONTEXT_FILES in 12.2 How to Synchronize FND_NODES ADOP_VALID_NODES FND_OAM_CONTEXT_FILES. Error 1:- adop phase=prepare FATAL ERROR PROGRAM : (/data01/ad/12.0.0/bin/adzdoptl.pl)TIME : Fri Oct 2 22:06:45 2015FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]ERRORMSG: adop is not able to detect any valid application tier nodes in ADOP_VALID_NODES table. Ensure autoconfig is run … Read more

Introduction: – Ora-20100 temporary file creation failed for fnd_file| ORA-20100: ORA-20100: File o00031194568.tmp creation failed for fnd_file. File could not be opened or operated on as requested. Action: Make sure the directory – /usr/tmp/RMDBUAT – is a valid directory with write permissions and is accessible from the database server node for write operation. Concurrent Request … Read more