tag:blogger.com,1999:blog-15518169637278291492024-02-18T21:25:02.798-08:00SAP4EASYUnknownnoreply@blogger.comBlogger17125tag:blogger.com,1999:blog-1551816963727829149.post-35395843521978184972020-08-02T03:00:00.000-07:002020-08-02T03:00:03.541-07:00Free course - SAP Hana Express 2.0 Installation for BeginnersIn this course you will learn about how to install SAP HANA Express 2.0 from scratch. It means, that I will guide you of full installation process. <div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiw-Aj89OCxT7iHFGEL6Ki0oz1fEohrvMgNfFIXR6Dr-GS45qfx3YFxzBQbjjPd9dNJQvhV_yuB2tsSuz1FdCzJ_XCUI0Pq3tQDA7E09FhMJjhfYlKg_YrFzw9lJ-QiT3WwoHdn1LCA3ds/s806/course_hana_free.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="452" data-original-width="806" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiw-Aj89OCxT7iHFGEL6Ki0oz1fEohrvMgNfFIXR6Dr-GS45qfx3YFxzBQbjjPd9dNJQvhV_yuB2tsSuz1FdCzJ_XCUI0Pq3tQDA7E09FhMJjhfYlKg_YrFzw9lJ-QiT3WwoHdn1LCA3ds/s640/course_hana_free.jpg" width="640" /></a></div><div><br /><h3 style="text-align: left;">
Requirements </h3><div>No special requirement. Just knoweldge basic of Windows. All learning software in this training course are free or have a trial version. </div><div><br /></div><h3 style="text-align: left;">Description</h3><div>Hello everyone! </div><div>Welcome to the very interesting training course about how to install SAP Hana Express 2.0. If you have a dream to try SAP Hana, this is a very good starting point. Why? Because all showing software in this training course is free or has trial version. </div><div>We will learn different methods. First method - when virtual machine have been prepared by SAP itself. Second method - we will create new our virtual machine, will see how to install and config SUSE Linux Enterprise Server, and of course how to install SAP Hana Express 2.0. </div><div><br /></div><h3 style="text-align: left;">Duratión</h3><div><span style="box-sizing: border-box; color: #3c3b37; font-size: 17.5px; margin: 0px; padding: 0px; user-select: text !important;">1 h 56 min</span><span style="color: #3c3b37; font-size: 17.5px;"> de vídeo bajo demanda</span></div><h3 style="text-align: left;"> Who is this course for?</h3><div>Anyone who would like to learn about SAP HANA Express 2.0.</div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-39274545704384726242020-02-13T11:11:00.003-08:002020-02-13T11:11:59.788-08:00How to modify the log mode on Sybase ASE<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
To modify the log mode on Sybase ASE, you have to follow further steps :</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
<br /></div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
1. Log in on your server with user syb<sid></div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
2. Launch with a command line tool to connect to ASE database</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
> isql -Usapsa -P<password> -X</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
3. On the SQL interface, enter the statements to change log mode</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
</div>
<a name='more'></a><br />
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
1> use master</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
2> go</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
1> sp_dboption <SID>, 'trunc',false</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
2> go</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
Database option 'trunc. log on chkpt.' turned OFF for database '<SID>'.</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
Running CHECKPOINT on database '<SID>' for option 'trunc. log on chkpt.' to take</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
effect.</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
(return status = 0)</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
1> checkpoint</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; margin-bottom: 8px; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
2> go</div>
<div style="background-color: #f3f9f3; border: 0px; box-sizing: inherit; color: #444444; font-family: SAPRegular, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 1.47; overflow-wrap: break-word; padding: 0px; word-break: break-word;">
1></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-37841798735713434122020-01-07T10:42:00.001-08:002020-01-07T10:42:06.423-08:00SAP Gateway: Technical Overview<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/VWvSCHGV1w8" width="560"></iframe>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-22694738129225949912019-12-04T01:54:00.004-08:002019-12-04T01:54:40.841-08:00SAP ABAP Training<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/videoseries?list=PLoAOH2CgJh8B4PwQB7R53MURGEpbTHKYo" width="560"></iframe>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-83313440052722173602019-10-24T07:02:00.005-07:002019-10-24T07:02:49.812-07:00Install SAP HANA Tools for Eclipse<div class="shortdesc" style="background-color: white; box-sizing: border-box; color: rgba(0, 0, 0, 0.8); font-family: "Benton Sans", Arial, sans-serif; font-size: 14px; line-height: 1.6em; margin-bottom: 1.5em; margin-top: 1.5em; padding: 0px;">
Before developing your SAP HANA XS application, you need to download and set up the necessary tools.</div>
<div class="section" style="background-color: white; box-sizing: content-box; color: rgba(0, 0, 0, 0.8); font-family: "Benton Sans", Arial, sans-serif; font-size: 14px;">
<section class="section" style="box-sizing: border-box;" type="Prerequisites"><h2 class="section_title" style="box-sizing: border-box; color: rgba(0, 0, 0, 0.7); font-family: inherit; line-height: 1.1em; margin: 1.6em 0px 1em;">
Prerequisites</h2>
<ul class="ul" id="loiob0e351ada628458cb8906f55bcac4755__ul_urk_2qc_jp" style="box-sizing: border-box; margin: 1.5em 0px;">
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">You have downloaded and installed a 32-bit or 64-bit version of Eclipse IDE, version <kbd class="ph userinput" style="background: 0px center; border-radius: 3px; box-shadow: none; box-sizing: border-box; color: inherit; font-family: Monaco, monospace; font-size: 1.071em; padding: 0px;">Neon</kbd>. For more information, see <a class="xref" href="https://help.sap.com/viewer/65de2977205c403bbc107264b8eccf4b/Cloud/en-US/761374e5711e1014839a8273b0e91070.html" style="background-color: transparent; box-sizing: border-box; color: rgba(0, 119, 200, 0.9); text-decoration-line: none;">Install Eclipse IDE</a>.<div class="p" style="box-sizing: content-box; font-size: 1em; line-height: 1.6em; margin: 1em 0px; padding: 0px;">
<aside class="note caution insertion" style="background-color: rgba(0, 0, 0, 0.08); border-bottom-color: rgba(231, 70, 0, 0.7) !important; border-bottom-style: initial; border-left-color: rgba(0, 119, 200, 0.7); border-left-style: solid; border-radius: 4px 0px 0px 4px; border-right-color: initial; border-right-style: initial; border-top-color: rgba(231, 70, 0, 0.7) !important; border-top-style: initial; border-width: 0px 0px 0px 0.6rem; box-sizing: border-box; margin: 1em 0px; overflow-wrap: normal; overflow-x: auto; padding: 0.75em; position: relative;"><span class="title" style="box-sizing: border-box; color: black; display: block; font-size: 1.357em; line-height: 1.1em; margin: 0px 0px 0.6em;">Caution</span>The support for <kbd class="ph userinput" style="background: 0px center; border-radius: 3px; box-shadow: none; box-sizing: border-box; color: inherit; font-family: Monaco, monospace; font-size: 1.071em; margin-bottom: 0px; margin-top: 0px; padding: 0px;">Mars</kbd> has entered end of maintenance.</aside></div>
</li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">You have configured your proxy settings (in case you work behind a proxy or a firewall). For more information, see <a class="xref" href="https://help.sap.com/viewer/65de2977205c403bbc107264b8eccf4b/Cloud/en-US/76137a37711e1014839a8273b0e91070.html" style="background-color: transparent; box-sizing: border-box; color: rgba(0, 119, 200, 0.9); text-decoration-line: none;">Install SAP Development Tools for Eclipse</a> → <span class="ph emphasis emphasis" style="box-sizing: border-box; font-weight: 600;">step 3</span>.<a name='more'></a></li>
</ul>
</section></div>
<div class="section" style="background-color: white; box-sizing: content-box; color: rgba(0, 0, 0, 0.8); font-family: "Benton Sans", Arial, sans-serif; font-size: 14px;">
<section class="section" style="box-sizing: border-box;" type="Procedure"><h2 class="section_title" style="box-sizing: border-box; color: rgba(0, 0, 0, 0.7); font-family: inherit; line-height: 1.1em; margin: 1.6em 0px 1em;">
Procedure</h2>
<ol class="ol" id="loiob0e351ada628458cb8906f55bcac4755__ol_tfw_d5p_lm" style="box-sizing: border-box; margin: 1.5em 0px;">
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">Open the Eclipse IDE.</li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">In the main menu, choose <span class="ph menucascade" style="box-sizing: border-box;"><span class="ph uicontrol" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">Help</span> <span class="ph uicontrol" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">Install New Software</span></span>.</li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">Enter the following URL in the <span class="keyword uinolabel" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">Work with</span> field for <span class="ph pname" style="box-sizing: border-box;">Eclipse Neon (4.6.1)</span>: <kbd class="ph userinput" style="background: 0px center; border-radius: 3px; box-shadow: none; box-sizing: border-box; color: inherit; font-family: Monaco, monospace; font-size: 1.071em; padding: 0px;">https://tools.hana.ondemand.com/neon</kbd></li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">Select <span class="ph uicontrol" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">SAP HANA Tools</span> (the whole feature group).<aside class="note note insertion" style="background-color: rgba(0, 0, 0, 0.08); border-bottom-color: initial; border-bottom-style: initial; border-left-color: rgba(0, 119, 200, 0.7); border-left-style: solid; border-radius: 4px 0px 0px 4px; border-right-color: initial; border-right-style: initial; border-top-color: initial; border-top-style: initial; border-width: 0px 0px 0px 0.6rem; box-sizing: border-box; margin: 1em 0px; overflow-wrap: normal; overflow-x: auto; padding: 0.75em; position: relative;"><span class="title" style="box-sizing: border-box; color: black; display: block; font-size: 1.357em; line-height: 1.1em; margin: 0px 0px 0.6em;">Note</span>In case you need to develop with SAPUI5, install also <span class="ph menucascade" style="box-sizing: border-box; margin-bottom: 0px; margin-top: 0px;"><span class="ph uicontrol" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">SAP Cloud Platform Tools</span> <span class="ph uicontrol" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">UI development toolkit for HTML5 (Developer Edition)</span></span>.</aside></li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">Choose <span class="ph uicontrol" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">Next</span>.</li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">On the next wizard page, you get an overview of the features to be installed. Choose <span class="ph uicontrol" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">Next</span>.</li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">Confirm the license agreements.</li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">Choose <span class="ph uicontrol" style="box-sizing: border-box; color: rgba(13, 35, 113, 0.8); font-weight: 600;">Finish</span> to start the installation.</li>
<li class="li" style="box-sizing: border-box; margin-bottom: 1em; margin-top: 1em;">After the successful installation, you will be prompted to restart your Eclipse IDE.</li>
</ol>
<div>
<a href="https://help.sap.com/viewer/65de2977205c403bbc107264b8eccf4b/Cloud/en-US/b0e351ada628458cb8906f55bcac4755.html" rel="nofollow" target="_blank">source</a></div>
</section></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-71931906200830239042019-09-24T06:03:00.004-07:002019-09-24T06:03:43.027-07:00How to install SAP Hana Database using GUI (hdblcmgui)<iframe width="560" height="315" src="https://www.youtube.com/embed/H0iPIyAurow" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-31203737780150499772019-09-07T08:37:00.004-07:002019-09-07T08:37:41.418-07:00TEST C_FIORADM_21 | SAP Certified Technology Associate - SAP Fiori System<br />
SAP Certified Technology Associate - SAP Fiori System - <a href="https://training.sap.com/certification/c_fioradm_21-sap-certified-technology-associate---sap-fiori-system-administration-g/" rel="nofollow" target="_blank">LINK</a><br />
<br />
<br />
NO.1 You want to work with the sap gate way performance trace tool (transaction/IWFND? TRACES).<br />
What can you configure?<br />
There are 2 correct answers to this question.<br />
Response:<br />
A. The application server(S) on which the trace is activated<br />
B. The duaration in hours for the active trace<br />
C. The maximum number of entries in the trace<br />
D. The number of days to keep the performance trace data<br />
<br />
<a name='more'></a><br /><br />
Answer: B,D<br />
<br />
NO.2 You want to enable an anonymous access to an ABAP-based SAP system. Which user type<br />
should you use?<br />
Please choose the correct answer.<br />
Response:<br />
A. System user<br />
B. Service user<br />
C. Communication user<br />
D. Dialog user<br />
<br />
Answer: B<br />
<br />
NO.3 You want to set up SAP Fiori search for SAP S/4HANA 1610. What should you do in the BES<br />
system?<br />
There are 2 correct answers to this question.<br />
Response:<br />
A. Run task list SAP_ESH_INTIAL_SETUP_000_CLIENT<br />
B. Assign role SAP_ESH_LOCAL_ADMIN to your user<br />
C. Assign role SAP_ESH_SEARCH to your user<br />
D. Run task list SAP_ESH_INITIAL_SETUP_WRK_CLIENT<br />
<br />
Answer: B,D<br />
<br />
NO.4 You are responsible for a newly installed (not upgraded) SAP S/4HANA 1610 System with<br />
several instances. Two of them are additional applications servers (AAS).<br />
How many active profile files are persisted in the profile directory of this SAP s/4HANA system?<br />
Please choose the correct answer.<br />
Response:<br />
A. 7<br />
B. 4<br />
C. 9<br />
D. 5<br />
<br />
Answer: D<br />
<br />
NO.5 In additional to a transaction code. What is required to define the target mapping for a single<br />
ABAP transaction?<br />
Please choose the correct answer.<br />
Response:<br />
A. System alias<br />
B. SAP Gateway service<br />
C. ICF service URL<br />
D. Application configuration<br />
<br />
Answer: A<br />
<br />
NO.6 What can you do with external aliases in the ICF (transaction SICF)?<br />
There are 2 correct answers to this question.<br />
Response:<br />
A. Create virtual hosts<br />
B. Deactivate the referred ICF service<br />
C. Give a semantic name to the referred ICF service<br />
D. Maintain logon groups<br />
<br />
Answer: A,C<br />
<br />
NO.7 You want to enable HTTPS between the SAP Web Dispatcher and the FES System. What are<br />
some of the steps you need to perform?<br />
There are 2 correct answers to this question.<br />
Response:<br />
A. In the FES system Create a new key pair in the SAPSSLS view of the pse management<br />
B. In the FES System determine the singer of SSI server certificates used for the FES Server PSE<br />
C. In the SAP Web dispatcher's client PSE import the CA root certificate used for the FES server PSE<br />
D. In the SAP Web Dispatcher's server PSE import a signed server certificate to the pse management<br />
<br />
Answer: C,D<br />
<br />
NO.8 Which tool can you use to investigate malformed OData requests?<br />
Please choose the correct answer.<br />
Response:<br />
A. FES system error log(/IWFND/ERROR_LOG)<br />
B. performance tarce(/IWBEP/TRACES)<br />
C. statistics (/IWFND/STATS)<br />
D. BES system error log(/IWBEP/ERROR_LOG)<br />
<br />
Answer: A<br />
<br />
<div>
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-91072579081150157092019-08-26T10:41:00.000-07:002019-08-26T10:41:02.362-07:00Increase the System Isolation Level<div class="MsoNormal" style="background-color: white;">
<b style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">Prerequisites </b><span style="background-color: transparent;"><span style="color: #222222; font-family: "arial" , "helvetica" , sans-serif; font-size: x-small;"><b>Increase the System Isolation Level</b></span></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
You have root access to the SAP HANA system.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
You are logged on to the system database in the SAP HANA cockpit.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
You have the system privilege DATABASE ADMIN.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
Internal SAP HANA communication has been appropriately configured for TLS/SSL.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
[communication] ssl in the global.ini file must have the value false (default) or systemPKI.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
For more information, see Secure Internal Communication and Server-Side TLS/SSL Configuration Properties for Internal Communication in the SAP HANA Security Guide.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
If the system is running in an SAP HANA system replication configuration, the system PKI SSFS data file and key file have been copied from the primary system to the same location on the secondary system(s):<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
$DIR_INSTANCE/../global/<wbr></wbr>security/rsecssfs/data/SSFS_<<wbr></wbr>SID>.DAT<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
$DIR_INSTANCE/../global/<wbr></wbr>security/rsecssfs/key/SSFS_<<wbr></wbr>SID>.KEY<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white;">
<span style="color: #222222; font-family: "arial" , "helvetica" , sans-serif; font-size: x-small;">P</span><b style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">rocedure </b><span style="background-color: transparent;"><span style="color: #222222; font-family: "arial" , "helvetica" , sans-serif; font-size: x-small;"><b>Increase the System Isolation Level</b></span></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
1 For every tenant database, create a dedicated OS user and group:<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
A As root user, log on to the server on which the name server of the system database is running.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
B Create new groups for every tenant database:<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
groupadd <groupname><u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
C Create new users for every tenant database, specifying sapsys as the primary group:<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
useradd -g sapsys <username><u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
D Add every new user to the sidshm group and their own group as secondary groups:<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
usermod -G <sid>shm,<usergroup> <username><u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
2 Stop all tenant databases in the system.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
In the system database, execute the SQL statement ALTER SYSTEM STOP DATABASE <databasename>.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
3 Configure the system for high isolation.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
As the operating system user <sid>adm, log on to the server on which the master index server is running and run the following command:<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
python /usr/sap/<SID>/HDB<instance>/<wbr></wbr>exe/python_support/convertMDC.<wbr></wbr>py --change=databaseIsolation --isolation=high<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
This command runs the following actions:<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
Stops the system<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
Changes the value of the [multidb] database_isolation property in the global.ini file to high<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
Starts the system<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
4 Assign every database to their respective OS user and group.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
In the system database, execute the SQL statement ALTER DATABASE <databasename> OS USER '<username>' OS GROUP '<groupname>'<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
5 Start all tenant databases.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
In the system database, execute the SQL statement ALTER SYSTEM START DATABASE <database_name> <wbr></wbr> <u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white;">
<b style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">Results </b><span style="background-color: transparent;"><span style="color: #222222; font-family: "arial" , "helvetica" , sans-serif; font-size: x-small;"><b>Increase the System Isolation Level</b></span></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
The system is now running in high isolation mode. As a result:<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
The processes of individual tenant databases run under dedicated OS users belonging to dedicated OS groups and the processes of the system database run under the <sid>adm user.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
Internal database communication is authenticated using X.509 client certificates. Depending on how SSL for internal communication is configured, data communication within databases may also be encrypted. For more information about secure internal communication, see the SAP HANA Security Guide.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
Operations that require operating system access are restricted to users with the correct permissions. For more information, see the section on file and directory permissions with high isolation.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
New tenant databases can only be created if a dedicated OS user and group exist.</div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<a href="https://help.sap.com/viewer/78209c1d3a9b41cd8624338e42a12bf6/2.0.03/en-US/a92f66e5a6564c1bafd33244b94558dc.html" rel="nofollow" target="_blank">Fuente </a></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-52716275474681054632019-08-21T10:19:00.000-07:002019-08-21T10:19:22.816-07:00SAP HANA - Secure storage is locked<br />
<div style="background: white; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #444444; font-family: Arial, sans-serif;"><span style="font-size: 14px;">Sometimes when entering the <b>SAP HANA Studio</b>, it shows us the message:</span></span></div>
<div style="background: white; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #444444; font-family: Arial, sans-serif;"><span style="font-size: 14px;"><br /></span></span></div>
<div style="background: white; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #444444; font-family: Arial, sans-serif;"><span style="font-size: 14px;"><b>Secure Storage locked.</b></span></span></div>
<div style="background: white; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #444444; font-family: Arial, sans-serif;"><span style="font-size: 14px;"><br /></span></span></div>
<div style="background: white; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #444444; font-family: Arial, sans-serif;"><span style="font-size: 14px;">Solution:</span></span></div>
<div style="background: white; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #444444; font-family: Arial, sans-serif;"><span style="font-size: 14px;"></span></span></div>
<a name='more'></a><span style="color: #444444; font-family: Arial, sans-serif;"><br /></span><br />
<div style="background: white; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #444444; font-family: Arial, sans-serif; font-size: 10.5pt;">Open <b>HANA Studio->Windows -> Preferences -> General -> Security -> Secure Storage -> Content</b></span></div>
<div style="background: white; box-sizing: inherit; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm; word-break: break-word;">
<span style="color: #444444; font-family: Arial, sans-serif; font-size: 10.5pt;">Then click the push button. It will restart your application and you can see your system.</span></div>
<div style="background: white; box-sizing: inherit; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm; word-break: break-word;">
<span style="color: #444444; font-family: Arial, sans-serif; font-size: 10.5pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdb3xrJXvdKUuvas7640ChurbGrb8BMdFYyekjV-QV_DGbOcWV3ir32uuzaTjZuUr05z6YfJ4Qml7-hNlF4k9VpLIH_Jey5OnopT5tedX24tdwWEl6H7tJWoCohRCRJA-kh0l1KWbfrqs/s1600/secure_storage_is_locked_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="468" data-original-width="747" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdb3xrJXvdKUuvas7640ChurbGrb8BMdFYyekjV-QV_DGbOcWV3ir32uuzaTjZuUr05z6YfJ4Qml7-hNlF4k9VpLIH_Jey5OnopT5tedX24tdwWEl6H7tJWoCohRCRJA-kh0l1KWbfrqs/s400/secure_storage_is_locked_1.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white; color: #444444; font-family: Arial, sans-serif; font-size: 14px; text-align: start;">Press on delete</span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtIvnfE_9yRYLlaES22FF6dG3VzFw74s2gAaHJkibVCpfN9xACK19VTA37MJZ6LBvo9BNnoNULzmntPdIx3Hh49sIbG7-baBOJXSpsQ2dcAbMybsnrLcnsqyAKNc7h3o90D_5bdbeY3Is/s1600/secure_storage_is_locked_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="161" data-original-width="475" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtIvnfE_9yRYLlaES22FF6dG3VzFw74s2gAaHJkibVCpfN9xACK19VTA37MJZ6LBvo9BNnoNULzmntPdIx3Hh49sIbG7-baBOJXSpsQ2dcAbMybsnrLcnsqyAKNc7h3o90D_5bdbeY3Is/s400/secure_storage_is_locked_2.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white; color: #444444; font-family: Arial, sans-serif; font-size: 14px; text-align: start;">We press on YES</span></div>
<div style="background: white; box-sizing: inherit; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-bottom: 6pt; margin-left: 0cm; margin-right: 0cm; word-break: break-word;">
<span style="color: #444444; font-family: Arial, sans-serif; font-size: 10.5pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOGsWqnbA3anCx8TLrKFICmhOLSePKSRUuK6v0-PJ-WdfRxqOnc25jKm6jhe8WeKW8Fl5Q_zQuaicM3cKFVNokiV7qkZA36Fn4J3GysjjfgD1gC8jjfdHdTJyvckyxFS9zw-SGRY26Z-0/s1600/secure_storage_is_locked_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="151" data-original-width="433" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOGsWqnbA3anCx8TLrKFICmhOLSePKSRUuK6v0-PJ-WdfRxqOnc25jKm6jhe8WeKW8Fl5Q_zQuaicM3cKFVNokiV7qkZA36Fn4J3GysjjfgD1gC8jjfdHdTJyvckyxFS9zw-SGRY26Z-0/s400/secure_storage_is_locked_3.png" width="400" /></a></div>
<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-48862196992788508072019-08-20T13:09:00.001-07:002019-08-20T13:09:48.155-07:00Info for the certification C_HANATEC_15<br />
Info for the certification C_HANATEC_15<br />
<br />
C_HANATEC_15<br />
SAP Certified Technology Associate - SAP HANA 2.0 (SPS03) <a href="https://training.sap.com/certification/c_hanatec_15-sap-certified-technology-associate---sap-hana-20-sps03-g/" rel="nofollow" target="_blank">Link</a><br />
<br />
HA200 – SAP HANA Installation & Operations based on SAP HANA 2.0 SPS03.<br />
HA201 – SAP HANA High Availability and Disaster Tolerance Administration based on SAP HANA 2.0 SPS03.<br />
HA215 – SAP HANA Using Monitoring Performance Tools based on SAP HANA 2.0 SPS03.<br />
HA240 – Authorization, Security and Scenarios based on SAP HANA 2.0 SPS03.<br />
HA250 – Migration to SAP HANA Using DMO based on SAP HANA 2.0 SPS02.<br />
<br />
<a name='more'></a><br /><br />
SAP HANA Administration Guide<br />
SAP HANA Platform 2.0 SPS 03<br />
<a href="https://help.sap.com/doc/eb75509ab0fd1014a2c6ba9b6d252832/2.0.03/en-US/SAP_HANA_Administration_Guide_en.pdf" rel="nofollow" target="_blank">Link</a><br />
<br />
SAP HANA Security Guide<br />
SAP HANA Platform 2.0 SPS 03<br />
<br />
<a href="https://help.sap.com/doc/eec734dbb0fd1014a61590fcb5411390/2.0.03/en-US/SAP_HANA_Security_Guide_en.pdf" rel="nofollow" target="_blank">Link</a><br />
<br />
<br />
How To Perform System Replicationfor SAP HANA <a href="https://www.sap.com/documents/2013/10/26c02b58-5a7c-0010-82c7-eda71af511fa.html" rel="nofollow" target="_blank">Link</a><br />
<br />
<br />
<br />
<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-27950648823732756522019-08-17T02:13:00.000-07:002019-08-17T02:13:06.035-07:00How to start or stop SAP HANA database<span style="font-weight: bold;">login as root:</span><br />
/usr/sap/hostctrl/exe/sapcontrol -nr 00 -function Start<br />
/usr/sap/hostctrl/exe/sapcontrol -nr 00 -function Stop<br />
/usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList<br />
<br />
<span style="font-weight: bold;">login as sidad:</span><br />
# su - hdbadm<br />
# ./HDB stop<br />
# ./HDB start<br />
# ./HDB --help<br />
usage: ./HDB { start|stop|reconf|restart|version|info|proc|admin|kill|kill-|term}<br />
<br />
<br />
/usr/sap/<SAPSID>/<Instance_Name>/HDB start<br />
/usr/sap/<SAPSID>/<Instance_Name>/HDB stop<br />
/usr/sap/HDB/HDB00> HDB info; netstat -nat<br />
<br />
<br />
<span style="font-weight: bold;"> Arrancar o parar tenant database desde SYSTEMDB</span><br />
ALTER SYSTEM START|STOP DATABASE CSNUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-84248702945976815582019-08-10T05:53:00.000-07:002019-08-10T05:53:52.439-07:00SAP HANA Best practices table partitioningSAP HANA Best practices table partitioning<br />
<br />
<br />
<ul>
<li>Keep the number of partitioned tables low.</li>
<li>Keep the number of partition per table low.</li>
<li>Keep the number of key columns low.</li>
<li>For SAP Business Suite on HANA, keep the partitions on same host.</li>
<li>Repartitioning aaa multiple or a division of current number of partitions.</li>
<li>No extra unique constrains.</li>
</ul>
<br />
<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-22401614280568102092019-07-29T01:38:00.000-07:002019-07-29T09:14:36.547-07:00How to create SAP HANA user using SQL Console<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUzf8HgU0LRVAI5JwRfJWhASyM6o4HU602-fDZNBZnR-lw2e5jPLZsURzmodT4tvi9KlYn9aAVfP0Rb5M03MwLaRw5ksmPpvBMaOcW1lRgYugyxk1tZQ2tlMzRdJddPIPEn64zn2X5f3s/s1600/SAP-consolida-su-nueva-estrategia.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="360" data-original-width="360" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUzf8HgU0LRVAI5JwRfJWhASyM6o4HU602-fDZNBZnR-lw2e5jPLZsURzmodT4tvi9KlYn9aAVfP0Rb5M03MwLaRw5ksmPpvBMaOcW1lRgYugyxk1tZQ2tlMzRdJddPIPEn64zn2X5f3s/s320/SAP-consolida-su-nueva-estrategia.jpg" width="320" /></a></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;"></span></span></span><br />
<a name='more'></a><span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;"><br /></span></span></span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;"><br /></span></span></span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;">CREATE USER SAP4EASY PASSWORD OALPassword; </span><span style="color: black;">//This wll create user SAP4EASY with password : OALPassword</span></span></span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="color: blue; font-family: "arial" , sans-serif; font-size: small;">CREATE USER SAP4EASY PASSWORD OALPassword NO FORCE_FIRST_PASSWORD_CHANGE; </span><span style="color: black; font-family: "arial" , sans-serif; font-size: small;">//This wll create user SAP4EASY with password : OALPassword without change password by user</span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;">GRANT SELECT ON SCHEMA SAPXYZ TO </span></span></span><span style="color: blue; font-family: "arial" , sans-serif; font-size: small;">SAP4EASY </span><span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;">; </span><span style="color: black;">//This will grant read access to </span></span></span><span style="color: black; font-family: "arial" , sans-serif; font-size: small;">SAP4EASY </span><span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: black;">schema to user</span></span></span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;">GRANT ABAP_ADMIN TO </span></span></span><span style="color: blue; font-family: "arial" , sans-serif; font-size: small;">SAP4EASY </span><span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;">; </span><span style="color: black;">//This will assign ABAP_ADMIN role to user</span></span></span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;">GRANT REPO.READ ON "oal-package" TO </span></span></span><span style="color: blue; font-family: "arial" , sans-serif; font-size: small;">SAP4EASY </span><span style="font-family: "arial" , sans-serif; font-size: small;"><span style="line-height: 24px;"><span style="color: blue;">; </span><span style="color: black;"> //This will give read access to package name 'oal-package ' to user.</span></span></span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="color: blue; font-family: "arial" , sans-serif; font-size: small;">GRANT EXECUTE ON REPOSITORY_REST TO </span><span style="color: blue; font-family: "arial" , sans-serif; font-size: small;">SAP4EASY </span><span style="color: blue; font-family: "arial" , sans-serif; font-size: small;">;</span><span style="font-family: "arial" , sans-serif; font-size: small;"> //This will give authorization to expand the "Content" folder to view the package.</span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="color: blue; font-family: "arial" , sans-serif; font-size: small;">ALTER USER SAP4EASY DISABLE PASSWORD LIFETIME; </span><span style="color: black; font-family: "arial" , sans-serif; font-size: small;">//Password without timelimite</span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="font-family: "arial" , sans-serif; font-size: small;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<span style="font-family: "arial" , sans-serif; font-size: small;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: "Lucida Grande", "Lucida Sans", Verdana, Arial, sans-serif; font-size: 13.3333px;">
<a href="https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.00/en-US/20d5ddb075191014b594f7b11ff08ee2.html">https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.00/en-US/20d5ddb075191014b594f7b11ff08ee2.html</a></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-59757232656767346382019-07-19T09:29:00.002-07:002019-07-19T09:29:38.650-07:00Display Schema List on SAP HANA Database<div style="background: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: black; font-family: Arial, sans-serif; font-size: 10pt;">SAP users can get the list of all schemas created on SAP HANA database with the schema owner name by executing SQL query on SYS.Schemas view.<u></u><u></u></span></div>
<div style="background: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: black; font-family: Arial, sans-serif; font-size: 10pt;"><br /></span></div>
<div style="background: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: black; font-family: Arial, sans-serif; font-size: 10pt;">Here is the SQLScript SELECT statement for database developers to display and return the list of all schemas on the HANA database.<u></u><u></u></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: black; font-family: "Courier New"; font-size: 8pt;">select</span><span style="color: black; font-family: "Courier New"; font-size: 8pt;"><br /><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"> schema_name,</span><br /><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"> schema_owner</span><br /><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">from sys.schemas;</span></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: black; font-family: "Courier New"; font-size: 8pt;"><br /><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">-- or using the public synonym</span></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: black; font-family: "Courier New"; font-size: 8pt;"><br /><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">select * from schemas;</span></span></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-35924216677911269762019-06-29T00:13:00.003-07:002019-06-29T00:14:22.436-07:00SAP BASIS - Starting and stopping SAP system instances - startsap/stopsap are deprecated<h3 style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 13.5pt; margin: 0cm 0cm 0.0001pt;">
<span style="color: #333333; font-weight: normal;">Symptom<u></u><u></u></span></h3>
<div style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #333333; font-family: "arial" , sans-serif;">The scripts </span><strong><span style="color: #333333; font-family: "arial" , sans-serif;">startsap</span></strong><span style="color: #333333; font-family: "arial" , sans-serif;"> and </span><strong><span style="color: #333333; font-family: "arial" , sans-serif;">stopsap</span></strong><span style="color: #333333; font-family: "arial" , sans-serif;"> <wbr></wbr>are deprecated and you need alternatives.<u></u><u></u></span></div>
<h3 id="m_-684098789242188428__title0-__layout4-1" style="background-color: white; box-sizing: border-box; color: #222222; display: inline-block; font-family: "Times New Roman", serif; font-size: 1.25rem; margin: 0cm 0cm 0.0001pt; max-width: 100%; overflow: hidden; text-overflow: ellipsis;">
<span style="color: #333333; font-weight: normal;">Environment<u></u><u></u></span></h3>
<div style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt;">Systems based on SAP NetWeaver 7.0 or higher</span><span style="color: #333333; font-family: "arial" , sans-serif;"><u></u><u></u></span></div>
<h3 id="m_-684098789242188428__title0-__layout4-2" style="background-color: white; box-sizing: border-box; color: #222222; display: inline-block; font-family: "Times New Roman", serif; font-size: 1.25rem; margin: 0cm 0cm 0.0001pt; max-width: 100%; overflow: hidden; text-overflow: ellipsis;">
<span style="color: #333333; font-weight: normal;">Cause<u></u><u></u></span></h3>
<div style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #333333; font-family: "arial" , sans-serif;">The scripts </span><strong><span style="color: #333333; font-family: "arial" , sans-serif;">startsap</span></strong><span style="color: #333333; font-family: "arial" , sans-serif;"> and </span><strong><span style="color: #333333; font-family: "arial" , sans-serif;">stopsap</span></strong><span style="color: #333333; font-family: "arial" , sans-serif;"> <wbr></wbr>used to start and stop SAP systems, are deprecated since April 2015.<u></u><u></u></span></div>
<div style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #333333; font-family: "arial" , sans-serif;">These scripts are no longer maintained, and should not be used.<u></u><u></u></span></div>
<h3 id="m_-684098789242188428__title0-__layout4-3" style="background-color: white; box-sizing: border-box; color: #222222; display: inline-block; font-family: "Times New Roman", serif; font-size: 1.25rem; margin: 0cm 0cm 0.0001pt; max-width: 100%; overflow: hidden; text-overflow: ellipsis;">
<span style="color: #333333; font-weight: normal;">Resolution<u></u><u></u></span></h3>
<div style="background-color: white; color: #222222; font-family: "Times New Roman", serif; font-size: 12pt; margin-left: 0cm; margin-right: 0cm;">
<span style="color: #333333; font-family: "arial" , sans-serif;">Instead of using </span><strong><span style="color: #333333; font-family: "arial" , sans-serif;">startsap</span></strong><span style="color: #333333; font-family: "arial" , sans-serif;"> or </span><strong><span style="color: #333333; font-family: "arial" , sans-serif;">stopsap</span></strong><span style="color: #333333; font-family: "arial" , sans-serif;">, use the SAP Management Console (</span><strong><span style="color: #333333; font-family: "arial" , sans-serif;">SAP MMC</span></strong><span style="color: #333333; font-family: "arial" , sans-serif;">) or the SAP command </span><strong><span style="color: #333333; font-family: "arial" , sans-serif;">sapcontrol</span></strong><span style="color: #333333; font-family: "arial" , sans-serif;">. </span></div>
<span style="background-color: white; color: #222222; font-family: "arial" , "helvetica" , sans-serif; font-size: x-small;"></span><span style="background-color: white; color: #222222; font-family: "arial" , "helvetica" , sans-serif; font-size: x-small;"></span><span style="background-color: white; color: #222222; font-family: "arial" , "helvetica" , sans-serif; font-size: x-small;"></span><br />
<ul style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; margin-bottom: 0cm;" type="disc">
<li class="MsoNormal" style="color: #333333; margin: 0px 0px 0px 15px;"><strong><u><span style="font-family: "arial" , sans-serif;">sapcontrol</span></u></strong><span style="font-family: "arial" , sans-serif;"><br /><br />Scripts startsap/stopsap use internally sapcontrol command to start and stop the SAP system, hence it is possible to use it manually.<br />Follow the syntax for sapcontrol call, corresponding to startsap/stopsap:<br /><br /> - In order to start the system, instead of using startsap, use:<br /><br /> <strong><i>sapcontrol</i></strong><em> -</em></span><em><span style="color: #993300; font-family: "arial" , sans-serif;">nr</span></em><em><span style="font-family: "arial" , sans-serif;"> <instance_<wbr></wbr>number> </span></em><em><span style="color: #993300; font-family: "arial" , sans-serif;">-function</span></em><em><span style="font-family: "arial" , sans-serif;"> </span></em><em><span style="color: green; font-family: "arial" , sans-serif;">StartSystem</span></em><i><span style="font-family: "arial" , sans-serif;"><br /></span></i><span style="font-family: "arial" , sans-serif;"> - In order to stop the system, instead of using stopsap, use:<br /><br /><em> </em><strong><i>sapcontrol</i></strong><em> -</em></span><em><span style="color: #993300; font-family: "arial" , sans-serif;">nr</span></em><em><span style="font-family: "arial" , sans-serif;"> <instance_<wbr></wbr>number> </span></em><em><span style="color: #993300; font-family: "arial" , sans-serif;">-function</span></em><em><span style="font-family: "arial" , sans-serif;"> </span></em><em><span style="color: red; font-family: "arial" , sans-serif;">StopSystem</span></em><i><span style="font-family: "arial" , sans-serif;"><br /></span></i><span style="font-family: "arial" , sans-serif;">For the complete option list of methods, run <strong>sapcontrol</strong> without any parameters options to see the available list.</span></li>
</ul>
<div>
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: x-small;"><br /></span></div>
<div>
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: x-small;"><br /></span></div>
<div>
<span style="background-color: white; color: #202124; font-family: "google sans" , "roboto" , "robotodraft" , "helvetica" , "arial" , sans-serif; font-size: 22px;">Note: 763593 - Starting and stopping SAP system instances - startsap/stopsap are deprecated</span></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-76772917818073141582019-06-25T11:35:00.004-07:002019-06-25T11:35:53.369-07:00Steps to retrive the SAP HANA Cockpit URLs<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
Steps to retrive the SAP HANA Cockpit URLs<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
1 . Use ssh to connect to the SAP HANA cockpit server as <b>SIDADM</b><u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<b><br /></b></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
2 . Logon to the XS Advanced with the command <b>xs login</b><u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; margin-left: 35.4pt;">
User name: cockpit_admin<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; margin-left: 35.4pt;">
Password: <Installation master password><u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; margin-left: 35.4pt;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
3 . List the XS Advanced applications with the command <b>xs apps</b><u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; margin-left: 35.4pt;">
The SAP HANA cockpit manager is listed as cockpit-admin-web-app<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; margin-left: 35.4pt;">
Teh SAP HANA cockpit is listed as cockpit-web-app</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1551816963727829149.post-67401447694622351872019-06-21T09:50:00.004-07:002019-06-21T09:50:57.137-07:00SAP SPAM--How to cleanup new support packages listGo to SPAM -> Environment -> Electronic Parcel Service -> Goto -> Inbox
Then you can put a check mark next to the support packages that you want to delete.
This removes the support package from the queue.Unknownnoreply@blogger.com0