How to Calculate Oracle Undo Retention

Oracle Software

12 March 2024   0 Comment

Hi folks, I decided to write a practical article for the Undo retention calculation. The transaction undo information generated in the database is stored in the rollback segments until the commit or rollback is performed. Sometimes our long-running queries in the database are met with the error ”ORA-01555:Snapshot Too Old”.This is due to the fact […]

Read More

Oracle Multi tenant Architecture ORA-20000 “12c 12.2.0.1.0” container Schema does not exist or insufficient privileges

Oracle Container Database and Pluggable Database

20 December 2023   0 Comment

I recently had to face such a problem. For those who give up, the answer is below 🙂 exec dbms_Stats.gather_schema_stats(‘TESTSCHEMA’); ERROR at line 1:ORA-20000: Schema ” TESTSCHEMA” does not exist or insufficient privilegesORA-06512: at “SYS.DBMS_STATS”, line 38330ORA-06512: at “SYS.DBMS_STATS”, line 38289ORA-06512: at “SYS.DBMS_STATS”, line 8593ORA-06512: at “SYS.DBMS_STATS”, line 38172ORA-06512: at “SYS.DBMS_STATS”, line 38317ORA-06512: at line […]

Read More

How to Quickly 13C Release 5 Update 17 RU(13.5.0.17) Patch Apply on Oracle Enterprise Manager Cloud Control 13.5

Oracle Cloud Control 13C Release 5 Update 17

8 December 2023   0 Comment

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

Read More

How to Enable Bluetooth On Linux

linux tutorial bigdba

28 November 2023   0 Comment

Recently, I needed to use bluetooth on my computer using the linux operating system, and I saw that the services were turned off, I share the steps and controls I applied as follows. You can also follow the same similar steps to give an idea in these distro’s as well: debian, ubuntu, kali, redhat, rhel6,7,8,9 […]

Read More

PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT “ORA-04036”

How to fix Oracle

26 October 2023   0 Comment

Unable to allocate memory for new incident error in file /u01/app/oracle/diag/rdbms/instance_name/instance_name/trace/instance_name_m72034.trc:ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT I had a same problem and solved it by doing the following. See what the current pga_aggregate_limit is using this (in case you want to revert your changes): show parameter pga_aggregate_limit; alter system set pga_aggregate_limit = […]

Read More

Oracle Database 19c Wait for an Undo Record Event “Wait for a undo record”

How to fix Oracle

20 October 2023   0 Comment

Hi Folks,I recently saw wait events on the single instance database, the root cause of the problem was caused by the undo event “Wait for a undo record”. There are cases where parallel process recovery is not as fast as serial process recovery, because the PQ secondary can interfere with each other’s operation by competing […]

Read More

How to Kill Long Running Transactions In The Goldengate Extract

How Problems with Oracle GoldenGate

28 May 2023   0 Comment

You can’t close an extract that is a long running transaction with Golden gate. Let’s find out how it’s done. ./ggsci You can check extract GGSCI (dev) 21> info all GGSCI (dev) 21> send extract name showtrans tabular GGSCI (dev) 21> stop extractname STOP request pending. There are open, long-running transactions. Before you stop Extract, […]

Read More

ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run

Oracle cluster check

27 March 2023   0 Comment

None of the ASM Ctl commands are working and are idle.when checked with ps -ef, you can see that the ASM instance is working and the database is also working well.But we have a problem, the Cluster high availability services are not working. -> asmcmd lsdgASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM […]

Read More

Oracle GoldenGate Best Practices 101

How Problems with Oracle GoldenGate

26 March 2023   0 Comment

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

Read More

ORA-09817: Write to audit file failed, ORA-01013: user requested cancel of current operation

How to fix Oracle

25 March 2023   0 Comment

ERROR at line 1:ORA-09817: Write to audit file failed.SVR4 Error: 49: Disc quota exceededAdditional information: 9ORA-01013: user requested cancel of current operation Solution You should check your disk space. Example cd /u01/app/oracle/admin/orcl/adump/ rm *.aud or solaris -> find /u01/app/oracle/admin/orcl/adump/ -name *.aud -mtime +0 -exec rm -rf {} \;

Read More

ORA-00700: soft internal error, arguments: [pga physmem limit]

21 February 2023   0 Comment

When starting an Oracle Instance, the following messages are displayed in the warning log files, ORA-700 errors are called flexible claims to note that something unexpected has happened, but not fatal to a transaction or moment, so the transaction can proceed without any damage. Cause PGA_AGGREGATE_TARGET specified is highErrors in file /u01/app/oracle/diag/rdbms/bugra/BUGRA/trace/BUGRA_ora_14488.trc (incident=948025):ORA-00700: soft internal […]

Read More

Recovering Deleted Datafile, Tables in Oracle Database and Understanding “Point In Time Recovery”

How to fix Oracle

19 January 2023   0 Comment

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

Read More

How to Simply do Oracle Physical Standby Database Using RMAN Backup/Restore and Change DBNAME Using NID Utility

longs-to-clob

30 November 2022   0 Comment

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

Read More

Oracle Exadata X8M Installation & Deployment Process

16 November 2022   0 Comment

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

Read More

How to Install Oracle 21C Database Real Application Clusters (RAC) on the Docker With Oracle Linux7/RHEL7

11 July 2022   0 Comment

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

Read More

How to Upgrading PostgreSQL 9.2 to 12

Postgresql 9 to 12

24 June 2022   0 Comment

That’s a Tutorial for upgrading the PostgreSQL9 database on CentOS 7 server. In order for your database to be properly patched, secured, and have all the DB features your applications need, you are supposed to upgrade your database. The upgrade process in this article installs another PostgreSQL engine alongside the old one and migrates the […]

Read More

How to use Ora2pg for Oracle to Postgres Migration

