Skip to content
Home » Oracle Database » How to Resolve PRCD-1066 : Invalid start option

How to Resolve PRCD-1066 : Invalid start option

PRCD-1066

Tried to startup a RAC database with a start option by SRVCTL, or modify the default start option of a RAC database by SRVCTL, we saw error PRCD-1066.

srvctl start database

[oracle@primary01 ~]$ srvctl start database -d orclcdb -o "open read only"
PRCD-1066 : Invalid start option open read only
[oracle@primary01 ~]$ echo $?
1

PRCD-1066 means that you used an invalid value to be the startup option for the RAC database, which is not allowable.

To startup a RAC database, we should use one of the following valid values to be the start option.

  • NOMOUNT
  • MOUNT
  • OPEN
  • RESTRICT
  • READ ONLY
  • READ WRITE

For the last two items, don't forget to use double quotes to mark multi-word.

In this case, we should use "READ ONLY" to start the database.

[oracle@primary01 ~]$ srvctl start database -d orclcdb -s "read only"
[oracle@primary01 ~]$ echo $?
0

srvctl modify database

Same error PRCD-1066 can also be seen in modifying the default start option of a RAC database.

[oracle@primary01 ~]$ srvctl modify database -d orclcdb -s "open read only"
PRCD-1066 : Invalid start option open read only
[oracle@primary01 ~]$ echo $?
1

In this case, we should use "READ ONLY" to set the default start option.

[oracle@primary01 ~]$ srvctl modify database -d orclcdb -s "read only"
[oracle@primary01 ~]$ echo $?
0

Please note that, the startup option RESTRICT is also a valid start options of SRVCTL, which is not documented in Oracle.

Leave a Reply

Your email address will not be published. Required fields are marked *