Question Re: Database error in sybase database when starting sap database in Technology Q&A

Database error in sybase database when starting sap database

Former Member — Mon, 24 Nov 2014 06:25:38 GMT

Hi guys,

my system environment is ecc 6.0 suse linux os and database is sybase..when i am starting database of pi system with command startdb in suse linux database is not coming up and its showing the below error what could be the reason plz help me with ur valuable solutions or any threads related to sybase database starting in suse linux...

kpiadm>startdb

starting database KPI...

log file :/sybase/KPI/sartdb.log

parse level 0:identified message 'database 'master' is now online.'

/usr/sap/KPI/sys/exe/run/stdartdb : terminating with error 10

startdb db start failed

/usr/sap/KPI/sys/exe/run/startdb: terminating with error code 13

BR,

venkat

Re: Database error in sybase database when starting sap database

Former Member — Mon, 24 Nov 2014 06:46:01 GMT

HI vs,

ASE logs would be more helpful to analysis the issue. the same can be get from /sybase/<SID>/ASE-15*/install/SID.log

thanks

Sunil

Re: Database error in sybase database when starting sap database

divyanshu_srivastava3 — Mon, 24 Nov 2014 06:51:06 GMT

Can you share ASE and startup logs ?

Re: Database error in sybase database when starting sap database

divyanshu_srivastava3 — Mon, 24 Nov 2014 06:54:22 GMT

Also, have you tried this ?


Run saproot.sh to set user, group and access mode settings of sybctrl helper binary correctly and retry startsap

Regards,

Re: Database error in sybase database when starting sap database

Former Member — Mon, 24 Nov 2014 06:59:20 GMT

thank u for ur response where will we get this navigation..

Re: Database error in sybase database when starting sap database

Former Member — Mon, 24 Nov 2014 06:59:58 GMT

where we will get all these plz send the exact navigations.....thank u

Re: Database error in sybase database when starting sap database

divyanshu_srivastava3 — Mon, 24 Nov 2014 07:04:49 GMT

Hi,

This is your system and you must be knowing where DB is installed.

Look into Sybase/Ase/Install/SID.log and /sybase/KPI/sartdb.log then share the results

Regards,

Re: Database error in sybase database when starting sap database

Former Member — Mon, 24 Nov 2014 07:06:34 GMT

i checked using ls command in linux startdb is there but after that sid log is not there how can we find the exact log..

BR,

venkat

Re: Database error in sybase database when starting sap database

Former Member — Mon, 24 Nov 2014 07:36:03 GMT

hi divanshu thank u for ur reply i checked install sid log is not there will found only startdb.log only will post plz send ur valuable solution as soon as possible and guide me

BR,

venkat

Re: Database error in sybase database when starting sap database

Former Member — Mon, 24 Nov 2014 08:15:06 GMT

Hi Venkat,

you can find the ASE logs in following location.

cd /sybase/KPI/ASE-15*/install

KPI.log

thanks

sunil

Re: Database error in sybase database when starting sap database

Former Member — Mon, 24 Nov 2014 08:37:20 GMT

=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2014.11.24 13:05:56 =~=~=~=~=~=~=~=~=~=~=~=

Using keyboard-interactive authentication.

Password:

Last login: Fri Nov 21 15:58:50 2014 from console

[?1034h [1m [31mKNVDEVPI1:~ # (B [mvd [K [K cd /sys

sys/ sys101/

[1m [31mKNVDEVPI1:~ # (B [mcd /sys

sys/ sys101/

[1m [31mKNVDEVPI1:~ # (B [mcd /sys [Kbase/KPI/

[1m [31mKNVDEVPI1:/sybase/KPI # (B [mvi startsap

[?1049h [?1h = [1;24r [?12;25h [?12l [?25h [27m [m [H [2J [?25l [24;1H"startsap" [New File] [>c [2;1H [1m [34m~ [3;1H~ [4;1H~ [5;1H~ [6;1H~ [7;1H~ [8;1H~ [9;1H~ [10;1H~ [11;1H~ [12;1H~ [13;1H~ [14;1H~ [15;1H~ [16;1H~ [17;1H~ [18;1H~ [19;1H~ [20;1H~ [21;1H~ [22;1H~ [23;1H~ [m [24;63H0,0-1 All [1;1H [?12l [?25h [?25l [24;1H [K [24;1H: [?12l [?25hq [?25l

:q [?12l [?25h

[?25l [24;1H [K [24;1H [?1l > [?12l [?25h [?1049l [1m [31mKNVDEVPI1:/sybase/KPI # (B [mls

[0m [00m.ICEauthority [0m [00m.inputrc [0m [00m.xsession-errors.old [0m [34;42mconfig [0m

[00m.bash_history [0m [01;34m.local [0m [34;42mASE-15_0 [0m [34;42mdata [0m

[00m.bashrc [0m [00m.login [0m [34;42mDBISQL [0m [00minterf.old [0m

[01;34m.cache [0m [34;42m.mozilla [0m [01;34mDesktop [0m [00minterfaces [0m

[01;34m.config [0m [00m.muttrc [0m [01;34mDocuments [0m [34;42mjConnect-7_0 [0m

[00m.cshrc [0m [01;34m.nautilus [0m [34;42mOCS-15_0 [0m [34;42mjre64 [0m

[01;34m.dbus [0m [00m.profile [0m [00;32mSYBASE.1.csh [0m [34;42mjutils-3_0 [0m

[00m.dmrc [0m [00m.profile.1 [0m [00mSYBASE.1.env [0m [34;42mlocales [0m

[00m.emacs [0m [00m.profile.2 [0m [00;32mSYBASE.1.sh [0m [34;42mlog [0m

[00m.esd_auth [0m [00m.profile.3 [0m [00;32mSYBASE.csh [0m [34;42msapdata_1 [0m

[01;34m.fontconfig [0m [01;34m.pulse [0m [00mSYBASE.env [0m [34;42msapdiag [0m

[34;42m.fonts [0m [00m.pulse-cookie [0m [00;32mSYBASE.sh [0m [34;42msaplog_1 [0m

[01;34m.gconf [0m [00m.recently-used.xbel [0m [34;42mSYBDIAG [0m [34;42msaptemp [0m

[01;34m.gconfd [0m [01;34m.skel [0m [34;42mSYSAM-2_0 [0m [34;42mshared [0m

[01;34m.gnome2 [0m [00m.viminfo [0m [34;42mSybase_Install_Registry [0m [00mstartdb.log [0m

[01;34m.gnome2_private [0m [00m.vimrc [0m [34;42mWS-15_0 [0m [34;42msybsystem [0m

[01;34m.gstreamer-0.10 [0m [00m.xim.template [0m [34;42mbin [0m [34;42msybtemp [0m

[01;34m.gvfs [0m [00;32m.xinitrc.template [0m [34;42mcharsets [0m [34;42msybuninstall [0m

[00m.history [0m [00m.xsession-errors [0m [34;42mcollate [0m

[1m [31mKNVDEVPI1:/sybase/KPI # (B [mvi startdb.log

[?1049h [?1h = [1;24r [?12;25h [?12l [?25h [27m [m [H [2J [?25l [24;1H"startdb.log"

"startdb.log" 28L, 1036C [>c [2;1H------------------------------ Mon Nov 24 11:20:49 IST 2014

LOGFILE FOR STARTING SYBASE ASE

starting database KPI ...

------------------------------ Mon Nov 24 11:20:49 IST 2014

checking required environment variables

------------------------------ Mon Nov 24 11:20:49 IST 2014

check if Sybase ASE processes are running

ASE instance not available

There are no Sybase processes running -

Database is probably already stopped.

------------------------------ Mon Nov 24 11:20:49 IST 2014

check if Sybase Backupserver is running

Backupserver instance already running (pid of backupserver is: 6825 )

Database not available

parse level 0: identified message 'Database 'master' is now online.' [24;63H1,0-1 Top [1;1H [?12l [?25h [?25l [24;63H2,1 Top [2;1H [?12l [?25h [?25l [24;63H3,1 Top [3;1H [?12l [?25h [?25l [24;63H4,0-1 Top [4;1H [?12l [?25h [?25l [24;63H5,1 Top [5;1H [?12l [?25h [?25l [24;63H6,0-1 Top [6;1H [?12l [?25h [?25l [24;63H7,1 Top [7;1H [?12l [?25h [?25l [24;63H8,1 Top [8;1H [?12l [?25h [?25l [24;63H9,0-1 Top [9;1H [?12l [?25h [?25l [24;63H10,0-1 Top [10;1H [?12l [?25h [?25l [24;63H11,1 Top [11;1H [?12l [?25h [?25l [24;63H12,1 Top [12;1H [?12l [?25h [?25l [24;63H13,0-1 Top [13;1H [?12l [?25h [?25l [24;63H14,1 Top [14;1H [?12l [?25h [?25l [24;63H15,1 Top [15;1H [?12l [?25h [?25l [24;63H16,1 Top [16;1H [?12l [?25h [?25l [24;63H17,0-1 Top [17;1H [?12l [?25h [?25l [24;63H18,1 Top [18;1H [?12l [?25h [?25l [24;63H19,1 Top [19;1H [?12l [?25h [?25l [24;63H20,0-1 Top [20;1H [?12l [?25h [?25l [24;63H21,1 Top [21;1H [?12l [?25h [?25l [24;63H22,1 Top [22;1H [?12l [?25h [?25l [24;63H23,1 Top [23;1H [?12l [?25h [?25l [1;23r [23;1H

[1;24r [23;1H00:0006:00000:00012:2014/11/24 11:20:51.50 kernel ueshutdown: exiting [24;1H [K [24;63H24,1 20% [23;1H [?12l [?25h [?25l [1;23r [1;1H [2M [1;24r [22;1H00:0000:00000:00000:2014/11/24 11:20:51.50 kernel Main thread performing final [23;1Hshutdown. [24;63H [K [24;63H25,1 50% [22;1H [?12l [?25h [?25l [1;23r [23;1H

[1;24r [23;1H00:0000:00000:00000:2014/11/24 11:20:51.55 kernel Blocking call queue shutdown. [24;63H [K [24;63H26,1 66% [23;1H [?12l [?25h [?25l [1;23r [23;1H

[1;24r [23;1HERROR: database startup failed [24;63H [K [24;63H27,1 83% [23;1H [?12l [?25h [?25l [1;23r [23;1H

[1;24r [23;1H/usr/sap/KPI/SYS/exe/run/startdb: Terminating with error code 10 [24;63H [K [24;63H28,1 Bot [23;1H [?12l [?25h [?25l [24;63H [K [24;1H: [?12l [?25hq [?25l

:q [?12l [?25h

[?25l [24;1H [K [24;1H [?1l > [?12l [?25h [?1049l [1m [31mKNVDEVPI1:/sybase/KPI # (B [mcd /hm [Kome/KPI [K [K [Kkp iadm/ start sap [K [K [K [K [K [K [K [K

[1m [31mKNVDEVPI1:/home/kpiadm # (B [mls

[0m [00m.ICEauthority [0m [00m.profile.2 [0m [00mstartsap_DVEBMGS40.log.7 [0m

[00m.Xauthority [0m [01;34m.pulse [0m [00mstartsap_DVEBMGS40.log.8 [0m

[00m.bash_history [0m [00m.pulse-cookie [0m [00mstartsap_DVEBMGS40.log.9 [0m

[00m.bashrc [0m [00m.recently-used.xbel [0m [00mstartsap_SCS41.log [0m

[01;34m.cache [0m [00m.sapenv.csh [0m [00mstartsap_SCS41.log.1 [0m

[01;34m.config [0m [00m.sapenv.sh [0m [00mstartsap_SCS41.log.2 [0m

[00m.cshrc [0m [00m.sapenv_KNVDEVPI1.csh [0m [00mstartsap_SCS41.log.3 [0m

[00m.cshrc.1 [0m [00m.sapenv_KNVDEVPI1.sh [0m [00mstartsap_SCS41.log.4 [0m

[00m.dbenv.csh [0m [00m.sapsrc.csh [0m [00mstartsap_SCS41.log.5 [0m

[00m.dbenv.sh [0m [00m.sapsrc.sh [0m [00mstartsap_SCS41.log.6 [0m

[00m.dbsrc_KNVDEVPI1.csh [0m [00m.sapsrc_KNVDEVPI1.csh [0m [00mstartsap_SCS41.log.7 [0m

[00m.dbsrc_KNVDEVPI1.sh [0m [00m.sapsrc_KNVDEVPI1.sh [0m [00mstartsap_SCS41.log.8 [0m

[01;34m.dbus [0m [01;34m.skel [0m [00mstartsap_SCS41.log.9 [0m

[00m.dmrc [0m [01;34m.themes [0m [00mstartsap_saphostagent.log [0m

[00m.emacs [0m [01;34m.thumbnails [0m [00mstopdb.log [0m

[00m.esd_auth [0m [00m.viminfo [0m [00mstopsap.trc [0m

[01;34m.fontconfig [0m [00m.vimrc [0m [00mstopsap_DVEBMGS40.log [0m

[01;34m.fonts [0m [00m.xim.template [0m [00mstopsap_DVEBMGS40.log.1 [0m

[01;34m.gconf [0m [00;32m.xinitrc.template [0m [00mstopsap_DVEBMGS40.log.2 [0m

[01;34m.gconfd [0m [00m.xsession-error [0m [00mstopsap_DVEBMGS40.log.3 [0m

[01;34m.gnome2 [0m [00m.xsession-errors [0m [00mstopsap_DVEBMGS40.log.4 [0m

[01;34m.gnome2_private [0m [00m.xsession-errors.old [0m [00mstopsap_DVEBMGS40.log.5 [0m

[01;34m.gstreamer-0.10 [0m [01;34mDesktop [0m [00mstopsap_DVEBMGS40.log.6 [0m

[01;34m.gvfs [0m [01;34mDocuments [0m [00mstopsap_DVEBMGS40.log.7 [0m

[00m.history [0m [01;34mbin [0m [00mstopsap_DVEBMGS40.log.8 [0m

[01;34m.icons [0m [00mdev_dpmon [0m [00mstopsap_DVEBMGS40.log.9 [0m

[00m.inputrc [0m [00mdev_sybctrl [0m [00mstopsap_SCS41.log [0m

[00m.j2eeenv.csh [0m [00msapcpe.log [0m [00mstopsap_SCS41.log.1 [0m

[00m.j2eeenv.sh [0m [00msapcpe.old.log [0m [00mstopsap_SCS41.log.2 [0m

[00m.j2eeenv_KNVDEVPI1.csh [0m [00msapcpe_base.log [0m [00mstopsap_SCS41.log.3 [0m

[00m.j2eeenv_KNVDEVPI1.sh [0m [00mstartdb.log [0m [00mstopsap_SCS41.log.4 [0m

[01;34m.local [0m [00mstartsap.trc [0m [00mstopsap_SCS41.log.5 [0m

[00m.login [0m [00mstartsap_DVEBMGS40.log [0m [00mstopsap_SCS41.log.6 [0m

[00m.login.1 [0m [00mstartsap_DVEBMGS40.log.1 [0m [00mstopsap_SCS41.log.7 [0m

[01;34m.mozilla [0m [00mstartsap_DVEBMGS40.log.2 [0m [00mstopsap_SCS41.log.8 [0m

[00m.muttrc [0m [00mstartsap_DVEBMGS40.log.3 [0m [00mstopsap_SCS41.log.9 [0m

[01;34m.nautilus [0m [00mstartsap_DVEBMGS40.log.4 [0m [00mtrans.log [0m

[00m.profile [0m [00mstartsap_DVEBMGS40.log.5 [0m

[00m.profile.1 [0m [00mstartsap_DVEBMGS40.log.6 [0m

[1m [31mKNVDEVPI1:/home/kpiadm # (B [mvi starts ap

startsap.trc startsap_SCS41.log

startsap_DVEBMGS40.log startsap_SCS41.log.1

startsap_DVEBMGS40.log.1 startsap_SCS41.log.2

startsap_DVEBMGS40.log.2 startsap_SCS41.log.3

startsap_DVEBMGS40.log.3 startsap_SCS41.log.4

startsap_DVEBMGS40.log.4 startsap_SCS41.log.5

startsap_DVEBMGS40.log.5 startsap_SCS41.log.6

startsap_DVEBMGS40.log.6 startsap_SCS41.log.7

startsap_DVEBMGS40.log.7 startsap_SCS41.log.8

startsap_DVEBMGS40.log.8 startsap_SCS41.log.9

startsap_DVEBMGS40.log.9 startsap_saphostagent.log

[1m [31mKNVDEVPI1:/home/kpiadm # (B [mvi startsap

startsap.trc startsap_SCS41.log

startsap_DVEBMGS40.log startsap_SCS41.log.1

startsap_DVEBMGS40.log.1 startsap_SCS41.log.2

startsap_DVEBMGS40.log.2 startsap_SCS41.log.3

startsap_DVEBMGS40.log.3 startsap_SCS41.log.4

startsap_DVEBMGS40.log.4 startsap_SCS41.log.5

startsap_DVEBMGS40.log.5 startsap_SCS41.log.6

startsap_DVEBMGS40.log.6 startsap_SCS41.log.7

startsap_DVEBMGS40.log.7 startsap_SCS41.log.8

startsap_DVEBMGS40.log.8 startsap_SCS41.log.9

startsap_DVEBMGS40.log.9 startsap_saphostagent.log

[1m [31mKNVDEVPI1:/home/kpiadm # (B [mvi startsap.trcx [K

[?1049h [?1h = [1;24r [?12;25h [?12l [?25h [27m [m [H [2J [?25l [24;1H"startsap.trc"

"startsap.trc" 315L, 10169C [>c [1;3H SAPSYSTEMNAME=KPI

}10:47:26 ## set_jdb_running() done: 0

}10:47:26 ## prepare() done

DB_LOCAL=1

DB_RUNNING=0

hasABAP=1

hasJava=0

hasSpecial=1

TASK=ALL

{10:47:26 ## Database() start: @=start

{10:47:26 ## getExePath() start: @=startdb

EXEDIR=/usr/sap/KPI/SYS/exe/run

EXECMD=/usr/sap/KPI/SYS/exe/run/startdb

}10:47:26 ## getExePath() done: 0

Running /usr/sap/KPI/SYS/exe/run/startdb

DB startup failed

Exit code 5 [24;63H315,1 Bot [23;1H [?12l [?25h [?25l [24;1H [K [24;1H: [?12l [?25hq [?25l

:q [?12l [?25h

[?25l [24;1H [K [24;1H [?1l > [?12l [?25h [?1049l [1m [31mKNVDEVPI1:/home/kpiadm # (B [mcd /sys [Kbase/KPI/ [K [K [K [KA s [K [K [K

[1m [31mKNVDEVPI1:/sybase # (B [mls

[0m [34;42mKPI [0m

[1m [31mKNVDEVPI1:/sybase # (B [mcd..

[1m [31mKNVDEVPI1:/ # (B [mcd /sy base/a [Kin [K [K [K [K [K [K [K [K [Khome/kp

kpdadm/ kpiadm/

[1m [31mKNVDEVPI1:/ # (B [mcd /home/kp

kpdadm/ kpiadm/

[1m [31mKNVDEVPI1:/ # (B [mcd /home/kpiadm/sta rt [K [K [K [K [K