Skip to Content

i have restore my db2 restore use bellow command

db2 restore db QAS taken at 20130926003617.

after that ,i can’t start sap.

prddb:db2qas 94> db2start

10/14/2013 15:02:19     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.

prddb:db2qas 94> db2start

10/14/2013 15:02:19     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.

prddb:qasadm 56> startsap
Checking db6 Database
Database is not available via R3trans
——————————————-
10/14/2013 15:02:35     0   0   SQL1026N  The database manager is already active.
SQL1026N  The database manager is already active.
Activate database failed
R3trans connect failed
DB startup failed

please send the tracefile /home/qasadm/startsap.trc to support

who can help me?

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

    1. jitendra singh

      Dear Frank,

      i have facing the same issue

      Please find the trans.log file.

      Trace of system startup/check of SAP System ECP on Wed Nov  5 10:39:43 IST 2014

      {10:39:43 ## Main() start: @=/usr/sap/ECP/SYS/exe/run/startsap
      @(#) $Id: //bas/721_REL/src/krn/startscripts/startsap#4 $
      BASENAME=startsap

      {10:39:43 ## check_user() start: @=ecpadm
      }10:39:43 ## check_user() done

      #=0
      @=

      {10:39:43 ## setPlatform() start
        PLATFORM=rs6000_64
      }10:39:43 ## setPlatform() done

      {10:39:43 ## setPing() start
        PING=/usr/sbin/ping
      }10:39:43 ## setPing() done

      {10:39:43 ## setIfconfig() start
        IFCONFIG=
      }10:39:43 ## setIfconfig() done

      {10:39:43 ## setRootDir() start: @=
        USR_SAP=/usr/sap
        USR_SAP_SID=/usr/sap/ECP
        PROFILE_DIR=/usr/sap/ECP/SYS/profile
        DIR_LIBRARY=/usr/sap/ECP/SYS/exe/run
      }10:39:43 ## setRootDir() done

      {10:39:43 ## setDbUser() start: @=
      }10:39:43 ## setDbUser() done

      {10:39:43 ## setVHostArray() start
        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx /usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx.backup /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.1 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.2 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.3 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.4 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.5 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.6 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.7 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.8 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.BAK /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.backup
        _nrProfiles=13

        {10:39:43 ## pushVHostsFromProfile() start: @=/usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx /usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx.backup /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.1 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.2 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.3 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.4 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.5 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.6 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.7 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.8 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.BAK /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.backup
         _DUMMY=ECP_ASCS00_wwgeccsbx
         _VHOST=wwgeccsbx

         {10:39:43 ## isVHostLocal() start: wwgeccsbx
          VHOST=wwgeccsbx
          _IS_LOCAL=1
         }10:39:43 ## isVHostLocal() done: 1

         _DUMMY=ECP_ASCS00_wwgeccsbx.backup
         _VHOST=wwgeccsbx.backup

         {10:39:43 ## isVHostLocal() start: wwgeccsbx.backup
          VHOST=wwgeccsbx.backup
          _IS_LOCAL=0
         }10:39:43 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx
         _VHOST=wwgeccsbx

         {10:39:43 ## isVHostLocal() start: wwgeccsbx
          VHOST=wwgeccsbx
          _IS_LOCAL=1
         }10:39:43 ## isVHostLocal() done: 1

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.1
         _VHOST=wwgeccsbx.1

         {10:39:43 ## isVHostLocal() start: wwgeccsbx.1
          VHOST=wwgeccsbx.1
          _IS_LOCAL=0
         }10:39:43 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.2
         _VHOST=wwgeccsbx.2

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.2
          VHOST=wwgeccsbx.2
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.3
         _VHOST=wwgeccsbx.3

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.3
          VHOST=wwgeccsbx.3
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.4
         _VHOST=wwgeccsbx.4

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.4
          VHOST=wwgeccsbx.4
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.5
         _VHOST=wwgeccsbx.5

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.5
          VHOST=wwgeccsbx.5
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.6
         _VHOST=wwgeccsbx.6

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.6
          VHOST=wwgeccsbx.6
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.7
         _VHOST=wwgeccsbx.7

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.7
          VHOST=wwgeccsbx.7
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.8
         _VHOST=wwgeccsbx.8

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.8
          VHOST=wwgeccsbx.8
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.BAK
         _VHOST=wwgeccsbx.BAK

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.BAK
          VHOST=wwgeccsbx.BAK
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         _DUMMY=ECP_DVEBMGS01_wwgeccsbx.backup
         _VHOST=wwgeccsbx.backup

         {10:39:44 ## isVHostLocal() start: wwgeccsbx.backup
          VHOST=wwgeccsbx.backup
          _IS_LOCAL=0
         }10:39:44 ## isVHostLocal() done: 0

         VHOSTS= wwgeccsbx
        }10:39:44 ## pushVHostsFromProfile() done

        VHOSTS= wwgeccsbx
      }10:39:44 ## setVHostArray() done

      {10:39:44 ## set_instance() start
        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_SCS??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=SCS

        {10:39:45 ## pushProfiles() start: @=SCS /usr/sap/ECP/SYS/profile/ECP_SCS??_wwgeccsbx
         _TEMPINST=SCS??
        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=ASCS

        {10:39:45 ## pushProfiles() start: @=ASCS /usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx
         _TEMPINST=ASCS00

         {10:39:45 ## setInstanceDo() start: @=ASCS00 /usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx:
          setInstanceDo: INSTascs=ASCS00:
          setInstanceDo: PROFILEascs=/usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx:
          setInstanceDo: INST=ASCS00:
          setInstanceDo: INSTFOUND=1:
         }10:39:45 ## setInstanceDo() done: 1:

        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_ERS??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=ERS

        {10:39:45 ## pushProfiles() start: @=ERS /usr/sap/ECP/SYS/profile/ECP_ERS??_wwgeccsbx
         _TEMPINST=ERS??
        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_SMDA??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=SMDA

        {10:39:45 ## pushProfiles() start: @=SMDA /usr/sap/ECP/SYS/profile/ECP_SMDA??_wwgeccsbx
         _TEMPINST=SMDA??
        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=D?*

        {10:39:45 ## pushProfiles() start: @=D?* /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx
         _TEMPINST=DVEBMGS01

         {10:39:45 ## setInstanceDo() start: @=DVEBMGS01 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx:
          setInstanceDo: INSTdvebmgs=DVEBMGS01:
          setInstanceDo: PROFILEdvebmgs=/usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx:
          setInstanceDo: INST=DVEBMGS01:
          setInstanceDo: INSTFOUND=2:
         }10:39:45 ## setInstanceDo() done: 2:

        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_JC??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=JC

        {10:39:45 ## pushProfiles() start: @=JC /usr/sap/ECP/SYS/profile/ECP_JC??_wwgeccsbx
         _TEMPINST=JC??
        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_D??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=D

        {10:39:45 ## pushProfiles() start: @=D /usr/sap/ECP/SYS/profile/ECP_D??_wwgeccsbx
         _TEMPINST=D??
        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_J??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=J

        {10:39:45 ## pushProfiles() start: @=J /usr/sap/ECP/SYS/profile/ECP_J??_wwgeccsbx
         _TEMPINST=J??
        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_JMS??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=JMS

        {10:39:45 ## pushProfiles() start: @=JMS /usr/sap/ECP/SYS/profile/ECP_JMS??_wwgeccsbx
         _TEMPINST=JMS??
        }10:39:45 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_G??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=G

        {10:39:46 ## pushProfiles() start: @=G /usr/sap/ECP/SYS/profile/ECP_G??_wwgeccsbx
         _TEMPINST=G??
        }10:39:46 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_TRX??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=TRX

        {10:39:46 ## pushProfiles() start: @=TRX /usr/sap/ECP/SYS/profile/ECP_TRX??_wwgeccsbx
         _TEMPINST=TRX??
        }10:39:46 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_W??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=W

        {10:39:46 ## pushProfiles() start: @=W /usr/sap/ECP/SYS/profile/ECP_W??_wwgeccsbx
         _TEMPINST=W??
        }10:39:46 ## pushProfiles() done

        _PROFILES=/usr/sap/ECP/SYS/profile/ECP_V??_wwgeccsbx
        _nrProfiles=1
        _Iset_instance=V

        {10:39:46 ## pushProfiles() start: @=V /usr/sap/ECP/SYS/profile/ECP_V??_wwgeccsbx
         _TEMPINST=V??
        }10:39:46 ## pushProfiles() done

        NINST=
        INSTFOUND=2
        NINSTFOUND=0
        hasABAP=1
        hasJava=0
        hasSpecial=1
      }10:39:46 ## set_instance() done

      {10:39:46 ## prepare() start

        {10:39:46 ## set_sapdbhost() start
         _PROFILE=/usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx
         SAPDBHOST=wwgeccsbx
        }10:39:46 ## set_sapdbhost() done

        {10:39:46 ## set_db_local() start
         VHOST=wwgeccsbx
         set_dblocal: _DB_LOCAL=1
         SAPDBHOST=wwgeccsbx
        }10:39:46 ## set_db_local() done: 1

        {10:39:46 ## set_db_sid() start: @=1
         DB_SID=db6
        }10:39:46 ## set_db_sid() done

        {10:39:46 ## set_db_running() start
         Checking db6 Database

         {10:39:46 ## getExePath() start: @=R3trans DVEBMGS01

          {10:39:46 ## set_path() start: @=/usr/sap/ECP/DVEBMGS01/exe
           N_PATH=/usr/sap/ECP/DVEBMGS01/exe
           LIBPATH=/usr/sap/ECP/DVEBMGS01/exe:/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
           O_LIBPATH=/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
          }10:39:46 ## set_path() done

          _DIR_EXECUTABLE=/usr/sap/ECP/DVEBMGS01/exe

          {10:39:46 ## restore_path() start
           LIBPATH=/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
          }10:39:46 ## restore_path() done

          EXEDIR=/usr/sap/ECP/DVEBMGS01/exe
          EXECMD=/usr/sap/ECP/DVEBMGS01/exe/R3trans
         }10:39:46 ## getExePath() done: 0

         DBCONNECT_TEST=/usr/sap/ECP/DVEBMGS01/exe/R3trans -d -w

         {10:39:46 ## set_path() start: @=/usr/sap/ECP/DVEBMGS01/exe
          N_PATH=/usr/sap/ECP/DVEBMGS01/exe
          LIBPATH=/usr/sap/ECP/DVEBMGS01/exe:/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
          O_LIBPATH=/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
         }10:39:46 ## set_path() done

         {10:39:53 ## restore_path() start
          LIBPATH=/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
         }10:39:53 ## restore_path() done

         Database is not available via R3trans
         DB_RUNNING=0
         JDB_RUNNING=
        }10:39:53 ## set_db_running() done: 0

        {10:39:53 ## set_sapjdbhost() start
         SAPJDBHOST=wwgeccsbx
        }10:39:53 ## set_sapjdbhost() done

        {10:39:53 ## set_jdb_local() start
         VHOST=wwgeccsbx
         set_jdb_local: _JDB_LOCAL=1
         SAPJDBHOST=wwgeccsbx
        }10:39:53 ## set_jdb_local() done: 1

        {10:39:53 ## set_jdb_running() start
         JDB_RUNNING=0
         _INST=
         _PROFILE=
         SAPSYSTEMNAME=ECP
        }10:39:53 ## set_jdb_running() done: 0

      }10:39:53 ## prepare() done

      DB_LOCAL=1
      DB_RUNNING=0
      hasABAP=1
      hasJava=0
      hasSpecial=1
      TASK=ALL

      {10:39:53 ## Database() start: @=start

        {10:39:53 ## getExePath() start: @=startdb
         EXEDIR=/usr/sap/ECP/SYS/exe/run
         EXECMD=/usr/sap/ECP/SYS/exe/run/startdb
        }10:39:53 ## getExePath() done: 0

        Running /usr/sap/ECP/SYS/exe/run/startdb
      DB startup failed

      Exit code 5

      REgards

      Jitendra Singh

      8800766770

      (0) 

Leave a Reply