SAP Rename - HANA SID/nn / SAP SID

[PruthvirajGoud]

Hello Team 

We have struck into so many issues in HANA DB while rename the system sid and nn.

We have performed the RENAME -HANA DB SID/nn ,SAP SID
using HDBLCM we have done SYSTEM RENAME ,Started Database but not able to login to Studio.
then we have using SWPM to rename ASCS renamed and started successfully, then DB rename ,Then PAS renamed.
for PAS showing below GetProcessList

1) Currently Application are not connecting to DB.When we are starting the application showing below error going down , But RC=0000 is showing.
gcp-saps4s01:es1adm 372> sapcontrol -nr 20 -function GetProcessList

15.04.2025 21:14:04
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
disp+work, Dispatcher, YELLOW, DB connect without progress, 2025 04 15 21:12:42, 0:01:22, 26212
igswd_mt, IGS Watchdog, GREEN, Running, 2025 04 15 21:12:42, 0:01:22, 26213
gwrd, Gateway, YELLOW, Starting, 2025 04 15 21:13:31, 0:00:33, 26373
icman, ICM, GREEN, Running, 2025 04 15 21:13:31, 0:00:33, 26374
gcp-saps4s01:es1adm 373> sapcontrol -nr 21 -function GetProcessList

2)When we are checking in HANA DB , All services are running at OS level, We have searching and deep dive into server, got the some issue. (Attached screen shots).

2.1) connecting to HANA DB via hdbsql only, not able to connect via Studio.
hdxadm> hdbsql -n gcp-hdbs01 -u SYSTEM -p 23ASC_23H4N4_s4
-sh: hdbsql: command not found

hdxadm> ./hdbsql -n gcp-hdbs01 -u SYSTEM -p XXXXXXXXXX
* -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused {10.243.128.3:30015} (gcp-hdbs01:30015)) SQLSTATE: HY000

hdxadm> ./hdbsql -n gcp-hdbs01:38015 -u SYSTEM -p XXXXXXXXXXX

Welcome to the SAP HANA Database interactive terminal.

Type: \h for help with commands
\q to quit

hdbsql HDX=> \c
Connected to HDX@gcp-hdbs01:38015
hdbsql HDX=> \q

hdxadm> pwd
/hana/shared/HDX/hdbclient

hdxadm>

2.2) Unable to run fullsystem dump.

gcp-hdbs01:/hana/shared/HDX/exe/linuxx86_64/hdb/python_support # ./fullSystemInfoDump.py
./fullSystemInfoDump.py: line 3: $'Collecting support information like trace files, log files, ini files and put them into a ZIP file.\n Authors: markus.schubert@sap.com (d072579), stefan.grintz@sap.com (d045776), thomas.simenec@sap.com (d030044)\n': command not found
./fullSystemInfoDump.py: line 4: from: command not found
./fullSystemInfoDump.py: line 5: from: command not found
./fullSystemInfoDump.py: line 6: import: command not found
./fullSystemInfoDump.py: line 7: import: command not found
./fullSystemInfoDump.py: line 8: __version__: command not found
./fullSystemInfoDump.py: line 10: import: command not found
./fullSystemInfoDump.py: line 11: import: command not found
./fullSystemInfoDump.py: line 12: from: command not found
./fullSystemInfoDump.py: line 13: from: command not found
./fullSystemInfoDump.py: line 14: from: command not found
./fullSystemInfoDump.py: line 15: from: command not found
./fullSystemInfoDump.py: line 16: from: command not found
./fullSystemInfoDump.py: line 17: from: command not found
./fullSystemInfoDump.py: line 19: ALL_DAYS: command not found
./fullSystemInfoDump.py: line 21: syntax error near unexpected token `('
./fullSystemInfoDump.py: line 21: `class FSIDException(Exception):'
gcp-hdbs01:/hana/shared/HDX/exe/linuxx86_64/hdb/python_support # pwd
/hana/shared/HDX/exe/linuxx86_64/hdb/python_support
gcp-hdbs01:/hana/shared/HDX/exe/linuxx86_64/hdb/python_support #

2.3) Env files are effected , like HDB show ,HDB version is not showing we need to go to home dir HDB80 then ./HDB version only work.
hdxadm> ./HDB version
HDB version info:
version: 2.00.079.03.1738055130
branch: fa/hana2sp07
machine config: linuxx86_64
git hash: 0e3e2112213648d7e3a0e6fb9dc549defbfb9a24
git merge time: 2025-01-28 10:05:30
weekstone: 0000.00.0
cloud edition: 0000.00.00
compile date: 2025-01-28 10:21:49
compile host: ccde1gl4673
compile type: rel

