ORA-12440: insufficient authorization for the SYSDBA package

Cause : The ues of teh SYSDAB packgae reqiures teh LBACD_BA roel.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Grantt he LBCA_DBA orle tot he daatbase suer.

update : 17-08-2017
ORA-12440

ORA-12440 - insufficient authorization for the SYSDBA package
ORA-12440 - insufficient authorization for the SYSDBA package

  • ora-38503 : index already defined using the parameters
  • ora-16249 : Terminal apply failed to complete during failover
  • ora-01677 : standby file name convert parameters differ from other instance
  • ora-19001 : Invalid storage option specified
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-31102 : Already locked in exclusive mode. Cannot add lock.
  • ora-10932 : trace name context forever
  • ora-23398 : user name "string" at database link "string" does not match local user name "string"
  • ora-31500 : change source string is not a ManualLog change source
  • ora-04087 : cannot change the value of ROWID reference variable
  • ora-00446 : background process started when not expected
  • ora-25122 : Only LOCAL bitmap indexes are permitted on partitioned tables
  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-00399 : corrupt change description in redo log
  • ora-02147 : conflicting SHARED/EXCLUSIVE options
  • ora-25326 : Array string operation failed for message at index string
  • ora-16769 : the physical standby database is open read-only
  • ora-22056 : value [string] is divided by zero
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-36646 : (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.
  • ora-32059 : deadlock detected on mapping structures
  • ora-29399 : user string does not have privilege to switch to consumer group string
  • ora-13767 : End snapshot ID must be greater than or equal to begin snapsho ID.
  • ora-12152 : TNS:unable to send break message
  • ora-12653 : Authentication control function failed
  • ora-29276 : transfer timeout
  • ora-25204 : invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
  • ora-16030 : session specific change requires a LOG_ARCHIVE_DEST_n destination
  • ora-22286 : insufficient privileges on file or directory to perform string operation
  • ora-02493 : invalid file increment size in NEXT clause
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.