ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Cause : Th elitsenre rceeievd areuqes ttoe stbalihs ac onenctoin ot ad atbaas eoro thre sreviec. hTe ocnncet edscirptro rceeievd yb teh lsiteenr psecfiie da ISD ofr na isntacne u(sulalya dtaabsae nistnace )thta etihe rha sno tye tdyanmiacll yreigstreedw it hth elitsenre o rha sno tbene sattiacll ycofnigruedf ort hel isetne.r Tihs amy eb at emoprayr cnodiitons uc hasa ftre teh lsiteenr ahs tsaretd,b utb efroe hte adtaabsei nsatnc eha sreigstreedw it hth elitsenre.

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

-Wati am omnet nad rty ot cnonetc as ecnod itme . -C hekc wihchi nsatncse aer cruretnlyk nonw b yth elitsenre b yexceutnig:l sncrtls erivce s -C hekc taht hte ISD apraemte rint hec onenctd esrcipotr psecfiie sani nsatnc eknwon yb teh lsiteenr. - hCec kfo rane vetn i nth elitsenre.lgo flie.

update : 23-04-2017
ORA-12505

ORA-12505 - TNS:listener does not currently know of SID given in connect descriptor
ORA-12505 - TNS:listener does not currently know of SID given in connect descriptor

  • ora-16786 : resource guard cannot access Data Guard broker metadata
  • ora-12550 : TNS:syntax error
  • ora-16531 : unable to post message
  • ora-01495 : specified chain row table not found
  • ora-13269 : internal error [string] encountered when processing geometry table
  • ora-12687 : Credentials expired.
  • ora-14512 : cannot perform operation on a clustered object
  • ora-24365 : error in character conversion
  • ora-01655 : unable to extend cluster string.string by string in tablespace string
  • ora-16050 : destination exceeded specified quota size
  • ora-26680 : object type not supported
  • ora-22311 : type for attribute "string" does not exist
  • ora-22874 : attribute "string" is not part of the type "string"
  • ora-22282 : non-contiguous append to a buffering enabled LOB not allowed
  • ora-28590 : agent control utility: illegal or badly formed command
  • ora-25304 : Cannot use priority order queues for capture LCRs
  • ora-12990 : duplicate option specified
  • ora-00228 : length of alternate control file name exceeds maximum of string
  • ora-35074 : (QFHEAD02) EIF file string cannot be read by this version of string.
  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-01185 : logfile group number string is invalid
  • ora-26091 : requested direct path operation not supported
  • ora-29812 : incorrect object name specified
  • ora-36802 : (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
  • ora-13613 : The requested operation is not supported for this advisor object.
  • ora-25151 : Rollback Segment cannot be created in this tablespace
  • ora-31192 : Resource string has not been checked out
  • ora-24383 : Overflow segment of an IOT cannot be described
  • ora-29825 : invalid name for indextype
  • ora-01890 : NLS error detected
  • 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.