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 : 26-04-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-10652 : Object has on-commit materialized views
  • ora-09209 : sftget: error reading from file
  • ora-24193 : the property value exceeds the valid range string
  • ora-23492 : no new sites for extension request "string"
  • ora-08261 : ora_addr: cannot find name in nameserver
  • ora-38786 : Flash recovery area is not enabled.
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-00224 : control file resize attempted with illegal record type (string)
  • ora-16413 : Unsupported database type for ONDEMAND archivelog destinations
  • ora-22307 : operation must be on a user-defined type
  • ora-03217 : invalid option for alter of TEMPORARY TABLESPACE
  • ora-23421 : job number string is not a job in the job queue
  • ora-38763 : flashback not started; enabled threads have changed
  • ora-10633 : No space found in the segment
  • ora-38747 : corrupt before image (file# string, block# string)
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-00080 : invalid global area specified by level string
  • ora-12015 : cannot create a fast refresh materialized view from a complex query
  • ora-12448 : policy string not applied to schema string
  • ora-38733 : Physical size string less than needed string.
  • ora-31187 : Cannot Add Node 'string' (type='string') to Simple Type Node 'string'
  • ora-24234 : unable to get source of string "string"."string", insufficient privileges or does not exist
  • ora-36956 : (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
  • ora-28342 : integrity check fails on column key
  • ora-00367 : checksum error in log file header
  • ora-25245 : agent name cannot be specified if address is a single-consumer queue or an exception queue
  • ora-12689 : Server Authentication required, but not supported
  • ora-23612 : unable to find tablespace "string"
  • ora-16151 : Managed Standby Recovery not available
  • 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.