Showing posts with label Multitenant architechture. Show all posts
Showing posts with label Multitenant architechture. Show all posts
Wednesday, September 25, 2024

How to plug and unplug a PDB in a multitenant configuration

›
What exactly does it mean to unlug and plug a database, in a multitenant architecture? To unplug means to close the PDB and then generate...
1 comment:
Wednesday, August 7, 2024

Workaround for ORA-65011: Pluggable database does not exist in an EBS environment

›
If you have upgraded an EBS database to Oracle 19c, you will also have migrated to the multitenant architechture, which is required. Durin...
Monday, July 22, 2024

Syntax for flashback database to a specific timestamp using sqlplus

›
flashback pluggable database PDB1 TO timestamp to_timestamp('2024-07-22 15:12:01', 'YYYY-MM-DD Hh24:MI:SS');
Friday, July 12, 2024

Datapatch seems to "hang" or taking an extraordinary long time to complete. What could be wrong?

›
When using the utility datapatch to either apply or rollback patches in my Oracle 19c ORACLE_HOME, I was suprised at the time it took to (i...
Friday, June 14, 2024

SQL for troubleshooting services in multitenant environment

›
Query for troubleshooting services in a multitenant environment: set lines 200 col name format a40 col network_name format a40 col pdb for...
Tuesday, June 4, 2024

Solution to ORA-29548: Java system class reported: release of Java system classes in the database (19.0.0.0.240116 1.8) does not match that of the oracle executable (19.0.0.0.240416 1.8)

›
When I was trying to drop and recreate a schema in my PDB, I received the following error: drop user myuser cascade * ERROR at line 1: ORA...
Monday, May 6, 2024

How to solve errors like "Interim patch num/num (DATAPUMP BUNDLE PATCH 19.21.0.0.0): Not installed in the CDB but installed in the PDB"

›
After running autoupgrade, I was left with the following message in the logfile $ORACLE_BASE/cfgtoollogs/upgrade/auto/status/status.log: [S...
Saturday, April 13, 2024

How to open the PDB$SEED database for patching in read/write mode

›
The following should only be done if you need to patch the PDB$SEED using datapatch, or under instructions from Oracle Support. sqlplus /...
Thursday, March 7, 2024

How to solve TNS-01194: The listener command did not arrive in a secure transport

›
On one of my servers running Oracle 19c with a container database and a PDB, I had trouble getting the services to automatically register t...
Thursday, November 23, 2023

Solution to ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

›
I had a situation where the error ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA was thrown when connecting to ...
Tuesday, September 12, 2023

How to delete a pluggable database with dbca using the command line

›
dbca -silent -deletePluggableDatabase \ -sourceDB cdb \ -pdbName pdb3 \

How to create a pluggable database with dbca using the command line

›
In the following code snippet, I am creating the pluggable database "pdb3" as a copy of the already existing pluggable database ...
Friday, September 8, 2023

Script for creating a multitenant database with dbca

›
Prerequisites: You have a valid Oracle 19c installation in a server You have set your Oracle environment already, so that your PATH, ORAC...
Thursday, September 7, 2023

Syntax for switching over a container database using data guard broker

›
Here I am switching over a container database called cdb, to the standby server which is running a container database with unique name cdb_...
Thursday, August 31, 2023

More on how to display the current container in a multitenant database

›
My listener is listening for connections to a service called "myservice1", which runs out of the pluggable database "pdb1...
Thursday, August 3, 2023

Script to check the services in a multitenant container databaser

›
A simple script to check services running out of a specific PDB, or for all PDBs if the root container is selected: column pdb_name format...
Monday, June 19, 2023

Using the autoupgrade tool to migrate a non-multitenant database to a PDB on the same host

›
The autoupgrade tool can convert a non-cdb database to a PDB running in a container database. If you need to switch to a multitenant archi...
Wednesday, May 10, 2023

Can the recyclebin be turned off for a container database but remain on in a pluggable database?

›
Yes, the multitenant architecture allows this. SQL>select name, value , ISPDB_MODIFIABLE from V$parameter where name = 'recyclebin...
Monday, May 1, 2023

How to use RMAN DUPLICATE FROM ACTIVE DATABASE to clone an entire CDB and all PDBs to a remote host

›
In this post I will show how to clone an entire cdb with all PDBs using the DUPLICATE FROM ACTIVE DATABASE command, which has been around f...
Wednesday, January 4, 2023

Check if your CDB is set up for local undo

›
col PROPERTY_NAME format a20 col PROPERTY_VALUE format a20 col DESCRIPTION format a40 col LOCAL_UNDO_ENABLED format a20 select * from data...