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.
Introduction:- In this article, we will use best API to reset password from backend | Being Oracle Database administrator,we are using various API scripts to do the administrative task in Oracle Database.Before executing script we should test it on test/dev instance, then migrate the solution/script to production carefully. Here we are discussing ‘how to change user password … Read more
Introduction:- Being Oracle Database administrator, we are using various API to end date responsibility to do the administrative task in Oracle Database.Before executing script we should test it on test/dev instance, then migrate the solution/script to production carefully. Here we are discussing ‘how to end date responsibility in oracle apps from backend‘ using API to … Read more
API to add responsibility to Assign responsibility to user in oracle apps from backend | Being Oracle Database administrator, we are using various API scripts to do the administrative task in Oracle Database.Before executing script we should test it on test/dev instance, then migrate the solution to production carefully. Here we are discussing ‘how to … Read more
Introduction: – RMAN catalog command tips | To restore the oracle database using rman , first of all we have to Cataloging RMAN backup in RMAN Catalog. There are many rman catalog commands to register old backupset to new location, so that rman read the backup piece and restore them. Below is some RMAN CATALOG command example. Catalog … Read more
In this post, we will resolve error importing function definition for ‘BASH_FUNC_module‘. Error: sh: module: line 1: syntax error: unexpected end of file sh: error importing function definition for ‘BASH_FUNC_module‘ or sh: module: line 1: syntax error: unexpected end of file sh: error importing function definition for `module’ Steps … Read more
Introduction: – Steps to remove oracle database in Oracle |. Suppose we have requirement to drop entire oracle database if we are planning to refresh test or development database instance, to fulfill the requirement we must drop/delete/remove the database. There are several ways to remove database. We will discuss here using CLI to delete oracle … Read more
Here I will explain how to disable trigger in oracle. Some time we have to disable the trigger on table. Use below query to disable the trigger in oracle database. How to disable trigger in oracle Here is the command alter table disable trigger to disable trigger for Table & schema etc. How to disable … Read more
Introduction: – In this article we will learn how to Backup database plus archive log delete input. In oracle database it’s very important to manage the archive logs to free up the space on archive log destination for new archive logs. Follow below steps to backup database plus archive log delete input. Some rman commands … Read more
adrelink is exiting with status 1 r12| When attempting to apply R12.ATG_PF.B.delta.3 patch 8919491, error appears on relink, the following error occurs on relinking executables task. How to fix adrelink is exiting with status 1 r12 ERROR — adrelink failed in r12 adrelink.log:- Relink of module “MSCCPP” failed. Relink of module “MSCMON” failed. Relink of module “MSCNEW” … Read more
How to Create bigfile tablespace| A bigfile tablespace is a tablespace with a single, but very large (up to 4g blocks) datafile. A bigfile tablespace with a typical 8K block can contain a single 32-terabyte datafile. If you’re using a 32K block, it can contain a 128-terabyte datafile. SQL> CREATE BIGFILE TABLESPACE bigtbls DATAFILE ‘/data01/prod/bigtbs01.dbf’ … Read more