What is the Database Initialization Parameter That is Associated to an ORA-32004 Error ?
APPLIES TO:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 24-Jan-2012***
GOAL
How to know which parameter is obsolete and/or deprecated when the only message on screen when
attempting to start a database is "ORA-32004: obsolete and/or deprecated parameter(s) specified" ?
SOLUTION
1. Look at the DBA's alert log of the associated instance as newer versions of the RDBMS software will identify the parameters that are obsolete and/or deprecated within the alert log at the time that an instance startup is initiated.
2. If the alert log is not available or does not identify the obsolete or deprecated parameter and the database is accessible then check to see that none of the parameters in the parameter initialization file match a parameter name stored in the V$OBSOLETE_PARAMETER view of that same database.
Especially review any parameter where V$OBSOLETE_PARAMETER.ISSPECIFIED='TRUE'.
If there is a match, then it is an obsolete parameter.
3. If the alert log is not available or does not identify the obsolete or deprecated parameter then check to see that none of the parameters in the parameter initialization file match a parameter name listed within the migration guide's list of deprecated parameters or it's list of obsolete parameters.
相关文章
- IUS database
- ERROR: Could not connect to lockdownd, error code -19 -20
- ERROR: Error loading ASGI app. Could not import module "main".
- MS SQL Could not obtain information about Windows NT group/user 'domainlogin', error code 0x5. [SQLSTATE 42000] (Error 15404)
- Loadrunner执行https报错Action.c(7): Error -27778: SSL protocol error when attempting to connect with hos
- [Node.js] Use Realm Object Database with Node.js
- ERROR: Upgrade faifailed bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
- Database Crash With ORA-27063 and OS Error: 5: I/O Error
- [AWS Design Cost-Optimized Architectures] 4.2 Identify cost-effective compute and database services
- [ERROR]java.lang.NullPointerException while starting TM1 10.1.1 Database Server
- 在 Google Kubernetes Cluster 上使用 HANA Expression Database Service
- 成功解决pandas.errors.ParserError: Error tokenizing data. C error: Expected 1 fields in line 48, saw 2
- Py之Database:Python和数据库的那些嘻嘻哈哈事详细攻略
- 关于appium踩坑 :Encountered internal error running command: Error: Cannot verify the signature of (已解决)
- Error pulling origin: error: The following untracked working tree files would be overwritten by...
- ERROR Fatal error during KafkaServer startup. Prepare to shutdown (kafka.server.KafkaServer)
- Which Tasks will be follow by Database Adminstrator
- SQL and Database Systems 基本知识
- 【Bug记录】Error:Internal error: (java.lang.IllegalAccessError) class com.intellij.util.io
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server