on 03-25-2013 10:59 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.