3 min read
LOCK A USER: alter user SCOTT account lock; UNLOCK A USER: alter user SCOTT account unlock; CHECK STATUS OF USERS:...
Year: 2022
3 min read
1 min read
Daily Archivelog Generation and size: with daily_summary as ( select trunc(COMPLETION_TIME,'DD') Day, thread#, round(sum(BLOCKSBLOCK_SIZE)/1048576) MB,count() Archives_Generated from v$archived_log where dest_id=1...
1 min read
Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory Solution export...
1 min read
SQL> ALTER DISKGROUP DATA MOUNT;ALTER DISKGROUP DATA MOUNT*ERROR at line 1:ORA-15032: not all alterations performedORA-15017: diskgroup "DATA" cannot be mountedORA-15040:...
This content is password protected. To view it please enter your password below: Password:
Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance by storing columnar-compressed database segments...
2 min read
Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance...
1 min read
The Oracle COALESCE() function accepts a list of arguments and returns the first one that evaluates to a non-null value. The following...
1 min read
The view v$sql contains almost of queries which are executed in your Oracle DB. Basicallyyou have privileges to query this...
4 min read
Install JDK, PYTHON, SCALASet path for JDK and Python3Install & Configure CassandraLoad Data In CassandraInstall & Configure SparkSet Path for...
5 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
Node server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 : olsnodes -nserver1 1server2 2server3 3...
3 min read
ISSUE: - WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR -> Error at line 255138: script md/admin/sdordfm.plb- ORA-20002: ORA-06502:...
1 min read
Issue: PDB went into restricted mode Investigation su - oracle export ORACLE_HOME=/u01/oracle/product/19/db export ORACLE_SID= cp9494 $ORACLE_HOME/OPatch/datapatch -verbose If you get...
2 min read
ORA-10567: Redo is inconsistent with data block on standby Issues: ORA-10567: Redo is inconsistent with data block on standby Error:...
1 min read
To perform the export/import first we need to create a backup directory at the OS level as well as Database...
3 min read
This content is password protected. To view it please enter your password below: Password:
5 min read
By using Optimized Incremental Backup to disk backup strategy, an up to date copy of the database is always available...
5 min read
Overview of Triggers A database trigger is a compiled stored program unit, written in either PL/SQL or Java, that Oracle...
1 min read
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
1 min read
Scenario 1: The following message is received when exporting an Oracle Data Integrator (ODI) 12c Master Repository: Scenario 2: While...
4 min read
Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions from doing something that requires...
4 min read
Character Data Types: • CHAR Data Type • VARCHAR2 Data Type • VARCHAR Data Type • NUMBER Data Type CHAR...
Adding partitions 11g/12c -- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD PARTITION <PARTITION_NAME> VALUES LESS THAN < HIGH_VALUE> TABLESPACE <TABLESPACE_NAME >...
3 min read
Primary Key Constraints A primary key constraint designates a column as the primary key of a table or view. A...
