Become Oracle Apps DBA: How to change hostname or domainname for Apps Instance Server

You sometime have to change hostname or domainname of your Apps Instance , today's post list various options & things you need to note while changing hostname on your existing Apps Instance.

Use cloning for changing hostname or domainname
I am sure you might be surprised to see how cloning can change hostname or domainname , yes you are right cloning will not change host or domain name but cloning can be used to change pointers to old hostname or domainname in Apps Instance after changing hostname/domainname by operating system commands. Steps you have to do is

Run adpreclone on Instance where you want to change hostname/domainname
Release Unix/Linux machine to sysadmin for changing hostname
Run postclone with new hostname/domain with same SID to change new name into effect

Above method is easy & best which I can think .

Use Autoconfig to change hostname or domainname of machine hosting apps Instance
If Machine on which you want to change hostname/domainname is on application tier then you just change entries in $CONTEXT_NAME.xml
Change hostname or domainname using operating system commands
execute autoconfig on that Instance so that application tier register new hostname/domainname

If machine on which you want to change host/domain name also host Database Tier then you also need to Deregister database tier from Net Service Topology Model & Reregister it with new hostname settings.
If you want to learn more about Net Service Topology Model follow Metalink Note # 218089.1 Autoconfig FAQ Under Section Net Services Question 28 to 41

For exact steps on how to change hostname using Autoconfig follow Metalink Note # 338003.1 How to change the hostname and/or port of the Database Tier using AutoConfig

I recently completed OCA for Application Server Exam 1Z0-311 and will be sharing my experience with Oracle Certification for Application Server with you all. Stay tuned on Oracle Application Server Certification 1Z0-311 & lot more things.

Your feedback/comment is quite important for improving this blog so feel free to leave your comments & suggestions

Labels: 10gAS, advanced

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 10:42 PM

10 Comments:

At 2:51 AM, Anonymous said…

Hi,
It is very good site with so many information rlated to apps and many more.
I'm very new in apps and trying to install apps-11.5.10, i followed below steps,
1st installing,
1.win 2003
2.craeting active directory
3.Jave 1.3
4.VC++
5.MKS Toolkit
6.Thn creating GNU
7.Rapidwiz.
But, may be some thing I was doing wrong, thats why I got error
"Utility not found" or which command is not working.
So if you give a proper installation steps from starting crash, then that will be helpfull for all. So will you pls send me the proper steps?

Regards,
Subir
At 7:59 AM, Atul Kumar said…

Subir,
Oracle has written very noce document in Installation Guide & I suppose you have all required software .

As per message (Though its not clear) this seems that some utility is not in path.

I suggest you raise this is forum at http://teachmeoracle.com/forum with Installation logs related to error message .
At 12:48 PM, Unknown said…

Atul, good lead to the metalink doc ID..Since i had few issues, I suggest for the doc id : 338819.1 as an additional reference.For DBA has permission denied error while logging after changing the hostname. Please check the ICX_PARAMETERS view to update the session_cookie_domain manually to the new domain name.. Ideally s_cookie_domain parameter in the autoconfig suppose to update the ICX_PARAMETERS view, but it doesnt..

samintouch@gmail.com
At 12:49 PM, Unknown said…

Atul, good lead to the metalink doc ID..Since i had few issues, I suggest for the doc id : 338819.1 as an additional reference.For DBA has permission denied error while logging after changing the hostname. Please check the ICX_PARAMETERS view to update the session_cookie_domain manually to the new domain name.. Ideally s_cookie_domain parameter in the autoconfig suppose to update the ICX_PARAMETERS view, but it doesnt..

samintouch@gmail.com
At 12:52 PM, Atul Kumar said…

Thanks Sam for sharing such a valuable information with readers

Atul
At 10:07 AM, yaseen said…

hi atul i am new to dba ,

i start to cloning, i am getting RC-50004

error. in the log file

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
CREATE CONTROLFILE REUSE SET DATABASE "VIS"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/d01/oracle/R11/visdata/sys1.dbf'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 2

alter database open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted

alter tablespace TEMP add tempfile '/d01/oracle/R11/visdata/tmp1.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

i am getting this error can you tell solution for this error.

my preclone completed successfull .

my apps version is 11.5.10.2

i run the preclone eith dbTier , appsTier , i copy the source files and if i run the postclone i am getting this error.

can you give solution for this error .

thnks

yaseen.a.r
At 10:53 AM, Anonymous said…

Hi

Give permission to the oracle folder
chmod -R 755 /d01/oracle

Regards
Mukarram
At 10:53 AM, Anonymous said…

Hi

Give permission to the oracle folder
chmod -R 755 /d01/oracle

Regards
Mukarram
At 6:51 AM, Unknown said…

Hi Atul and all,

you are doing really a good work.
I have few doubts in this topic that the metalink you refer is only applicable to applcn.system with ADX.E applied. But what if i have not applied it. how can i change my hostname using autoconfig. What context parameters i need to change to change hostname of application tier and lastly i could not find any metalink doc. with 338819.1 no.

Regards,

Ibnhussain
At 7:54 PM, Roberto said…

Hi Yas

I had the same error cloning in equal conditions

I found this article in metalink 375389.1 and the solution number 2 resolved my problem.

I hat to copy again de source database tier (data and db) to the target system (section 2, step 2.b of 230672.1) and continue with configure the target system (section 2, step 3 of 230672.1)

rcombariza@gmail.com