Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
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
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
ORA-02020 too many database links in use means that the database limits the number of open database links on every session. You can increase the parameter for later use. For example, after opening 9 db links, we failed to open the 10th db link. Fixing ORA-02020 too many database links in use. To fix the … 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