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-04-2017
ORA-12170

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

  • ora-09921 : Unable to get information label from connection
  • ora-04094 : table string.string is constraining, trigger may not modify it
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-30183 : invalid field width specifier
  • ora-25464 : ROWID not specified for table alias: string
  • ora-23533 : object "string"."string" can not be cached
  • ora-07394 : unable to append string to text file
  • ora-36276 : (XSCGMDLAGG06) The current operator does not need a weight variable.
  • ora-06422 : NETCMN: Error in sending data
  • ora-12815 : value for INSTANCES must be greater than 0
  • ora-13381 : table:string not found in network:string
  • ora-10656 : Table is in unusable state due to incomplete operation
  • ora-12013 : updatable materialized views must be simple enough to do fast refresh
  • ora-27206 : requested file not found in media management catalog
  • ora-12234 : TNS:Redirect to destination
  • ora-01781 : UNRECOVERABLE cannot be specified without AS SELECT
  • ora-30451 : internal error
  • ora-19755 : could not open change tracking file
  • ora-36875 : (XSTFDSC05) LIMITMAP is missing or is not a string literal.
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-30566 : Index maintainence clause not allowed for this command
  • ora-14104 : RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
  • ora-06130 : NETTCP: host access denied
  • ora-24048 : cannot create QUEUE_TABLE, user does not have access to AQ object types
  • ora-06432 : ssaio: Buffer Not Aligned
  • ora-12585 : TNS:data truncation
  • ora-30371 : column cannot define a level in more than one dimension
  • ora-12061 : invalid ALTER MATERIALIZED VIEW option
  • ora-22903 : MULTISET expression not allowed
  • ora-07274 : spdcr: access error, access to oracle denied.
  • 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.