SAP Knowledge Base Article - Preview

3494171 - SWPM fails to change SYS user password with error ORA-01031: insufficient privileges - NetWeaver

Symptom

  • brconnect -u / -c -f chpass -o SYS -p <password>
    BR0301E SQL error -1031 at location password_change-11, SQL statement:
    '/* BRCONNECT */ ALTER USER "SYS" IDENTIFIED BY "****************"'
    ORA-01031: insufficient privileges
    BR0832E Changing password for user SYS failed
  • In Br*tools trace brconnect fails to connect in SYSDBA MODE with error ORA-01017.
    BR0644I BR_TRACE: location db_connect-3, SQL statement:
    'CONNECT / IN SYSDBA MODE'
    BR0300I BR_TRACE: SQL code: -1017, number of processed rows: 0
  • The command sqlplus / as sysdba also fails with error ORA-01017 by user <sid>adm
    OS> sqlplus / as sysdba
    SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 9 11:39:03 2024
    Version 19.3.0.0.0
    Copyright (c) 1982, 2019, Oracle.  All rights reserved.
    ERROR:
    ORA-01017: invalid username/password; logon denied
  • <sid>adm user is in group dba but the database administrator (OSDBA) group is not dba


Read more...

Environment

SAP NetWeaver on Oracle database on Unix

Product

SAP ERP 6.0

Keywords

ORA-01031,-1031,ORA-01017,-1017,CONNECT / IN SYSDBA MODE,ALTER USER "SYS" IDENTIFIED BY , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.