Skip to Main Content
Forums

APEX

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!

Maintaining data & data schema between Development vs Production?

DannyS-OracleJun 15 2017 — edited Jun 16 2017

Hi everyone, I am a beginner Apex developer and need some advice on how to sync between my development and production instances. I tried searching on this forum, and this has been asked before here , but there was no feedback.

So my situation is, we are planning to have two different instance of our application:

  1. Development, where we do all experiment and add new features; and
  2. Production, where we put all stable features, production data, and make it accessible for our users.

We are thinking to put these two instances on different workspaces, so we can safely export and import all pages easily and separate development vs production data.

The case where I am concerned is, how to keep the data schema between the development and production workspaces in sync? Let's say I implemented some features in dev environment, where I need to make changes to certain table (e.g. adding/removing columns or triggers in Table A). How to reflect this changes automatically in the production environment? I believe I can't just export the data, replace the data schema with the one from dev, and then re-import the data because some table columns might have changed. Do I have to implement all those changes manually in the production workspace?

Please let me know if you have been in similar situation, or if you know better solution for this. Any feedback will be appreciated! I am using Apex v5.1, Oracle DB v12.

Comments

kmsdatasystems

Turn OFF your Firewall on your Windows 10 Pro machine for the duration of the install. You will likely need to run deintall.bat first, to deinstall the failed attempt. Then re-run the Oracle installer after you've disabled your Firewall. You can re-enable the firewall AFTER you've successfully installed Oracle.

SureshDooly-Oracle

Oracle isn't/wasn't/won't (as far as I can tell) be supported on any MS Windows Home edition. True, some people made it work, but that's more matter of luck. You should upgrade operating system.
Or, maybe a better option, download one of Pre-Built Developer VMs (for Oracle VM VirtualBox).

Regards,
Suresh

user8834596

In my case, I removed registry entry Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraClient19Home1 and reinstall completed without the error. Firewall had nothing to do with it.

User_234CO

tengo el mismo error 'failed to add acl's for specified user
se logro solucionar?

User_6GLL2

I know this is unrelated to the topic of your entry, but sometime ago I found a very similar website to this one (it was even about the same topic!), but it was laggy as hell, it reminded me of my very old personal website.
Fortunately on my recent website I didn't got any issues as I decided to change my hosting provider to Truxgo and until today I it's working flawlessly.

User_TNUCD

Hello,
I faced the same issue, solved after cleaning all Oracle 19 related entries at the registry under:
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\
I deleted KEY_OraClient19Home1 then, searched for whatever Oracle 19 entries under all items under Oracle.
Then started the installation again, and it went successfully.
Thanks

Solomon jayasena

if you select different location and disable fire wall then it will install successfully

Ian Oelofse

Install the Oracle Client first!

Ysrael Medina

Por favor necesito ayuda, instalé oracle versión 18 modo cliente pero en el requisito numero 5 me exige crear la carpeta network/admin y dentro de la carpeta admin, debo pegar los archivos sqlnet.ora y tnsnames.ora para poder realizar la conexión. El probelam es que no sé donde están los archivos sqlnet.ora y tnsnames.ora para pegarlos. Lo he descargado en windows

Ben Choley

Hi, I’m also encountering this issue right now while trying to install Oracle Database 19c on Windows 10 Pro. I followed the same steps, including creating a new Windows user, and encountered the same error at 7%: ‘failed to add ACLs for specified user.’ While troubleshooting, I realized that managing permissions and user roles on Windows is a common challenge, even in non-database contexts. For example, I’ve faced similar permission issues when using video editors like CapCut for PC. I found useful resources on capprocutapk.com that helped me get the software running smoothly by addressing file access permissions. It seems Windows permissions can be tricky across various software. If anyone has resolved this or knows a fix, I’d greatly appreciate your insights! Thanks in advance for any help!

1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 13 2017
Added on Jun 15 2017
#apex-discussions, #data, #database, #schema, #workspace
3 comments
1,290 views