Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the first …
Read More »ORACLE
Oracle Database Architecture Part 1
In this article I will tell you about Oracle Database Architecture. Oracle Database is the most preferred database in the world, especially in large scale …
Read More »Running the Oracle ASM Configuration Assistant (asmca) tool from the command line
We can use the Oracle ASM configuration assistant (asmca) tool via the GUI, or from the command line. In other words, we can run …
Read More »Oracle Database Startup and Shutdown Modes
In this article, I will explain the startup and shutdown modes of Oracle database. Oracle Database Startup Modes A closed Oracle database opens in …
Read More »ORA-12528: TNS:listener: all appropriate instances are blocking new connections
When trying to connect to an open intance via the listener, you may receive the error “ORA-12528: TNS: listener: all appropriate instances are blocking new …
Read More »Oracle 11g Software and Database Installation
In this article I will explain the software and database installation of Oracle 11g database. You can download Oracle 11g software from this link. …
Read More »How To Resize Datafiles in Oracle
We ensure that unused space in the datafiles are reclaimed by the ASM disk group with the resize process. This ensures that unused areas …
Read More »How To Calculate IOPS of an Oracle Database
IOPS (Input/Output Operations Per Second) is a common performance metric used to compare computer storage devices. IOPS in Oracle databases is the total number of …
Read More »Why Exadata Disks in “CLOSED” or “IGNORED” Status(v$asm_disk)
Some of the disks may be in CLOSED and IGNORED status when “v$asm_disk” is queried after a broken disk on the Exadata storage is …
Read More »Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors
When taking a backup with Expdp, it can be terminated with ORA-31693, ORA-02354 and ORA-01555 errors when it comes to a table with a lob …
Read More »