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 how to configure DMZ (Isupplier on external node) on shared file system. To add external node, we must follow the below steps. Steps to Add Node to a Shared Application Tier File System for Oracle E-Business Suite R12 Configuring DMZ in R12. Here we will know ‘how to configure isupplier (dmz) in … Read more
In this post we will learn how to check ora error on oracle database using shell scripts. We can prepare scripts and schedule to monitor error in alert log., due to this error our database not functioning as expected. To overcome this issue well prepare proactive alert to check the ora error if any. How … Read more
Schedule shell script for tablespace report in oracle database| In this article we will explain ‘how to generate Tablespace report’ in oracle database and automate alert on mail using mailx. To pull out tablespace report in oracle database. We will prepare the shell script as below and schedule it using crontab. Step 1:- Prepare tablespace … Read more
In this post we learn how to manage Temporary Table space in Oracle Database. | Temporary tablespaces are providing temporary space for database sort operations and for storing global temporary tables. To Create user with default tablespace and temporary tablespace. SQL> CREATE USER scott DEFAULT TABLESPACE data TEMPORARY TABLESPACE temp; SQL> ALTER USER scott … Read more