Change Sid

Changing Database SID in Oracle In case of database migration to new landscape some times we need to change database sid. Manualy it can be done by creating controlfile & so on. But using nid tool it can be done very easily. Steps: 1. Mount the source database. 2. Run nid target=sys/password@sourcedb dbname=newsid (It will modify controlfile,datafile & every thing & shutdown the database ) 3. The parameter file has to be modified manually. 4. Start the database with new pfile with RESETLOG option. So, now you've successfully changed the db sid. Note: All the previous backup & controlfile will be useless for this new database.