Skip to Content
author's profile photo Former Member
Former Member

Unable to Start SAP

Hi,

I get a following message when i try to start SAP using STARTSAP.

maltr35:sbdadm 16> startsap

Checking SBD Database

-


ABAP Database is not available via R3trans

Checking SBD Database

-


Starting SAP-Collector Daemon

-


***********************************************************************

  • This is Saposcol Version COLL 20.94 640 - AIX v10.35 5L-64 bit 070216

  • Usage: saposcol -l: Start OS Collector

  • saposcol -k: Stop OS Collector

  • saposcol -d: OS Collector Dialog Mode

  • saposcol -s: OS Collector Status

  • The OS Collector (PID 4448328) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/SBD/SYS/exe/run/startdb

Trying to start SBD database ...

Log file: /home/sbdadm/startdb.log

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

DB startup failed

The STARTDB.LOG states that the DATABASE is already OPEN with error code 0012.

<b>I tried to start the oracle manually and tried starting sap using startsap R3. then it gives me the following error. </b>

maltr35:sbdadm 15> startsap R3

Checking SBD Database

-


ABAP Database is not available via R3trans

Checking SBD Database

-


Starting SAP-Collector Daemon

-


***********************************************************************

  • This is Saposcol Version COLL 20.94 640 - AIX v10.35 5L-64 bit 070216

  • Usage: saposcol -l: Start OS Collector

  • saposcol -k: Stop OS Collector

  • saposcol -d: OS Collector Dialog Mode

  • saposcol -s: OS Collector Status

  • The OS Collector (PID 4448328) is already running .....

************************************************************************

saposcol already running

Database SBD must be started first

ALSO STARTED THE LISTERNER AND STARTED THE DATABASE AND TRIED STARTING SAP STILL IT FAILS WITH THE FIRST ERROR MESSAGE MENTIONED ABOVE, KINDLY LET ME KNOW WHAT SHOULD BE DONE.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2007 at 02:31 PM

    your DB is not starting. /usr/sap/SBD/SYS/exe/run/startdb: Terminating with error code 12

    DB startup failed

    could you please paste db log? (startsap_<hostname>_<system no>.log

    Cheers,

    -Sunil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2007 at 04:23 PM

    Hello again

    It looks like either the ORA_NLS33 or NLS_LANG environnement vars are not correct or not set. Do you have another system to compare them?

    Regards

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2007 at 05:19 PM

    Hello Naresh,

    It is just enough if you change the envoirnment variable for <sid>adm, because all workprocesses and startsap are running from <sid>adm user.

    Regards,

    Madhukar

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Madukar,

      May I know that is this your new installed system ?

      Because the OCI connection failed will be occured due to following two reasons:

      1. your DB client binaries permission is not ok.....

      2. your OPS$ mechanism is not working properly...

      Please check both and can you can send me the R3trans -x log ( trans.log in the working directory ) ?

      Thanks

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2007 at 06:00 PM

    Hi,

    Sorry, I may not be very clear enough in last reply.

    I meant, ORA_NLS33 need not point to oracle client software directory in ora<sid>. And the above error (startsap) is mainly because of some issues in ORA_NLS33 in <sid>adm.

    In ORA<SID> it should point to $ORACLE_HOME/ocommon/nls/admin/data and not to the client software.

    Regards,

    Madhukar

    Message was edited by:

    Madhukara Shenoy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Naresh

      I was reviewing your trans.log:

      4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 54 0.004694

      4 ETW000 [dev trc ,00000] got NLS_LANG=<b>'AMERICAN_AMERICA.WE8DEC'</b> from environment

      4 ETW00030 0.004724

      4 ETW000 [dev trc ,00000] Client NLS settings: <b>AMERICAN_AMERICA.US7ASCII</b> 1412 0.006136

      Again SAP note 592657:

      NLS_LANG contains a value that depends on the database code page. This can be set in a running database using

      SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

      NLS_LANG must then be set to

      NLS_LANG = AMERICAN_AMERICA.<codepage>

      Also check this variable for possible typing errors.

      Regards

      Michael

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2007 at 01:14 PM

    Hello Naresh,

    Did you check the all the points from the SAP note 592657 (which i mentioned in some replies) .

    Even if the problem occurs after this (make sure permission and authorization is correct), then the reason could be some files are corrupted / missing from the client directory. So you can try for re-installation of client.

    Anyways, can attach the latest trans.log generated by the R3trans -d

    Regards,

    Madhukar

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Madhukar,

      I have fixed the problem by changing environmental variable NLS_33 of <SID>adm with ORA<sid> and that has worked, but i guess that is the temporary fix as the client software might me corrupted and i need to reinstall it. Thanks for u time and patience to answer the question.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.