Home / server / Questions / 511426
Accepted
sreimer
Asked: 2013-05-29 07:30:43 +0800 CST

Retain SIDs and TNS when upgrading Oracle

  • 772

I am researching the process to upgrade Oracle from 11.2.0.1 to 11.2.0.3. I am planning on using the DBUA utility. My question is, will the DBUA make the necessary changes to retain my SIDs and update TNS so that no application changes will need to be made?

oracle-11g

1 Answers

  1. Best Answer

    Yes, it will. The database SID will remain the same, and thus, no edits needed in the TNS files. The applications will be able to access/use the database as they used to, no client modification is needed.

    • 1