Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

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!

Cloud ERP with offline and online data sync features

uraliaApr 12 2021

I have many independent modules what are running in my clients work stations powered by php / mysql.
but there have some limitation. my client's demand and I feel also to overcome the limitations, now looking for a geek to get the solutions. The application will have the demands are below:
platform independent desktop client app, don't want to use browser. the app will connected with online database.
synchronization options at client hand, auto sync. if server down or client device disconnected from internet , everything will work by using of local database. when internet connection restore every data will automatic upload to server. if multiple branch sync. update time algorithm will allow.
this is a group of company, under it have 3 single company, every company has multiple branch, every branch has multiple warehouse to store material / product. inventory will adjust under the main umbrella.
others modules are HRM, Accounting, delivery, sales, purchase
any one is there to give a architecture or development guideline. i think it should developed from scratch in java or python. i want to leave php for it's limitation . or have any alternative?

Comments

John Thorton

4130935 wrote:

Hello

I just did an upgrade from 12.1 to 12.2 using dbua however I realized that compatible parameter is still set 12.1.0.2.0 although it was upgraded to 12.2

Why didnt dbua change this parameter ? Is it because the flashback was on ?

Oracle  did NOT change COMPATIBLE parameter because it assumed that since you explicitly set it (as opposed to taking Oracle default), that you wanted it set to 12.1.0.2 & left it for you to change it. Problem Exists Between Keyboard And Chair.

TK03

Hi John,

Does it mean that any upgrades with dbua, the compatible parameter will always be same ? DBUA will never change that parameter

John Thorton

4130935 wrote:

Hi John,

Does it mean that any upgrades with dbua, the compatible parameter will always be same ? DBUA will never change that parameter

IMO, you are asking the WRONG question.

What does DBUA do when COMPATIBLE is NOT set to any value & the upgrade is performed?

TK03

Compatible is set to 12.1.0.2

After the upgrade with dbua

It is still same.

I thought dbua will change it 12.2.0.1 once the upgrade is finished

John Thorton

4130935 wrote:

Compatible is set to 12.1.0.2

After the upgrade with dbua

It is still same.

I thought dbua will change it 12.2.0.1 once the upgrade is finished

Oracle & reality demonstrated that you thought wrongly.

yoonas

Hi,

You should have spent little more time reading upgrade guide, it has well depth of information.

When to Set the COMPATIBLE Initialization Parameter in Oracle Database

When to Set the COMPATIBLE Initialization Parameter in Oracle Database

Oracle recommends increasing the COMPATIBLE parameter only after you have completed testing the upgraded database.

After the upgrade is complete, you can increase the setting of the COMPATIBLE initialization parameter to the maximum level for Oracle Database 12c. However, after you increase the COMPATIBLE parameter, you cannot subsequently downgrade the database.

Regards,

Yoonas

TK03

1-) does it mean that once i increase the COMPATIBLE parameter, I can never downgrade the database ?

2-) Assume I enabled flashback database before the upgrade and after the upgrade I increased the COMPATIBLE parameter.  Can i still flashback database to before upgrade state ?

dvohra21

To downgrade, first decrease the COMPATIBLE parameter.

John Thorton

dvohra21 wrote:

To downgrade, first decrease the COMPATIBLE parameter.

What happens when a feature that exists in the higher version (& has been used)  does NOT exist in the lower version & attempt a downgrade?

TK03

Hi John,

so once i increase the COMPATIBLE parameter, there is no way to downgrade ?

yoonas

What Is Oracle Database Compatibility?

Downgrading Oracle Database to an Earlier Release

6 Downgrading Oracle Database to an Earlier Release

For supported releases of Oracle Database, you can downgrade a database to the release from which you last upgraded. For example, if you recently upgraded from release 11.2.0.4 to Oracle Database 12c, and you did not change the compatible initialization parameter to 12.1 or higher, then you can downgrade to release 11.2.0.4. If your Oracle Database 12c is release 12.1.0.2, and you did not change the compatible initialization parameter to 12.1.0.2, then you can downgrade to release 12.1.0.1 and so forth.

dvohra21

Seems like not.

"You cannot downgrade a database once you have set the compatible initialization parameter to 12.1.0.2."

1 - 12

Post Details

Added on Apr 12 2021
0 comments
599 views