STARTUP RESTRICTED problem in OEM Jobs
530389Nov 1 2006 — edited Nov 2 2006Under the "Jobs" tab in OEM 10.2 I created a new job to shutdown a DB and start it in "restricted mode".
To add the "Startup Restrict" step, I selected the Task Type "Startup Database". On the parameters tab for that task I have "Startup mode" as "Open the database", and under "Other Startup Options" I have checked "Restrict access to database".
However, when I run the job, I receive the following error:
=========================
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 105911712 bytes
Fixed Size 456096 bytes
Variable Size 54525952 bytes
Database Buffers 50331648 bytes
Redo Buffers 598016 bytes
ORA-01504: database name 'RESTRICTED' does not match parameter db_name 'MYDB'
=========================
If I uncheck "Restrict access to database" I don't get this error and the job completes successfully.