Skip to Content
avatar image
Former Member

SAP & Database not starting

hii all,

when i start as sysdba oracle it generate error

<SQL*Plus: Release 10.2.0.2.0 - Production on Tue Oct 13 11:49:32 2009>

<Copyright (c) 1982, 2005, Oracle. All Rights Reserved.>

<ERROR:>

<ORA-01031: insufficient privileges>

<Enter user-name:>

and when start or stop lestner it say that

<c:\Documents and Settings\Administrator>lsnrctl start>

<LSNRCTL for 64-bit Windows: Version 10.2.0.2.0 - Production on 13-OCT-2009 11:38:21>

<Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting tnslsnr: please wait...

Service OracleDEV102TNSListener already running.

TNS-12560: TNS:protocol adapter error>

<C:\Documents and Settings\Administrator>lsnrctl stop

LSNRCTL for 64-bit Windows: Version 10.2.0.2.0 - Production on 13-OCT-2009 11:52:49

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=devsap)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 61: Unknown error>

C:\Documents and Settings\Administrator>

plz guide

regards

Imran

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    Oct 13, 2009 at 08:59 AM

    Hi imran,

    Pls paste the enviroment varibale which is set to user devadm.

    Also check DBA role is set on OS level for user devadm

    Thanks

    Anil

    Edited by: Anil Bhandary on Oct 13, 2009 11:00 AM

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2009 at 08:20 AM

    Hi imaran,

    You get all this error because you doing all the activity through administrator user id

    <c:\Documents and Settings\*Administrator*>lsnrctl start>

    Try all the activities through sap user SIDADM i.e in your scenario , you have to login in OS with user devadm and carry on the activity ... it should work.

    Thanks

    Anil

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi,

      i login with SIDadm , it is just showing administrator , actually this is SID adm user

      there is some diff. problem that generating the errors

      Best Regards

      Khan

  • Oct 13, 2009 at 09:46 AM

    Hi Imran,

    Login on OS with user devadm & run following command.

    tnsping DEV

    Pls paste the log in form.

    Thanks

    Anil

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2009 at 10:16 AM

    Hi Imram,

    Did you made any changes in system, where after you are getting error ???

    Pls add the parameter as mention my BOSE earlier .

    in file sqlnet.ora which is present in 2 location

    <drive:\ >oracle\DEV\102\NETWORK\ADMIN\sqlnet.ora

    &

    G:\usr\sap\DEV\SYS\profile\oracle\sqlnet.ora

    Both location sqlnet.ora should be in sync

    after syncing both try again.

    Thanks

    Anil

    Edited by: Anil Bhandary on Oct 13, 2009 12:16 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2009 at 10:56 AM

    What happened prior to this error? was the system working before? Did you do some changes to the system?

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2009 at 11:10 AM

    Dear Imran,

    Please refer

    [ Note 480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=480266]

    [Note 441518 - ORA-12560 composite SAP Note|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=441518]

    [Note 175636 - cannot startup Oracle (with no/meaningless error(s))|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=175636]

    When you connect as sysdba with Database, the system checks whether the calling operating system user belongs to ORA_<sid>_DBA operating system group. If so, the user logs on with comprehensive SYSDBA privileges. If not, the system prompts the user to enter a password and then issues ORA-01017 or ORA-01031.

    Make sure that ora_<SID>_dba & ora_<SID>_oper groups are created. and user <SID>adm is a member of both groups and user sapservice<SID> is included in the group ora_<SID>_oper.

    Have you tired to restart the tnslistner service manually ? Is it starting normally ?

    Regards,

    Bhavik G. Shroff

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2009 at 11:50 AM

    Hi Imran,

    Nice to see your that problem resolved.

    For SAP start problem.

    Solution :- Goto sqlplus with sysdba & unlock the scheme user

    sqlplus "/as sysdba"

    sqlplus > alter user SAPSR3 account unlock.

    Thanks

    Anil

    Add comment
    10|10000 characters needed characters exceeded