Performance tuning is one area where most Junior DBAs face those tough-to-break problems. The kind of problems which require deep understanding of the concepts before…
1 CommentExpert Oracle Posts
In one of our database where GoldenGate setup is done, RMAN process was not able to delete the archive logs. The error message that coming…
Leave a CommentUsually we monitor the EXPDP/IMPDP jobs by monitoring the log files generated by expdp/impdp process. Also we monitor alert log too just in case some error pops up. This helps most of the time. If you have a long running expdp/impdp sessions as you are exporting/importing huge GBs then it helps to have a more detailed monitoring of the expdp/impdp jobs. Some of the useful queries which can be used to monitor the Data Pump Jobs are mentioned below.
To start with some of the important tables/views that you should refer to monitor Data Pump Jobs are:
2 CommentsAll Oracle Apps DBA must have referred below Note id at least once in their career. Most of us refer it during installation and upgrade of Oracle EBS
application to verify if we have right set if database parameters defined for the optimum performance of EBS application.
Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)
This document has all the required database parameters which are common to all the database release and which are required by EBS application. It also contains release specific database initialization parameters for different releases like 10g, 11g, 12c etc.
Leave a CommentIt is required sometime to connect oracle database to SQL Server database using uni-direction or bi-direction methods. Since these are two different database so something as simple as direct DBLINK will not work here. Below are the basic concepts of making connection from SQL SERVER to Oracle and vice-versa.
Leave a CommentWe faced a scenario in our database where users were complaining about database performance. Database seems to be hanging and queries were either stuck or not running at all.
It was also seen that UNDO tablespace consumption was increasing.
Leave a CommentOne of our EBS R12 instance was giving below kind of errors when users were trying to open the log and out files of Concurrent requests from EBS front end.
“The Applications File Server could not open the file /fs01/logs/appl/conc/log/l106163221.req for read”
Leave a CommentGoldenGate 12c version has many great features as compared to older versions. Below are some of the key new features of Oracle GoldenGate 12c that are worth mentioning
1 CommentWhen we face issues in GoldenGate extract or replicat setup, we follow some of the tried and tested initial troubleshooting steps mentioned below that helps us in pointing out the exact case of the issue.
To start with, GGSCI commands which are useful for Gathering evidences of issue:
Leave a CommentDuring one of our 11gR2 database restore activity we found below error message in the RMAN “duplicate database command”
channel aux4: ORA-19870: error while restoring backup piece /oraclone/ORCL/rman_clone/ORCL_F_20170605_c1s60alv_1_1 ORA-19504: failed to create file "+DATA3" ORA-15045: ASM file name '+DATA3' is not in reference form ORA-17502: ksfdcre:5 Failed to create file +DATA3 ORA-15081: failed to submit an I/O operation to a disk ORA-27091: unable to queue I/O ORA-27041: unable to open file SVR4 Error: 13: Permission denied1 Comment