tag:blogger.com,1999:blog-2530682427657016426.post8308187134233555162..comments2024-03-18T22:59:35.401+01:00Comments on Marko Sutic's Database Blog: Change SID of the Oracle database using DBNEWIDMarko Sutichttp://www.blogger.com/profile/08926232581329666732noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-2530682427657016426.post-81549936305258668162020-08-10T13:08:52.743+02:002020-08-10T13:08:52.743+02:00Sorry, but the title of the document is misleading...Sorry, but the title of the document is misleading: to change the instance_name it's sufficient to change the name of the spfile, orapwd and variable ORACLE_SID. You only need NID if you want to change the database nameJohannes Ahrendshttp://www.carajandb.comnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-56770674898554015742015-07-03T10:40:11.367+02:002015-07-03T10:40:11.367+02:00Hello
I found what causing this half renamed db.
...Hello<br />I found what causing this half renamed db. <br />I forgot in.bash_profile exports of ORACLE_SID and ORACLE_UNQNAME pointed to the old name.<br />I corrected them, restart db, and now everything is as expected!<br /><br />Thanks for your guide!night_dreamerhttps://www.blogger.com/profile/16451983183836208225noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-27409388178212887232015-07-03T08:48:46.586+02:002015-07-03T08:48:46.586+02:00This parameter is not important for changing name ...This parameter is not important for changing name of the database. <br />You can probably ignore it. Parameter is important for dispatcher configuration.<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-41683855206244126202015-07-02T14:36:03.809+02:002015-07-02T14:36:03.809+02:00Hello.
Thanks for your reply!
Yes, I've chang...Hello.<br />Thanks for your reply!<br /><br />Yes, I've changed this parameter. But here is another parameter and I don't know whether to change it or not:<br /><br />*.dispatchers='(PROTOCOL=TCP) (SERVICE=atlantisXDB)'night_dreamerhttps://www.blogger.com/profile/16451983183836208225noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-69331911557144723842015-07-01T09:44:33.435+02:002015-07-01T09:44:33.435+02:00Hello night_dreamer,
have you changed DB_NAME par...Hello night_dreamer,<br /><br />have you changed DB_NAME parameter with new name in parameter file?<br /><br />Regards,<br />Marko<br /><br /><br /><br /><br /><br /><br />Marko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-13029623500609292812015-06-30T16:10:50.384+02:002015-06-30T16:10:50.384+02:00I did exactly what you did in your blog without an...I did exactly what you did in your blog without any errors, but when I grep for pmon or smon, the name is still the old one. Also "select instance_name from v$instance;" return old name. <br />Now I have 2 folders in diag/rdbms/ with "new" name and the old name. Alert.log file is in the directory with the "new" name, but the file itself is named still alert_oldname.log<br />(Linux x64, 11.2.0.4.0)<br /><br />It seems your guide is incomplete ;) night_dreamerhttps://www.blogger.com/profile/16451983183836208225noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-25464723959944813402013-04-10T19:50:53.494+02:002013-04-10T19:50:53.494+02:00Hi Mladen,
also thanks for comment.
You are corre...Hi Mladen,<br /><br />also thanks for comment.<br />You are correct, there isn't much need for changing database name when you have DB_UNIQUE_NAME. But I wanted to test nid utility as I've never tried to use it.<br /><br />Why you prefer re-creating control file over nid?<br />Have you experienced some odd problems with nid? I'm just curious :)<br /><br />I don't think that re-creating control files is the wrong way (as I said, it was the only way for me till now). But using nid utility means less writing/editing, less chance for stupid typos, so why not use it... yes, I know, I'm lazy :D<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-45820706611854122402013-04-10T19:30:15.855+02:002013-04-10T19:30:15.855+02:00Hello Damir,
thanks for comment ;)
I've teste...Hello Damir,<br /><br />thanks for comment ;)<br />I've tested nid only on Linux machine. But as I can see on Google some DBA's tried to run nid on Windows machine so it probably works there also.<br /><br />For 10g version : http://tinyurl.com/c3vquva<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-43744996398827554642013-04-10T16:59:24.290+02:002013-04-10T16:59:24.290+02:00Generally speaking, there isn't much need for ...Generally speaking, there isn't much need for changing the database name, ever since the advent of the parameter DB_UNIQUE_NAME. That parameter is also used by RMAN, in conjunction with the DBID. If you have to chane the DB name, I would still prefer re-creating the control file to nid. This utility is an anachronism from the times of 9i, at least in my opinion.Mladen Gogalahttps://www.blogger.com/profile/06288417393291387067noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-43559123261202091782013-04-10T08:29:30.337+02:002013-04-10T08:29:30.337+02:00windows databases are not so lucky...
:-)windows databases are not so lucky...<br />:-)Damir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.com