Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Oracle Apps Administration categories is related to EBS issues and solutions.
In this post we will discuss about OPW-00010: Could not create the password file. We faced the issue while creating the password file. Error :- Enter password for SYS: OPW-00010: Could not create the password file.RESOURCE LIST: ora.gbpatc.db Solution:- To solve OPW-00010, we should reset the location of password file. Then try to recreate it … Read more
In this post we will discuss about OPW-00014: Could not delete password file. Facing OPW-00014: Could not delete password file while executing $orapwd FILE=’+DATA/PRTEST/orapwprtestc’ delete=y. Error: – Solution:- Use the below command to delete the Password File which was previously created in oracle database.
To Covert .pld to .pll we must follow the steps as given below. Here we are generating .pll from .pld file. In 11i Converting .pld file in .PLL File f60gen Module=XXSXDO.pld Userid=apps/***** parse=yes Module_Type=LIBRARY In R12 Converting .pld file in .PLL File frmcmp_batch Module=XXSXDO.pld Userid=apps/***** parse=yes Module_Type=LIBRARY To Generate .plx from .pll Once you convert … Read more
One day i had faced error ora-01031 insufficient privilege while tried to connect database as sysdba using sys user. Normally we were able to connect database successfully, but today no luck to do so. Resolve ORA-01031 insufficient privileges Issue $sqlplus / as sysdba SQL*Plus: Release 19.2.0.3.0 – Production on Wed Apr 9 01:12:00 2022 Copyright … Read more
We know that ORA-01031 Insufficient Privileges means current user did not have the right privilege to access or process the SQL statement. We can see this error almost in every kind of SQL statement, sometimes you would never know what privilege you have required. We have several situation where we can face the ORA-01031 error. … Read more
In this post we will discuss How to change database name using nid in oracle. The “nid” (New Database Identifier) utility in Oracle cannot be used to directly update the database name, also known as the global database name. The Global Database Name, which is normally defined during the database creation process, serves as the … Read more
Running AutoConfig in parallel on a multi node EBS R12 environment presents an effective solution to improve performance, achieve configuration consistency, and speed up the setup process to address this issue. Enterprise systems must be flexible and scalable in the fast-paced corporate environment of today. The Oracle E-Business Suite Suite Release 12 (EBS R12) is a … Read more
How to run AutoConfig in Test Mode | An intelligent strategy that enables you to verify configuration changes before implementing them in your production environment is to run AutoConfig in test mode within EBS. You will be guided through the process of executing AutoConfig in test mode in Oracle E-Business Suite in this manual. Understanding … Read more
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