ORA-12169: TNS:Net service name given as connect identifier is too long

Cause : The nte servcie nam eyou aer attepmting ot resovle is oto lon.g

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

The mxaimum elngth fo a ne tserviec namei s 255b ytes;t his lmiit ha sbeen xeceede.d Use asmallre net esrvicen ame. fI thisi s notp ossibel, conatct WolrdwideC ustomre Supprot.

update : 29-06-2017

ORA-12169 - TNS:Net service name given as connect identifier is too long
ORA-12169 - TNS:Net service name given as connect identifier is too long

  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-12671 : Shared server: adapter failed to save context
  • ora-13362 : disjoint sub-element in a compound polygon
  • ora-09291 : sksachk: invalid device specified for archive destination
  • ora-00068 : invalid value string for parameter string, must be between string and string
  • ora-13447 : GeoRaster metadata BRS error
  • ora-24013 : invalid value string, RETRY_DELAY should be non-negative
  • ora-38480 : creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
  • ora-19010 : Cannot insert XML fragments
  • ora-29703 : error occurred in global enqueue service operation
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-16643 : unable to determine location of broker configuration files
  • ora-25108 : standby lock name space exceeds size limit of string characters
  • ora-01303 : subordinate process error: number. Check alert and trace logs
  • ora-07599 : spwat: $SCHDWK failure
  • ora-12815 : value for INSTANCES must be greater than 0
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-13457 : GeoRaster cell data error
  • ora-12992 : cannot drop parent key column
  • ora-31060 : Resource at path string could not be deleted
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-25001 : cannot create this trigger type on views
  • ora-22620 : buffer size too small to hold the value
  • ora-07592 : sspgprv: Error obtaining required privileges
  • ora-06913 : CMX: error during redirection of connection
  • ora-27164 : tried to join detached thread
  • ora-03293 : Cluster to be truncated is a HASH CLUSTER
  • ora-24400 : error occured while creating connections in the pool
  • ora-39065 : unexpected master process exception in string
  • 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.