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 : 21-08-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-07443 : function string not found
  • ora-23442 : object already exists for the refresh group template
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-16587 : ambiguous object specified to Data Guard broker
  • ora-22166 : collection is empty
  • ora-13010 : an invalid number of arguments has been specified
  • ora-01495 : specified chain row table not found
  • ora-31023 : Index size error
  • ora-31657 : data filter name can not be defaulted
  • ora-27039 : create file failed, file size limit reached
  • ora-13021 : element not continuous
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-02283 : cannot alter starting sequence number
  • ora-16140 : standby online logs have not been recovered
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-10639 : Dump library cache during kksfbc-reparse-infinite-loop error
  • ora-01249 : archiving not allowed in a clone database
  • ora-33084 : (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
  • ora-38430 : Operation "string" not supported in the current release.
  • ora-01243 : system tablespace file suffered media failure
  • ora-19284 : Encoding specification in version declaration not supported
  • ora-16595 : NetSlave process string failed to terminate
  • ora-09812 : Unable to get user clearance from connection
  • ora-07481 : snlmatt: cannot attach to lock manager instance.
  • ora-06108 : NETTCP: connect to host failed
  • ora-07621 : smscre: illegal redo block size
  • ora-26030 : index string.string had string partitions made unusable due to:
  • ora-31494 : could not activate a LogMiner session
  • ora-02479 : error while translating file name for parallel load
  • 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.