oracle<sid>102isql service not working

[Former Member]

Hi,

oracle<sid>102isql is not in start status, when i try to start it i got below message.

the above service could not start local services and error:1067 the process terminated unexpectedly.

iam not able to connect the SAP for this reason.Please advice.

Regards,

Asif

[markus_doehr2 · Accepted solution]

> oracle<sid>102isql is not in start status, when i try to start it i got below message.

> the above service could not start local services and error:1067 the process terminated unexpectedly.

> iam not able to connect the SAP for this reason.Please advice.

isql is not used in the SAP environment so that is surely not the reason why you are "not able to connect to SAP".

Is the database up and running? Can you start it manually?

Markus

[Former Member]

Dear,

check the listner status and start listner (go to cmd) than try start your service for oracle.

vinod

[Former Member]

Hi,

Check the DB and Listener is UP or not.. If it OK and still you are facing database connection problem then check the TNS entry in tnsnames.ora file is correcty given or not. The host, port and SID of TNS entry should match with Listener Host, Port and SID.

Check the Listener status using the command

lsnrctl status

Check the TNSping using Command

tnsping <DB TNS entry name>

Then check SAP is able to connect the DB using command

R3trans -d

if it give the return code 0, then SAP will be able to connect DB.

Thanks

Manoj

[Former Member]

Asif,

First check DB. Whether it is up or down, then check listner service. SAP wont connect to DB if Listener is down.

Thanks

Sushil