Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
COURSE of the MONTH
10 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Replicate Oracle Apex (Apps and Data) between 2 different hosted environments
Posted on 2008-06-18
Scenario:
2 Different hosted and managed APex environments (env1 and env2), both of which I have shell access to workspace Schema using puTTY.
1 of the envionments (env1) is running a production apex application. The other environment (env2) is completely empty (in fact is hypothetical at this point), however I will create a snapshot of env1 on env2 when the time comes.
What I'm trying to do is create replication from env1 to env2. So should env1 go down, then I can manually switch to use app on env2. When env1 comes back up, changes made to env2 get replicated back to env1.
2nd best is to have one-way replication from env1 to env2, so we can have "read-only" access to app on env2 when env1 is down.
Be great to have apex apps replicating as well as data and ddl, but would settle for just data if it made things significantly simpler.
I'm looking for a simple solution which needs little if any involvement from the hosting companies themselves (I have shell access to workspaces). So installing custom software etc is not an option, however I also don't want to have to write loads of custom code and create manual "replication tables" for each table in the schema if at all possible.
Is there any inbuilt oracle functionality (I looked briefly at Oracle Streams), that would not require involvement from hosting companies ?
I'm also lacking in knowledge as to how you could create a secure connection between the 2 environments using only shell access to db ? (Presumably at worst I would have to set-up a server which had connections to both environments and then pass data between them) ?
Any pointers much appreciated.
2 Different hosted and managed APex environments (env1 and env2), both of which I have shell access to workspace Schema using puTTY.
1 of the envionments (env1) is running a production apex application. The other environment (env2) is completely empty (in fact is hypothetical at this point), however I will create a snapshot of env1 on env2 when the time comes.
What I'm trying to do is create replication from env1 to env2. So should env1 go down, then I can manually switch to use app on env2. When env1 comes back up, changes made to env2 get replicated back to env1.
2nd best is to have one-way replication from env1 to env2, so we can have "read-only" access to app on env2 when env1 is down.
Be great to have apex apps replicating as well as data and ddl, but would settle for just data if it made things significantly simpler.
I'm looking for a simple solution which needs little if any involvement from the hosting companies themselves (I have shell access to workspaces). So installing custom software etc is not an option, however I also don't want to have to write loads of custom code and create manual "replication tables" for each table in the schema if at all possible.
Is there any inbuilt oracle functionality (I looked briefly at Oracle Streams), that would not require involvement from hosting companies ?
I'm also lacking in knowledge as to how you could create a secure connection between the 2 environments using only shell access to db ? (Presumably at worst I would have to set-up a server which had connections to both environments and then pass data between them) ?
Any pointers much appreciated.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
6 Comments
I use Apex on one computer in 11g database. It uses tables on a remote DB.
I access the tables via DBlink and views based on this DBlink.
To replicate the Apex you have to use the Export/Import tool in it.
To replicate the data you can use:
1. Data Pump
2. materialized views
3. Oracle Streams
I access the tables via DBlink and views based on this DBlink.
To replicate the Apex you have to use the Export/Import tool in it.
To replicate the data you can use:
1. Data Pump
2. materialized views
3. Oracle Streams
Thanks for your prompt response schwertner.
Dblinks wouldn't work for me as introduces no reduncancy - ie if remote db goes down then so does your apex app.
For your 3 replication options - are they all in-built in a standard oracle 10g implementation, and can they all be programmed via a shell account without having to install additional oracle software (I'm aware that materialised views are in-built).
Also any ideas of connecting to a remote db from one hosted environment to another, without having to set up a "3rd party" to connect to both and manage communications between them ?
Thanks
Dblinks wouldn't work for me as introduces no reduncancy - ie if remote db goes down then so does your apex app.
For your 3 replication options - are they all in-built in a standard oracle 10g implementation, and can they all be programmed via a shell account without having to install additional oracle software (I'm aware that materialised views are in-built).
Also any ideas of connecting to a remote db from one hosted environment to another, without having to set up a "3rd party" to connect to both and manage communications between them ?
Thanks
Your assignment has a proven standart solution on Oracle.
It is called Save Guard (former Standby DB). It replicates
the Oracle DB on a second instance that can be also used for Reporting
(not for Forms!!!!).
The abve mentioned options (Materialized Views, Oracle Streams) are
proven replication methods. As I recall there are also others ...
They do not need 3rd party tool, they are embeded in Oracle.
Also be aware that Apex for my great surprise is embedded in
Oracle 11g. You get it with the standart installation of 11g.
I was surprised ... and now I use it and it is nice development
tool.
It is called Save Guard (former Standby DB). It replicates
the Oracle DB on a second instance that can be also used for Reporting
(not for Forms!!!!).
The abve mentioned options (Materialized Views, Oracle Streams) are
proven replication methods. As I recall there are also others ...
They do not need 3rd party tool, they are embeded in Oracle.
Also be aware that Apex for my great surprise is embedded in
Oracle 11g. You get it with the standart installation of 11g.
I was surprised ... and now I use it and it is nice development
tool.
>>Also be aware that Apex for my great surprise is embedded in Oracle 11g. You get it with the standart installation of 11g. I was surprised ... and now I use it and it is nice development tool.
APEX is great for RAD, but it has its quirks. The latest version(s) of SQL Developer have native support of APEX apps, fwiw.
APEX is great for RAD, but it has its quirks. The latest version(s) of SQL Developer have native support of APEX apps, fwiw.
Thanks for this. Didn't have all the answers I was looking for, but appreciate it was a very broad question. Cheers
I have nothing against to discuss further your problem.
The issue I see is that you have to define the assignment.
1. What is your current architecture
2. What would you like to replicate:
a. The Data Base
b. the Apex enviromnent
3. How many servers will you use
Be aware thet in Apex you can base the query on PL/SQL procedure and
the procedure can check which of the both replicated servers is running.
Of course all this needs investigations and planning.
The issue I see is that you have to define the assignment.
1. What is your current architecture
2. What would you like to replicate:
a. The Data Base
b. the Apex enviromnent
3. How many servers will you use
Be aware thet in Apex you can base the query on PL/SQL procedure and
the procedure can check which of the both replicated servers is running.
Of course all this needs investigations and planning.
Featured Post
With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
- Server Hardware
- IT Administration
- Disaster Recovery
- Storage Software
- Databases
- Storage Hardware, MySQL Server, Hardware, Percona, *Backups
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility. The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses
Course of the Month10 days, 17 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.