Skip to Content
avatar image
Former Member

When trying to start sap with startsap command

We are doing new installation.After patching ORACLE 10 G ,the problem is coming .

Oracle is running fine but when we are trying to start SAP with STARTSAP getting following error.

-


sd2n1v5:yc5adm> startsap

Checking YC5 Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


13:49:11 23.09.2007 LOG: Effective User Id is root

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

  • This is Saposcol Version COLL 20.89 700 - v2.02 for HP-UX - 24.1.2006

  • 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 2777) is already running .....

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

saposcol already running

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

Trying to start YC5 database ...

Log file: /home/yc5adm/startdb.log

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

DB startup failed

sd2n1v5:yc5adm>

-


trans.logf file.

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x6000000001071cb8,srvhp=0x6000000001073fc8,usrhp=0x6000000001061e28)

4 ETW000 48 0.404349

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000

4 ETW000 3135 0.407484

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x6000000001073fc8)

4 ETW000 45 0.407529

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x6000000001071cb8,srvhp=0x6000000001073fc8)

4 ETW000 47 0.407576

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x6000000001073fc8

4 ETW000 745 0.408321

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28000'

4 ETW000 151 0.408472

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 28000 performing CON [dblink#3 @ 431]

4 ETW000 452 0.408924

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28000: the account is locked [dblink#3 @ 431]

4 ETW000 46 0.408970

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'YC5'"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 24, 2007 at 12:49 PM

    below trans.log error ,after I did what you told in the earlier reply

    -


    ERROR => ORA-942 when accessing table SAPUSER

    LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]

    SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

    no rows selected

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Can you login on the database with SAP DB User /pw?

      sqlplus /nolog

      connect sap<sid>/pw ( or sapr3/pw)

      If not, you should change the password for the SAP Database user with BR*Tools.

      e.g. like that

      brconnect -u system/pw -f chpass -o sap<SID> (or SAP DB User. e.g SAPR3) -p <new password)

      and try again.

      Which OPS$ Users do you have? If you don't OPS$ Users, you should create them.

      select username from dba_users where username like '%OPS%'

      You can create SAPUSER Table according to the SAP Note.

      400241 - Problems with ops$ or sapr3 connect to Oracle

      On UNIX you get the following result, if the table SAPUSER exists.

      SQL> select table_name, owner from dba_tables where table_name like '%SAPUSER%';

      TABLE_NAME OWNER

      -


      -


      SAPUSER OPS$<SID>ADM

      Best regards>

  • avatar image
    Former Member
    Sep 23, 2007 at 12:17 PM

    hi,

    I think the error is clear:<br>

    <br>

    ORA-28000: the account is locked http://i66.photobucket.com/albums/h276/DianneOnly/blink.gif" alt="Blinking" />

    <br>

    Check the account status ( should be SAP<DBSID> ) an unlock it.

    <br>

    Afterwards, run R3trans -x and check the trans.log.

    You should not get the same error but I think you will get an ora-1017.<br>

    I think you have changed the default password for SAP<DBSID> using sqlplus instead of BRCONNECT

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2007 at 12:44 PM

    When try to execute ,getting following error

    SQL> alter user sapyc5 account unlock ;

    alter user sapyc5 account unlock

    *

    ERROR at line 1:

    ORA-01918: user 'SAPYC5' does not exist

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Then your user is not <b>sapyc5</b>

      on the trans.log it is indicated the user SAP tries to connect to.

      It is also on the environment variable dbs_ora_schema

      check that user

  • avatar image
    Former Member
    Sep 24, 2007 at 06:07 AM

    I am trying right now and update ,what is the result.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2007 at 01:36 PM

    You are right the user is SAPSR3 .I have unlocak the user and after that I execute R3trans -k and got the following information.

    -


    sd2n1v5:yc5adm> R3trans -x

    This is R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

    unicode enabled version

    2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'YC5'"

    R3trans finished (0012).

    -


    trans.log file error.

    -


    4 ETW000 [dev trc ,00000] Now '/@YC5' is connected (con_hdl 0, nls_hdl 0).

    4 ETW000 1586 0.416081

    4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-942 when accessing table SAPUSER

    4 ETW000 1736 0.417817

    4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 133 0.417950

    4 ETW000 [dev trc ,00000] Rolling back transaction ... 66 0.418016

    4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x6000000001071cb8,usrhp=0x6000000001061e28)

    4 ETW000 216 0.418232

    4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 593 0.418825

    4 ETW000 [dev trc ,00000] Try to connect with default password 34 0.418859

    4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@YC5 on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

    4 ETW000 47 0.418906

    4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

    4 ETW000 49 0.418955

    4 ETW000 [dev trc ,00000] 0 UTF8 1 0x6000000001059ce0 0x6000000001061610 0x6000000001071d88

    4 ETW000 49 0.419004

    4 ETW000 [dev trc ,00000] Assigning username to user session 0x6000000001061e28

    4 ETW000 43 0.419047

    4 ETW000 [dev trc ,00000] Assigning password to user session 0x6000000001061e28

    4 ETW000 53 0.419100

    4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x6000000001071cb8,srvhp=0x6000000001073fc8,usrhp=0x6000000001061e28)

    4 ETW000 48 0.419148

    4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

    4 ETW000 5456 0.424604

    4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

    4 ETW000 46 0.424650

    4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 431]

    4 ETW000 439 0.425089

    4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]

    4 ETW000 45 0.425134

    2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'YC5'"

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I'm pretty sure this is answered on the forum a couple of times ( or more )

      You have changed the default password for the user SAPSR3 at database level ( ORA-01017 ) without enabling first the OPS$ mechanism ( ORA-942 when accessing table SAPUSER )

      so, I did a little search on the SAP Notes ( it only takes a couple of minutes ) and Iget only 4 results back:

      662644 Composite SAP Note: ORA-00942

      400241 Problems with ops$ or sapr3 connect to Oracle

      623242 ORA-1017 opening a secondary link

      700548 FAQ: Oracle authorizations

      Except the 3rd one, the other 3 are relevant for your exact problem.

      The soultion is:

      1 - Use the search functionality in SAP Service Marketplace

      2 - Use the search functionality in SAP developer Network

      3 - Read the mentioned notes and apply the solution indicated on the note 400241

  • avatar image
    Former Member
    Sep 24, 2007 at 02:19 PM

    Thanks a lot.

    I only change SAPSR3 password ,remaining things will do one by one.

    I have some other problem how I will I put that ,in this message or new one.If it is a new message please pick up .

    Thanks once again.

    Add comment
    10|10000 characters needed characters exceeded