Oracle Error 12157
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
ORA-12157: TNS:internal network communication error This error can happen if the network files not generated properly.relink them using the below commands to fix the issue.cd $ORACLE_HOME/network/libmake -f ins_net_client.mk ntcontab.ocd $ORACLE_HOME/bingenclntshcd $ORACLE_HOME/rdbms/libmake -f ins_rdbms.mk installcd $ORACLE_HOME/sqlplus/libmake -f ins_sqlplus.mk install Posted by Naresh Miryala 5 comments: SanjaySeptember 8, 2011 at 11:06 PMI m facing the same https://community.oracle.com/community/developer/search.jspa?q=ORA-12157 problem... I tried this .. but its not working for me.. Is there any other solution[oracle@localhost ~]$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 8 23:06:51 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn sys/sys as sysdbaERROR:ORA-12157: TNS:internal network http://www.dbatutor.com/2011/01/ora-12157-tnsinternal-network.html communication errorReplyDeleteAnonymousOctober 21, 2011 at 6:58 PMThanks man. It worked for me.ReplyDeleterakesh sahuJuly 23, 2012 at 10:21 PMHi i followed the same above steps but still issue not resolved, please suggest me... -bash-3.1$ export ORACLE_SID=test-bash-3.1$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 23 22:05:08 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-12157: TNS:internal network communication errorReplyDeleterene chavezAugust 21, 2014 at 8:03 AMSQL> conn systemEnter password: ERROR:ORA-12157: TNS:internal network communication errorayuda pleaseReplyDeleteSridevi KoduruAugust 1, 2016 at 10:37 AMRegardsSridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8bPlease Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.ReplyDeleteAdd commentLoad more... Newer Post Older Post Home Sub
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle http://www.dba-oracle.com/t_troubleshooting_sql_net_connectivity_errors.htm Scripts Ion Excel-DB Don Burleson Blog
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=53081 Troubleshooting & diagnosing TNS SQL*Net connectivity errors Oracle Database Tips by Burleson Consulting There are a variety of common network connectivity error messages, and most DBA's have seen TNS error messages these at sometime in their careers. oracle error Here is just a small sample of possible TNS network connectivity-related errors: TNS-12545: Connect failed because target host or object does not exist ORA-12154: TNS: Could not resolve service name ORA-12157: TNS Internal network communication error In the simplest of terms, the Oracle*Net architecture is like peeling on onion, with one transport layers nested inside the inner oracle error 12157 payer. The lowest level of Oracle transport is TCP/IP (or rarely other protocols), where the packets are shipped between the servers. Steps to troubleshoot Oracle connectivity: Also see my notes on Oracle network tuning. To troubleshoot & diagnose Oracle connectivity problems, I like to start at the simplest, outermost level, and follow this checklist: Check with "ping" using the IP address ("ping 198.11.34.43") Check with "ping" using DNS name (e.g. "tnsping uranus") Try telnet to the IP on port 1521 (telnet 1.2.3.4 1521) Check with "tnsping" using TNS service name Invoke SQL*Plus from the OS command line "sqlplus fred@flintstone". If this fails, check to ensure that your listener has the flintstone service defined. Sign-on to SQL*Plus and connect with the TNS name ("connect fred/flintstome@service_name") Within SQL*Plus, try a select from table@remote_db_link Let's look closer as we peel away the layers of our onion. Server-level connectivity layer in TNS When the Oracle DBA creates their tnsnames.ora file to define remote databases they often specify the host name of the foreWeb and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | Question Most of my databases are on version 12.1 11.2 11.1 10.2 10.1 or lower Answer and see the results DBA Top 10 1 M. Cadot 35800 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. Hudspith 9200 10 A. Khan 4100 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47788Total active users2117Act. users last 24h9Act. users last hour1Registered user hits last week756Registered user hits last month6432 Go up ORA-12157: TNS:internal network communication error Next thread: High User I/O Prev thread: Removing Duplicate Rows (seeking optimal method) Message Score Author Date -bash-3.1$ uname -a Linux localhost.localdomain 2...... Real DBA Jul 23, 2012, 18:55 Hi, Never seen that problem before and am not t...... BenBart BartBen Jul 24, 2012, 02:04 Hi, Check the following link: http://blog.ro...... BenBart BartBen Jul 24, 2012, 02:07 Follow up by mail Click here Subject: ORA-12157: TNS:internal network communication error Author: Real DBA, India Date: Jul 23, 2012, 18:55, 1553 days ago Os info: Linux Oracle info: 10.2.0.1.0 Message: -bash-3.1$ uname -a Linux localhost.localdomain 2.6.18-53.el5 #1 SMP Wed Oct 10 16:34:02 EDT 2007 i686 i686 i386 GNU/Linux -bash-3.1$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 23 22:04:41 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn /as sysdba ERROR: