cancel
Showing results for 
Search instead for 
Did you mean: 

Database error in sybase database when starting sap database

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Venkat,

you can find the ASE logs in following location.

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

KPI.log

thanks

sunil

divyanshu_srivastava3
Active Contributor
0 Kudos

Can you share ASE and startup logs ?

divyanshu_srivastava3
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

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

divyanshu_srivastava3
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

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

login as: root

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

[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 start

startdb.log                startsap_SCS41.log

startsap.trc               startsap_SCS41.log.1

startsap_DVEBMGS40.log     startsap_SCS41.log.2

startsap_DVEBMGS40.log.1   startsap_SCS41.log.3

startsap_DVEBMGS40.log.2   startsap_SCS41.log.4

startsap_DVEBMGS40.log.3   startsap_SCS41.log.5

startsap_DVEBMGS40.log.4   startsap_SCS41.log.6

startsap_DVEBMGS40.log.5   startsap_SCS41.log.7

startsap_DVEBMGS40.log.6   startsap_SCS41.log.8

startsap_DVEBMGS40.log.7   startsap_SCS41.log.9

startsap_DVEBMGS40.log.8   startsap_saphostagent.log

startsap_DVEBMGS40.log.9  

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

startdb.log                startsap_SCS41.log

startsap.trc               startsap_SCS41.log.1

startsap_DVEBMGS40.log     startsap_SCS41.log.2

startsap_DVEBMGS40.log.1   startsap_SCS41.log.3

startsap_DVEBMGS40.log.2   startsap_SCS41.log.4

startsap_DVEBMGS40.log.3   startsap_SCS41.log.5

startsap_DVEBMGS40.log.4   startsap_SCS41.log.6

startsap_DVEBMGS40.log.5   startsap_SCS41.log.7

startsap_DVEBMGS40.log.6   startsap_SCS41.log.8

startsap_DVEBMGS40.log.7   startsap_SCS41.log.9

startsap_DVEBMGS40.log.8   startsap_saphostagent.log

startsap_DVEBMGS40.log.9  

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

startdb.log                startsap_SCS41.log

startsap.trc               startsap_SCS41.log.1

startsap_DVEBMGS40.log     startsap_SCS41.log.2

startsap_DVEBMGS40.log.1   startsap_SCS41.log.3

startsap_DVEBMGS40.log.2   startsap_SCS41.log.4

startsap_DVEBMGS40.log.3   startsap_SCS41.log.5

startsap_DVEBMGS40.log.4   startsap_SCS41.log.6

startsap_DVEBMGS40.log.5   startsap_SCS41.log.7

startsap_DVEBMGS40.log.6   startsap_SCS41.log.8

startsap_DVEBMGS40.log.7   startsap_SCS41.log.9

startsap_DVEBMGS40.log.8   startsap_saphostagent.log

startsap_DVEBMGS40.log.9  

[1m [31mKNVDEVPI1:/home/kpiadm #  (B [mvi start  [K  [K  [K  [K  [K  [K  [K  [K         cd..

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

[1m [31mKNVDEVPI1:/ #  (B [mexit  [K  [K  [K  [K cd..     [2Pls  cd /home/kpiadm/              .. [K  [K  [K  [K  [K          exit

logout

Former Member
0 Kudos

Hi Srivastava,

I am also facing the same error,

in /sybase/<SID>/ASE-15_0/install/ SID.log its showing below error.

00:0006:00000:00001:2014/12/06 11:16:18.10 server  Database 'sybsystemprocs' is now online.

00:0006:00000:00012:2014/12/06 11:16:18.11 kernel  Connectivity Library (Directory Control Layer) Error: Error returned by se

rvice provider.

00:0006:00000:00012:2014/12/06 11:16:18.11 kernel  Connectivity Library (Directory Control Layer) Error: (InterfacesDriver):

Requested server name not found.

00:0006:00000:00012:2014/12/06 11:16:18.11 kernel  Server RUN_<SID> not registered in the interfaces file or directory services

.

00:0006:00000:00012:2014/12/06 11:16:18.11 kernel  Cannot start any network listeners.

00:0006:00000:00012:2014/12/06 11:16:18.11 kernel  ueshutdown: exiting

00:0000:00000:00000:2014/12/06 11:16:18.11 kernel  Main thread performing final shutdown.

00:0000:00000:00000:2014/12/06 11:16:18.16 kernel  Blocking call queue shutdown.

00:0000:00000:00000:2014/12/06 11:16:18.26 kernel  SySAM: Checked in license for 4 ASE_ASM (2014.1231/permanent/1296 8FE3 0A8

3 A167).

R3trans log sowing as

unicode enabled version

2EETW152 Cannot open file "trans.log".

: Permission denied

R3trans finished (0012).

Please suggest me where I need to check to resolve the issue and make the database up &  running

Regards,

Manoj

0 Kudos

hi,

i used sap note

1721715 - SYB: sybctrl: No such file or directory

Reason and Prerequisites

bash-3.00$ stopdb
cp: /usr/sap/<SID>/SYS/exe/run/sybctrl: No such file or directory
stopping database <SID> ...
/usr/sap/<SID>/SYS/exe/uc/<OS>/stopdb[230]: /usr/sap/<SID>/SYS/exe/run/sybxctrl:  not found
stopdb DB stop failed
/usr/sap/<SID>/SYS/exe/uc/<OS>/stopdb: Terminating with error code 13

 

Solution

  After an SAP upgrade, sybctrl is missing from the kernel directory.

If the upgrade directory /usr/sap/<SID>/SUM/abap/exenew is still available, copy it to the requested place:

cp /usr/sap/<SID>/SUM/abap/exenew/sybctrl /usr/sap/<SID>/SYS/exe/run

If the upgrade directory is no longer available, download sybctrl from SAP Service Marketplace and copy it to the requested place:

SAP Kernel

--> SAP Kernel 64-BIT Unicode

--> SAP KERNEL 7.20 EXT 64-BIT UC

--> <OS>

--> Sybase ASE

sybctrl is contained in SYBCTRL_<pl>-<OS>.SAR and SAPEXEDB_<pl>-<OS>.SAR

Run

/usr/sap/<SID>/SYS/exe/run/saproot.sh <SID> to adjust the permissions of the executable.

or   

1902347 - SYB: Unable to start database with startsap

% startsap

Checking syb Database

Database is not available via R3trans

-------------------------------------------

Error: starting database failed.

startdb DB start failed

/usr/sap/<SID>/SYS/exe/run/startdb: Terminating with error code 13

DB startup failed

please send the tracefile /home/<sid>adm/startsap.trc to support

Cause

The sybctrl helper executable used by startsap does not have the correct user, group or access mode settings after a KERNEL patch update.

 

Resolution

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

e.g

aothist:~/Desktop # whoami

root

aothist:~/Desktop # cd /usr/sap/AOT/SYS/exe/run

aothist:/usr/sap/AOT/SYS/exe/run # ./saproot.sh AOT

Preparing /usr/sap/AOT/SYS/exe/run/sybctrl ...

Preparing icmbnd ...

done

aothist:/usr/sap/AOT/SYS/exe/run # startdb

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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