ora2pg oracle to postgres

15 June 2022   0 Comment

We will review Ora2pg, great open source solution for migrations to PostgreSQL. All companies have requests to migrate their small databases to postgres. Ora2pg is a great utility full of features. Prerequisites Oracle clientOracle DatabasePostgres DatabasePerl modules DBI DBD:Oracle DBD:PG Latest version of ora2pg Establish You can install oracle client for first connection Or rpm […]

Read More

How to Resolve ORA-02020: too many database links

Oracle Software

15 April 2022   0 Comment

We have prepared a script to learn the fra status of database instances Oracle cloud control. It caused the ORA-02020 error because the open_links parameter was insufficient. SQL> select * from dual@dbllink; ORA-02020: too many database links in use This is because both the OPEN_LINKS and the OPEN_LINKS_PER_INSTANCE server parameter are too small. SQL> show […]

Read More

ORA-46952: standby database format mismatch for password file

oracle dataguard

8 April 2022   0 Comment

If there is a gap problem in your standby dataguard environment and you are getting this error, you are in the right post. This error is a generic error and your password file indicates a problem. It’s time to check your file. Let’s get started. First of check, do a bidirectional connection test and make […]

Read More

How to Install Oracle Trace File Analyzer (TFA)

Oracle Software

  0 Comment

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

Read More

How to Integrate Grafana, InfluxDB and Telegraf Monitoring on Ubuntu/Debian/Other Linux Distros

telegraf-influx-grafana

24 January 2022   0 Comment

Influxdb is a time series database. It will be used to save the information received from the telegram. Influxdb can be defined as “output” in the config file of Telegraf. To install InfluxDB on “Ubuntu” or “Debian” operating systems, follow the steps below. System update is done before starting the installation. sudo apt-get update sudo […]

Read More

Limiting Parallel Degree at User Level with Oracle Resource Manager

Oracle Resource Manager

18 January 2022   0 Comment

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

Read More

Oracle Database Appliance (ODA) Bundle Patching

20 December 2021   0 Comment

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

Read More

How to ASR Installation & Configuration For Exadata X6,7,8 and PCA X6,7,8

Oracle ASR

12 November 2021   0 Comment

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

Read More

How To Install PostgreSQL 12 Streaming Replication Master/Slave(Synchronous / Asynchronous) on the CentOS 7

PostgreSQL Streaming Replicatiıon master slave Installation big dba

2 February 2021   0 Comment

Using High Availability is a requirement for companies all over the world. Stream Replication as the replication method, PostgreSQL Stream Replication is asynchronous by default, so it is possible to do some operations on the primary node that have not yet been copied to the standby server. This means there is some potential possibility of […]

Read More

How to Install Oracle 19C Two Node Real Application Cluster(RAC) on the Google Cloud Platform

oracle rac on the google cloud

10 January 2021   1 Comment

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.

Read More

How to Enable Oracle Exadata Write Back Smart Flash Cache

Oracle Exadata Troubleshooting

15 December 2020   0 Comment

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

Read More

Basic Usage Netcat Nmap

linux tutorial bigdba

20 November 2020   0 Comment

Netcat has become one of the indispensable tools of system administrators, network administrators and even programmers because it does its job both very simple and very efficient. It is one of the best representatives of the Unix philosophy as well, with its under-defined job well done. Install Netcat Package yum install -y nc Check if […]

Read More

What is Oracle Data Safe

Oracle Data Safe

13 November 2020   0 Comment

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

Read More

Managing Oracle Database Maintenance Tasks

Oracle Software

6 November 2020   0 Comment

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

Read More

How to Registering Hosts and Deploying the Agent in Oracle Audit Vault Server

Oracle Audit Vault

21 October 2020   0 Comment

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

Read More

HOW TO RENAME DATABASE IN ORACLE RDBMS

longs-to-clob

4 October 2020   0 Comment

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

Read More

How to change IP of Oracle Exadata in Oracle Linux

Oracle Exadata Troubleshooting

1 October 2020   0 Comment

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

Read More

How to Connecting PostgreSQL using PHP 7.3 with Basic Ajax Login Script

PostgreSQL PHP7 Login

30 September 2020   0 Comment

You can use Apache(LEMP), PHP, PostgreSQL to build a easy web app. PgAdmin It is an excellent tool to manage PHP PostgreSQL projects. You must upload the postgreSQL extension by editing the php.ini and restart apache service in order to access psql with php. For install PostgreSQL on Redhat and Centos 6,7 Linux we have […]

Read More

How to Install Oracle Enterprise Manager Cloud Control 12cR5 in Red Hat Linux Step by step

Oracle cloud control

24 September 2020   0 Comment

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

Read More

How to Install Oracle Database 12CR2 Standalone in Red Hat Linux Step by step

12c install

  0 Comment

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

Read More

Oracle RDBMS Database Sql Tuning Best Practices

Oracle Sql Tuning

10 September 2020   0 Comment

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

Read More

How to resolve Agent Unreachable errors in Enterprise Manager Cloud Control 13c

Oracle cloud control

21 August 2020   0 Comment

I encountered such an error in Enterprise Manager Cloud Control 13C In the Cloud Control Manager Target , you may see issue of rack showing status as “Down” when running “show status” button Please follow the steps below for solition.. Go to the directory where Agent in is installed. <AGENT-HOME>/bin/emctl stop agent Take a backup […]

Read More

ORA-01111: Name For Data File Is Unknown – Rename To Correct File

oracle dataguard

28 July 2020   1 Comment

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

Read More

Exalogic Elastic Cloud IB(InfiniBand) Switch Ports State Shown as Down Status Showing AutomaticHighErrorRate Message

Oracle Exalogic Elastic Cloud

25 June 2020   0 Comment

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

Read More