{"id":2677,"date":"2018-02-02T21:36:32","date_gmt":"2018-02-02T12:36:32","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2677"},"modified":"2018-02-02T21:36:52","modified_gmt":"2018-02-02T12:36:52","slug":"db_name%ea%b3%bc-sid-%eb%b3%80%ea%b2%bd%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2677","title":{"rendered":"DB_NAME \uacfc SID \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Modifying a database to run under a new ORACLE_SID<\/strong><\/p>\n

—————————————————————–<\/p>\n

1. Shutdown instance<\/p>\n

 <\/p>\n

2. Backup all control, redo and data files.<\/p>\n

 <\/p>\n

3. Go thru the .profile, .cshrc, .login, oratab, tnsnames.ora(for net v2) , and redefine the environment variable ORACLE_SID to a new value. ie search thru disks and do a grep ORACLE_SID *<\/p>\n

 <\/p>\n

4. cd $ORACLE_HOME\/dbs and rename the following files:<\/p>\n

o init.ora (or use pfile to point to the init file.)<\/p>\n

o control file(s) This is optional if you don’t rename any of the controlfiles, and the control_files parameter is used. control_files would be set in the initSID.ora file or in a file it references with the ifile parameter. Make sure control_files doesn’t point to any old file names, if you renamed them.<\/p>\n

o crdb.sql & crdb2.sql This is optional. These are only used at database creation.<\/p>\n

 <\/p>\n

5. cd $ORACLE_HOME\/rdbms\/admin and rename the file:<\/p>\n

o startup.sql This is optional. (On some platforms, this file may be in $ORACLE_HOME\/rdbms\/install.)<\/p>\n

Make sure the contents of this file do not reference old initSID.ora files that have been renamed. This file simplifies the process to “startup exclusive” your database.<\/p>\n

 <\/p>\n

6. To rename the database files and redo log files, you would follow the instructions in the bulletin: 98863.723.<\/p>\n

 <\/p>\n

7. Change the ORACLE_SID environment variable to the new value.<\/p>\n

 <\/p>\n

8. start up database and verify it works. Once you have done this, shutdown the database and take a final backup of all control, redo and data files.<\/p>\n

 <\/p>\n

9. When the instance is started, the control file gets updated with the current ORACLE_SID.<\/p>\n

 <\/p>\n

 <\/p>\n

Changing the dbname for a database<\/strong><\/p>\n

———————————————–<\/p>\n

1. sqldba<\/p>\n

 <\/p>\n

2. connect internal<\/p>\n

 <\/p>\n

3. alter database backup controlfile to trace;<\/p>\n

This will write in a trace file, the CREATE CONTROLFILE command that would recreate the controlfile as it currently exists.<\/p>\n

 <\/p>\n

4. Exit and go to the directory where your trace files are located.<\/p>\n

They are usually in the $ORACLE_HOME\/rdbms\/log directory.<\/p>\n

If user_dump_dest is set in the initSID.ora, then go to the directorylisted in the user_dump_dest variable.<\/p>\n

The trace file will have the form “ora_NNNN.trc with NNNN being a number.<\/p>\n

 <\/p>\n

5. Get the CREATE CONTROLFILE command from the trace file and put it in a new file called something like ccf.sql.<\/p>\n

 <\/p>\n

6. Edit the ccf.sql file and modify the CREATE CONTROLFILE command. Just change the word “REUSE” to “SET”,and “NORESETLOGS” to “RESETLOGS”, and modify the dbname.<\/p>\n

Old line:<\/strong><\/p>\n

CREATE CONTROLFILE REUSE DATABASE “olddbname” NORESETLOGS …<\/strong><\/p>\n

New line:<\/strong><\/p>\n

CREATE CONTROLFILE set DATABASE “newdbname” RESETLOGS …<\/strong><\/p>\n

Then save the ccf.sql file.<\/strong><\/p>\n

 <\/p>\n

7. Rename the old control files for backup purposes and so they are not in the way of creating the new ones.<\/p>\n

 <\/p>\n

8. Edit initSID.ora so that db_name=”newdbname”.<\/p>\n

 <\/p>\n

9. sqldba<\/p>\n

 <\/p>\n

10. connect internal<\/p>\n

 <\/p>\n

11. startup nomount<\/p>\n

 <\/p>\n

12. @ccf<\/p>\n

 <\/p>\n

13. alter database open;<\/p>\n

 <\/p>\n

14. Make sure the database is working. Shutdown and backup the database.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Modifying a database to run under a new ORACLE_SID —————————————————————– 1. Shutdown instance   2. Backup all control, redo and data files.   3. Go thru the .profile, .cshrc, .login, oratab, tnsnames.ora(for net v2) , and redefine the environment variable ORACLE_SID to a new value. ie search thru disks and do a grep ORACLE_SID * […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[879,877,533,878],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2677"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2677"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2677\/revisions"}],"predecessor-version":[{"id":2679,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2677\/revisions\/2679"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2677"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}