Problem while database create phase during SAP installation on Oracle 11g

[former_member1166083]

Dear All,

I am currently faced with with Installation error in create database phase;

Logs are attached for your reference.

Problem Summary:

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

Soln attempted :

Soln 1

Database was already shutdown by sapinst tools

a)But still cmd shutdown immediate

b)alter system reset log_archive_start scope=spfile sid='*';

But reported the above problem.

Soln 2

a)Shutdown database

b)Change the parameter in the pfile.

log_archive_start = TRUE                                           ##Inserted parameter

log_archive_dest_1 = 'LOCATION='Your location'         ##Already there

log_archive_dest_state_1 = ENABLE                           ##Inserted parameter

log_archive_format = %d_%t_%s.dbf                          ##Already there

Create spfile from pfile

Tryied to startup database in MOUNT state

but reported the problem

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

Logs attached for reference;

Regards

Asadul Momin

[former_member182307 · Accepted solution]

Hello,

You shoul have a look at your init or spfile.

There mus be a reference to LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST.

This is not compatilble with th user of parameter LOG_ARCHIVE_DEST_1.

What you should do is :

shutdown the database.

move your current spfile tp spfile_old.

you should have an initfile reflecting your spfile in your dbs directory.

remove parameters LOG_ARCHIVE_DEST and/or LOG_ARCHIVE_DUPLEX_DEST from the init file.

create spfile from pfile.

restart the DB.

What you did was removing the "log_archive_start" parameters which is not the problematic one.

Hope this helps.

BR, Steve.

[former_member1166083 · Accepted solution]

Hi Steve,

Your solution took a step forward .

changed spfile to spfile_old

Manually edited pfile to remove the parameter LOG_ARCHIVE_DEST.

LOG_ARCHIVE_DUPLEX_DEST parameter not found.

created spfile from pfile.

But still facing the isse as below,

sql>startup MOUNT,

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started

Fixed Size	....
Variable Size	....
Databse Buffers	....

ORA -00205: error in identifying control file ,

check alert log for more info.

But I dont find alert<SID>.log generated.

Attaching the pfile for your reference.

Note: I changed the pfile in "database" directory as it is in Windows environment

Regards

Asadul Momin

initID9.ora.zip

[former_member182307 · Accepted solution]

Hello,

This is strange, there should be an alert_SID.log file somewhere in /oracle/SID/saptrace/diag/rdbms/SID/SID/trace ( i let you translate on your windows system file tree) .

This is the new place where the alert log is placed in 11G.

In this alert log file , the missing control_file should be specified.

You 'll then have 2 choices : wether starting the db without using the failing control_file (by altering the control_file database parameter ) , or restoring the failing control_file.

Best regards,

Steve.

[former_member1166083 · Accepted solution]

Dear Steve,

The Create Database phase is successfully done.

sapinst tool took care of it.

Thanks

Asadul Momin

[former_member182034]

hi Asad,

For ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

SQL>alter system reset log_archive_start scope=spfile sid='*';

shutdown and startup

Regards,

[former_member1166083]

As ORACLE instance is not avaiable ,I cannot alter /see any parameter.

I faced the issue during create database phase.

Steve SOUMAH solution took me a little forward,but still pawning on the issue.

Regards,

Asad

[former_member182034]

hi Asad,

would you past the Ora error which you are getting during Create Database Phase?

Regards,