{"id":54988,"date":"2023-09-05T09:34:11","date_gmt":"2023-09-05T09:34:11","guid":{"rendered":"https:\/\/dbtut.com\/?p=54988"},"modified":"2023-09-05T09:37:14","modified_gmt":"2023-09-05T09:37:14","slug":"how-to-change-database-name-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/","title":{"rendered":"How To Change Database Name In Oracle"},"content":{"rendered":"<p>In this topic we will see how can we change our database name using Oracle NID tool.<\/p>\n<p>Use the syntax bellow to change the Dtabase Name.<\/p>\n<p>Make sure you shutdown and start up in mount mode your oracle database before.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; shu immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt; startup mount\r\nORACLE instance started.\r\n\r\nTotal System Global Area 1610612736 bytes\r\nFixed Size                  2077904 bytes\r\nVariable Size             385878832 bytes\r\nDatabase Buffers         1207959552 bytes\r\nRedo Buffers               14696448 bytes\r\nDatabase mounted.\r\nSQL&gt; exit<\/pre>\n<pre class=\"lang:default decode:true \">$ nid TARGET=SYS\/Password DBNAME=NEWDB SETNAME=YES\r\n\r\nDBNEWID: Release 11.2.0.4.0\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to database TEST (DBID=2127904120)\r\n\r\nConnected to server version 11.2.0\r\n\r\nControl Files in database:\r\n    \/uu1\/oracle\/oradata\/ABUZERDB\/control01.ctl\r\n    \/u01\/oracle\/flash_recovery_area\/control02.ctl\r\n\r\nChange database name of database TEST to NEWDB? (Y\/[N]) =&gt; Y\r\n\r\nProceeding with operation\r\nChanging database name from TEST to NEWDB\r\n    Control File \/uu1\/oracle\/oradata\/ABUZERDB\/control01.ctl - modified\r\n    Control File \/u01\/oracle\/flash_recovery_area\/control02.ctl - modified\r\n\r\n    Datafile \/uu1\/oracle\/oradata\/ABUZERDB\/system01.db - wrote new name\r\n    Datafile \/uu1\/oracle\/oradata\/ABUZERDB\/sysaux01.db - wrote new name\r\n    Datafile \/uu1\/oracle\/oradata\/ABUZERDB\/undotbs01.db - wrote new name\r\n    Datafile \/uu1\/oracle\/oradata\/ABUZERDB\/users01.db - wrote new name\r\n    Datafile \/uu1\/oracle\/oradata\/ABUZERDB\/temp01.db - wrote new name\r\n    Control File \/uu1\/oracle\/oradata\/ABUZERDB\/control01.ctl - wrote new name\r\n    Control File \/u01\/oracle\/flash_recovery_area\/control02.ctl\/control02.ctl - wrote new name\r\n    Instance shut down\r\n\r\nDatabase name changed to NEWDB.\r\nModify parameter file and generate a new password file before restarting.\r\nSuccesfully changed database name.\r\nDBNEWID - Completed succesfully.<\/pre>\n<p>2. Recreate the new password file.<\/p>\n<pre class=\"lang:default decode:true \">$ orapwd file=\/u01\/oracle\/product\/11.2.0\/dbhome_1\/dbs\/passwd.ora password=Password entries=5\r\n<\/pre>\n<p>3. Make sure that you drop any password files before or you will get some errors. Rename the init.ora file.<\/p>\n<pre class=\"lang:default decode:true \">$ rename init.ora initDB.ora\r\n<\/pre>\n<p>4. Edit the initDB.ora parameters file.<\/p>\n<pre class=\"lang:default decode:true \">$ vi initDB.ora\r\n# Change '&lt;oracle_BASE&gt;' to point to the oracle base (the one you specify at\r\n# install time)\r\n\r\ndb_name='NEWDB'<\/pre>\n<p>5. Now start the database in nomount mode and alter the db_name parameter in the control file.<\/p>\n<pre class=\"lang:default decode:true \">$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production\r\n\r\nCopyright (c) 1982, 2009, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup nomount\r\nORACLE instance started.\r\n\r\nTotal System Global Area  417546240 bytes\r\nFixed Size                  2213936 bytes\r\nVariable Size             289408976 bytes\r\nDatabase Buffers          121634816 bytes\r\nRedo Buffers                4288512 bytes\r\nSQL&gt; alter system set db_name=NEWDB scope=spfile;\r\n\r\nSystem altered.<\/pre>\n<p>6. Shutdown the database and start it backup.<\/p>\n<pre class=\"lang:default decode:true \"> SQL&gt; shutdown immediate;\r\nORA-01507: database not mounted\r\n\r\n\r\nORACLE instance shut down.\r\nSQL&gt; startup;\r\nORACLE instance started.\r\n\r\nTotal System Global Area  417546240 bytes\r\nFixed Size                  2213936 bytes\r\nVariable Size             268437456 bytes\r\nDatabase Buffers          142606336 bytes\r\nRedo Buffers                4288512 bytes\r\nDatabase mounted.\r\nDatabase opened<\/pre>\n<p>7. Check the status and name of you database.<\/p>\n<pre class=\"lang:default decode:true\">SQL&gt; select status from v$instance;\r\n\r\nSTATUS\r\n------------\r\nOPEN\r\n\r\nSQL&gt; select * from global_name;\r\n\r\nGLOBAL_NAME\r\n--------------------------------------------------------------------------------\r\nNEWDB<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54988\" class=\"pvc_stats all  \" data-element-id=\"54988\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this topic we will see how can we change our database name using Oracle NID tool. Use the syntax bellow to change the Dtabase Name. Make sure you shutdown and start up in mount mode your oracle database before. SQL&gt; shu immediate Database closed. Database dismounted. ORACLE instance shut down. SQL&gt; startup mount ORACLE &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54988\" class=\"pvc_stats all  \" data-element-id=\"54988\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":574,"featured_media":54991,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-54988","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Change Database Name In Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In this topic we will see how can we change our database name using Oracle NID tool. Use the syntax bellow to change the Dtabase Name.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Change Database Name In Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In this topic we will see how can we change our database name using Oracle NID tool. Use the syntax bellow to change the Dtabase Name.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-05T09:34:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-05T09:37:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png\" \/>\n\t<meta property=\"og:image:width\" content=\"687\" \/>\n\t<meta property=\"og:image:height\" content=\"273\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"How To Change Database Name In Oracle\",\"datePublished\":\"2023-09-05T09:34:11+00:00\",\"dateModified\":\"2023-09-05T09:37:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/\"},\"wordCount\":110,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/\",\"name\":\"How To Change Database Name In Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png\",\"datePublished\":\"2023-09-05T09:34:11+00:00\",\"dateModified\":\"2023-09-05T09:37:14+00:00\",\"description\":\"In this topic we will see how can we change our database name using Oracle NID tool. Use the syntax bellow to change the Dtabase Name.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png\",\"width\":687,\"height\":273},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Change Database Name In Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Change Database Name In Oracle - Database Tutorials","description":"In this topic we will see how can we change our database name using Oracle NID tool. Use the syntax bellow to change the Dtabase Name.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How To Change Database Name In Oracle - Database Tutorials","og_description":"In this topic we will see how can we change our database name using Oracle NID tool. Use the syntax bellow to change the Dtabase Name.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2023-09-05T09:34:11+00:00","article_modified_time":"2023-09-05T09:37:14+00:00","og_image":[{"width":687,"height":273,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png","type":"image\/png"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"How To Change Database Name In Oracle","datePublished":"2023-09-05T09:34:11+00:00","dateModified":"2023-09-05T09:37:14+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/"},"wordCount":110,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/","name":"How To Change Database Name In Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png","datePublished":"2023-09-05T09:34:11+00:00","dateModified":"2023-09-05T09:37:14+00:00","description":"In this topic we will see how can we change our database name using Oracle NID tool. Use the syntax bellow to change the Dtabase Name.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-05-123113.png","width":687,"height":273},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/05\/how-to-change-database-name-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Change Database Name In Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=54988"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54988\/revisions"}],"predecessor-version":[{"id":54992,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54988\/revisions\/54992"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54991"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}