Oracledataba.se
  • Home
  • About
  • Labs (Free)
  • LinkedIn
Sign in Subscribe
Configuring a baseline using queries
Paid-members only
operational

Configuring a baseline using queries

Here are some queries that can be used to check the best execution plan using the tables dba_hist_sqlstat, dba_hist_sqltext, and dba_hist_snapshot: 1. List the SQL statements with the highest CPU usage in the last hour: SELECT sql_id, elapsed_time_delta/1000000 as elapsed_
Mar 14, 2023 1 min read
Managing tablespaces
Paid-members only
operational

Managing tablespaces

Mar 5, 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:
Feb 8, 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=DBONEPDB; Session altered.
Jan 26, 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:
Jan 17, 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 access
Jan 6, 2023 2 min read
ORA-3951: Correcting the ORACLE HOME
Paid-members only
oerr

ORA-3951: 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 'datahost' CRS-0223: Resource 'ora.dbone.db' has
May 30, 2022 1 min read
Lab: Installing Oracle Database 21c
Lab

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 step is
May 30, 2022 4 min read
Lab: installing Oracle Database 19c
Lab

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 the Oracle
May 29, 2022 4 min read
Lab: Installing Oracle Linux 8.3
Lab

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 a container and a
May 29, 2022 6 min read
Page 1 of 1
Oracledataba.se © 2023
  • Account Portal
  • Climate
  • LinkedIn
  • Donate
Powered by Ghost