Oracle Database Upgrade Dbua Action blocking workaround (Resolve ORA-32004 error)

Operating Environment

1. SUSE11SP3 Operating System

2, Oracle 11.2.0.3 version upgrade to 11.2.0.4 version

Problem phenomenon

Oracle 11.2. Version 0.3 upgrade to 11.2.0.4 version when the Execute Dbua command prompts for the Pfile file when obtaining the Dabase information step, the next operation is not possible and the upgrade is blocked. (Do not operate in their own environment, temporarily none)

Problem analysis

The Oracle start Mount step appears with a hint ora-32004:obsolete or deprecated parameter (s) specified for RDBMS instance error, as previously understood Does not affect the use of Oracle, but is not sure whether the problem is a blocking cause. Check the Alert*.log to see if there is an error at startup.

1. Log in to the ORACLE user and find the alert log log using the Find $ORACLE _base-name "Alert*.log". Empty the log file or use Tail-f Alert*.log

2. Restart Oracle instance (shutdown Immedate;start mount)

3, through the alert log log to see the following message:

Deprecated system parameters with specified values:  remote_os_authent       End of Deprecated system parameter listing

4, according to the hint is not in favor of the parameter value has a default value, using show parameter remote_os_authent view does exist the default value is True

5, using the following SQL to view the actual expiration parameters, the next step is to remove this parameter.

Sql> columnname format A10; SQL> columnvalue format A10; SQL> columnisdefault format A10; SQL> columndescriptio format A10; SQL>SELECTName,value,isdefault,description fromV$parameterWHEREisdeprecated= 'TRUE'  andName='remote_os_authent';

6, view parameter file SPFile, can't directly modify, Sir finished file

(1) To view the parameter file type, there is a value indicating that the SPFile is used

Sql>show parameter SPFile

(2) generate the Pfile file. Description:/home/oracle is the Oracle user home directory. Any path that Oracle can access can be specified.

Create pfile='/home/oracle/pfile.ora' from SPFile;

(3) Open the Pfile.ora file, delete the remote_os_authent parameter in the row

(4) Restart the Oracle instance, open with the Pfile.ora file, regenerate the SPFile file, and then restart Oracle to make the SPFile file effective (note: Because here in the upgrade operation, only boot to mount state, startup Mount).

SQL>shutdown  immedate; SQL> startup mount pfile='/home/oracle/pfile.ora'; SQL>Createfrom  pfile='/home/oracle/ Pfile.ora';

(5) Re-execute the Dbua command to start the operation upgrade, problem resolution, upgrade success.

Problem solving

Refer to the problem analysis step, actually should be ORA-32004 hint will affect Dbua operation, the goal is to solve this ORA-32004 hint.

Other

ORA-32004 information refer to the following, give a clear method of operation, view alert log, from the SPFile or pfile file Delete expiration parameters.

32004,00000, "obsoleteorDeprecated parameter (s) specified for %S Instance "// *Cause:obsoleteorDeprecated parameters forThis instance type//were specifiedinchThe SPFILEorThe PFILE onThe server side.// *Action:see AlertLog  forA list ofparameters that is obsolete// orDeprecated. Remove them fromThe SPFILEorThe server//Side PFILE.

Oracle Database Upgrade Dbua Action blocking workaround (Resolve ORA-32004 error)