Restore rman backup to different server with different database name

Here we will Restore rman backup to different server with different database name. Perform backup on production server and we will restore it on any QC,DEV or UAT server.     We have taken “RMAN backup” of PROD and will restore rman backup to different server with different database name.   Let’s take two servers … Read more

How to schedule shell script for rman backup using shell script to backup oracle database.

Here we will discuss about requirement configure shell script, configure shell script to backup & schedule shell script for rman backup script to complete rman full backup using crontab in Linux, Solaris and Unix platform. Cron job will be triggered as per scheduled time. How to schedule shell script for rman backup?   In this … Read more

Importance of executing root.sh and orainstroot.sh in oracle

In this post we will understand how to execute root.sh and orainstroot.sh  scripts  and What is the importance of executing orainstRoot.sh and root.sh scripts .     Post installation steps, we have to execute two scripts ‘orainstRoot.sh’ and ‘root.sh’ scripts and Oracle also suggest backing up the ‘orainstRoot.sh’ and ‘root.sh’ scripts. These two scripts we should execute as ‘root’ user as it … Read more

lp and lpr return unauthorized error in linux cups printing on cups server.

Resolved printing lp and lpr return unauthorized error and MSG-00002: reject in Linux CUPS print server. Many times, Invoice printing failed as lp: Unauthorized below while ebs user’s trying to print from oracle application. Here I will show how to resolve lp: Unauthorized issue in CUPS Server printers.conf setting. Error showing in ebs Request log. … Read more

rman commands with examples

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

WARNING inbound connection timed out ORA-3136 in oracle database

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

Refresh TEST DEV Database from Production RMAN backup

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

Oracle Database Administrator

Here we will discussed environment and tasks of an Oracle Database administrator (DBA). It also discusses DBA security and how you obtain the necessary administrative privileges. Administering an Oracle Database:-   A small site can have one database administrator who administers the database for application developers and users related issues.    Database Administrator:-   Database requires … Read more

Oracle dba interview questions and answers for experienced.

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