SAP HANA 2.0 Cockpit Installation and Configuration

Recently for testing purpose, I have installed SAP HANA 2.0 Cockpit on my Google Cloud Virtual Machine by following the below steps –

SAP HANA 2.0 Cockpit InstallationSAP HANA 2.0 Cockpit Installation

SAP HANA Cockpit install with the HANA DB which also requires by default mount point – /hana/shared

However i have also summarised the below steps which are useful for a newbie to install the same –

1. Download SAP HANA Cockpit 2.0 from SAP Support Portal
2. SAP HANA Cockpit come with SAP HANA DB & can be install on separate system
3. UNCAR the SAR file of SAP HANA Cockpit & Install with ./hdblcm command
4. Default Port for SAP HANA Cockpit – 51029
5. Default Port for SAP HANA XSA – 330 – i.e. – 39630
6. Default Instance Number for SAP HANA Cockpit – 96
7. Default first time user login in HANA Cockpit – COCKPIT_ADMIN with Master Password (Created during installation)
8. SAP HANA Cockpit installation use default installation directory – /hana/shared

Note – Default Installation Directory can be change by adding extra parameter while running ./hdblcm

However when i ran ./hdblcm, i got the below error as SIGNATURE.SMF file is missing in the installation directory.

File ‘SIGNATURE.SMF’ cannot be found in the SAP HANA Database installation kit. To include the signature when extracting the installation kit from a .SAR archive, use the SAPCAR option: -manifest SIGNATURE.SMF You can ignore this error and continue with the execution by passing the ignore option ‘check_signature_file’ to hdblcm, started as root. See SAP note 2078425, section ‘How to prepare SAP HANA packages for installation or update’ for instructions how to prepare packages for update or implications of ignoring this error.

Then i followed the above given SAP Note & ignore the file by passing the below command –

./hdblcm -sh –ignore=check_signature_file

Above is the workaround, I would suggest to extract the SIGNATURE.SMF file as per SAP Note & run the installation.

Once I have successfully installed the SAP HANA Cockpit, installer given me below 2 URL to access the same.

Launch SAP HANA cockpit by opening https://hanabox1.us-east1-b.c.hana-273005:51027
Launch SAP HANA cockpit manager by opening https://hanabox1.us-east1-b.c.hana-273005.internal:51029

However as I am running the Cockpit in Google Cloud VM with Public IP, i want to access the same from outside world & I changed the above hostname with Google Public IP but still page is not opening & throwing the error – “Can’t reach the Page”

I tried by both ports – SAP HANA Cockpit & XSA URL but both are failing.

While digging into more in the system I have identified that there is an change requires in XSCONTROLLER.INI file on below location –

/usr/sap/SID/SYS/global/hdb/custom/config

Make a copy of xscontroller.ini & change the below 2 parameter by giving your PUBLIC IP –

default_domain = PUBLIC IP
api_url = https://PUBLIC IP:39630

save the file & restart the HANA instance.

Please Note – I am using Dynamic Public IP so whenever I shut down & start the Google Cloud VM, it change the Public IP & I need to update the same again.

Once it’s start successfully, wait for sometime & check the XSA URL

https://PUBLIC IP:39630

Voila… Page is now opening & now you can login to HANA Cockpit & Manage your HANA DB’s.

SAP HANA Cockpit XSA
Page

Let me know if you find this useful.

Google Cloud Associate Engineer Certification

Recently I have prepared for GCP Associate Cloud Engineer exam and passed. Here are some of by observations –

• Exam questions are quite tricky not so much tough but basic knowledge of GCP should be there, some of the questions are really requires more attention as answers are really close to each other with some wording difference — take your time to read the question properly then respond.

• As Google FAQ said that some of the questions are not marked, they are just trial questions but actually you don’t know which one is trial so better to focus on the questions & make your attempt successful.

• There are also scenario-based questions which requires your knowledge to understand & respond.

• Topics mentioned in the exam details on Google site were covered. GCE, IAM, Google Groups, Copy Roles, GKE / App Engine, Cloud Storage (for Archiving – Coldline), Deployment Manager, KMS, Traffic Splitting VPC, gcloud commands, BigQuery & BigTable etc.

• I have an work experience on SAP BASIS & also working on cloud SAP projects, now this has been an added advantage for me to understand the cloud concepts however I had to learn a lot & also do hands on experience on Google Cloud.

• I have learned through Google official documentation for understanding the GCP concepts. It’s very comprehensive guide but obviously it’s requires hands on experience too because you don’t know when it goes deeper & wider.

• The self assessment tests given on Google official site is only for giving you a fair idea where you stand but doesn’t mean that you are ready to pass the exam. You have to go through each & every topic which mentioned in the official exam guide.

• Once you complete the test in the end you will get the provisional result indicating whether you passed or failed. Once you passed, within a day or so, you will get an official email from Google with Certification link.

• Like for any other exams, there is no break in this too. if you take break then it will minus from your exam time.

• Resources for learning –

o Google official documentation
o Udemy / Cloudera
o Braincert (for Practice exams)

Learning Resources

https://cloud.google.com/certification/cloud-engineer
• GCE: https://cloud.google.com/compute/docs/faq
• App Engine: https://cloud.google.com/appengine/kb/
• Google IAM: https://cloud.google.com/iam/docs/faq
• gcloud: https://cloud.google.com/sdk/gcloud/
• gcloud command reference: https://cloud.google.com/sdk/gcloud/reference/
• Storage FAQs: https://cloud.google.com/storage/docs/faq
• Cloud SQL FAQs: https://cloud.google.com/sql/faq
• gsutil command reference: https://cloud.google.com/storage/docs/gsutil (refer to gsutils Commands section)
• bq CLI reference: https://cloud.google.com/bigquery/docs/reference/bq-cli-reference
• Free Tier FAQs: https://cloud.google.com/free/docs/frequently-asked-questions
• Support: https://cloud.google.com/support/docs/
• Selecting storage options:https://cloud.google.com/images/storage-options/flowchart.svg
• GCP mapping to AWS & Azure:https://cloud.google.com/free/docs/map-aws-google-cloud-platform
https://cloud.google.com/free/docs/map-azure-google-cloud-platform
• Google Cost Calculator & Comparison: https://cloud.google.com/products/calculator/
https://cloud.google.com/pricing/#calculators
• 3rd Party Online Cost Comparison Websites:
https://calculator.unigma.com/
https://www.cloudorado.com/
• Practice Test:https://cloud.google.com/certification/practice-exam/cloud-engineer

Wish you the very best with your GCP certification. You can reach out to me for SAP BASIS or GCP short time consulting.