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-07-2017

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

  • ora-16081 : insufficient number of processes for APPLY
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-33315 : (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
  • ora-23317 : a communication failure has occurred
  • ora-27473 : argument string does not exist
  • ora-38480 : creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
  • ora-19770 : invalid change tracking file name
  • ora-01034 : ORACLE not available
  • ora-09270 : szalloc: error allocating memory for security
  • ora-09817 : Write to audit file failed.
  • ora-25236 : buffer too small for user data
  • ora-16012 : Archive log standby database identifier mismatch
  • ora-06308 : IPA: No more connections available
  • ora-31498 : description and remove_description cannot both be specified
  • ora-04034 : unable to shrink pool to specified size
  • ora-31643 : unable to close dump file "string"
  • ora-19568 : a device is already allocated to this session
  • ora-35180 : (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}
  • ora-30657 : operation not supported on external organized table
  • ora-02832 : Segment deallocation failed - segment not on list
  • ora-10634 : Segment is already being shrunk
  • ora-19613 : datafile string not found in backup set
  • ora-12700 : invalid NLS parameter value (string)
  • ora-08341 : On nCUBE, this command can only be executed from instance 1.
  • ora-12544 : TNS:contexts have different wait/test functions
  • ora-02173 : invalid option for DROP TABLESPACE
  • ora-00475 : TRWR process terminated with error
  • ora-29874 : warning in the execution of ODCIINDEXALTER routine
  • ora-01539 : tablespace 'string' is not online
  • ora-01690 : sort area size too small
  • 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.