cancel
Showing results for 
Search instead for 
Did you mean: 

ORA32004, ORA error during installation

0 Kudos

Hi,

During SAP installation I got below error

SAP 2004S

Oracle 10.2

Oracle installation was done successfully(SID-ANK) during SAP installation I am getting this error....

ERROR 2009-07-09 08:32:28

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.

ERROR 2009-07-09 08:32:28

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2009-07-09 08:32:28

FCO-00011 The step createDatabase with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Doublestack_OneHost|ind|ind|ind|ind|3|0|NW_Cr

eateDB|ind|ind|ind|ind|10|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|in

d|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|c

reateDatabase was executed with status ERROR .

also during starting oracle...via SQL I am getting error

SQL> startup

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

I am not sure if both issues are related to each other.

Just for info..

OracleServiceANK is in start mode

OracleANK102Listener is also in start mode.

Also attaching listener.ora sqlnet.ora and tnsnames.ora

listener.ora

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

  1. Filename......: listener.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#3 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = ANK.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = ANK)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = INLD50057853A)

(PORT = 1521)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = ANK)

(ORACLE_HOME = C:\oracle\ANK\102)

)

)

tnsnames.ora

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

  1. Filename......: tnsnames.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#3 $

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

ANK.WORLD=

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = INLD50057853A)

(PORT = 1521)

)

)

(CONNECT_DATA =

(SID = ANK)

(GLOBAL_NAME = ANK.WORLD)

)

)

sqlnet.ora

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

  1. Filename......: sqlnet.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#3 $

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

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

NAME.DEFAULT_ZONE = WORLD

SQLNET.EXPIRE_TIME = 0

SQLNET.AUTHENTICATION_SERVICES = (NTS)

TCP.NODELAY=YES

Please do let me know if you need more inputs.

Regards,

Ankit Baphna

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Sorry to all,

I replied from my official ID (default set)

Nothing to do just

go <ORACLE_HOME>/dbs/ check init<SID>.ora file if this parameter exists then delete & save.

SQL>startup pfile=<path/init<sid>.ora>

now you can create spfile by

SQL>create spfile from pfile;

Surendra

Former Member
0 Kudos

Hi,

you have assigned some obsolete or deprecated parameter check alert<sid>.log and delete those parameter.

SurendraJain

0 Kudos

Thanks, I can see in alert_ANK.log

Obsolete system parameters with specified values:

enqueue_resources

End of obsolete system parameter listing

How do I remove it now?

Regards,

Ankit Baphna

Edited by: I041468 on Jul 9, 2009 10:10 AM

Former Member
0 Kudos

Can you whether enqueue_resources parameter exist in your system. If yes then try by deleting it.

Thanks,

Sushil

0 Kudos

Thanks so far...

where can I find this parameter list?

Regards,

Ankit Baphna

Former Member
0 Kudos

sqlplus /nolog

connect /as sysdba

show parameter enqueue_resources;

Thanks

Sushil

0 Kudos

thanks

this is what I got...

C:\Documents and Settings\I041468>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 9 14:11:58 2009

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

SQL> conn /as sysdba

Connected.

SQL> show parameter enqueue_resources;

SQL> show parameter enqueue_resources;

SQL>

Any action for me now?

Regards,

Ankit Baphna

Former Member
0 Kudos

Try the following to delete the parameter

sqlplus "/as sysdba"

>shutdown immediate

>startup mount

>alter system set enqueue_resources=''; (the quotes afer resouces= is two single quotes without space.

> create pfile from spfile;

Regards

Anil Verma B

0 Kudos

Hi,

Thanks,

I got this...now

SQL> alter system set enqueue_resources='';

alter system set enqueue_resources=''

*

ERROR at line 1:

ORA-25138: ENQUEUE_RESOURCES initialization parameter has been made obsolete

SQL> create pfile from spfile;

create pfile from spfile

*

ERROR at line 1:

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

SQL> startup

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area 356515840 bytes

Fixed Size 1248984 bytes

Variable Size 188743976 bytes

Database Buffers 163577856 bytes

Redo Buffers 2945024 bytes

ORA-00205: error in identifying control file, check alert log for more info

Regards,

Ankit Baphna

Edited by: I041468 on Jul 9, 2009 10:56 AM

former_member603052
Contributor
0 Kudos

Hi Ankit,

Is your database having SPFILE. first check it out in oracle_home/dbs folder.

Also see that the control file location in the initsid.ora file are different from the actual control file locations.Change those respectively.

Kalyan

rsil_team
Explorer
0 Kudos

Nothing to do just

go <ORACLE_HOME>/dbs/ check init<SID>.ora file if this parameter exists then delete & save.

SQL>startup pfile=<path/init<sid>.ora>

now you can create spfile by

SQL>create spfile from pfile;

Surendra

Former Member
0 Kudos
O/S-Error: (OS 2) The system cannot find the file specified.

Check whether spfile is present in location Drive:\oracle\102\database (win) or

oracle_home/dbs ( Unix)

Thanks

Sushil

Former Member
0 Kudos

Check the profile init.ora in /oracle/<SID>/102_64/dbs

Check to see if the parameter is available there and comment out this parameter with # at the begining of the line. and then in

try searching for the parameter init.ora in other location... i believe during installation SAP places this parameter in a different location and reads it from there.

under unix try searching with the command

>find / -name "init.ora" -print

If you find a file comment out the same entry.

Regards

Anil Verma B

0 Kudos

Aha it worked...

I went to initANK.ora and just put # in front of enqueue_resources parameter.

now my installation is moving ahead...

Thanks a lot guys for your help.

Regards,

Ankit Baphna

Former Member
0 Kudos

Looks like obsolete parameters have been maintained in SPFILE.

check the alert logs under /oracle/<SID>/saptrace/backgroung/alerr_<SID>.log

see if any parameters have been mentioned as obsolete or deprecated.

Logon to sql and remove the parameters

#sqlplus "/as sysdba"

>alter system set <Parameter name>='';

after removing the parameters execute

>create pfile from spfile;

and retry the installation.

Regards

Anil Verma B

Former Member
0 Kudos

Ankit,

Error message: ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.+

Check Note 609430 - Error messages due to obsolete parameters

Note 830576 - Parameter recommendations for Oracle 10g

Hope it helps

Thanks

Sushil