24.8.11

SAP Note 26953 - SAPDBA: User/password problems

Symptom:

The user can no longer log on to the database with SAPDBA using the password that he choses.
In particular, entry by changing online/batch (password in protected file) no longer works, that is, the call: sapdba -check -u system < does not work!

Cause and prerequisites

The length of the string in the UNIX function getpass is limited on some BS and is unfortunately always read from the keyboard rather than STDIN!
The length restriction is determined in the MACRO: PASS_MAX, in the file /usr/include/limits.h!

Solution
There is an additional option with 3.0B or 2.2G -l (for long user_name), which makes the old transparent entry via STDIN and with long names possible again!
Here are the different procedures for using the password:
Examples
1.) BATCH:
'sapdba -check -l system < ', where contains the password of the SYSTEM user.
2.) ONLINE:
'sapdba -l system < '
3.) ONLINE:
'sapdba -l system', where SAPDBA processes the password in the foreground.
4.) ONLINE:
'sapdba -u system', where SAPDBA processed the password in the background.
5.) ONLINE or BATCH also permit the use of
OPS$ mechanisms:
'sapdba -u /', where the OPS$ must be in possession of the DBA roll.

No comments:

Post a Comment