on 11-06-2012 6:01 PM
I ran follow commands in hdbadm user. now, how does "HDB info" looks like when it's running correctly?
here is how mine looks like:
imdbhdb:/usr/sap/HDB/HDB00> HDB info; netstat -nat
USER PID PPID %CPU VSZ RSS COMMAND
hdbadm 4402 4401 0.0 13728 2720 -sh
hdbadm 4658 4402 0.0 12744 1672 \_ /bin/sh /usr/sap/HDB/HDB00/HDB info
hdbadm 4684 4658 0.0 4788 848 \_ ps fx -U hdbadm -o user,pid,ppid,pcpu,vsz,rss,args
hdbadm 4290 1 0.0 42628 1824 sapstart pf=/usr/sap/HDB/SYS/profile/HDB_HDB00_imdbhdb
hdbadm 4306 4290 0.1 504952 158408 \_ /usr/sap/HDB/HDB00/imdbhdb/trace/hdb.sapHDB_HDB00 -d -nw -f /usr/sap/HDB/HDB00/imdbhdb/daemon.ini pf=/usr/sap/HDB/SYS/profile/HDB_HDB00_imdbhd
hdbadm 4150 1 0.0 285868 107284 /usr/sap/HDB/HDB00/exe/sapstartsrv pf=/usr/sap/HDB/SYS/profile/HDB_HDB00_imdbhdb -D -u hdbadm
and I don't see port 30015 listening when I run netstat -nat.
Any help is appreciated.
Thanks,
Well, It's working now.
I've been starting/stoping aws instance from AWS console but I think maybe it's not good practice to do stop instance from aws console every end-of-day.
I restarted hanadb instance from root user (# shutdown -r now) and it's working fine now.
Here is screenshot of HDB info and tcp ports when running correctly.
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sejin,
Based on your above screenshot, it does not appear to be HANA One instance. If you use HANA One, you only need to SSH once to the instance to set hdmadm (OS) password, start HANA, reset system (DB) password and open recommended ports (30015, 50013-50014). Subsequently, you do not need to do anything to start or stop HANA at AWS. They will come up or go down once you stop EC2 instance from EC2 console. If you use HANA One and want to keep running HANA, you do not need to stop or start EC2 instance but it will incur costs.
Regards,
Swapan
Hi Sejin,
Could you please let us know which step(s) you followed in the Quick Start Guide?
Regards,
Swapan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am sorry I don't think I followed Quick Start Quide.
I have followed from http://scn.sap.com/docs/DOC-28294 .
I was able to install and setup and connect from my studio and created new user and created databases etc
also, I was able to connect from my application no problem.
I was also stopping aws hanadb instance everyday at end-of-day and start back on next morning for about a week without any problem; until over this weekend.
also, I tried to run startsap or stopsap didn't work either. I get this when I run stopsap in the command line.
imdbhdb:/usr/sap/HDB/HDB00> stopsap
End program!
Starting with NGAP 2.0 the startsap/stopsap scripts will be removed
and is no more available.
For detailed information see Incompatible Change:
https://wiki.wdf.sap.corp/wiki/display/LeanByD/IC_0152
Thanks,
Hi Sejin,
SAP HANA One is for productive use cases and different from the link you sent. If you are looking for a productive grade HANA on public cloud with having performance, scalability, security considered, you can use SAP HANA One.
Before you start using, we request you to read . if you have any questions from SAP HANA One, please feel free to post questions here. Please monitor your instance from AWS EC2 console. If you do not need to keep running, please make sure you shut down and restart when you need to control the cost.
Regards,
Swapan
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.