Oracledataba.se
  • About
  • Lab (Free)
Sign in Subscribe
Release dates for Oracle Database 23ai
operational

Release dates for Oracle Database 23ai

Release dates for Oracle Database 23ai
08 May 2024 1 min read
Installing Oracle Linux 9.2
Lab

Installing Oracle Linux 9.2

Learn how to install Oracle Linux 9.2 step by step.
09 Jun 2023 6 min read
Connecting to an Autonomous Oracle Database from a Windows Desktop using SQLcl
Lab Featured

Connecting to an Autonomous Oracle Database from a Windows Desktop using SQLcl

In this article, we'll discuss how to use SQLcl, a modern command-line interface for Oracle databases, to connect to an Autonomous Oracle Database running in Oracle Cloud from a Windows desktop. We'll cover the prerequisites, installation, and configuration of SQLcl, as well as provide a step-by-step
20 Apr 2023 3 min read
Oracle Database Performance Tunning
Paid-members only
operational

Oracle Database Performance Tunning

This is how to detect the longest running queries in an Oracle Database by utilizing the tables dba_hist_sqlstat, dba_hist_sqltext, and dba_hist_snapshot. We will also explore the previous execution plans (hash values) that could potentially offer better performance. Lastly, we will differentiate between SQL Profiles
14 Mar 2023 3 min read
Managing tablespaces
Paid-members only
operational

Managing tablespaces

05 Mar 2023 1 min read
ORA-20000 in a multitenant database while doing an export
Paid-members only
oerr

ORA-20000 in a multitenant database while doing an export

When doing a expdp of a PDB, you may see the next error message: ORA-20000: Resource Manager Plan Is Not Active or is not managing CPU usage This are the steps to avoid the error message and be able to do the export:
08 Feb 2023
ORA-65149: PDB name conflicts with existing service name in the CDB or the PDB
Paid-members only
oerr

ORA-65149: PDB name conflicts with existing service name in the CDB or the PDB

After refreshing a database with a container database, you need to restore the refreshed name of the pluggable database to the expected in the non-prod environment. For this, you would first connect to the PDB and restart it on "open restrict" mode: SQL> alter session set container=
26 Jan 2023 1 min read
After restart, following tracing is seen: "psdgbt: bind csid (1) does not match session csid (XX) psdgbt: session charset is WE8ISO8859P15"
Paid-members only
oerr

After restart, following tracing is seen: "psdgbt: bind csid (1) does not match session csid (XX) psdgbt: session charset is WE8ISO8859P15"

In a situation like a server being rebooted due activities that need to be carried by system administrators and then you get the go to start the databases, you may see the alertlog showing the same trace file appearing repetitively at the alertlog. The trace file shows the following text:
17 Jan 2023 1 min read
Select on read-only standby database returns ORA-04045 and ORA-16000
Paid-members only
oerr

Select on read-only standby database returns ORA-04045 and ORA-16000

A customer reports that while doing a select through a DB Link or directly to a standby database that is opened in read-only, the following error is shown: SQL> select * from DATAHUB1; * ERROR at line 1: ORA-04045: errors during recompilation/revalidation of PUBLIC.DATAHUB1 ORA-16000: database open for read-only
06 Jan 2023 2 min read
ORA-39511: Correcting the ORACLE HOME
Paid-members only
oerr

ORA-39511: Correcting the ORACLE HOME

When you're trying to start the database, you could find this error: SQL> startup restrict; ORA-39511: Start of CRS resource for instance '223' failed with error: [CRS-2800: Cannot start resource 'ora.DATA.dg' as it is already in the INTERMEDIATE state on server
30 May 2022 1 min read
Installing Oracle Database 21c
Lab

Installing Oracle Database 21c

In this tutorial, you are going to learn how to install a standalone Oracle Database version 21c. To download the Oracle database 21c software, go to https://www.oracle.com/database/technologies/oracle-database-software-downloads.html and copy the download link for Oracle Database. Select the "RPM" download. The next
30 May 2022 4 min read
Installing Oracle Database 19c
Lab

Installing Oracle Database 19c

Installation of Oracle Database Software In this tutorial, you are going to learn how to install a standalone Oracle Database version 19c. Connect as root and issue: yum update Confirm and proceed with the updates. Once the "Complete!" message is shown, issue the command yum update To download
29 May 2022 4 min read
Installing Oracle Linux 8.3
Lab

Installing Oracle Linux 8.3

If you're trying to spin up a database with new software, one thing that is worth noting is that Oracle has simplified the way to download and install it's software. Here we are going to take the most straight-up way to get a 19c database with
29 May 2022 6 min read
Page 1 of 1
Oracledataba.se © 2025
  • Account Portal
  • LinkedIn
  • Donate
  • Terms and conditions
Powered by Ghost