Oracle Archives - Page 17 of 30

Read-only user Creation.

Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the user,one should always keep in mind that the user should have minimum privileges. There is…

asrblogger January 15, 2023No Comments

GoldenGate Oracle

Before we start tuning GoldenGate…

Large objects (LOBs) LOBs can be a problem in data replication by virtue of their size and the ability to extract, transmit, and deliver the data from source to target.…

asrblogger January 12, 2023No Comments

Oracle

System Locks Oracle Database uses various types of system locks to protect internal database and memory structures. These mechanisms are inaccessible to users because users have no control over their…

asrblogger January 7, 2023No Comments

GoldenGate Oracle

Adding Replicats with @RANGE function in GG

Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation). To resolve the gap quickly, we opted in creating Range Replicat. The RANGE function The…

asrblogger January 3, 2023No Comments

Interview Questions Oracle

ORA-01653: Adding, Resizing of datafiles in Oracle

Datafiles are part of the Oracle Database, these are the files that have the actual data in them. Datafiles can be located on ASM or file system on disk. So…

asrblogger December 31, 2022No Comments

ASM Oracle RAC

Step by Step ASM/ Grid Installation in Oracle RAC

Grid-Installation-ASRBLG-1Download Hope it helped !! :)

asrblogger December 30, 2022No Comments

Linux Oracle Scripts

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 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…