Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Question Unanswered: Possible To Change SID / Retain Data?

    I have a Oracle 11.2.0.3 VM running with a 12.2 GB database size. Currently I would like to take a snapshot / clone of the Oracle database 11g and replicate it. Obviously I would change the Linux OS hostname / IP parameters to avoid conflicts on the LAN however I would like to know if its possible in Oracle 11g (and acceptable) to change the SID on the said cloned machine once the machine has been replicated?

    Currently my SID on the above mentioned database is ATL and after I snapshot the virtual machine and get the OS parameters unique, I'd like to make the SID = ORL. Is this acceptable in the Oracle DBA community or is it highly frowned upon to make changes to a SID once there has been data added to the database?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    /home/oracle/app/oracle/product/11.2.0/dbhome_2/bin/nid

    above can be used to change SID
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •