sap-nw-abap-vagrant icon indicating copy to clipboard operation
sap-nw-abap-vagrant copied to clipboard

Published 20 hours ago • verified publisher icon sbcgua

password help

Open tufnanm opened this issue 5 years ago • 3 comments

Can you please let me know what is master password , password for sybnpl and npladm

tufnanm avatar Feb 18 '20 02:02 tufnanm

I guess it is either the standard Down1oad from the guide or the one specifies in install_nw.expect scripts. But I haven't event needed it - it is always easy to login with sudo su - npladm or execute a command from those users like sudo -i -u npladm startsap

sbcgua avatar Feb 18 '20 04:02 sbcgua

I was trying follow below steps as mentioned in link to improve performance. Can I do this after installation ? https://assets.cdn.sap.com/sapcom/docs/2019/09/32638f18-687d-0010-87a3-c30de2ffd8ff.pdf#pdfjs.action=download

I. OPTIMIZATION OF SAP ASE DATABASE DBA Cockpit - Set password for its database connection To use DBACOCKPIT, you need to set the user credentials of the database connection that DBACOCKPIT will use. To do so, follow the steps:

  1. Log into the SAP system with SAP GUI using the user DEVELOPER, client 001 and your password
  2. Call transaction DBCO
  3. Switch to the Change mode (Ctrl + F1)
  4. Select database connection +++SYBADM and click Goto → Details
  5. Enter the correct password of SAP ASE database user sapsa
  6. Hit the Save button (Ctrl + S)
  7. Switch to the View mode (Ctrl + F4) SAP ASE Granular Permissions The database of the SAP NetWeaver Developer Edition for SAP ASE is configured with granular permissions. This is the default setup for SAP ASE 16.0 SP03 running SAP NetWeaver. Since various parameters of the database are configured in a way to enable the usage of the SAP NetWeaver Developer Edition on small personal computers, you may experience a slow performance. If your use cases for the SAP NetWeaver Developer Edition do not require granular permissions being active and set up, you can improve performance by deactivating this option. You can achieve this by:
  8. Log into the operating system as user sybnpl
  9. Run the command isql -Usapsa -X -SNPL
  10. Run command sp_configure 'granular permission', 0
  11. Run the command go
  12. Run the command quit SAP ASE Auditing The database of the SAP NetWeaver Developer Edition for SAP ASE is configured in a way to keep an audit log of various activities on database level. This is the default setup for SAP ASE 16.0 SP03 running SAP NetWeaver. This audit log will accumulate and use up free space in the database. After some time this may mean that space needs to be freed up. In addition, you may not need to keep an audit log for your use cases. In this case, you can easily turn off auditing by following the steps:
  13. Log into the operating system as user sybnpl
  14. Run the command isql -Usapsa -X -SNPL
  15. Run command sp_configure 'auditing', 0
  16. Run the command go
  17. Run the command quit J.

tufnanm avatar Feb 18 '20 17:02 tufnanm

Hmmm, didn't try this. Not sure what to suggest, I'm not an expert in ASE :(

sbcgua avatar Feb 20 '20 15:02 sbcgua