More discussions in SAP MaxDBWhere is place located?
    6 Replies Latest reply: Aug 21, 2007 10:37 AM by Tushar Chavan RSS

    Logon failure  while starting livecache

    Tushar Chavan
    Tushar Chavan Aug 20, 2007 10:06 AM
    Currently Being Moderated

    Hello All,

     

    While starting livecache we are facing problems  for SUPERDBA's login:

     

    lcinit.log file says,

     

                                                    • START ****************************

    liveCache LCF (restart)

    -

    installation path: /sapdb/LCF/db

    operating system : SunOS

    OK State OFFLINE

    Starting LCF into ADMIN

    OK

    OK DBMServer 7.5.0 Build 035-123-123-944

    Starting LCF into ONLINE

    OK

    Creating liveCache application procedures

    ERR

    -24964,ERR_EXECUTE: error in program execution

    768,/sapdb/LCF/db/bin/x_python /sapdb/LCF/db/env/lapps.py -R /sapdb/LCF/db -d LCF -u superdba,*

    Installing APPS

    -

    Traceback----

      File "/sapdb/LCF/db/env/installib.py", line 374, in connectAndInstall

        installRoutine (session, options)

      File "/sapdb/LCF/db/env/lapps.py", line 44, in install

        "APPS"

      File "/sapdb/LCF/db/env/installib.py", line 159, in include

        install (session, options)

      File "/sapdb/LCF/db/env/APPS.py", line 75, in install

        loaderCmd (session, 'USE USER %s %s' % (sapuser[0], sapuser[1]))

    -

    Command----

    USE USER SAPLCD CONTROL

    -

    Error----

    loader.LoaderError: [-25008] Logon failure; previous user's (SUPERDBA) connection was restored.

    ERROR : liveCache LCF not restarted (see /sapdb/data/wrk/LCF/lcinit.log)

     

     

     

    Can somebody help.

     

    Regards,

    Tushar

    • 2036 Views
    • Re: Logon failure  while starting livecache
      Markus Doehr
      Markus Doehr Aug 20, 2007 11:11 AM (in response to Tushar Chavan)
      Currently Being Moderated

      > loader.LoaderError: [-25008] Logon failure; previous

      > user's (SUPERDBA) connection was restored.

      > ERROR : liveCache LCF not restarted (see

      > /sapdb/data/wrk/LCF/lcinit.log)

       

      What do you see in that logfile?

       

       

      --

      Markus

    • Re: Logon failure  while starting livecache
      Tushar Chavan
      Tushar Chavan Aug 20, 2007 12:45 PM (in response to Tushar Chavan)
      Currently Being Moderated

      Hello Markus,

       

      I have attached same file (lcinit.log)

      I tried to restart livecache but got the same error.

       

      <b>loader.LoaderError: [-25008] Logon failure; previous user's (SUPERDBA) connection was restored.</b>

       

      We are facing this error after system copy.Should we check  users or do we need to change password of SUPERDBA.

       

      Thanks in advance.

       

      Regards,

      Tushar

    • Re: Logon failure  while starting livecache
      Tushar Chavan
      Tushar Chavan Aug 20, 2007 1:44 PM (in response to Tushar Chavan)
      Currently Being Moderated

      Hello Markus,

       

      We have not loaded system tables.

      Also we found out that users like SAPSID etc are same of those source system.

       

      DB59 works fine  with users of source system in Integration.

       

      So do you want to delete users and create users on of targer system.(like control,SAPSID,SUPERDBA) or should we use same users  of source system.

      which are appeared on target system due to system copy.

       

       

      Also should we load system tables as:

       

      dbmcli -d SID  -u control,control load_systab -u superdba,<password>

      Thanks in advance

       

       

      Regards,

      Tushar

      • Re: Logon failure  while starting livecache
        Natalia Khlopina
        Natalia Khlopina Aug 20, 2007 7:11 PM (in response to Tushar Chavan)
        Currently Being Moderated

        Hello Tushar,

         

        -> Did you do the Homogenous liveCache copy using backup/restore?

        -> please check which user you set for LCA connection in LC10 -> Integration.

        -> run the SQL statement as superdba user & check if this user is listed:    

                        select * from domain.users                                         

        -> To make sure that the lcinit script works with the correct  Standard liveCache                          

        user then you should run the commands to check the                                

        liveCache user in the upc container:                                                  

        In a dbmcli session (e.g. in LC10 -> liveCache:Monitoring -> Tools)                                                   

        sql_execute user-type=SAP select user from dual                                      

        Should return this user.                                                              

        When an error returns ( unknown user/password ), then no user is set.   

         

        To set the Standard user run:                                                       

        dbmcli -d <SID> -n <LC-server> -u control,<control> user_sap <user>,<pwd>                                                                               

        ( please see the SAP note 616555 for more details ).                                                                               

        This sets the new user in the upc container.                  

        After that the above command should return the user.                                                                               

        Restart the liveCache in the LC10 transaction.                                                                               

        Thank you and best regards, Natalia Khlopina

    • Re: Logon failure  while starting livecache
      Tushar Chavan
      Tushar Chavan Aug 21, 2007 10:37 AM (in response to Tushar Chavan)
      Currently Being Moderated

      Hello Natalia,

       

      Thanks a lot.

      Hats off to you.

       

      We followed  the steps and problem is solved.

       

      Regards,

      Tushar

    Actions