Understanding Oracle APEX: Oracle APEX is a low-code development platform that empowers users to build data-centric web applications swiftly. Leveraging SQL and PL/SQL, developers can create responsive and feature-rich applications without extensive programming knowledge. APEX offers a plethora of pre-built components and templates, facilitating rapid prototyping and deployment. Key Features of Oracle APEX: Drag-and-Drop Interface: […]

Oracle Advanced Support Gateway is a crucial component for managing and maintaining Oracle Engineered Systems effectively. It provides advanced support capabilities, allowing businesses to optimize performance, enhance security, and streamline operations. The installation process involves several steps, including preparation, software download, configuration, testing, and documentation. Each step must be executed carefully to ensure a successful […]

Sub Title: Step-by-Step Guide: Applying Update 17 Patch on Oracle Enterprise Manager Cloud Control 13.5 Software Reference: Cloud Control Advanced Installation and Configuration Guide We previously had an infrastructure running Oracle Enterprise Manager Cloud Control 13.2 version on Solaris OS. Upon upgrading our database version from 12 to 19c, we encountered numerous errors due to […]

CONTENTSSECTION 1-) GOLDENGATE INSTALLATION • Goldengate Installation• Extract Process• GGSCI commands• Parameter Files• As400 Extract Example• Oracle Extract Example• Pump Example• Replicate Process• GGSCI commands• Parameter files• Replicate Example• Manager Operation• GGSCI commands• Parameter File• Manager Example• Useful commands SECTION 2-) USE OF GOLDENGATE • Goldengate Daily Usage• INFO• STATS• Using Extracta. As400 ExampleI. infoii. […]

Recovering Deleted Datafile, Tables in Oracle Database and Understanding “Point In Time Recovery” Scenario 1: Loss of a datafile Scenario 2: Loss of all datafiles  Scenario 3: Point-In-Time Recovery Scenario 4: Loss of datafiles, control files, online redo log files and server parameter file  Prerequisites Create a Oracle database with the name PRİMARYDB running in […]

In the development environment, a quick copy of a database with a different dbname or sid may be required. In such cases, we need to use rman duplicate or standard rman restore method. In this post, we will change the dbname by doing a quick copy. Steps Perform a backup of the primary standby database […]

Hi mate, How is your day going so far? I wish you luck to achieve what you’re hardworking for. this post I wanted to handle on the Exadata installation process. All IP addresses must be statically assigned, including dynamically assigned (DHCP) addresses.All RDMA Network structure IP addresses must be in the same subnet with a […]

Oracle RAC provides clustering by allowing multiple computers to run Oracle RDBMS software simultaneously while accessing a single database. In a non-RAC Oracle database, a single instance accesses a single database. The database consists of a collection of data files , control files and redo logs located on disk . Example contains a collection of […]

TFA is now called the Autonomous Health Framework (AHF). After this installation you will have (TFA) & ORAchk/EXAchk service. Oracle Trace File Analyzer TFA setup is very simple, please follow the steps below. Download Here Then put the downloaded file in any folder. Login as root. You can run the file. ./ahf_setup Make a note […]

Oracle Database Resource Manager allows you to manage multiple workloads within a database that compete for system and database resources. The Resource Manager helps overcome these issues by allowing the database to gain greater control over how hardware resources are allocated. In an environment with multiple concurrent user sessions running jobs with different priorities, not […]

Oracle released Oracle Exadata, the first engineering database system, in 2008. in 2011, the company announced the Oracle Database Appliance as a smaller, less powerful alternative to Oracle Exadata at a lower price point. According to industry analysts, Oracle expected Oracle Database Appliance to fill the gap in its product line under Oracle Exadata by […]

ASR Manager Installation and registration steps are as follows; ASR Manager Installation Follow the procedures below while installing the ASR package on the ASR manager system. You can connect as root in the ASR Manager system and open a terminal window 2. You can install For ASR package, go to the folder where you unpacked […]

Thing first RAC stands for real application cluster the main objective of real application cluster is to provide performance scalability and resilience. Real application cluster is one of the database options that are available to extend the functionality of Oracle database.

Write-back flash caching is faster than writing to hard disks, a write back flash cache, used to improve write-intensive operations, is useful for running heavy-duty jobs in a database. According to Oracle, depending on the application, write performance to disk can be 20 times faster (measured at input / output operations per second (IOPS)) and […]

Data Safe is a unified control center for your Oracle Databases that helps you understand the sensitivity of your data, assess data-related risks, mask sensitive data, implement and monitor security controls, evaluate user security, monitor user activity, and meet data security compliance requirements. . Whether you are using Oracle Autonomous Database. Data Safe, Oracle Database […]

Oracle database has started to work proactively since 10G. Working proactively means taking measures by intervening as soon as we receive an alert about the database. As seen in the picture above, it does everything automatically.Automatic Workload Repository (AWR): It is a storage area that keeps the statistical information necessary for the detection and solution […]

Registering Hosts and Deploying the Agent 6.2.2 Audit Vault Agent Requirements Ensure that the host machine has OpenSSL 1.0.1 (or later) installed for Audit Vault Agent [root@sp000dba03 ~]# rpm -qa|grep -i ssl openssl-libs-1.0.2k-19.0.1.el7.x86_64 openssl-1.0.2k-19.0.1.el7.x86_64 JAVA Requirements: Table 2-10 JRE Support Matrix JRE Version Release/Version 1.8 1.8.0_45 and later 11 11.0.3 Starting Oracle Audit Vault and Database […]

Two Best Practice Recreating controlfile DBNEWID utility First let’s see how to change the DB name using manual assumption (By recreating the control file) ASSUMPTİON 1: RE-CREATING CONTROLFILE STEP1:- CREATE CONTROLFILE CREATATION SCRIPT. [oracle@NVMBD1BZY150D00 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed May 24 16:29:40 2014Copyright (c) 1982, 2011, Oracle. All rights […]

In this post the changing of IP addresses on an Oracle Exadata Database Machine system. The most common use case for this procedure is when a system is moved, so this document was written with that case in mind. Importantly, system hostnames and domain name changes are not handled by this procedure. Assumptions The grid […]

Oracle Enterprise Manager 12c R5 (12.1.0.5) Cloud Control Installation, Configuration and Management Oracle Database 12CR2 Standalone in Red Hat Linux Step by step Database installation is made by adhering to the document. We install the packages required for Oracle Enterprise Manager 12c Cloud Control Installation to our operating system. yum install make-3*yum install binutils-2*yum install […]

INDEX 1   Downloading Database Files. 2   Database Software. 3   OS Configuration And Preparation. 4   Oracle Installation. 4.1 Prerequisites. 4.2 Add groups. 4.3 Add user Oracle for database software. 4.4 Change password for user Oracle. 5  Manual Setup. 5.1 Additional Setup. 5.2 Installation. First visit: 24 Sep, 2020 | 13:42:08Last visit:  24 Sep, 2020 | 13:42:08 Number of visits: 1 […]

Oracle Database SQL PLAN BASELINE is probably the most important performance component of the software in terms of exceptional performance offered by Oracle. This reduces link traffic between the execution plan, database layer database and buffer cache improves. GET THE PLAN OF THE QUESTION AT SHARED POOL select inst_id,SQL_PLAN_BASELINE ,sql_fulltext,sql_profile ,trunc(elapsed_time/decode(executions, 0, 1, executions)/1000000) elapsed_time, […]

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 […]

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 […]

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 […]

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 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 […]

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. […]

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 […]

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, […]

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 […]