cancel
Showing results for 
Search instead for 
Did you mean: 

Instance not start

Former Member
0 Kudos

Hello, actually  updated the parameter language installed to from ES to DES on  profile ( DEV_XXXX_XXX) and before restar the system but  the db doesn´t start  we got this message on

startdb.log:

------------------------------ Mon Mar 25 11:14:50 ECT 2013
LOGFILE FOR STARTING DATABASE

Trying to start database ...

------------------------------ Mon Mar 25 11:14:50 ECT 2013
Checking required environment variables

SAPSYSTEMNAME is >DEV<
Start database with xuserkey >c<

------------------------------ Mon Mar 25 11:14:50 ECT 2013
Connect to the database to check the database state

dbmcli: connect check finished with return code: 0
Database not available

------------------------------ Mon Mar 25 11:14:52 ECT 2013
Starting XServer

2013-03-25 11:14:53 74512 INF  12903          XServer on port 7200 started
2013-03-25 11:14:53 74512 INF  13010            installation DEV  - path: /sapdb/DEV/db
2013-03-25 11:14:53 86736 INF  12798 NISERVER NI support started.
2013-03-25 11:14:53 90256 WNG  12453 NISSLSRV NISSL Init: SSL: Could not locate ticket file
2013-03-25 11:14:53 25008 INF  12903          sdbgloballistener on port 7210 started

------------------------------ Mon Mar 25 11:14:53 ECT 2013
Starting database

Starting Database Instance...
ERR
19,Error while using the file ID 'RunDirectory'.
-24979,ERR_XPNOTFOUND: Parameter RunDirectoryPath not found
-24748,ERR_FILEOPEN: Error opening file DEV
-24994,ERR_RTE: Runtime environment error
20016,file /sapdb/DEV/data/config/DEV has unknown type
Opening Database...
ERR
19,Error while using the file ID 'RunDirectory'.
-24979,ERR_XPNOTFOUND: Parameter RunDirectoryPath not found
-24748,ERR_FILEOPEN: Error opening file DEV
-24994,ERR_RTE: Runtime environment error
20016,file /sapdb/DEV/data/config/DEV has unknown type

------------------------------ Mon Mar 25 11:14:54 ECT 2013
Connect to the database to verify the database is now open

dbmcli check finished with return code: 0
Database start failed

and  un the startsap.trc

Trace of system startup/check of SAP System DEV on Mon Mar 25 11:14:47 ECT 2013