hdxadm> ./HDB info
USER PID PPID %CPU VSZ RSS COMMAND
hdxadm 15158 15157 0.0 15260 6256 -sh
hdxadm 15347 15158 0.0 10444 4012 \_ /bin/sh ./HDB info
hdxadm 15389 15347 0.0 17856 3900 \_ ps fx -U hdxadm -o user:8,pid:8,ppid:8,pcpu:5,vsz:10,rss:10,args
hdxadm 1134 1 0.0 13856 3468 sapstart pf=/usr/sap/HDX/SYS/profile/HDX_HDB80_gcp-hdbs01
hdxadm 1141 1134 0.0 496024 106508 \_ /usr/sap/HDX/HDB80/gcp-hdbs01/trace/hdb.sapHDX_HDB80 -d -nw -f /usr/sap/HDX/HDB80/gcp-hdbs01/daemon.ini pf=/usr/sap/HDX/SYS/profile/HDX_HDB80_gcp-hdbs01
hdxcrypt 1170 1141 0.4 1543284 54448 \_ lss {Controller}
hdxadm 1173 1141 1.6 12251760 5357172 \_ hdbnameserver
hdxadm 1918 1141 0.8 6892312 507416 \_ hdbcompileserver
hdxadm 1921 1141 0.8 7121112 507056 \_ hdbpreprocessor
hdxadm 1963 1141 1.4 11648412 3245028 \_ hdbdocstore -port 38040
hdxadm 1966 1141 1.5 10028316 2151532 \_ hdbdpserver -port 38011
hdxadm 1969 1141 10.7 45292776 41126696 \_ hdbindexserver -port 38003
hdxadm 1973 1141 1.7 9834452 1694988 \_ hdbscriptserver -port 38004
hdxadm 1976 1141 1.4 10081688 1894016 \_ hdbxsengine -port 38007
hdxadm 3317 1141 0.8 7885024 619544 \_ hdbdiserver -port 38025
hdxadm 3320 1141 0.8 8168332 738852 \_ hdbwebdispatcher
hdxadm 3323 1141 0.4 884616 411356 \_ /hana/shared/HDX/xs/bin/xscontroller -Xmx128m -Xms64m -XX:ThreadStackSize=256 -XX:ReservedCodeCacheSize=64m -XX:MetaspaceSize=64m -XX:MaxGCThreads=2 -XX:MaxErrorQueueLength=1
hdxadm 4424 3323 0.0 1902616 422860 | \_ /hana/shared/HDX/xs/router/webdispatcher/sapwebdisp pf=/hana/shared/HDX/xs/controller_data/controller/router/webdispatcher/conf/sapwebdisp.pfl -f /hana/shared/HDX/xs/cont
hdxadm 3326 1141 2.3 893164 449704 \_ /hana/shared/HDX/xs/bin/xsexecagent -Xmx128m -Xms64m -XX:ThreadStackSize=256 -XX:ReservedCodeCacheSize=64m -XX:MetaspaceSize=64m -XX:MaxGCThreads=2 -XX:MaxErrorQueueLength=10
hdxadm 3331 1141 0.2 6764720 715124 \_ /hana/shared/HDX/xs/bin/xsuaaserver -Djava.util.logging.config.file=/hana/shared/HDX/xs/bin/../uaaserver/tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache
hdxadm 30755 1 0.0 4463768 37760 hdbrsutil --start --port 38003 --volume 3 --volumesuffix mnt00001/hdb00003.00003 --identifier 1744723644
hdxadm 29818 1 0.0 597068 34480 hdbrsutil --start --port 38001 --volume 1 --volumesuffix mnt00001/hdb00001 --identifier 1744723627
hdxadm 29041 1 0.0 582480 58712 /usr/sap/HDX/HDB80/exe/sapstartsrv pf=/usr/sap/HDX/SYS/profile/HDX_HDB80_gcp-hdbs01

2.4) from HANA Studio we are not able to connect to SYSTEMDB ,TENANT DB.

2.5 Permission :
gcp-hdbs01:/usr/sap/HDX/HDB80/gcp-hdbs01 # ll
total 44
-rw-r--r-- 1 hdxadm 79 2780 Apr 15 09:52 daemon.ini
-rw-r--r-- 1 hdxadm 79 234 Mar 14 2024 global.ini
-rw-r--r-- 1 hdxadm 79 285 Mar 11 2024 java_err.log
-rw-r--r-- 1 hdxadm 79 1216 Mar 11 2024 java_std.log
drwxr-x--- 2 hdxadm 79 4096 Apr 15 09:52 lock
drwxr-x--- 5 hdxadm 79 48 Nov 2 2023 log
-rwxr-x--- 1 hdxadm 79 207 Apr 15 08:26 sapprofile.ini
drwxr-x--- 2 hdxadm 79 233 Apr 15 09:52 sec
drwxr-x--- 3 hdxadm 79 61 Apr 15 09:52 tmp
drwxr-x--- 4 hdxadm 79 12288 Apr 16 10:55 trace
drwxr-x--- 4 hdxadm 79 66 Nov 2 2023 wdisp
-rw-r----- 1 hdxadm 79 277 Nov 2 2023 webdispatcher.ini
drwxr-x--- 4 hdxadm 79 34 Apr 15 08:27 work
gcp-hdbs01:/usr/sap/HDX/HDB80/gcp-hdbs01 # pwd
/usr/sap/HDX/HDB80/gcp-hdbs01
gcp-hdbs01:/usr/sap/HDX/HDB80/gcp-hdbs01 #