Fix ORA-01504: database name 'RESTRICT' does not match parameter db_name 'DBNAME'

Error Description
startup mount restrict; command failed with following error message

SQL> startup mount restrict;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.


Total System Global Area 4026531840 bytes
Fixed Size                  4504720 bytes
Variable Size            2197816176 bytes
Database Buffers         1811939328 bytes
Redo Buffers               12271616 bytes
ORA-01504: database name 'RESTRICT' does not match parameter db_name
'ONLPROD'

Solution Description
To fix this issue you have to nomount the database with restrict option first and then mount the database.
SQL> shut immediate;
ORA-01507: database not mounted 

ORACLE instance shut down.

SQL> startup nomount restrict
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4026531840 bytes
Fixed Size                  4504720 bytes
Variable Size            2197816176 bytes
Database Buffers         1811939328 bytes
Redo Buffers               12271616 bytes
SQL> alter database mount;

Database altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics

and Real Application Testing options
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google