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.
Then I got the error like this after I run the script in nomount state.
Replace the line like below and try again,

CREATE CONTROLFILE SET DATABASE "AZDB" RESETLOGS FORCE LOGGING NOARCHIVELOG
Advertisements

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

%d bloggers like this: