asrblogger, Author at ASRblogger

ORA-01000: Maximum Open Cursors Exceeded

The ORA-01000 error indicates that the maximum number of open cursors allowed in the database session has been exceeded. This is controlled by the OPEN_CURSORS initialization parameter, which sets the…

asrblogger June 30, 2022No Comments

Oracle

Oracle Database Locking Mechanism – 3

Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions from doing something that requires exclusive access to the same resource. The database automatically acquires…

asrblogger June 22, 2022No Comments

SQL

Detailed explanation of Built-In Data Type in SQL

Character Data Types: • CHAR Data Type • VARCHAR2 Data Type • VARCHAR Data Type • NUMBER Data Type CHAR Data Type The CHAR data type specifies a fixed-length character…

asrblogger June 17, 2022No Comments

Oracle

How to check Total, Active and Inactive sessions in Oracle database ?

To check the total, active, and inactive sessions in an Oracle database, you can query the V$SESSION view. Checking Total Sessions To get the total number of sessions: SELECT COUNT(*)…

asrblogger June 8, 2022No Comments

Scripts

PARTITIONING

Adding partitions 11g/12c -- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD PARTITION <PARTITION_NAME> VALUES LESS THAN < HIGH_VALUE> TABLESPACE <TABLESPACE_NAME > < UPDATE GLOBAL INDEXES(optional)>; -- NOTE: UPDATE GLOBAL INDEXES is…

asrblogger June 7, 2022No Comments

Oracle

OPW-00029: Password complexity failed for SYS !!

PROBLEM : The attempt to create a password file for a 12.2 database failed : [oracle@localhost dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwprod101 password=oracle OPW-00029: Password complexity failed for SYS user : Password must…

asrblogger June 2, 2022No Comments

Splunk

What is SPLUNK?

Splunk is a software platform to search, analyse & visualize the machine generated data gathered from different websites, applications, sensors, devices etc. which make up your IT infrastructure and business.…

asrblogger May 25, 2022No Comments

SQL

Part 3: Constraints (Primary Key) in SQL

Primary Key Constraints A primary key constraint designates a column as the primary key of a table or view. A composite primary key designates a combination of columns as the…

asrblogger May 22, 2022No Comments

Oracle RAC

Connect String

This property specifies connection information used to connect to an Oracle database. The Oracle installer generally places a sample tnsnames.ora file in your $ORACLE_HOME/network/admin directory, but you can see many sample tnsnames.ora…

asrblogger May 18, 2022No Comments

Oracle

Grid Restart (HAS) & Clusterware (CRS)

Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform (Oracle /Redhat Linux) if [[ `grep ^HAS_USER /etc/init.d/init.ohasd` = "HAS_USER=oracle" ]];then echo "GRID Restart found..."…