Change Sid Name of Oracle (Instance Name)

[HenriqueMachado]

Environment information:
* Oracle version: 10.2.0.1
* Operating system: Winserver 2003

Hello everyone wanted to know how I can do to change the sid name Oracle. The name of the Oracle instance.

and also taking advantage to change the TNS Listener port. Because it was not like the 1521 standard and wanted to leave in the standard. (Today is 1522, for two version of Oracle on the same machine).

[josinei]

I think you will not be able to change the bank's sid.
You will probably have to export the current bank, create a new instance (with the SID you want) and import the bank into the new instance.

As to Listener, use the Oracle Net Configuration Assistant. It has a listener configuration option where you can change the port.

I hope I have helped.

[ruevers]

You can change yes, it's kind of complicated, but it gives yes ...
has an Oracle application for this ...

At the prompt type ...

NID

is only to enter with the parameters he asks for.

[diegoleite]

Do you want the most complicated or the easiest way?
Complicated You would have to change all directories with the name of the instance
ex: mv $ oracle_base / oradata / orclic $ oracle_base / oradata / test. And still recreate the service.


follows the mamao link with sugar.rsrs
http://www.psoug.org/reference/utilities.html