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.
rman commands with examples | In this post, we will discuss Important RMAN commands for Oracle database. We are using these rman commands to manage the Oracle Database. Below is the various RMAN commands list that will help it more for daily dba jobs. Some rman commands with examples Below are some rman commands which … Read more
The “WARNING inbound connection timed out ORA-3136” in the alert log indicates that the client was not able to complete it’s authentication within the period of time specified by parameter. WARNING inbound connection timed out ORA-3136. SQLNET.INBOUND_CONNECT_TIMEOUT. You may also witness ORA-12170 without timeout error on the database server sqlnet.log file. This entry … Read more
In this post I will explain how to refresh test dev database from production RMAN backup. To “refresh database from rman backup” we will prefer from valid production rman backup. oracle database refresh from production to test involves restoring the database backup from the production environment to the test/development environment. This process should be executed carefully to … Read more
Here we will discuss how to do the manual installation/configuration of oracle binary and restore database on new server using backup. To configure the Oracle Home binary on new server or existing one backup of all we need to take the binary file backup. After that follow the below steps to configure. Step 1: -Copy all … Read more
Best Oracle DBA Interview Questions and Answers:- In this post , discussing about oracle dba Interview Questions and Answers for senior and junior DBA:—- Grid Computing (Architecture):- Grid computing groups of independent, modular hardware and software components, can be connected and rejoined on demand to meet the changing needs of businesses. Grid computing also enables … Read more
Introduction:- How to manually compile JSP in R12. Steps to manually Compile JSP in R12 to resolve login page blank EBS R12| In hist article, we will cover jsp compilation in R12. Why are we compiling jsp? Actually, sometime we are facing blank ebs login page due to missing or corrupted class files under EBS … Read more
Introduction:- In this article, we will resolve Rapid Clone Issue ouicli.pl inste8_apply 255 in R12. After setting the PATH as below, rerun the Perl and issue got resolved. R12: Rapid Clone Issue ouicli.pl INSTE8_APPLY 255 During EBS rapid clone, I had faced error as below mentioned. (i,e RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack.). … Read more
Introducton:- In this post we will discuss ‘How to clone EBS and Database clone using rman backup’. Here we will perform rapid clone for ebs and restore database using rman How to clone EBS and Database? Follow the below steps carefully to complete ‘rapid clone using rman’ backup for the EBS & Database … Read more
how to block restrict prevent access E-Business Suite from users access And Allow Specific Users in 11i/R12:- In this post we will know how to prevent EBS user access(restrict ebs login from user in oracle) and allow specific user in 11i/R12. During critical activity going from the business side and willing to restrict/prevent Business users accessing Oracle Applications, … Read more
Introduction: – Here we will discuss how to steps to clean nonexistent nodes and cleanup fnd_node in R12. To clear fnd_node in ebs, we need to execute FND_CONC_CLONE.SETUP. Steps to clean nonexistent nodes. We are going to execute FND_CONC_CLONE.SETUP to clear fnd_node table. Step 1:- Execute EXEC FND_CONC_CLONE.SETUP_CLEAN; SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN; SQL> COMMIT; Note: … Read more