Skip to Main Content

Integration

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!

how to change hostname & Domain name in Oracle application server

Vikash Jain (DBA )May 23 2013 — edited May 27 2013
Hi ,

I have oracle 10g Application 64bit installed on Windows 2003 R2 server which is in xxx.domain.com , now i want to do the below changes , how it is possible ?

1. If i change the Hostname (For Example proddb to testdb).
2. if i change the hostname with domain name (For Example xxx.domain.com to abc.domain.com).

When i tried to change the above things i was not able to access the application . Can somebody tell me how can we do this ?

Thanks & Regards,
Vikash Jain

Comments

TexasApexDeveloper

You should be using version control for your database objects and if need be you should build scripts to update the objects in beta/prod when you need to migrate the changes.  Remember version control is developers friend, don't develop without it!!

Thank you,

Tony Miller

Los Alamos, NM

DannyS-Oracle

Hi Tony, thanks for the reply! I agree that version control is necessary here. I guess I am still trying to figure out the detailed steps - please bear with me

So far here is the best practice from what I found so far, including questions I still have:

  1. Have 2 separate workspace: Dev and Prod. I heard that both of apps in Dev and Prod should have the same App ID - what is the purpose of this?
  2. Whenever a feature / DB change is ready to release, check-in the Application export script / DDL scripts to the version control. This step is fairly straightforward.
  3. We import the scripts to the prod environment. I have some confusion here:
    1. For application export (pages, shared components), should I delete the previous production application entirely, to replace it with the script? Or is there a way to automatically check diff and merge the differences? I assume it is the former one (delete and replace), because this will make the idea of having same APP IDs between Dev and Prod environments much more understandable.
    2. Same question for DDL script: should I purge the database in prod and then replace the tables, functions, triggers, etc with the ones from script? Is there a way to merge automatically?
    3. How to manage the production data during this rollout process? Is there a way to generate DML script (which allow me to do INSERT data after the database tables reconstructed) in Apex? Also, what if the table columns changed in the new release, how can I merge the production data to this new table structure?

Any idea will be appreciated!

ATK

Hi Danny,

To create a stable and reliable deployment process for APEX you need more than one Database/APEX instance. With one single database and APEX you cannot have same app ID in two different workspaces. Also it is a risk of updating the wrong table in wrong schema and damage production data.

Ideally, you need 3 different servers, and Database, (1)Dev, (2)Test and (3)Production. You do all your development on Dev. Create a seperateSQL file contain all table alter and DML.Put all together and create a script to run them on Test. Run this deployment script on Test, do a full test and UAT, then deploy App to production with using this tested script.

On 12c you can use pluggable databases (PDBs) and install multiple APEX each on separate PDB. Then configure ORDS to connect to each and you find different URL for each environment. It is not a simple newbie task but you can study more here.

For generate alter scripts, if you use Oracle SQLDeveloper (here), when you do a change in a table, it gives you alter script as well. And you can export all changed packages or procedures. Also, you could use third party tools or Database Diff in Oracle SQL Developer to generate alter scripts by comparing two databases.

ATK

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

Post Details

Locked on Jun 24 2013
Added on May 23 2013
7 comments
1,112 views