Internal Network Communication Error
Things Small and Medium Business Service Providers All Solutions Services Advise, Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management Software Application Lifecycle Management Application Delivery Management Big Data Analytics DevOps Enterprise Security Hybrid and Private Cloud Information Governance Information Management IT Service Management Operations Management Server Management Software as a Service (SaaS) Software-Defined Data Center Storage Management All Software Servers Rack Servers Tower Servers Blade Servers Density Optimized Mission Critical Servers Servers for Cloud Server Management All Servers Storage All-flash and Hybrid Storage Midrange and Enterprise Storage Entry Storage Systems Data Availability, Protection and Retention Software Defined Storage Management and Orchestration Storage Networking All Storage Networking Switches Routers Access Points and Controllers Wireless LAN Campus and Branch Networking Data Center Networking Wide Area Network Software Defined Networking Network Functions Virtualization Network Management All Networking About UsSupportClearType to search2086159Solutions Transform to a Hybrid Infrastructure Protect Your Digital Enterprise Empower the Data-Driven Organization Enable Workplace Productivity Cloud Security Big Data Mobility Infrastructure Internet of Things Small and Medium Business Service Providers All Solutions Services Advise, Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Inf
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 Scripts Ion Excel-DB Don Burleson Blog
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 https://community.hpe.com/t5/Data-Protector-Practitioners/12-1165-Internal-Database-network-communication-error/td-p/5219530 in their careers. 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 http://www.dba-oracle.com/t_troubleshooting_sql_net_connectivity_errors.htm layers nested inside the inner 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 datthese days. It seems every time you do you risk offending someone. Tag me stupid, baby! seemed more than a little relevant. The comments associated with some high-profile blogs only serve to depress me more. It's like the pedants and PC freaks have https://oracle-base.com/blog/2005/07/28/tns-12157-tnsinternal-network-communication-error/ come out in force lately. I don't know what the answer is and I'm sure, http://psoug.org/oraerror/ORA-12157.htm like everyone else, I am part of the problem, but I think everyone should take a step back from the keyboard and chill out! I'm not sure how I'm going to approach my next posts as my enthusiasm has died a little due to all this. Remember, this post is not about you, it's not a criticism of you and if you internal network take it that way you are merely proving my point. Cheers Tim… Author: Tim... I DBA, Developer, Author, Trainer. View all posts by Tim... Author Tim...Posted on July 28, 2005June 14, 2006Categories Oracle, Random 7 thoughts on “TNS-12157 TNS:internal network communication error” Bill S. says: July 28, 2005 at 2:24 pm Tim, I think the problem is that it's hard to gauge someone's intent when you can't see them. I am always afraid of offending someone inadvertently internal network communication simply by the way I phrased something (as you probably already know ;-D). Additionally, there are those folks out there (you KNOW who you are ;-D) who are simply masters of the double entendre (sp?). You look at what they wrote and immediately see 2 different meanings - but which one did they REALLY mean? There's also the speed factor - it takes about .25 seconds to hit the enter key - but you can agonize over what got sent for a loooong time. A little forethought goes a long way. Now if I could just practice what I preach….. 😀 Tim... says: July 28, 2005 at 9:23 pm I know what you're saying. If I know I'm in a bad mood I make sure I reread messages before sending them, making sure to remove some of the venom. My real problem is when I'm in a good mood I make flippant comments without thinking (I do this in conversation also), but on the forums they come back to haunt me. Such is life 🙂 Aman Sharma says: July 29, 2005 at 5:16 am /*I'm not sure how I'm going to approach my next posts as my enthusiasm has died a little due to all this. */ don't let it happen Sir,your blog is one of the most happening blogs and I simply love your style of writting.IMHO a
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-12157 Error Description: TNS:internal network communication error Error Cause: Internal error during network communication. Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 74 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?