![oracle sql prompt on virtual field oracle sql prompt on virtual field](https://m.media-amazon.com/images/I/51XfsLVP2FL._AC_SY780_.jpg)
Change SID referencesĬhanges will need to be made in the database parameter, tnsnames, oratab, and environment files to reflect the change of the database SID.
![oracle sql prompt on virtual field oracle sql prompt on virtual field](https://www.seercomputing.com/images/latest_essential_sql.jpg)
Repeat starting a SQLPlus session and enter the command shutdown immediate as shown in Step 2.1.
![oracle sql prompt on virtual field oracle sql prompt on virtual field](http://www.rebellionrider.com/wp-content/uploads/2019/07/cropped-how-to-install-oracle-database-19c-1.png)
The database will need to be shut back down. Successfully changed database name and ID.ĭBNEWID – Completed from NID program showing a successful completion.
Oracle sql prompt on virtual field password#
Modify parameter file and generate a new password file before restarting.ĭatabase ID for database QA changed to 1714809981Īll previous backups and archived redo logs for this database are unusable.ĭatabase is not aware of previos backups and archived logs in Recovery Area.ĭatabase hase been shut down, open database with RESETLOGS option. See figure 2.3.1 for the screen display.įigure 2.3.1 Screen display of running NID commandĭatafile /u02/app/oracle/oradata/prd/dw03.db – dbid changed, wrote new nameĭatafile /u02/app/oracle/oradata/prd/dw04.db – dbid changed, wrote new nameĭatafile /u02/app/oracle/oradata/prd/dw05.db – dbid changed, wrote new nameĭatafile /u01/app/oracle/oradata/prd/temp01.db – dbid changed, wrote new nameĬontrol File /u01/app/oracle/oradata/prd/control01.ctl – dbid changed, wrote new nameĬontrol File /u02/app/oracle/oradata/prd/control02.ctl – dbid changed, wrote new name You will be prompted to confirm that you want to change the SID. After you press enter, you will be prompted for the SYS account password. With the new SID being qa, the command line will be nid target=SYS dbname=qa. To use it, you will need the SYS account password and the new SID for the database. The NID command is the Oracle program that changes the SID of the database. Run the following query to see if your database was started with a PFILE or SPFILE:įigure 1.1 Query to see if SPFILE is in sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 11 20:02:24 2014Copyright © 1982, 2011, Oracle, All rights reserved.Įxample of Output when starting the database to mount mode.Įnter exit to return back to the shell prompt. If the database is using an server parameter file ( SPFILE) instead of a parameter file ( PFILE), you will need to convert from a SPFILE to a PFILE before the database name change occurs. There are four steps to perform to change an Oracle database name ( SID).Īfter the database name change, changes will need to be made to the Oracle parameter file. This will be referenced when appropriate in the document. The database name, or SID, is being changed from prd to qa. Located in $ORACLE_HOME/network/admin folder. TNSNAMES – Oracle network configuration file that associates incoming connections with Oracle SIDs. ORATAB – Oracle configuration file that associates the Oracle SIDs with Oracle homes. This is the database name that is being changed. The following terminology and definitions will be used in this document. This document will detail the steps required to perform the database name change using NEWID. Oracle has a utility for this, the NEWID application. Other times, you will need to change the database name and the DBID internally. Sometimes you can resolve it sufficiently with aliasing at the TNSNAMES level. Unfortunately, that ends up with you having two databases with the same name and DBID in your network. If the database is on a virtual machine, cloning could occur at the VM level.Ĭloning does exactly what it means, creating an exact duplicate of a database. Usually this is done from a production database to a quality assurance or test database to provide production volume data. One of the many tasks a DBA will perform is cloning a database.