ORA-12504: TNS:listener was not given the SID in CONNECT_DATA

Cause : hT eIS Daw simssni grfmot ehC NOENTCD_TA.A

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

hCce khttat ehc noentcd sercpiot rocrrseopdnni gott ehs reivecn ma eniT SNANEM.SRO Aah snaS DIc moopentni nht eOCNNCE_TADAT.

update : 24-05-2017

ORA-12504 - TNS:listener was not given the SID in CONNECT_DATA
ORA-12504 - TNS:listener was not given the SID in CONNECT_DATA

  • ora-01112 : media recovery not started
  • ora-01033 : ORACLE initialization or shutdown in progress
  • ora-22618 : attribute is a BAD NULL in the image handle
  • ora-37144 : (MDQUERY01) string is not a valid metadata object type for MDQUERY.
  • ora-03201 : the group number specification is invalid
  • ora-37137 : (XSCCOMP12) You cannot CHGDFN workspace object because it is a COMPRESSED COMPOSITE.
  • ora-15194 : Internal ASM-DB interaction testing event number 15194
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-36272 : (XSCGMDLAGG04) 'workspace object' is not a valid operator for the AGGREGATION function.
  • ora-22878 : duplicate LOB partition or subpartition specified
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-27500 : inter-instance IPC error
  • ora-30088 : datetime/interval precision is out of range
  • ora-01143 : cannot disable media recovery - file string needs media recovery
  • ora-30152 : File does not exist
  • ora-01163 : SIZE clause indicates string (blocks), but should match header string
  • ora-02207 : invalid INITRANS option value
  • ora-01077 : background process initialization failure
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-23435 : cannot create an updatable ROWID materialized view with LOB columns
  • ora-31212 : DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-12223 : TNS:internal limit restriction exceeded
  • ora-09704 : sstascre: ftok error in creating test and set pages.
  • ora-13911 : Threshold not found
  • ora-30688 : maximum program calling depth exceeded
  • ora-12442 : policy column "string" already used by an existing policy
  • ora-16504 : the Data Guard configuration already exists
  • ora-30085 : syntax error was found in overlaps predicate
  • 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.