ORA-01192: must have at least one enabled thread 2. 重建脚本 CREATE CONTROLFILE REUSE DATABASE testNORESETLOGSFORCE LOGGING ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 32 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/oradata/onlinelog/group_1.373.871427395' SIZE 50M BLOCKSIZE ...
ORA-01192: must have at least one enabled thread 2. 重建脚本 CREATE CONTROLFILE REUSE DATABASE testNORESETLOGSFORCE LOGGING ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 32 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/oradata/onlinelog/group_1.373.871427395' SIZE 50M BLOCKSIZE ...
ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/home/oracle/database/HRMS/system01.dbf' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 Could you please help me to fix this issue ?
As I tried to create the controlfiles by running the script "create_controlfile.sql", I received the following errors: CREATE CONTROLFILE SET DATABASE "SID" RESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/oracle/SID/sapdat...
CREATE CONTROLFILE SET DATABASE "T12" RESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01100: database already mounted I`m wondering why it says the "ORA-01589" again. Sincerely, Alessandro former_member524429 Active Contributor 2010 Feb 16 0 Kudos Hi,...
你是不是手工创建的数据库啊，你查看下'D:\app\Administrator\oradata\orcl\SYSTEM01.DBF'是否存在，然后手工重建下控制文件试试！
ORA-01503: create controlfile failed 原因: 在创建控制文件时发生一个错误。 操作:查看相应信息。 ORA-01161: database name <name> in file header does not match given name of <name> 原因:在命令行给出的数据库名与在文件头中找到的数据库名不匹配。
CREATE CONTROLFILE REUSE DATABASE “EDWPROD” RESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01189: file is from a different RESETLOGS than previous files ORA-01110: data file 2: ‘/ora/prod/edwprod/data/EDWPROD/datafile/o1_mf_undotbs1_334h0kxm_.dbf’ ...
ORA-01503: CREATE CONTROLFILE ?? ORA-00600: ???, ??: [kccccfl_1], [], [], [], [], [], [], [], [],,程序员大本营,技术文章内容聚合第一站。
ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/home/oracle/database/HRMS/system01.dbf' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 Could you please help me to fix this issue ?