Solution : https://service.sap.com/sap/support/notes/168243 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the setup of sysoper/sysdba authorization for users in Oracle databases post-9I version. For security, any internal user login must now utilize individual name/password authentication stored in ABAP Dictionary rather than OS-level group membership. To delegate sysdba or sysoper roles, the user must either be part of the designated OPER or ORA_DBA groups or, if excluded, create a password file especially for OS-level or remote operations. Implementations involve setting REMOTE_LOGIN_PASSWORDFILE, creating password files with orapwd, and issuing grants in Oracle using proper connection commands.
Key words :
orapwd file=$oracle_home/dbs/orapw password=<passwd> entries=10 5, $oracle_home/dbs/init<sid>, terms connect internalsysopersysdba reason, operating system group 'dba', allocating sysoper/sysdba authorization, connect sys/<passwd>, operating system level, aconnect <username>/<password>, connect <username>/<password>, ora_<sid>_dba
Related Notes :
| 480266 | Problems with the SYSDBA/SYSOPER/INTERNAL connect |