15 Jan
by dbtut
It is often time consuming job to gather detailed information about the backups of Oracle databases with RMAN. You need to collect information from many different environments. However, it is easier to access RMAN backup information with queries. You can reach detailed information about the backups taken in the last x days with the […]
14 Jan
by dbtut
When calculating the size of a table in an Oracle database, it is incorrect to just look at the data size. It is necessary to calculate the size of the index, lobsegment and lobindex objects of the table. Because when we move the table to another database, all objects belonging to the table will […]
13 Jan
by dbtut
In Oracle databases running on Linux, you can access the relevant session information from each user processes. In most cases, it is necessary to detect queries that use excessive resources in the operating system. For this determination, the process id of the corresponding process on linux can be matched with the session’s spid information […]
12 Jan
by dbtut
On Exadata cellnodes, the RS-7445 error can be received due to the inability to send heartbeat under overload. This error appears in versions 11.2.2.4.0 and 11.2.3.2.1 of the Oracle Exadata Storage Server software. As a result of the error, the CELLSRV service is restarted by RS. When Cellnode alert.log is examined, errors will be […]
11 Jan
by dbtut
Tags: MAXCORRUPT, MAXCORRUPT FOR DATAFILE, RMAN MAXCORRUPT, RMAN ORA-19566
When we get a backup with Rman, if there is a damaged block on a datafile, the ORA-19566 error will be received and the backup operation will not be completed. It will generate error message as below. ORA-19566: exceeded limit of 0 corrupt blocks for file +DATA/orcl/datafile/users.369.864669603 First, the corrupt block should be corrected. […]
10 Jan
by dbtut
Tags: chained_rows, ORA-01495, ORA-01495: specified chain row table not found
A chained row is called a row that does not fit into a single database block. For example, when you try to add a 16K size row to a database that has a block size of 8KB, that record will use 3 blocks. This row is called a chained row because it does not […]
9 Jan
by dbtut
Tags: ORA-01031, ORA-06512, ORA-39127
When you are backing up with Data Pump (expdp), it may indicate that the privileges are insufficient and may end with errors such as ORA-39127, ORA-01031, ORA-06512. Possible errors may be as follows. ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.schema_info_exp(‘ORCL1′,0,1,’10.02.00.05.00’,newblock) ORA-01031: insufficient privileges ORA-06512: at “SYS.DBMS_SESSION”, line 97 ORA-06512: at “WMSYS.LT_CTX_PKG”, line 2116 ORA-06512: […]
7 Jan
by dbtut
ADR Command Interpreter (ADRCI) is a command-line tool in the fault detection infrastructure of Oracle databases. With ADRCI; We can see the diagnostic data in the Automatic Diagnostic Repository (ADR). We can view Health Monitoring reports. For Oracle Support, we can create packages containing accident and problem information in the form of a zip file. […]
6 Jan
by dbtut
Oracle Flashback Query allows us to query as much as possible of the past committed data. We can query the data in the past over the time stamp or system change number (SCN). For Flashback Query use, the flashback feature of the database does not need to be turned on. Oracle flashback query usage […]
5 Jan
by dbtut
Tags: qcisSetPlsqlCtx
Depending on the timezone differences ORA-00600 error can be occured when opening the database. The argument for this error is [qcisSetPlsqlCtx: tzi init], which causes the database not to open. The error is due to timezone differences. If the patch has been applied to the restored backup, but this patch is not available for […]
