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

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE “PROD” NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1630
LOGFILE
GROUP 1 (‘D:\ORACLE\ORADATA\PROD\REDO03.LOG’,’D:\ORACLE\ORADATA\PROD\REDO13.LOG’)
GROUP 2 (‘D:\ORACLE\ORADATA\PROD\REDO02.LOG’,’D:\ORACLE\ORADATA\PROD\REDO12.LOG’)
GROUP 3 (‘D:\ORACLE\ORADATA\PROD\REDO01.LOG’,’D:\ORACLE\ORADATA\PROD\REDO11.LOG’)
DATAFILE
‘D:\ORACLE\ORADATA\PROD\SYSTEM01.DBF’,
‘D:\ORACLE\ORADATA\PROD\DB01.DBF’,
‘D:\ORACLE\ORADATA\PROD\USERS01.DBF’,
‘D:\ORACLE\ORADATA\PROD\TEMP01.DBF’,
‘D:\ORACLE\ORADATA\PROD\TOOLS01.DBF’,
‘D:\ORACLE\ORADATA\PROD\INDX01.DBF’,
‘D:\ORACLE\ORADATA\PROD\UNDOTBS01.DBF’,
‘D:\ORACLE\ORADATA\PROD\SYSAUX01.DBF’
CHARACTER SET WE8ISO8859P1
;

 

then I got the error like this after I run the script in nomount state.

ORA-1503 – Create Controlfile failed
ORA-1192 – Must have at least one enabled thread

 Resolved the issue by

Replace the line like below and try again,

CREATE CONTROLFILE SET DATABASE "PCARD" RESETLOGS FORCE LOGGING NOARCHIVELOG

 

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle backup & recovery. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s