 |
|
ORA-00306: limit of string instances in this database tips
Oracle Error Tips by Burleson Consulting
|
The Oracle docs note this on the
ora-00306 error:
- ORA-00306: limit of
string instances in this database
-
-
Cause: Starting this instance would exceed the
maximum number of instances allowed for this database. This
message occurs only with STARTUP shared and multiple
instances.
-
Action: You cannot start more than the lower of a)
port-specific limit as to the number of instances b) the
number of instances specified at create-database time
For further explanation, ORA-00306 is caused when upon
beginning an instance, the process would exceed full number of allowed instances
for the database.
- ORA-00306 intervenes only when instance is being attempted in Parallel
Server mode or with STARTUP numerous instances.
- If you cannot generate more than the present number of instances,
ORA-00306 will show.
To avoid ORA-00306 remember, you
cannot begin more than the lesser of either:
- the limit of the maximum of instances per operating system OR
- the specific maximum of
MAXINSTANCES
option shown in the CREATE DATABASE
expression
