One step of a large server move that I've been working on for the past 3 months required me to move and Oracle XE instance from one server to another server while still retaining all of my user accounts.
I looked into the Data Pump Export function, but even using the FULL option does not bring the user accounts themselves. I opened a Service Request with Oracle, a disappointing experience to say the least, but finally was "pointed" in the right direction. And when I say "pointed", that's about it, they quoted a Document ID 73301.1, which when I searched Metalink for this, returned 7 different articles, none of which described my type of situation.
Anyway, long story short, I shutdown the "OracleServiceXE" and the "OracleXETNSListner" services on server "A" and server "B", copied the entire c:\oraclexe folder to server "B", modified the TNSNAMES.ora file to reference the new server name and not the old one, then restarted both services. My users were able to connect once again to the XE instance with their username and passwords.
No comments:
Post a Comment