Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ALEPH_DBA user: "insufficient privileges" / "invalid username/password"

    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:
    After installing new ARC version, ALEPH and ALEPH_DBA Oracle users get "insufficient privileges" or "invalid username/password".

    1. Util O/7/3 (Show Archiving Status) doesn't work:

    To continue you will need to enter ALEPH_DBA username/password.
    username/password:aleph_dba/aleph_dba
    SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 28 09:08:38 2014
    Copyright (c) 1982, 2011, Oracle. All rights reserved.
    idle> ERROR:
    ORA-01031: insufficient privileges
    idle> idle> ORA-01012: not logged on

    2. The backup for the archive doesn't work. See Additional Information below for detailed log.

    Cause:
    Change of Oracle user password not done through util y/8.

    Possibly, the case of the username/password. (See last sentence of Resolution below.)

    Resolution:
    Login as sys user:

    > sqlplus sys/oradba as sysdba

    And type this command:

    sys@ALEPH2n> ALTER USER aleph_dba IDENTIFIED BY aleph_dba; [User altered]

    If the username/password is being entered in in lowercase (aleph_dba/aleph_dba), try entering it in uppercase (ALEPH_DBA/ALEPH_DBA). (Case sensitive passwords are a default feature of newly created database since version 11g. See Additional Information #2 below.)

    Additional Information

    1. Message in the archive backup log:

    /exlibris/backup/logs/ora_archive_a3_Detail_140227_2302.log
    exec_backup_main 27-02-2014 23:02:02
    BKP_TYPE = ora_archive
    SLOT = a3
    BKP_USER = aleph
    BKP_DB = aleph-arc.aleph21
    BKP_UDIR = /exlibris/aleph/a21_1
    BKP_DIR = /exlibris/backup_files/
    RM_USER = aleph_dba
    ORACLE_HOME = /exlibris/app/oracle/product/11r2
    ORACLE_SID = aleph21
    HOST = aleph-arc
    OS = Linux
    su = /bin/su -f
    Recovery Manager: Release 11.2.0.3.0 - Production on Thu Feb 27 23:02:02 2014
    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-04005: error from target database:
    ORA-01017: invalid username/password; logon denied
    >>>rman_set_config ... bstatus=1
    >>> 27-02-2014 23:02:02
    >>>Error in rman_set_config ... bstatus=1
    <end log>

    2. Case sensitive passwords are a default feature of newly created database since version 11g. You can revert these setting by issuing an ALTER SYSTEM command:

    Connect to sqlplus as sysdba:

    > sqlplus / as sysdba

    to show the current status of the case sensitivity:
    SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    sec_case_sensitive_logon boolean TRUE

    To change the case sensitivity:
    SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

    System altered.

    If the SEC_CASE_SENSITIVE_LOGON is TRUE, the password needs to be entered with the precise mixed case letters as defined when the user was created.

    3. Article 000019082 ("Unable to add file to a Tablespace; insufficient privileges") is a similar case.

     

     

    Note: Ex Libris strongly recommends keeping your passwords secure based on the Ex Libris Password Management Policy.

    We recommend that the default passwords be changed to a complex combination and maintained.

    Cloud customers are assured that Ex Libris maintains passwords based on best practice in the industry.


    • Article last edited: 4/21/2014
    //Feedback