Today one of the Physical standby database environment faced an case where the Media Recovery MRP process got crashed and the standby database got out of sync. This post describes how to repair multiple or single-correct file of data files. Mon Jul 28 10:26:04 2020MRP0: Background Media Recovery terminated with error 1111ORA-01157: cannot identify/lock data […]

I encountered such an error in cloud control: Port IBPort[14] is polling for peer port. This could happen when the cable is unplugged from one of the ends or the other end port is disabled. In the Exalogic Elastic Cloud racks, you may see issue of IB ports showing status as “Down” when running “ibstat” […]

İs as follows the output of these commands: maintenance hardware list maintenance problems show confirm shell zpool status confirm shell zpool list maintenance hardware show We have a memory problem in Exalogic ZFS Storage cel01 node.Details appearing on the ilom are as follows; İlom > Maintenance > ProblemsDescription Multiple correctable ECC errors on a memory […]

Oracle Exadata Smart Scan and Cell Offloading Smart Scan is probably the most important performance component of the software in terms of exceptional performance offered by Exadata. Smart Scan is a cell offloading feature that is to process into storage cells offload of performing block I / O requests at the database layer. The purpose […]

Hi, in this post I will write about how Oracle Database 19c Multitenant architecture PDB is created with DBCA. Run the DBCA after the CDB Database is set. Then just follow the steps as below. Choose Manage Pluggable Databases Choose Create a Pluggable Database Enter the sys information for the container database. Choose Create a […]

If you get an error like below while running root.sh file on the installation screen, you need to restart the installation. [root@db~]#/oracle/grid18c/root.shPerforming root user operation for Oracle 18c The following environment variables are set as:ORACLE_OWNER= ora18cORACLE_HOME= /oracle/grid18c Enter the full pathname of the local bin directory: [/usr/local/bin]:The contents of “dbhome” have not changed. No need […]

