asrblogger, Author at ASRblogger

How to Perform ORACLE_HOME Backup?

Backup of the Oracle home can be taken using any preferred method. You can use any tool such as zip, tar, and cpio to compress the Oracle home. It is…

asrblogger December 26, 2022No Comments

Linux Oracle

UNIX Shell Script To Run DataPump Or Traditional Export Or Import Utilities

To create a shell script to run export/import utilities. # SCRIPT # --------- # # Set environment variables for ORACLE_HOME, ORACLE_SID, # and DUMPDIR -- in case of datapump --,…

asrblogger December 19, 2022No Comments

Linux

How to check Java Version Installed on Linux ??

There are many middleware tools which require latest version of java jdk to be installed on your Linux machine. You can easily find and check the latest version of jdk…

asrblogger December 18, 2022No Comments

Linux Oracle

How To tell if a script was run in the background ?

The ps utility can get the process state. The process state code will contain the character + when running in foreground. Absence of + means code is running in background.…

asrblogger December 12, 2022No Comments

Oracle

How to move/copy controlfile from filesystem to ASM ??

1. Create a pfile as a backup of your spfile sqlplus '/ as sysdba' SQL> create pfile='/tmp/spfile-bk.ora' from spfile; 2. Update the control_file parameter in the spfile. sqlplus '/ as…

asrblogger December 6, 2022No Comments

Oracle Scripts

Profiles

A profile is a collection of attributes that apply to a user.The profile is used to enable a single point of reference for multiple users who share theseattributes.You should assign…

asrblogger December 4, 2022No Comments

Oracle

User Management

About User Accounts:The areas in which you can configure security are as follows: • User accounts For users to access your database, you must create user accounts and grant appropriate…

asrblogger December 4, 2022No Comments

Oracle Scripts

How to Decide if column should be indexed?

Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine index will really help to perform query faster? Q. Which…

asrblogger December 4, 2022No Comments

Oracle Scripts

Protected: Database Link (DB Link)

This content is password protected. To view it please go to the post page and enter the password.

asrblogger December 4, 2022

Oracle SQL

Recovery Catalog

What is Recovery Catalog? A recovery catalog is a database schema used by RMAN Which is used to stored Metadata of one ormore databases. Benefits: It creates the redundancy for…