Step 4: Set the DB_NAME initialization parameter in the initialization parameter file to the new database name. Modify parameter file and generate a new password file before restarting. All rights reserved.Ĭonnected to database MYORDB (DBID=2436089413)Ĭhange database name of database MYORDB to MYNEWDB? (Y/) => YĬhanging database name from MYORDB to MYNEWDBĬontrol File C:ORADATAMYORDBCONTROL01.CTL - modifiedĭatafile C:ORADATAMYORDBSYSTEM01.DB - wrote new nameĭatafile C:ORADATAMYORDBSYSAUX01.DB - wrote new nameĭatafile C:ORADATAMYORDBUNDOTBS01.DB - wrote new nameĭatafile C:ORADATAMYORDBUSERS01.DB - wrote new nameĭatafile C:ORADATAMYORDBMYORDBDAT01.DB - wrote new nameĭatafile C:ORADATAMYORDBMYORDBIDX01.DB - wrote new nameĭatafile C:ORADATAMYORDBTEMP01.DB - wrote new nameĬontrol File C:ORADATAMYORDBCONTROL01.CTL - wrote new nameĬontrol File C:ORADATAMYORDBCONTROL02.CTL - wrote new name No other special characters are permitted in a database name. nid dbname=MYNEWDB setname=YESĭBNEWID: Release 11.2.0.1.0 - Production on Tue May 30 12:50:01 2015Ĭopyright (c) 1982, 2009, Oracle and/or its affiliates. In Oracle RAC environments, the database name (DBUNIQUENAME) portion is a string of no more than 30 characters that can contain alphanumeric, underscore (), dollar (), and pound () characters, but must begin with an alphabetic character. The user specified in the connection string should have SYSDBA privilege. Run the DBNEWID utility by specifying the connection string and a new name for the database. Total System Global Area 1071333376 bytesĭisconnected from Oracle Database 11g Release 11.2.0.1.0 - Production Step 1: The first step is to start an instance and mount a database without opening it. DBNAME is the database name that you specify while creating the database and DBID is a unique number that is assigned to the database when it is created. You could change either the DBID or DBNAME or both. Step 0: Before you start, find out the current DBNAME and DBID of your database: DBNEWID is a database utility to change the DBNAME and DBID of an Oracle Database.
#Oracle database name full#
IMPORTANT: Before you start the procedure make sure you have a full backup of your database.
#Oracle database name how to#
The following steps demonstrates how to change the DBNAME and DBID of an Oracle Database using the DBNEWID utility. You could change either the DBID or DBNAME or both.ĭBNAME is the database name that you specify while creating the database and DBID is a unique number that is assigned to the database when it is created. DBNEWID is a database utility to change the DBNAME and DBID of an Oracle Database.
0 kommentar(er)
