Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Downgrade database with standby

4331679Sep 22 2020 — edited Sep 24 2020

Hello all,

Please help me understanding the following

In oracle documentation it is mentioned

ref.

#https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sbydb/upgrading-patching-downgrading-oracle-data-guard-configuration.html#GUID-FDB0FA2C-EA66-423C-AFD9-51F3FA4899F8

#Data Guard configuration that does not contain a logical standby database.

#Ensure that all physical standby databases are mounted,

#but not open. Do not open the standby database(s) until prim and standby are in sync

#Downgrade the primary database

#keeping the following in mind:

#At each step of the downgrade procedure where a script is executed,

#execute the script only at the primary database.

#Do not perform the next downgrade step until all redo generated by

#the execution of the script at the primary database has been applied

#to each physical standby database.

#At each step of the downgrade procedure where an action other than

#running a script is performed, perform the step at the primary database

#first and then at each physical standby database.

#Do not perform the next downgrade step at the primary database

#until the action has been performed at each physical standby database.

Instead can this be done and is there any disadvantage or impact to do it ?

shutdown standby databases, downgrade primary database, Then later mount standby database from old home and apply all the logs generated during downgrade of primary

Comments

thatJeffSmith-Oracle
Answer

Should be out soon.

Marked as Answer by jdoornae · Jun 29 2022
jdoornae

It's there now. Thanks!

Mal Baird

Is JDK 8 or 11 included?
image.pngimage.png

thatJeffSmith-Oracle

11, fixing the typo now

stom

Downloaded SQL Developer 22.2 with JDK 11
Copied my preferences over from the previous installation (21.4.3.063).
When I try to connect to a database from the connection tree, I get this error.
image.png Any ideas?

thatJeffSmith-Oracle

What type of connection is it?
I'm running the exact same thing you are, 64-bit Windows w/Java 11 included, and on an upgrade can connect just fine.
Maybe, try extracting the zip again using native Windows file explorer to a net-new directory, and try connecting from that location?

stom

It is a basic connection. I specify the host, port and service name. I right clicked on the connection name -> properties -> Test
image.pngI extracted to a new location and I also downloaded the "No Java" version. I get the same error on both attempts.

thatJeffSmith-Oracle

Do you have an oracle client defined in the Advanced Preferences, or are you using a TNS connection type or do you have 'OCI' checked on your advanced connection properties?

stom

I am using a basic connection type. I have a TNSNAMES file but I don't use it.
image.pngI have "OCI/Thick driver" checked. We use Radius authentication for our DB logins and I remember it wasn't working without this box checked.

thatJeffSmith-Oracle

That's probably it, get a newer client and try that, a 19c or 21c client.

user-x79xr

Same issue for me - java.lang.NoClassDefFoundError: oracle/jdbc/datasource/impl/OracleDataSource

I'm using 19c Client with "OCI/Thick driver" checked in SQLDeveloper 22.2 but still facing this issue.

1 - 11

Post Details

Added on Sep 22 2020
1 comment
217 views