While working on Installation of SAP Netweaver 7.40 on SYBASE DB ASE 16 PL5 on Linux OS, i have faced multiple errors. i thought it should be worth sharing to you all.<\/p>\n
Mount Point requirement.<\/p>\n
\/sybase\/(SID)
\n\/sybase\/(SID)\/sapdata_1
\n\/sybase\/(SID)\/sapdata_2
\n\/sybase\/(SID)\/saplog_1<\/p>\n
Sybase store all the database related binaries on \/sybase\/(SID) mount point. This mount point should be big enough to handle all the temp DB device, log data, log device, sybtemp, saptemp & other log files. Minimum – 20 GB, during installation it will ask you multiple inputs.<\/p>\n
sapdata_1 & sapdata_2 – depends on your DB size. minimum – 150 GB each<\/p>\n
saplog_1 – depends on log size. minimum – 100 GB<\/p>\n
During installation, i stuck on database configuration & other steps, where i need to stop & start the SYBASE DB, there are 2 ways to perform the same (may be more) as i aware.<\/p>\n
1. SYBASE Control Center
\n2. isql<\/p>\n
I was working on isql to start stop my DB. (Please note once SAP installed successfully, “sa” user will lock automatically & only “sapsa” user will login. if you want to use “sa” user you need to unlock the same from isql command.<\/p>\n
it’s recommended to start \/ stop DB from sap command only. (startsap DB \/ stopsap DB)<\/p>\n
But if you have only installed Sybase DB so here is the way to start & stop through isql. here “sa” user will work because we have not installed SAP yet.<\/p>\n
Stopping the SYBASE DB in Linux<\/strong>.<\/p>\n isql -Usa -Ppassword -S DBSID the above command will stop the SYBASE server & show the below output. now you cannot login into isql as server is down. Starting the SYBASE DB in Linux<\/strong><\/p>\n for starting you need to go install folder, that install folder is in your SYBASE_HOME. usually at below location.<\/p>\n \/sybase\/SID\/ASE-16_0(Version)\/install\/RUN_SID<\/p>\n once you trigger the above command, SYBASE DB will start successfully & you can verify the process.<\/p>\n In Windows you can stop\/start SYBASE DB by Windows Services.<\/p>\n","protected":false},"excerpt":{"rendered":" While working on Installation of SAP Netweaver 7.40 on SYBASE DB ASE 16 PL5 on Linux OS, i have faced multiple errors. i thought it should be worth sharing to you all. Mount Point requirement. \/sybase\/(SID) \/sybase\/(SID)\/sapdata_1 \/sybase\/(SID)\/sapdata_2 \/sybase\/(SID)\/saplog_1 Sybase store all the database related binaries on \/sybase\/(SID) mount point. This mount point should be […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[321,320,325,187,319,323,322,324],"class_list":["post-420","post","type-post","status-publish","format-standard","hentry","category-sap-updates","tag-ase","tag-isql","tag-isql-commands","tag-sap","tag-sybase","tag-sybase-start","tag-sybase-stop","tag-sybase-stop-start-commands"],"_links":{"self":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/comments?post=420"}],"version-history":[{"count":2,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/420\/revisions"}],"predecessor-version":[{"id":422,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/420\/revisions\/422"}],"wp:attachment":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/media?parent=420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/categories?post=420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/tags?post=420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2> shutdown
\n3> go<\/p>\n
\nMsg 2812, Level 16, State 5:
\nServer ‘SID’, Line 1:
\nStored procedure ‘help’ not found. Specify owner.objectname or use sp_help to
\ncheck whether the object exists (sp_help may produce lots of output).
\nServer SHUTDOWN by request.
\nASE is terminating this process.
\nCT-LIBRARY error:
\n ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect<\/p>\n