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

[Former Member]

Hi Experts,

I have installed SAP solution manager 7.0 with ehp1 and database 11G2 with OS suse-linux 11.

Installation completed successfully.After stopping the application and database i took a OS reboot.

Now i am not able to start the database.

Error:

orapis> sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 3 12:55:39 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

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

ORA-27072: File I/O error

Linux-x86_64 Error: 22: Invalid argument

Additional information: 4

Additional information: 1

Additional information: -1

also No alert log file is generated in location /oracle/SID/saptrace/background

Pfile:

###########################################################

1. (c)Copyright SAP AG, Walldorf #

2. @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/INITSIDBASE.ORA#2 $

###########################################################

shared_pool_size = 1094807715

open_cursors = 2000

1. processes = ABAP-Workprozesse * 2 + J2EE-Serverprozesse *

2. <max-connections> + PARALLEL_MAX_SERVERS + 40

processes = 80

1. session = 2 * processes

sessions = 160

db_name = PIS

db_block_size = 8192

remote_os_authent = true

1. retention time for RMAN backup information in control file

control_file_record_keep_time = 30

log_checkpoints_to_alert = true

compatible = 11.2.0

parallel_execution_message_size = 16384

query_rewrite_enabled = false

replication_dependency_tracking = false

star_transformation_enabled = true

log_archive_dest_1 = 'LOCATION=/oracle/PIS/oraarch/PISarch'

log_archive_format = %t_%s_%r.dbf

undo_tablespace = PSAPUNDO

pga_aggregate_target = 1459743621

db_cache_size = 1094807715

remote_login_passwordfile = exclusive

recyclebin = off

FILESYSTEMIO_OPTIONS = setall

diagnostic_dest = /oracle/PIS/saptrace

audit_file_dest = /oracle/PIS/saptrace/audit

OPTIMPEEK_USER_BINDS = FALSE

OPTIMIZERMJC_ENABLED = FALSE

BTREE_BITMAP_PLANS = FALSE

INDEXJOIN_ENABLED = FALSE

INMEMORY_UNDO = FALSE

SORTELIMINATION_COST_RATIO = 10

TABLELOOKUP_PREFETCH_SIZE = 0

db_recovery_file_dest = /oracle/PIS/oraflash

db_recovery_file_dest_size = 30000M

max_dump_file_size = 20000

parallel_threads_per_cpu = 1

control_files = (/oracle/PIS/origlogA/cntrl/cntrlPIS.dbf, /oracle/PIS/origlogB/cntrl/cntrlPIS.dbf, /oracle/PIS/sapdata1/cntrl/cntrlPIS.dbf)

Please help me solve this issue.

Thanks,

Hari

[Former Member · Accepted solution]

Dear Hari,

ora 32004 can be ignored with 11g, it's because of the 'remote_os_authent = true' parameter, but don't touch this.

Maybe problem is the I/O error. Take a look at snote 914177.

Kind regards,

Gerd

Edited by: Gerd Kirchner on Jun 3, 2011 10:15 AM

[Former Member · Accepted solution]

Thanks Gerd.

I will check for I/o error.