6 Replies Latest reply: Aug 21, 2007 10:37 AM by Tushar Chavan RSS

Logon failure  while starting livecache

Tushar Chavan
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

  • Re: Logon failure  while starting livecache
    Markus Doehr
    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
    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
    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
      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
    Currently Being Moderated

    Hello Natalia,

     

    Thanks a lot.

    Hats off to you.

     

    We followed  the steps and problem is solved.

     

    Regards,

    Tushar

Actions