{11:14:47 ## Main() start: @=/usr/sap/DEV/SYS/exe/run/startsap db
@(#) $Id: //bas/720_REL/src/krn/startscripts/startsap#30 $
BASENAME=startsap

{11:14:47 ## check_user() start: @=devadm
}11:14:47 ## check_user() done

#=1
@=db

{11:14:47 ## setPlatform() start
  PLATFORM=linuxx86_64
}11:14:47 ## setPlatform() done

{11:14:47 ## setPing() start
  PING=/bin/ping
}11:14:47 ## setPing() done

{11:14:47 ## setIfconfig() start
  IFCONFIG=
}11:14:47 ## setIfconfig() done

{11:14:47 ## setRootDir() start: @=
  USR_SAP=/usr/sap
  USR_SAP_SID=/usr/sap/DEV
  PROFILE_DIR=/usr/sap/DEV/SYS/profile
  DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run
}11:14:47 ## setRootDir() done

{11:14:47 ## setDbUser() start: @=
}11:14:47 ## setDbUser() done

Argument=db

{11:14:47 ## getarg() start

  {11:14:47 ## checkInstance() start: @=db
  }11:14:47 ## checkInstance() done: 1

  {11:14:47 ## checkTask() start: @=db
   _opt=db
  }11:14:47 ## checkTask() done: 0

  TASK=DB
}11:14:47 ## getarg() done: 1

{11:14:47 ## setVHostArray() start
  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev /usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev.bak
  _nrProfiles=2

  {11:14:47 ## pushVHostsFromProfile() start: @=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev /usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev.bak
   _DUMMY=DEV_DVEBMGS10_erpdev
   _VHOST=erpdev

   {11:14:47 ## isVHostLocal() start: erpdev
    VHOST=erpdev
    _IS_LOCAL=1
   }11:14:47 ## isVHostLocal() done: 1

   _DUMMY=DEV_DVEBMGS10_erpdev.bak
   _VHOST=erpdev.bak

   {11:14:47 ## isVHostLocal() start: erpdev.bak
    VHOST=erpdev.bak
    _IS_LOCAL=0
   }11:14:47 ## isVHostLocal() done: 0

   VHOSTS= erpdev
  }11:14:47 ## pushVHostsFromProfile() done

  VHOSTS= erpdev
}11:14:47 ## setVHostArray() done

{11:14:47 ## set_instance() start
  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_SCS??_erpdev
  _nrProfiles=1
  _Iset_instance=SCS

  {11:14:47 ## pushProfiles() start: @=SCS /usr/sap/DEV/SYS/profile/DEV_SCS??_erpdev
   _TEMPINST=SCS??
  }11:14:47 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_ASCS??_erpdev
  _nrProfiles=1
  _Iset_instance=ASCS

  {11:14:47 ## pushProfiles() start: @=ASCS /usr/sap/DEV/SYS/profile/DEV_ASCS??_erpdev
   _TEMPINST=ASCS??
  }11:14:47 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_ERS??_erpdev
  _nrProfiles=1
  _Iset_instance=ERS

  {11:14:47 ## pushProfiles() start: @=ERS /usr/sap/DEV/SYS/profile/DEV_ERS??_erpdev
   _TEMPINST=ERS??
  }11:14:47 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_SMDA??_erpdev
  _nrProfiles=1
  _Iset_instance=SMDA

  {11:14:48 ## pushProfiles() start: @=SMDA /usr/sap/DEV/SYS/profile/DEV_SMDA??_erpdev
   _TEMPINST=SMDA??
  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev
  _nrProfiles=1
  _Iset_instance=D?*

  {11:14:48 ## pushProfiles() start: @=D?* /usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev
   _TEMPINST=DVEBMGS10

   {11:14:48 ## setInstanceDo() start: @=DVEBMGS10 /usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev:
    setInstanceDo: INSTdvebmgs=DVEBMGS10:
    setInstanceDo: PROFILEdvebmgs=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev:
    setInstanceDo: INST=DVEBMGS10:
    setInstanceDo: INSTFOUND=1:
   }11:14:48 ## setInstanceDo() done: 1:

  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_JC??_erpdev
  _nrProfiles=1
  _Iset_instance=JC

  {11:14:48 ## pushProfiles() start: @=JC /usr/sap/DEV/SYS/profile/DEV_JC??_erpdev
   _TEMPINST=JC??
  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_D??_erpdev
  _nrProfiles=1
  _Iset_instance=D

  {11:14:48 ## pushProfiles() start: @=D /usr/sap/DEV/SYS/profile/DEV_D??_erpdev
   _TEMPINST=D??
  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_J??_erpdev
  _nrProfiles=1
  _Iset_instance=J

  {11:14:48 ## pushProfiles() start: @=J /usr/sap/DEV/SYS/profile/DEV_J??_erpdev
   _TEMPINST=J??
  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_JMS??_erpdev
  _nrProfiles=1
  _Iset_instance=JMS

  {11:14:48 ## pushProfiles() start: @=JMS /usr/sap/DEV/SYS/profile/DEV_JMS??_erpdev
   _TEMPINST=JMS??
  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_G??_erpdev
  _nrProfiles=1
  _Iset_instance=G

  {11:14:48 ## pushProfiles() start: @=G /usr/sap/DEV/SYS/profile/DEV_G??_erpdev
   _TEMPINST=G??
  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_TRX??_erpdev
  _nrProfiles=1
  _Iset_instance=TRX

  {11:14:48 ## pushProfiles() start: @=TRX /usr/sap/DEV/SYS/profile/DEV_TRX??_erpdev
   _TEMPINST=TRX??
  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_W??_erpdev
  _nrProfiles=1
  _Iset_instance=W

  {11:14:48 ## pushProfiles() start: @=W /usr/sap/DEV/SYS/profile/DEV_W??_erpdev
   _TEMPINST=W??
  }11:14:48 ## pushProfiles() done

  _PROFILES=/usr/sap/DEV/SYS/profile/DEV_V??_erpdev
  _nrProfiles=1
  _Iset_instance=V

  {11:14:48 ## pushProfiles() start: @=V /usr/sap/DEV/SYS/profile/DEV_V??_erpdev
   _TEMPINST=V??
  }11:14:48 ## pushProfiles() done

  NINST=
  INSTFOUND=1
  NINSTFOUND=0
  hasABAP=1
  hasJava=0
  hasSpecial=0
}11:14:48 ## set_instance() done

{11:14:48 ## prepare() start

  {11:14:48 ## set_sapdbhost() start
   _PROFILE=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS10_erpdev
   SAPDBHOST=erpdev
  }11:14:49 ## set_sapdbhost() done

  {11:14:49 ## set_db_local() start
   VHOST=erpdev
   set_dblocal: _DB_LOCAL=1
   SAPDBHOST=erpdev
  }11:14:49 ## set_db_local() done: 1

  {11:14:49 ## set_db_sid() start: @=1
   DB_SID=ADA
  }11:14:49 ## set_db_sid() done

  {11:14:49 ## set_db_running() start
   Checking ADA Database

   {11:14:49 ## getExePath() start: @=R3trans DVEBMGS10

    {11:14:49 ## set_path() start: @=/usr/sap/DEV/DVEBMGS10/exe
     N_PATH=/usr/sap/DEV/DVEBMGS10/exe
     LD_LIBRARY_PATH=/usr/sap/DEV/DVEBMGS10/exe:/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/sapdb/clients/DEV/lib
     O_LD_LIBRARY_PATH=/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/sapdb/clients/DEV/lib
    }11:14:49 ## set_path() done

    _DIR_EXECUTABLE=/usr/sap/DEV/DVEBMGS10/exe

    {11:14:49 ## restore_path() start
     LD_LBRARY_PATH=/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/sapdb/clients/DEV/lib
    }11:14:49 ## restore_path() done

    EXEDIR=/usr/sap/DEV/DVEBMGS10/exe
    EXECMD=/usr/sap/DEV/DVEBMGS10/exe/R3trans
   }11:14:49 ## getExePath() done: 0

   DBCONNECT_TEST=/usr/sap/DEV/DVEBMGS10/exe/R3trans -d -w

   {11:14:49 ## set_path() start: @=/usr/sap/DEV/DVEBMGS10/exe
    N_PATH=/usr/sap/DEV/DVEBMGS10/exe
    LD_LIBRARY_PATH=/usr/sap/DEV/DVEBMGS10/exe:/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/sapdb/clients/DEV/lib
    O_LD_LIBRARY_PATH=/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/sapdb/clients/DEV/lib
   }11:14:49 ## set_path() done

   {11:14:50 ## restore_path() start
    LD_LBRARY_PATH=/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/sapdb/clients/DEV/lib
   }11:14:50 ## restore_path() done

   Database is not available via R3trans
   DB_RUNNING=0
   JDB_RUNNING=
  }11:14:50 ## set_db_running() done: 0

  {11:14:50 ## set_sapjdbhost() start
   SAPJDBHOST=erpdev
  }11:14:50 ## set_sapjdbhost() done

  {11:14:50 ## set_jdb_local() start
   VHOST=erpdev
   set_jdb_local: _JDB_LOCAL=1
   SAPJDBHOST=erpdev
  }11:14:50 ## set_jdb_local() done: 1

  {11:14:50 ## set_jdb_running() start
   JDB_RUNNING=0
   _INST=
   _PROFILE=
   SAPSYSTEMNAME=DEV
  }11:14:50 ## set_jdb_running() done: 0

}11:14:50 ## prepare() done

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

{11:14:50 ## Database() start: @=start

  {11:14:50 ## getExePath() start: @=startdb
   EXEDIR=/usr/sap/DEV/SYS/exe/run
   EXECMD=/usr/sap/DEV/SYS/exe/run/startdb
  }11:14:50 ## getExePath() done: 0

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

Exit code 5

I have check the profile, and  I didn´t  find any change on this profile

any suggestion  about this problema

Thanks

Juan Carlos

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

The usual fix is to put back the .BAK profile files and try to startsap again. The are located in the /sapmnt/SID/profile directory.

If that does not work, then you most probably have another problem.

Cheers Michael

former_member188883
Active Contributor
0 Kudos

Hi Juan,

you need to make sure that the x_server and the globallistener are started.

Run the following command as administrator and let me know the ouput- Comand: "sdbregview -l"

Run the dbmcli commands as a user in the sdb group or the root/administrator user - because other users will not have access to the Database Runtime folders.

Adjust the database instance parameter RunDirectoryPath. You must adjust the value of the parameter RunDirectoryPath accordingly. You can convert the parameter using the following command:

dbmcli -d <SID> -u control,<passwd> param_put RunDirectoryPath

/sapdb/<SID>/data/wrk/<SID>

Hope this helps.

Regards,

Deepak Kori