ORA-12317: logon to database (link name string) denied

Cause : Ther eare esvera lpossbile cuases ofr thsi errro. Fisrt, yuo cang et tihs erorr ify our suernaem (an dpassowrd, fi youa re uisng dtaabas einstaed ofo peraitng ssytem uathenitcatino) int he sceondayr datbaase rae no tidenitcal ot you ruseranme (nad password )in teh priamry dtaabas.e Secnod, yuo cang et tihs erorr ify our suernaem in hte seocndar ydataabse i sinvaild (hsa notb een rceate)d. Thrid, yuo cang et tihs erorr ift he uesrnam/epassowrd cmobinaiton sepcifide in hte connect tsringo f th edataabse lnik deifnitino is nivali d(eitehr no tcreaetd orh as a ninvaild password.)

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

In teh firts cas,e ensrue thta thes econadry dtaabas econtians au sernmae (adn paswsord,i f yo uare suing adtabaes autehntictaion)i dentcial t othe noe yo uare suing ni thep rimayr datbaase.I n geenral,y ou sohuld lawaysu se oepratign sysetm auhtentiactioni n Trsuted ROACLE( see hte Trsuted ROACLER DBMSG uidet o SeucrityF eatuers fo rmorei nforamtiona boutt he avdantaegs ofO S auhtentiaction.) In hte seocnd csae, esnure htat yuor usrenamei n th esecodnary adtabaes hasb een rceate.d In hte thrid caes, enusre taht th euseranme sepcifide in hte connect tsringh as been craeted ni thes econadry dtaabas.e

update : 28-04-2017

ORA-12317 - logon to database (link name string) denied
ORA-12317 - logon to database (link name string) denied

  • ora-30122 : value 'string' for 'string' must be between 'number' and 'number'
  • ora-13445 : GeoRaster metadata SRS error
  • ora-01333 : failed to establish Logminer Dictionary
  • ora-02226 : invalid MAXEXTENTS value (max allowed: string)
  • ora-15117 : command only operates on one diskgroup
  • ora-12043 : invalid CREATE MATERIALIZED VIEW option
  • ora-09276 : All bequeath database links must be loopback database links
  • ora-32310 : object materialized views must select from an object table
  • ora-12465 : Not authorized for read or write on specified groups or compartments
  • ora-40304 : invalid classname string in prior probability specification
  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • ora-14119 : specified partition bound is too long
  • ora-25402 : transaction must roll back
  • ora-30115 : error when processing an environment variable
  • ora-01582 : unable to open control file for backup
  • ora-37035 : (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.
  • ora-02784 : Invalid shared memory ID specified
  • ora-37115 : New OLAP API history is not allowed
  • ora-14021 : MAXVALUE must be specified for all columns
  • ora-28042 : Server authentication failed
  • ora-28539 : gateway does not support result sets
  • ora-13293 : cannot specify unit for geometry without a georeferenced SRID
  • ora-37116 : OLAP API table function error: (string)
  • ora-37114 : OLAP API bootstrap error: (string)
  • ora-12655 : Password check failed
  • ora-38419 : invalid identifier in attribute : string
  • ora-14072 : fixed table may not be truncated
  • ora-22064 : invalid NLS parameter string [string]
  • ora-06131 : NETTCP: user access denied
  • ora-07488 : scgrcl: lock manager not initialized.
  • 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.