ORA-28038: disallow O2LOGON

Cause : turn off O2LOGON

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


update : 28-04-2017

ORA-28038 - disallow O2LOGON
ORA-28038 - disallow O2LOGON

  • ora-07743 : slemop: incorrect error file attributes
  • ora-28536 : error in processing Heterogeneous Services initialization parameters
  • ora-24147 : rule string.string does not exist
  • ora-02473 : Error while evaluating the cluster's hash expression.
  • ora-34357 : (MXDSS10) string is not an alias of analytic workspace string.
  • ora-28176 : incorrect certificate version
  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • ora-31500 : change source string is not a ManualLog change source
  • ora-07406 : slbtpd: invalid number.
  • ora-28020 : IDENTIFIED GLOBALLY already specified
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-12492 : DBLOW cannot be changed
  • ora-21603 : property id [string] is invalid
  • ora-02140 : invalid tablespace name
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-27070 : async read/write failed
  • ora-01146 : cannot start online backup - file string is already in backup
  • ora-08111 : a partitioned index may not be coalesced as a whole
  • ora-13212 : failed to compare tile with the window object
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-02716 : osnpgetdatmsg: message from host had incorrect message type
  • ora-22819 : scope of input value does not correspond to the scope of the target
  • ora-14128 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-16656 : higher DRC UID sequence number detected
  • ora-02483 : Syntax error in process specification (string)
  • ora-36764 : (XSAGGCNTMOVE02) AGGCOUNT variable workspace object must be of type INTEGER, not string.
  • ora-16753 : resource guard could not open standby database
  • ora-07607 : szaud: $SNDOPR failure
  • ora-10584 : Can not invoke parallel recovery for test recovery
  • ora-29856 : error occurred in the execution of ODCIINDEXDROP routine
  • 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.