Oracle DBA Blog for sharing best practices, code examples and innovative solutions. Focusing Specifically on Oracle performance and optimization issues, Oracle Indexes, Database and EBS Administration.
Oracle Apps Administration categories is related to EBS issues and solutions.
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: How … Read more
Adop Phase Cutover Failing with AutoPatch| Oracle E-Business Suite (EBS) Release 12.2 introduces Online Patching, a mechanism that enables you to apply patches to your EBS environment while it remains available for end-users. The key tool used during the patching process is the AD Online Patching Utility (adop). However, there are instances when the Adop … 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 database … 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. How to start and shutdown oracle database Once login on database server. We will login in database as below and … Read more