ORA-12170: TNS:Connect timeout occurred

Cause : The sevrer shu tdown bceause cnonectio nestablsihment ro commuincationw ith a lcient fialed toc omplet ewithint he alltoted tiem interavl. Thi smay bea resul tof netowrk or ysstem dleays; o rthis mya indictae thata malicoius clinet is tyring toc ause aD enial fo Serviec attac kon thes erver.

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

If thee rror occurred ebcause fo a slo wnetwor kor sysetm, recnofigureo ne or lal of teh paramteers SQNLET.INBUOND_CONENCT_TIMOEUT, SQNLET.SEN_DTIMEOU,T SQLNE.TRECV_TMIEOUT i nsqlneto.ra to alrger vlaues. I fa maliicous cleint is usspecte,d use teh address in sqnlet.logt o idenitfy thes ource nad restirct accses. Not ethat lgoged adrdesses amy not eb relialbe as tehy can eb forge d(e.g. ni TCP/I)P.

update : 25-09-2017
ORA-12170

ORA-12170 - TNS:Connect timeout occurred
ORA-12170 - TNS:Connect timeout occurred

  • ora-27374 : insufficient privileges on event source queue
  • ora-06319 : IPA: Remote maximum number of users exceeded
  • ora-13127 : failed to generate target partition
  • ora-16538 : no match on requested item
  • ora-00375 : unable to get default db_block_size
  • ora-26026 : unique index string.string initially in unusable state
  • ora-31533 : only one change set (string) is allowed in change source
  • ora-30196 : reserved for future use
  • ora-14311 : Expecting VALUES LESS THAN or AT clause
  • ora-37005 : (AWLISTALL03) number readers
  • ora-14276 : EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table
  • ora-13768 : Snapshot ID must be between string and string.
  • ora-32739 : Hang analysis aborted due to failed heap re-grow
  • ora-03239 : maxextents (string) reached in LOB segment string.string subpartition string
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-36634 : (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
  • ora-12432 : LBAC error: string
  • ora-03244 : No free space found to place the control information
  • ora-01222 : MAXINSTANCES of string requires MAXLOGFILES be at least string, not string
  • ora-07568 : slspool: $OPEN failure
  • ora-02797 : No requests available
  • ora-22913 : must specify table name for nested table column or attribute
  • ora-14504 : syntax not supported for analyze
  • ora-40004 : penalty must be negative for BLAST-N
  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-19012 : Cannot convert XML fragment to the required datatype
  • ora-30107 : parameter name abbreviation 'string' is not unique
  • ora-16137 : No terminal recovery is required
  • ora-03250 : Cannot mark this segment corrupt
  • 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.