on 07-09-2009 6:57 AM
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
################
Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $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
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $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
################
Filename......: sqlnet.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $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
Hi,
you have assigned some obsolete or deprecated parameter check alert<sid>.log and delete those parameter.
SurendraJain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
78 | |
10 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.