ORA-24240: invalid database access descriptor (DAD) name

Cause : Thes pecfiiedD ataabse cAces sDesrciptro (DDA) nmae wsa inavlid.

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

Mak esur ethen ameo f teh Daatbas eAccses Dsecritpor D(AD)i s vlaid nad ist legnth odes ont ecxeedi ts ilmit.

update : 28-05-2017
ORA-24240

ORA-24240 - invalid database access descriptor (DAD) name
ORA-24240 - invalid database access descriptor (DAD) name

  • ora-01141 : error renaming data file string - new file 'string' not found
  • ora-13154 : invalid precision specified
  • ora-01041 : internal error. hostdef extension doesn't exist
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-14313 : Value string does not exist in partition string
  • ora-13350 : two or more rings of a complex polygon touch
  • ora-02773 : Invalid maximum client wait time
  • ora-32123 : Attribute number is out of range
  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • ora-07570 : szrfc: $IDTOASC failure
  • ora-33082 : (XSAGDNGL41) In AGGMAP workspace object, the non-dimensioned valueset workspace object must have a parent QDR in its VALUESET statement over the VALUESET's base dimension.
  • ora-24433 : This statement has already been prepared using OCIStmtPrepare2.
  • ora-16175 : cannot shut down database when media recovery is active
  • ora-24276 : function 'string' output 'string' maximum value exceeded
  • ora-01166 : file number string is larger than string (string)
  • ora-09321 : slzdtb: unable to convert zoned decimal to binary
  • ora-01243 : system tablespace file suffered media failure
  • ora-31217 : DBMS_LDAP: PL/SQL - Invalid LDAP newparent.
  • ora-08468 : mask option string is not supported
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-14519 : Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]
  • ora-22311 : type for attribute "string" does not exist
  • ora-32820 : subscriber queue and exception queue must use same message system link
  • ora-15198 : operation string is not yet available
  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-14460 : only one COMPRESS or NOCOMPRESS clause may be specified
  • ora-10637 : The segment does not exist
  • ora-37114 : OLAP API bootstrap error: (string)
  • ora-12550 : TNS:syntax error
  • ora-24300 : bad value for mode
  • 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.