Oracle Archives - Page 26 of 30

Trigger – Oracle Database Objects

Overview of Triggers A database trigger is a compiled stored program unit, written in either PL/SQL or Java, that Oracle Database invokes ("fires") automatically in certain situations. A trigger fires…

asrblogger July 14, 2022No Comments

Oracle

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

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

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

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

asrblogger May 18, 2022No Comments

Oracle RAC

Change Archivelog Destination (FRA)

Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database. It can be done in up are running condition of DB .…

asrblogger May 4, 2022No Comments

DataGuard Oracle

ORA-01194: file 1 needs more recovery to be consistent

SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/prod/system01.dbf' Suppose we are…

asrblogger May 1, 2022No Comments

Oracle

Cassandra Commands

cassandra -f [start commads] ./nodetool status [checking status] ./nodetool ring [depicts of the state of nodes] ./nodetool -h 192.168.0.101 clean [cleanup of keys that no longer belong to a particular…