To change the NLS_DATE_FORMAT setting Use the below command, it will help to solve your problems for after restart database. Also, if you do not want to do this at the instance level, you can make session NLS_DATE_FORMAT based on sql queries. ALTER SESSION SET NLS_DATE_FORMAT=’DD-MM-YYYY’; [oraetkb@sp000dba01 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 […]

In this post, Pluggable database ORA-01157 error we will examine.I encountered an error on when opening the database like below The data file may have been renamed at the operating system level, moved to a different directory or disk drive with or without awareness.In this case, restore and recover the data file or move the […]

I encountered an error on Exadata like below. Alert Summary Maintenance A memory component suspected of causing a fault Detailed Alert Information A memory component is suspected of causing a fault with a 100% certainty. Check Cellcli. cellcli > list alerthistory There is no error Check İlom -> show /SYS/MB/P0/D7 /SYS/MB/P0/D7 Targets: PRSNT SERVICE fault_state […]

When I wanted to change the password on the pluggable database user, I got an error like the one below. SQL> alter user test identified by test; alter user test identified by test ERROR at line 1:ORA-65066: The specified changes must apply to all containers View connection information. SQL> show con_nameCON_NAMEPLUG1 Login as sysdba SQL> […]

Today I will talk about a problem I encountered in pdbs “ORA-01033” error on Oracle Container Database. Query existing databases running on the container. SELECT inst_id,con_id,name,open_mode FROM gv$pdbs ORDER BY con_id,inst_id If the databases are “ALTER PLUGGABLE DATABASE ALL OPEN” If you opened it with the command, you just opened it on the relevant cdb. […]

When doing data pump operation with Oracle, you can get an error like below if schema to import is not authorized.This is very common error which comes due to insufficient privileges on tablespace. ORA-39083: Object type TABLE:”TEST”.”TEST1″ failed to create with error: ORA-01950: no privileges on tablespace ‘USERS’ SQL>select USERNAME, DEFAULT_TABLESPACE from dba_users where USERNAME=’test’; […]

Create a Oracle database with the name PRİMARYDB running in ARCHIVELOG mode. For simplicity the database can be created with all files located under one common area: For example “/opt/oracle/oradata/primarydb/” Archive log files can be located at “/opt/oracle/oradata/primarydb/arch” Use small redo log file sizes (1 megabyte) to simulate redo activity. Before using RMAN, we need […]

When the control file file is deleted or its location changes, when you try to run oracle database, we encountered an error like below. SQL> startupORACLE instance started.ORA-00205: error in identifying control file, check alert log for more info See control file location show parameter control_files NAME TYPE VALUE control_files string +DATAC/TESTDB/CONTROLFILE/cu rrent.814.1034955455 Confirm the […]

On the Oracle GoldenGate app, you may encounter an error like below when logging in with the goldengate user. The error I encountered occurred in the 11.2.0.4 database on the Oracle 19c GoldenGate version. Oracle Bug fixed in 12.1.2.1.0 and on later versions. Correct it by adding DBMS_STREAMS_ADM.set_tag for 11g DB. Oracle will continue to […]

I encountered a problem with yum repository problem on Oracle linux 8, you can produce a solution by doing the following operations. It can also cause the following issues. Incorrect date and time settings Old dnf cache available or expired Proxy address not defined or proxy address specified in /etc/dnf/dnf.conf file is incorrect cd /etc/yum.repos.d […]

Dataguard Switchover is a planned role change. In other words, it is the transition of the live database to the standby role and the standby database to the live role. We may be doing Dataguard switchover for testing the functionality of our backup database, doing maintenance work in our live database, etc.Dataguard Switchover operation can […]

In this post we will demonstrate how to create the Oracle RAC Database Software Clone manually, add them to the respective clone.pl script on Oracle Full Rack Exadata Compute Node. Create a tarball of the source home Node1 cd /u01/app/ orcl /product/orcl_12201tar zcvf /u01/app/ orcl /orcl .tar Node2 cd /u01/app/ orcl /product/orcl_12201tar zcvf /u01/app/ orcl […]

In the Exadata and Exalogic Elastic Cloud racks, you may see issue of IB ports showing status as “Down” when running “ibstat” command. This issue can of happen on Compute Nodes,İnifiniband Switch or Storage heads. IB port being down on Compute Node can be confirmed by running below command [root@xc000xc-ibb01 ~] # listlinkup Connector 0A […]

While working on an Oracle ASM instance, we may encounter a spfile creation error like the one below. SQL> create pfile=’/u01/ora/inittkitest3.ora’ from spfile; create pfile=’/u01/ora/inittkitest3.ora’ from spfile * ERROR at line 1: ORA-01565: error in identifying file ‘?/dbs/[email protected]’ ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 […]

While working on the Exadata Storage cell insert, the attachment failed due to the internal USB drive in the storage cell. Oracle uses the internal USB drive to automatically back up the Exadata Storage cell. We do not have to back up the storage cell manually. In this article, I will show you how to […]

In this post we will demonstrate how to create the Cell Disk and Grid disks manually, add them to the respective ASM Disk Group on Oracle Full Rack Exadata Cell Node. The Exadata Machine is expected to be up and running and the storage cell containing the failed drive to boot and be available. If […]

Today I received an email from Anuj Agarwal, founder of Feedspot .Thank you for your attention. I will try to be worthy. BigDBA is on the Top 100 list. For detailed list: https://blog.feedspot.com/oracle_blogs

In this article, we will learn how to congure yum server in dierent Oracle Linux versions. YUM repository is a software package manager which allows you to easily install, update or delete RPMs. Most of the required RPM packages come along with the Linux installer CD. But! if you have internet connection, you can congure […]

The solution for Oracle Database insufficient privileges generic error is as follows. [grid@testdb1 ~]$ srvctl start asm; [grid@testdb1 ~]$ crsctl stat res -t SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file ‘+DATA/ORCL/PARAMETERFILE/spfileORCL.ora’ ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora […]

1- Veritas InfoScaleVeritas InfoScale Availability is a comprehensive high availability and disaster recovery center solution that protects critical business services from planned and unplanned outages. 2- Advantages of Veritas InfoScaleVeritas InfoScale Advantages: The InfoScale family of products is installed on an on-premises disc media. This product is especially active in disk virtualization, brand-independent inter-disk data […]

Oracle Enterprise Manager 12c is one of the Cloud Control Database management tools. It is a database management tool developed by Oracle for managing databases and operating systems independently from one place. Enterprise Manager Grid Control, which was previously called Enterprise Manager 12c & 13C Cloud Control is the new name of the management tool. […]

SGA = also known as shared memory space. This is the area where data and control information generated on the Ram is stored when Oracle Instance is started. It is not allowed to be used by another application until the database is closed. When turned off, the memory space returns to the source system. This […]

The purpose of LOB (Large Object) Data Types is to store large data. Ex. document (txt, word, excel, xml), pictures, video, audio and so on. This type of data was previously held in data types such as long, raw, long raw, and nowadays large objects are held in data types such as BLOB, CLOB, NCLOP. […]

ORA-03113: end-of-file on communication channel Process ID: 194555 Session ID: 1537 Serial number: 3 ERROR: failed to establish dependency between database TEDAS and diskgroup resource ora.DATAC1.dg SQL> shu immediate; SQL> alter database nomount; SQL> alter database mount; SQL> select * from v$log; SQL> alter database clear unarchived logfile group 50; SQL> alter database clear unarchived […]

I will write, what we should do when a log interval “GAP” occurs between Primary / Standby and we accidentally delete some of the archive log files on the Primary database. Suppose we do not have a backup of the deleted archive files. Normally we dba should not allow such a situation, but such a […]

What Is Big Data? It is the concept of making large amounts of data collected over time in an economic and scalable manner and where the relational database techniques are not sufficient. The importance and value of the data is increasing day by day. The reason for the increase in the importance and value of […]

SCAN is a name that gives clients access to the cluster service. You can use cluvfy comp scan (found Grid_home \ bin) to verify that DNS correctly associates the SCAN with the addresses. Because SCAN is associated with the cluster as a whole instead of a specific node, SCAN makes it possible to add or […]

This post describes how to repair multiple or single-block corruption of data files, including system data files, in the Oracle database. Block corruption is a common source of database outages. Database block becomes corrupted when its content is different from what the Oracle database expects to find. If block corruption is not prevented or repaired, […]

PostgreSQL 12 An open-source object is a relational, highly scalable, SQL-compliant database management system. PostgreSQL was developed at the University of California at the Berkeley Computer Science Department. This article will help you install PostgreSQL 12 on a CentOS / RHEL 7/6 system. CentOS’s default repositories contain postgresql packages, so we can install them seamlessly […]

Oracle MySQL 5.6 and 5.7 stands out as the most mature version with the highest performance in MySQL’s history. Also the third release after Oracle’s acquisition. In this article, we will install and configure Oracle MySQL 5.6 and 5.7 on Linux and Red Hat Enterprise Linux 6,7 and 7. If you want to run the […]

What is MongoDB? MongoDB (“humongous”); is a scalable, document-oriented, open source, NoSQL database application developed with C ++. MongoDB is especially used in structures that require speed and where traditional relational databases (RDBMS) remain cumbersome and slow. MongoDB can work in C, C # .NET, C ++ Erlang, Java, JavaScript, Ruby, Perl, Pyton, Node.JS. In […]

Oracle’s GoldenGate is a software solution that enables DML, DDL, DCL and TCL replication of existing data between databases. If you want to explain this sentence briefly, thanks to Oracle GoldenGate, we can transfer and operate the records of the transactions performed on the source database on the target databases we want, in real time […]

Starting from Oracle HA (High Availability) products, Oracle Dataguard, RAC and RMAN are the most commonly used products. Oracle Streams emerges as a replication product, but mainly uses Oracle Logical Standby technology. Oracle Streams generally consists of three different processes called Apply, Propagate and Capture. Apply is the process that runs the LCR records in […]

It is a low level cache mechanism used by Zend to reduce CPU usage on each request through the intermediate code generated by the standard Zend runtime compiler in the Zend Optimizer. A product that improves for faster operation. If you are using php 5.5 on your server and you have not turned it off, […]