This article explains how to configure Oracle Golden Gate software to perform a unidirectional replication from a source non-CDB database on Oracle 12c to a target pluggable database on Oracle 19c. One possible use case is if you need to migrate from your non-CDB...
Oracle Blog Posts
Oracle 11g AUD$ Table Maintenance after ORA-01653: unable to extend table SYS.AUD$
Problem: ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM This error generally results when the aud$ table has a next_extent value that is greater than the available contiguous space in the SYSTEM tablespace. The aud$ table records logins to the...
Database vs Instance vs Schema vs User
Today I wanted to talk about some terminology that applies to multiple database platforms, however, I want to talk specifically to how it relates to the Oracle RDBMS. These four words seem to cause a lot of confusion and are often misused. The specific terminology or...
ORA-01017: Invalid Username/Password; Logon Denied
The Oracle ORA-01017: Invalid Username/Password; Logon Denied is an error that comes up pretty frequently it can be caused by several things, though most of the time it's simply just the wrong password being used. One thing that we should check if we're pretty sure we...
Is Your Database Healthy? The Importance of Health Checks for your Database
Ahhhhhh—the fresh smell of a brand new laptop, being pulled out of its box for the first time. Breathe it in. Your tax return really paid off this year, but your shopping doesn’t end with this new device. On the contrary, you’ve got a spree ahead of you. This laptop...
How to Fix ORA-12560: TNS: Protocol Adapter Error
When you see this ORA-12560 error on Windows, you need to check these two things before anything else. Make sure the windows service is up and running Make sure your ORACLE_SID is set to the instance name you're trying to connect to If either one or two are not...
Oracle ORA-00604: Error Occurred at Recursive SQL Level String
This error is rather common; however, the following error is the error that needs to be resolved. Below you can see several of these errors and their associated error that needs to be resolved. Each of the following errors has their own resolutions. Here the variable...