Thursday, November 15, 2007

Change Windows Hostname and Keep Oracle 10g Running

Step 1 – Create Hosts Entry for Old Hostname add entry to the file WINNT\system32\drivers\etc\hosts
Step 2 – Uninstall Enterprise Manager Console emca -deconfig dbcontrol db -repos drop
Step 3 – Stop All Oracle Services
Step 4 – Update listener.ora and tnsnames.ora with the new Hostname
Step 5 – Rename Host and Restart DELETE THE OLD SERVICE FROM THE REGISTRY
Step 6 – Ensure Oracle Instance is running
Step 7 - Start windows to remove Enterprise Manager service
Step 8 – Reinstall Enterprise Manager Console emca -config dbcontrol db -repos create
Step 9 – Validate Enterprise Manager Console Installation http://:1158/em

No comments: