Change Oracle Apex apps to another Database on same system
Good Day. I have a situation which I am unsure of how to solve. I have searched numerous places and found nothing concrete.
The scenario:
I have 3 Oracle Apex 5 applications running on a single server using Oracle Express locally in order to run the app. I however had to go to Oracle 12c which is installed as a separate instance on the same server and it's listener is now listening on 1522 where XE is still listening on 1521.
I am needing to find a way to export the schema, tables, apps etc. into 12C from XE, then simply configure the apps to connect to the 12C instance and no longer on XE. I can then remove XE completely.
I know I am supposed to post what I have tried, but simply have no code, I have tried to do a export DDL but the script does not seem to carry the Schema data at all.
Question: How can I migrate everything on the XE instance to the 12C instance without breaking either instances.
Any direction would be appreciated.
oracle oracle-apex-5
asked Nov 22 '18 at 12:26
GerryGerry
304
add a comment |
Good Day. I have a situation which I am unsure of how to solve. I have searched numerous places and found nothing concrete.
The scenario:
I have 3 Oracle Apex 5 applications running on a single server using Oracle Express locally in order to run the app. I however had to go to Oracle 12c which is installed as a separate instance on the same server and it's listener is now listening on 1522 where XE is still listening on 1521.
I am needing to find a way to export the schema, tables, apps etc. into 12C from XE, then simply configure the apps to connect to the 12C instance and no longer on XE. I can then remove XE completely.
I know I am supposed to post what I have tried, but simply have no code, I have tried to do a export DDL but the script does not seem to carry the Schema data at all.
Question: How can I migrate everything on the XE instance to the 12C instance without breaking either instances.
Any direction would be appreciated.
oracle oracle-apex-5
asked Nov 22 '18 at 12:26
GerryGerry
304
Have done this once. First I copied the schema (or schmas) from the old database to the new one. Then I did an Apex install (or rather upgrade) on the new database. Then I imported the Apex App into Apex on the new database.
– sers
Nov 22 '18 at 13:35
@sers Thank you. What was the method you used to copy the schema's to the new DB?
– Gerry
Nov 22 '18 at 13:36
don't really remember. But you should have a look here: stackoverflow.com/questions/8451219/… Or here: community.oracle.com/thread/2369986?start=0&tstart=0
– sers
Nov 22 '18 at 15:05
Thank you @sers I will have a look at the link. appreciate the help.
– Gerry
Nov 23 '18 at 6:34
add a comment |
Good Day. I have a situation which I am unsure of how to solve. I have searched numerous places and found nothing concrete.
The scenario:
I have 3 Oracle Apex 5 applications running on a single server using Oracle Express locally in order to run the app. I however had to go to Oracle 12c which is installed as a separate instance on the same server and it's listener is now listening on 1522 where XE is still listening on 1521.
I am needing to find a way to export the schema, tables, apps etc. into 12C from XE, then simply configure the apps to connect to the 12C instance and no longer on XE. I can then remove XE completely.
I know I am supposed to post what I have tried, but simply have no code, I have tried to do a export DDL but the script does not seem to carry the Schema data at all.
Question: How can I migrate everything on the XE instance to the 12C instance without breaking either instances.
Any direction would be appreciated.
oracle oracle-apex-5
asked Nov 22 '18 at 12:26
GerryGerry
304
Good Day. I have a situation which I am unsure of how to solve. I have searched numerous places and found nothing concrete.
The scenario:
I have 3 Oracle Apex 5 applications running on a single server using Oracle Express locally in order to run the app. I however had to go to Oracle 12c which is installed as a separate instance on the same server and it's listener is now listening on 1522 where XE is still listening on 1521.
I am needing to find a way to export the schema, tables, apps etc. into 12C from XE, then simply configure the apps to connect to the 12C instance and no longer on XE. I can then remove XE completely.
I know I am supposed to post what I have tried, but simply have no code, I have tried to do a export DDL but the script does not seem to carry the Schema data at all.
Question: How can I migrate everything on the XE instance to the 12C instance without breaking either instances.
Any direction would be appreciated.
oracle oracle-apex-5
oracle oracle-apex-5
asked Nov 22 '18 at 12:26
GerryGerry
304
asked Nov 22 '18 at 12:26
GerryGerry
304
asked Nov 22 '18 at 12:26
GerryGerry
304
asked Nov 22 '18 at 12:26
GerryGerry
304
asked Nov 22 '18 at 12:26
GerryGerry
304
304
Have done this once. First I copied the schema (or schmas) from the old database to the new one. Then I did an Apex install (or rather upgrade) on the new database. Then I imported the Apex App into Apex on the new database.
– sers
Nov 22 '18 at 13:35
@sers Thank you. What was the method you used to copy the schema's to the new DB?
– Gerry
Nov 22 '18 at 13:36
don't really remember. But you should have a look here: stackoverflow.com/questions/8451219/… Or here: community.oracle.com/thread/2369986?start=0&tstart=0
– sers
Nov 22 '18 at 15:05
Thank you @sers I will have a look at the link. appreciate the help.
– Gerry
Nov 23 '18 at 6:34
add a comment |
Have done this once. First I copied the schema (or schmas) from the old database to the new one. Then I did an Apex install (or rather upgrade) on the new database. Then I imported the Apex App into Apex on the new database.
– sers
Nov 22 '18 at 13:35
@sers Thank you. What was the method you used to copy the schema's to the new DB?
– Gerry
Nov 22 '18 at 13:36
don't really remember. But you should have a look here: stackoverflow.com/questions/8451219/… Or here: community.oracle.com/thread/2369986?start=0&tstart=0
– sers
Nov 22 '18 at 15:05
Thank you @sers I will have a look at the link. appreciate the help.
– Gerry
Nov 23 '18 at 6:34
Have done this once. First I copied the schema (or schmas) from the old database to the new one. Then I did an Apex install (or rather upgrade) on the new database. Then I imported the Apex App into Apex on the new database.
– sers
Nov 22 '18 at 13:35
Have done this once. First I copied the schema (or schmas) from the old database to the new one. Then I did an Apex install (or rather upgrade) on the new database. Then I imported the Apex App into Apex on the new database.
– sers
Nov 22 '18 at 13:35
@sers Thank you. What was the method you used to copy the schema's to the new DB?
– Gerry
Nov 22 '18 at 13:36
@sers Thank you. What was the method you used to copy the schema's to the new DB?
– Gerry
Nov 22 '18 at 13:36
don't really remember. But you should have a look here: stackoverflow.com/questions/8451219/… Or here: community.oracle.com/thread/2369986?start=0&tstart=0
– sers
Nov 22 '18 at 15:05
don't really remember. But you should have a look here: stackoverflow.com/questions/8451219/… Or here: community.oracle.com/thread/2369986?start=0&tstart=0
– sers
Nov 22 '18 at 15:05
Thank you @sers I will have a look at the link. appreciate the help.
– Gerry
Nov 23 '18 at 6:34
Thank you @sers I will have a look at the link. appreciate the help.
– Gerry
Nov 23 '18 at 6:34
add a comment |
1 Answer
1
active
oldest
votes
Two steps: data(base) migration & (Apex) application migration.
The simplest way to move data is to perform export and import. Although you can use the original EXP and IMP utilities, consider using modern Data Pump Export and Import.
- EXP and IMP are somewhat simpler; export (DMP) file is created on your disk
- Data Pump requires you to create an Oracle directory (object) which points to a directory on the disk. As it is XE installed on your computer, no problem if it is, for example, C:Temp
- syntax is very similar in both cases, especially if there's nothing fancy in your data
The second step is application migration; you should first install Apex in the new Oracle 12c. Make sure it is up and running (create a workspace, assign a schema (you've just imported) to it, create a developer).
Then export the Apex application(s) - if there are only a few of them, a simple way is to do export from the application itself (you'll see the "Export/Import" button in the "main" application page within the App. Builder). Follow the wizard. The result will be a plain textual (.SQL) file.
In Apex on 12c, revert the process - do the Import by navigating to previously exported .SQL file, follow the wizard once again. Once the import is finished, you should be able to run the application.
Good luck!
answered Nov 22 '18 at 20:02
LittlefootLittlefoot
21k71433
Thank you for the response, I will follow the steps and see where I get with this.
– Gerry
Nov 23 '18 at 6:29
All done, it was no so painful after all, installed 12c, installed apex on it, copied the workspaces from internal to 12c and imported/exported views, tables and db links.. Working great. Think I can actually build an automation tool for this to be honest.. will make it much easier.
– Gerry
Nov 23 '18 at 14:12
Excellent! I'm glad you made it.
– Littlefoot
Nov 23 '18 at 15:10
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431008%2fchange-oracle-apex-apps-to-another-database-on-same-system%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Two steps: data(base) migration & (Apex) application migration.
The simplest way to move data is to perform export and import. Although you can use the original EXP and IMP utilities, consider using modern Data Pump Export and Import.
- EXP and IMP are somewhat simpler; export (DMP) file is created on your disk
- Data Pump requires you to create an Oracle directory (object) which points to a directory on the disk. As it is XE installed on your computer, no problem if it is, for example, C:Temp
- syntax is very similar in both cases, especially if there's nothing fancy in your data
The second step is application migration; you should first install Apex in the new Oracle 12c. Make sure it is up and running (create a workspace, assign a schema (you've just imported) to it, create a developer).
Then export the Apex application(s) - if there are only a few of them, a simple way is to do export from the application itself (you'll see the "Export/Import" button in the "main" application page within the App. Builder). Follow the wizard. The result will be a plain textual (.SQL) file.
In Apex on 12c, revert the process - do the Import by navigating to previously exported .SQL file, follow the wizard once again. Once the import is finished, you should be able to run the application.
Good luck!
answered Nov 22 '18 at 20:02
LittlefootLittlefoot
21k71433
Thank you for the response, I will follow the steps and see where I get with this.
– Gerry
Nov 23 '18 at 6:29
All done, it was no so painful after all, installed 12c, installed apex on it, copied the workspaces from internal to 12c and imported/exported views, tables and db links.. Working great. Think I can actually build an automation tool for this to be honest.. will make it much easier.
– Gerry
Nov 23 '18 at 14:12
Excellent! I'm glad you made it.
– Littlefoot
Nov 23 '18 at 15:10
add a comment |
Two steps: data(base) migration & (Apex) application migration.
The simplest way to move data is to perform export and import. Although you can use the original EXP and IMP utilities, consider using modern Data Pump Export and Import.
- EXP and IMP are somewhat simpler; export (DMP) file is created on your disk
- Data Pump requires you to create an Oracle directory (object) which points to a directory on the disk. As it is XE installed on your computer, no problem if it is, for example, C:Temp
- syntax is very similar in both cases, especially if there's nothing fancy in your data
The second step is application migration; you should first install Apex in the new Oracle 12c. Make sure it is up and running (create a workspace, assign a schema (you've just imported) to it, create a developer).
Then export the Apex application(s) - if there are only a few of them, a simple way is to do export from the application itself (you'll see the "Export/Import" button in the "main" application page within the App. Builder). Follow the wizard. The result will be a plain textual (.SQL) file.
In Apex on 12c, revert the process - do the Import by navigating to previously exported .SQL file, follow the wizard once again. Once the import is finished, you should be able to run the application.
Good luck!
answered Nov 22 '18 at 20:02
LittlefootLittlefoot
21k71433
Thank you for the response, I will follow the steps and see where I get with this.
– Gerry
Nov 23 '18 at 6:29
All done, it was no so painful after all, installed 12c, installed apex on it, copied the workspaces from internal to 12c and imported/exported views, tables and db links.. Working great. Think I can actually build an automation tool for this to be honest.. will make it much easier.
– Gerry
Nov 23 '18 at 14:12
Excellent! I'm glad you made it.
– Littlefoot
Nov 23 '18 at 15:10
add a comment |
Two steps: data(base) migration & (Apex) application migration.
The simplest way to move data is to perform export and import. Although you can use the original EXP and IMP utilities, consider using modern Data Pump Export and Import.
- EXP and IMP are somewhat simpler; export (DMP) file is created on your disk
- Data Pump requires you to create an Oracle directory (object) which points to a directory on the disk. As it is XE installed on your computer, no problem if it is, for example, C:Temp
- syntax is very similar in both cases, especially if there's nothing fancy in your data
The second step is application migration; you should first install Apex in the new Oracle 12c. Make sure it is up and running (create a workspace, assign a schema (you've just imported) to it, create a developer).
Then export the Apex application(s) - if there are only a few of them, a simple way is to do export from the application itself (you'll see the "Export/Import" button in the "main" application page within the App. Builder). Follow the wizard. The result will be a plain textual (.SQL) file.
In Apex on 12c, revert the process - do the Import by navigating to previously exported .SQL file, follow the wizard once again. Once the import is finished, you should be able to run the application.
Good luck!
answered Nov 22 '18 at 20:02
LittlefootLittlefoot
21k71433
Two steps: data(base) migration & (Apex) application migration.
The simplest way to move data is to perform export and import. Although you can use the original EXP and IMP utilities, consider using modern Data Pump Export and Import.
- EXP and IMP are somewhat simpler; export (DMP) file is created on your disk
- Data Pump requires you to create an Oracle directory (object) which points to a directory on the disk. As it is XE installed on your computer, no problem if it is, for example, C:Temp
- syntax is very similar in both cases, especially if there's nothing fancy in your data
The second step is application migration; you should first install Apex in the new Oracle 12c. Make sure it is up and running (create a workspace, assign a schema (you've just imported) to it, create a developer).
Then export the Apex application(s) - if there are only a few of them, a simple way is to do export from the application itself (you'll see the "Export/Import" button in the "main" application page within the App. Builder). Follow the wizard. The result will be a plain textual (.SQL) file.
In Apex on 12c, revert the process - do the Import by navigating to previously exported .SQL file, follow the wizard once again. Once the import is finished, you should be able to run the application.
Good luck!
answered Nov 22 '18 at 20:02
LittlefootLittlefoot
21k71433
answered Nov 22 '18 at 20:02
LittlefootLittlefoot
21k71433
answered Nov 22 '18 at 20:02
LittlefootLittlefoot
21k71433
answered Nov 22 '18 at 20:02
LittlefootLittlefoot
21k71433
21k71433
Thank you for the response, I will follow the steps and see where I get with this.
– Gerry
Nov 23 '18 at 6:29
All done, it was no so painful after all, installed 12c, installed apex on it, copied the workspaces from internal to 12c and imported/exported views, tables and db links.. Working great. Think I can actually build an automation tool for this to be honest.. will make it much easier.
– Gerry
Nov 23 '18 at 14:12
Excellent! I'm glad you made it.
– Littlefoot
Nov 23 '18 at 15:10
add a comment |
Thank you for the response, I will follow the steps and see where I get with this.
– Gerry
Nov 23 '18 at 6:29
All done, it was no so painful after all, installed 12c, installed apex on it, copied the workspaces from internal to 12c and imported/exported views, tables and db links.. Working great. Think I can actually build an automation tool for this to be honest.. will make it much easier.
– Gerry
Nov 23 '18 at 14:12
Excellent! I'm glad you made it.
– Littlefoot
Nov 23 '18 at 15:10
Thank you for the response, I will follow the steps and see where I get with this.
– Gerry
Nov 23 '18 at 6:29
Thank you for the response, I will follow the steps and see where I get with this.
– Gerry
Nov 23 '18 at 6:29
All done, it was no so painful after all, installed 12c, installed apex on it, copied the workspaces from internal to 12c and imported/exported views, tables and db links.. Working great. Think I can actually build an automation tool for this to be honest.. will make it much easier.
– Gerry
Nov 23 '18 at 14:12
All done, it was no so painful after all, installed 12c, installed apex on it, copied the workspaces from internal to 12c and imported/exported views, tables and db links.. Working great. Think I can actually build an automation tool for this to be honest.. will make it much easier.
– Gerry
Nov 23 '18 at 14:12
Excellent! I'm glad you made it.
– Littlefoot
Nov 23 '18 at 15:10
Excellent! I'm glad you made it.
– Littlefoot
Nov 23 '18 at 15:10
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431008%2fchange-oracle-apex-apps-to-another-database-on-same-system%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have done this once. First I copied the schema (or schmas) from the old database to the new one. Then I did an Apex install (or rather upgrade) on the new database. Then I imported the Apex App into Apex on the new database.
– sers
Nov 22 '18 at 13:35
@sers Thank you. What was the method you used to copy the schema's to the new DB?
– Gerry
Nov 22 '18 at 13:36
don't really remember. But you should have a look here: stackoverflow.com/questions/8451219/… Or here: community.oracle.com/thread/2369986?start=0&tstart=0
– sers
Nov 22 '18 at 15:05
Thank you @sers I will have a look at the link. appreciate the help.
– Gerry
Nov 23 '18 at 6:34