ORA-32004 obsolete or deprecated parameter specified for RDBMS instance

[Former Member]

Hi, i have error try apply comand startsap in the SAP system. the database only start with tools sqlplus.

this log the startsap:

SQL*Plus: Release 11.2.0.3.0 Production on Sun Apr 1 03:41:38 2012

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

Connected to an idle instance.

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

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_SMP'

Disconnected

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

*** ERROR: Startup of database failed

    Notify Database Administrator.

/usr/sap/SMP/SYS/exe/run/startdb: Terminating with error code 12

Best Regards,

EDRS

[Former Member · Accepted solution]

Hi, I solved problem apply the command:

alter system reset local_listener scope=spfile sid='*';

Regards,

Eli Daniel

[francois_keen · Accepted solution]

Hi Eli

actually there is no need to reset the local_listener parameter, the solution is to add

LISTENER_<DBSSID>.WORLD = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = <hostname>)(PORT = <listener_port>))

in the listener.ora in the TNS_ADMIN directory.

Cf.  step 5.14 of the UX ORA 11203 upgrade guide

Thanks

Francois