on 2018 Jun 26 1:55 PM
for some script i wanted to find HANA sid and instance number from the server as a root user, is there any way to find it ?
Request clarification before answering.
Please check this table: "SYS"."M_SYSTEM_OVERVIEW"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear customer,
You could use following OS command to find all HANA sid users.
cat /etc/passwd |grep HANA
Moreover, for HANA system instance number, you could refer to the folder name of your HANA system.
e.g.
/usr/sap/<SID>/HDB<instance number>
Best Regards,
Eason Chen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT * FROM SYS.M_SYSTEM_OVERVIEW;
From this sql command you will get the sid user ,instance number,current patch ...etc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT * FROM SYS.M_SERVICES
Derive instance number from sql port , if sql port is 34015 then instance number is 40.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
59 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.