Oracle 11g XE 改變預設 sid XE

http://stackoverflow.com/questions/410951/how-can-i-change-the-sid-of-an-oracle-xe-instance

The asktom article has the answer, but the formatting and verbosity makes it hard to follow, so here's a summary:

[XE_HOME] means where Oracle XE is installed. Normally this is C:\oraclexe\app\oracle\product\10.2.0\server.

Make sure you have Administrator privileges or the procedure will fail.

1. Configure the SPFILE (you can remove the old file if you want)
   1. copy [XE_HOME]\dbs\spfileXE.ora [XE_HOME]\dbs\spfileNEW_SID_NAME.ora
   2. copy [XE_HOME]\database\initXE.ora [XE_HOME]\database\initNEW_SID_NAME.ora
   3. Edit [XE_HOME]\database\initNEW_SID_NAME.ora: It should contain a single line like this: SPFILE='[XE_HOME]\server\dbs/spfileNEW_SID_NAME.ora'
2. Shutdown and replace the old service with a new:
   1. sqlplus / as sysdba and execute shutdown
   2. lsnrctl stop
   3. oradim -new -sid NEW_SID_NAME -startmode auto -pfile [XE_HOME]\database\initNEW_SID_NAME.ora
   4. oradim -delete -sid XE
   5. lsnrctl start
3. Update the ORACLE_SID environment property (System Settings > Advanced > Environment)
4. Force Oracle to register with listener
   • sqlplus / as sysdba and execute alter system register;

You can verify that the SID was changed by executing the following query: select instance_name from v$instance;




I had some problems with the solution posted by Johannes, so I had to do some extra steps. When trying to connect to oracle (step 4) by doing sqlplus / as sysdba I got:

ERROR: ORA-12560: TNS:protocol adapter error

The solution for this was executing the following line:

oradim -start -sid NEW_SID_NAME

Then connecting with / worked fine, but trying to connect to NEW_SID_NAME with system or HR got me another problem:

ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I checked that with the query select instance_name from v$instance; that the listener would be NEW_SID_NAME, and so did. But running lsnrctl status in the command line or querying select name from dba_services; didn't show NEW_SID_NAME as a listener. The solution of this problem was executing the followind sentence on sqlplus:

alter system set service_names='NEW_SID_NAME';

Maybe you'll need to execute alter system register; after this also.

After doing this two steps I can connect to the NEW_SID_NAME with system and HR.

Hope it helps

完整移除 ORACLE 11 G

http://www.oracle-base.com/articles/misc/manual-oracle-uninstall.php#Windows

Windows

In the past I've had many problems uninstalling all Oracle products from Windows systems. Here's my last resort method:

• Uninstall all Oracle components using the Oracle Universal Installer (OUI).
• Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/Oracle key. This contains registry entires for all Oracle products.
• If you are running 64-bit Windows, you should also delete the HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/Oracle key if it exists.
• Delete any references to Oracle services left behind in the following part of the registry (HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*). It should be pretty obvious which ones relate to Oracle.
• Reboot your machine.
• Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.
• Delete the "C:\Program Files\Oracle" directory.
• If you are running 64-bit Wiindows, you should also delete the "C:\Program Files (x86)\Oracle" directory.
• Remove any Oracle-related subdirectories from the "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\" directory.
• Empty the contents of your "C:\temp" directory.
• Empty your recycle bin.

At this point your machine will be as clean of Oracle components as it can be without a complete OS reinstall.

Remember, manually editing your registry can be very destructive and force an OS reinstall so only do it as a last resort.

If some DLLs can't be deleted, try renaming them, the after a reboot delete them.