Modify the Oracle Instance name ORCL to Demo

There are six steps to modifying the Oracle instance name:

1. Sqlplus Username/password as SYSDBA, then create Pfile file from SPFile file: Creation Pfile from SPFile

2, modify the pfile db_name parameter name is demo, and then save it.

3. Create SPFile file based on pfile file creation spfile= ' C:\%oracle_home%\database\spfiletemp.ora ' from pfile= ' c:\%oracle_home%\ Database\initorcl.ora '

4. Then close the database, shutdown immediate--"Rename spfiletemp.ora--" Spfiledemo.ora

5, the creation of control files, then need to be familiar with the database configuration, start Nomount state, startup Nomount

Create Controlfile Reuse Set Database "DEMO" Resetlogs
Maxlogfiles 16
Maxlogmembers 3
Maxdatafiles 100
Maxinstances 8
Maxloghistory 454
LogFile
Group 1 ' C:\app\LPH\oradata\orcl\redo01.log ' size 10m,
Group 2 ' C:\app\LPH\oradata\orcl\redo02.log ' size 10m
DataFile--Location of previous system files
' C:\app\***\oradata\orcl\system01.dbf ',
' C:\app\***\oradata\orcl\sysaux01.dbf ',
' C:\app\***\oradata\orcl\undotbs01.dbf ',
' C:\APP\***\ORADATA\ORCL\USERS01.DBF '
Character Set ZHS16GBK;

6. Open data, ALTER DATABASE open Resetlogs

Error-prone places are three points:

1. The path or name of the log or system file is incorrectly written

2, no start database bit nomount status

3, open the data without adding resetlogs

Modify the Oracle Instance name ORCL to Demo