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 : 25-09-2017

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

  • ora-31480 : staging database and source database cannot be the same
  • ora-02280 : duplicate or conflicting CYCLE/NOCYCLE specifications
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-29314 : tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
  • ora-12628 : TNS:no event callbacks
  • ora-08119 : The new initrans will make the index too big
  • ora-24906 : invalid recepient attribute passed into OCI call
  • ora-09793 : szguns: length of user name is greater than buffer.
  • ora-01617 : cannot mount: string is not a valid thread number
  • ora-00569 : Failed to acquire global enqueue.
  • ora-25473 : cannot store string in rule action context
  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • ora-30476 : PLAN_TABLE does not exist in the user's schema
  • ora-19715 : invalid format string for generated name
  • ora-02167 : LOGFILE clause specified more than once
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-22276 : invalid locator for LOB buffering
  • ora-02738 : osnpwrtbrkmsg: incorrect number of bytes written
  • ora-14156 : invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-31649 : Master process string violated startup protocol.
  • ora-14551 : cannot perform a DML operation inside a query
  • ora-00230 : operation disallowed: snapshot control file enqueue unavailable
  • ora-07703 : error in archive text: need '/' after device type
  • ora-28515 : cannot get external object definitions from string
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-37037 : (XSMLTDCL03) You cannot RENAME objects in analytic workspace string because it is attached in MULTI mode.
  • ora-15080 : synchronous I/O operation to a disk failed
  • ora-12406 : unauthorized SQL statement for policy string
  • ora-00133 : value of string is too long
  • 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.