ORA-19854: error obtaining connect string from target

Cause : Could not obtain the connect string from the target database

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

Check the accompanying errors.

update : 25-06-2017
ORA-19854

ORA-19854 - error obtaining connect string from target
ORA-19854 - error obtaining connect string from target

  • ora-24750 : incorrect size of attribute
  • ora-31457 : maximum length of description field exceeded
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-24438 : Invalid Authentication Handle specified.
  • ora-19255 : XQ0035 - too many declarations of string in imported schemas
  • ora-16703 : cannot set property while the database is enabled
  • ora-32131 : bind data type cannot be changed
  • ora-39128 : unexpected DbmsJava error number from statement string
  • ora-12481 : effective label not within program unit clearance range
  • ora-06024 : NETASY: VTM error
  • ora-30953 : XML minoccurs value (string) violated
  • ora-06447 : ssvpstp: Incorrect parameter passed to function call
  • ora-02197 : file list already specified
  • ora-39204 : No subsetting of tablespaces is allowed for transportable import.
  • ora-22898 : existing scope clause on "string" points to a table other than the one mentioned in the referential constraint
  • ora-00384 : Insufficient memory to grow cache
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-19125 : fn:exactly-one() called with a sequence containing zero or more than one item
  • ora-31444 : parameter error while acquiring lock on string
  • ora-18000 : invalid outline name
  • ora-00077 : dump string is not valid
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-29968 : No primary operator bindings found for ancillary binding #string
  • ora-12663 : Services required by client not available on the server
  • ora-16820 : Fast-Start Failover observer is no longer observing this database
  • ora-28030 : Server encountered problems accessing LDAP directory service
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-29959 : error in the execution of the string routine for one or more of the index partitions
  • ora-36668 : (XSDPART06) string is not a legal RANGE partition.
  • ora-08267 : destroy_ora_addr: cannot close nameserver
  • 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.