SAP Note 480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/480266 (SAP Service marketplace login required)

Summary :
When attempting to establish a database connection using privileged modes such as "CONNECT INTERNAL", "CONNECT/AS SYSDBA", or "CONNECT / AS SYSOPER" in SAP environments, users may encounter errors such as ORA-01017, ORA-01031, and others, indicating issues like invalid credentials or insufficient privileges. These connection types rely on operating system group memberships (e.g., UNIX's dba or WINDOWS' ORA__DBA groups) rather than Oracle's data dictionary entries. Resolving these errors typically involves ensuring that the operating system user belongs to the correct groups as these are fundamental for authenticating SYSDBA or SYSOPER roles. Additionally, sapdba roles must also correctly configure to overcome related instance status errors.

Key words :
relevant local groups ora_<sid>_dba, calling operating system user belongs, domain user <domain>\<sid>adm, relevant fix apar iy22458, create audit trail fileora-09817, incorrectly set nls parameters, means ora_<sid>_oper, <sid>adm/sapservice<sid>, slightly restricted sysoper privileges, $oracle_home/rdbms/lib directory

Related Notes :

625222connect with sqlplus takes a long time on Windows 2000
614036Composite SAP Note: ORA-12631/ORA-12638
602843Environment settings for R/3/Oracle on UNIX
595874Failure of domain controller causes Oracle failover
583861UNIX: Errors due to Oracle executable
562863FAQ: Logon mechanisms
554112Important Changes in Oracle9i
445038Problems when accessing Net8 configuration files
417561Connect internal in Windows of 2000 domain
403269AIX: Database can not be started, startsap hangs
175636cannot startup Oracle (with no/meaningless error(s))
168243Assigning sysdba and sysoper authorizations
148535Database backup fails with RMAN-04005/ORA-01031
97953UNIX: Relinking of the Oracle executables