oracle实例名要和数据库名一样吗,修改Oracle实例名(sid)和数据库名(db_name)

我修改后的ccf.sql文件内容如下

STARTUP NOMOUNT

CREATE CONTROLFILE set DATABASE "cnhtm" RESETLOGS ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 '+DATA/cnhtm/onlinelog/group_1.LOG' SIZE 100M,

GROUP 2 '+DATA/cnhtm/onlinelog/group_2.LOG' SIZE 100M,

GROUP 3 '+DATA/cnhtm/onlinelog/group_3.LOG' SIZE 100M,

GROUP 4 '+DATA/cnhtm/onlinelog/group_4.LOG' SIZE 100M

DATAFILE

'+DATA/cnhtm/datafile/system01.DBF',

'+DATA/cnhtm/datafile/undotbs101.DBF',

'+DATA/cnhtm/datafile/sysaux01.DBF',

'+DATA/cnhtm/datafile/users01.DBF',

'+DATA/cnhtm/datafile/example01.DBF',

'+DATA/cnhtm/datafile/tbs_lmt01.DBF',

'+DATA/cnht