I am trying to login to hdbsql tenant database using command line post a password change and it prompts me to manually update the password via a password confirmation prompt like:
hdbsql -i 02 -u SYSTEM -p Password123
You have to change your passwo...
Hi,
I am consistently getting the error hdbcli.dbapi.Error: (10, 'authentication failed') when I have $ in my password "Aditya$123". I am using standard hdbcli dbapi with the connection syntax as below:
self.dbConn = dbapi.connect(user=db_user, p...
Hi,
I am performing a refresh of a target SAP HANA 2.0 SPS4 database H47 from a source database H45 using data of the latter. Post refresh and recovery of the Systemdb, I noticed that the primary tenant name (which should be same as systemdb name) ...
Hi,
How can we find log backups created during a particular time interval? I am looking for a hdbsql command/query that can return the list of log backups created during a time interval t2-t1. Also I wish to copy the log backups generated in this i...
Hi,
It took some efforts to find the location of the HANA db binaries that my colleague had downloaded and extracted from market place at /home/mydir/Downloads/SAP_HANA_DATABASE. There was a HANA db installed on the Linux VM. Is it possible to find...
Thanks Dan, I was not giving the password within quotes in new password and confirmation. I think it is required for certain special characters. I am using SAP HANA 2.0 SPS3. Do you have any inputs on the original issue?Thanks,Aditya
Hi Dan van Leeuwen,Thanks for your inputs. But the issue with dot in password is only happening for tenant password and its confirmation prompt, which is very strange indeed, unless there is a document that specifies that limitation. We need SYSTEM u...
Hello Experts,Is there a tested way to either feed in the password and confirmation as per my initial request or a way to disable the SAP HANA from prompting for a password change for tenant again on logon via hdbsql. I have also noticed that if we m...
Hi Vivek, Still the prompt appears, pls refer detailed steps below:/usr/sap/TST/HDB02> hdbsql -i 02 -u SYSTEM -p Aditya1Welcome to the SAP HANA Database interactive terminal.Type: \h for help with commands \q to quit ...
Hi Vivek, I tried the steps but the prompt persists:/usr/sap/TST/HDB02> hdbsql -i 02 -u SYSTEM -p Aditya321Welcome to the SAP HANA Database interactive terminal.Type: \h for help with commands \q to quithdbsql TST=> alter system alter...