Visit Counter

Tuesday, July 18, 2017

Create controlfile error ORA-1192 – Must have at least one enabled thread




SQL>  CREATE CONTROLFILE REUSE DATABASE "SSAERP" NORESETLOGS FORCE
  2   logging archivelog
  3   MAXLOGFILES 16
  4   MAXLOGMEMBERS 3
  5   MAXDATAFILES 100
  6   MAXINSTANCES 8
  7   MAXLOGHISTORY 31664
  8    LOGFILE
  9   GROUP 4 '/ora/ora_dat/ssaerp/redo04.log' SIZE 50M BLOCKSIZE 512,
 10   GROUP 5 '/ora/ora_dat/ssaerp/redo05.log' SIZE 50M BLOCKSIZE 512,
 11  GROUP 6 '/ora/ora_dat/ssaerp/redo06.log' SIZE 50M BLOCKSIZE 512
 12   datafile
 13  '/ora/ora_dat/ssaerp/system01.dbf',
 14  '/ora/ora_dat/ssaerp/undotbs01.dbf',
 15   '/ora/ora_dat/ssaerp/sysaux01.dbf',
 16   '/ora/ora_dat/ssaerp/users01.dbf',
 17   '/ora/ora_dat/ssaerp/system02.dbf',
 18   '/ora/ora_dat/ssaerp/xdb_SSAERP01.dbf',
 19   '/ora/ora_idx/ssaerp/xdb_SSAERP01.dbf',
 20   '/ora/ora_dat/ssaerp/xdb_SSAERP02.dbf',
 21   '/ora/ora_dat/ssaerp/xdb_SSAERP03.dbf',
 22    '/ora/ora_dat/ssaerp/xdb_SSAERP04.dbf',
 23    '/ora/ora_dat/ssaerp/xdb_SSAERP05.dbf',
 24    '/ora/ora_dat/ssaerp/xdb_SSAERP06.dbf',
 25   '/ora/ora_dat/ssaerp/xdb_SSAERP07.dbf',
 26   '/ora/ora_dat/ssaerp/xdb_SSAERP08.dbf',
 27    '/ora/ora_dat/ssaerp/xdb_SSAERP09.dbf',
 28     '/ora/ora_dat/ssaerp/xdb_SSAERP10.dbf',
.......
.......
 56   CHARACTER SET WE8ISO8859P1;
 CREATE CONTROLFILE REUSE DATABASE "SSAERP" NORESETLOGS FORCE
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01192: must have at least one enabled thread


Solution:


CREATE CONTROLFILE SET DATABASE "PCARD" RESETLOGS FORCE LOGGING NOARCHIVELOG

No comments:

Post a Comment