[wcci] - Updating Oracle hostname for exisitng WNC

[clawrenz-2]

Amol,

The steps are pretty straight forward:

Export the Oracle Dbfrom wncserver and import into your oracleserver
Update the WT_HOME\db\db.properties to point to the new host

wt.pom.jdbc.host=oracleserver

Note: You do not directly edit the db.properties, instead edit WT_HOME\site.xconf and then propagate those changes to db.properties via xconfmanger -p


Best Regards,

Carsten Lawrenz
Kalypso
Delivering on the Promise of Innovation
m. 415.378.6374
[">http://kalypso.com/sigs/sig_smalljewel.png]<http: kalypso.com=" smalljewel=">
[[http://kalypso.com/sigs/sig_facebook.png]<http: www.facebook.com=" kalypsolp=">[http://kalypso.com/sigs/sig_twitter.png]<http: twitter.com=" kalypsolp=">[http://kalypso.com/sigs/sig_linkedin.png]<http: www.linkedin.com=" company=" kalypso=">[http://kalypso.com/sigs/sig_youtube.png]<http: www.youtub...

wrote:

Hi Fellow Windchillers,

As a test installation have Windchill 10.1 M030 successfully running on a server(say- wncserver) with Oracle11g on the same machine. We have another machine (with a different hostname- say oracleserver) which has Oracle11g installed on it. Want to update the existing Windchill installation such that the - wncserver connects to the new oracleserver. Have tried using the PTC user manuals and they suggest steps which involve restarting the installation process and then it will prompt user for the new oracleserver details.

Please let me know if this is the only way or the new oracle connection can be achieved by updating wt.properties and/or db.properties or any similar updations.


Thanks,
Amol


Amol S. Akolkar
PhD Student-PLM Lab
COT-Computer Graphics Technology
Purdue University, West Lafayette-IN


----------