Solved: LOCAL_LISTENER syntex problem error

Former Member · ‎08-28-2007

While installing Java -Add-in on ABAP server (NW 2004s), i'm getting the following error.

i'm getting the problem while implemeting the Central

Instance Java Add-in step. It failed to start the Java Engine. (Pls see

the attachment). When i checked the system on operating system level,

BSN was down. I try to re-start it with Startsap but system was not

able to start the oracle database. As orabsn, i tried to start the

database at sql level (sqlplus "/as sysdba" --> Startup), but it failed

with the following message:

rx2n0v3:orabsn 4> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Aug 28 14:05:39 2007

Connected to an idle instance.

SQL> startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

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

SQL> exit

Disconnected

rx2n0v3:orabsn 5> exit

4. I checked the "spfileBSN.ora" in /oracle/BSN/102_64/dbs

directory and following is the paratmeter that has been mentioned there:

*.local_listener='LISTENER_BSN'

but as oracle is down right now, i'm not able to change this parameter.

Pls let us know how to fix this problem..

Former Member · ‎08-30-2007

Hi,

Add this entry to your tnsnames.ora located at /oracle/SID/102_64/network/admin

LISTENER_<SID>.WORLD =

(ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = <HOST>)(Port = <PORT>))

<SID>: YOUR SID

<HOST>: YOUR DATABASE HOST

<PORT>: YOUR LISTENER PORT

Thanks

Former Member · ‎08-30-2007

Thanks for all answer. I added the following lines at sql level and it fixed our problem....

SQL> ALTER SYSTEM set LOCAL_LISTENER="(address=(protocol=tcp)(host=dbcibsn)(port=1543))" SCOPE=BOTH;

System altered.

Former Member · ‎08-28-2007

Hi

If a network name is specified, check that it corresponds to an entry in TNSNAMES.ORA or other address as configured for your system.

Make sure that the entry is syntactically correct.

Regards

Madhu

LOCAL_LISTENER syntex problem error