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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.