Oracle Error Message 3511
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business
3509:message Not Found Telus
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation tns-12557: tns:protocol adapter not loadable Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like tns-03502 insufficient arguments you, helping each other. Join them; it only takes a minute: Sign up Trouble setting Enivronment variable ORACLE_HOME up vote 0 down vote favorite I have a fresh installation of Oracle 11g client. I am having trouble using https://heliosguneserol.com/2014/02/14/message-3511-not-found-no-message-file-for-productnetwork-facilitytnstns-03505-message-3505-not-found-no-message-file-for-productnetwork-facilitytns/ tnsping. It is giving an error: Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-0 05: Message 3505 not found; No message file for product=NETWORK, facility=TNS I have set the Environment variable for ORACLE_HOME as follows: D:\oracle\product\11.2.0\client_1\BIN I am not sure what should be exact path for ORACLE_HOME . How to identify what is the exact path for ORACLE_HOME directory? Is it D:\oracle\product\11.2.0\client_1 ? or D:\oracle\product\11.2.0\client_1\BIN Any suggestions or solutions ? oracle11g database-connection tnsping http://stackoverflow.com/questions/22931440/trouble-setting-enivronment-variable-oracle-home share|improve this question edited Jan 8 '15 at 0:30 JasonMArcher 6,26183744 asked Apr 8 '14 at 8:21 Sai Avinash 2,89093665 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted Your ORACLE_HOME should be D:\oracle\product\11.2.0\client_1, assuming that is where you installed the software. The BIN directory under it should be in PATH. Read more about ORACLE_HOME The value should be set in the registry by the installer, along with other environment variables that have to be set manually in Unix. share|improve this answer edited Apr 8 '14 at 9:14 answered Apr 8 '14 at 9:08 Alex Poole 86.9k55993 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged oracle11g database-connection tnsping or ask your own question. asked 2 years ago viewed 2414 times active 1 year ago Related 0SP2-0750: You may need to set ORACLE_HOME2IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer1Oracle not available 11g R21Exception: ORA-12154: TNS:could not resolve the connect identifier spec
LinksContact Our NotesHope this helps! We've been writing websites and scripts commercially since 1999 and using this website to store notes as we go along. No need to sign up or generate enough points to post, if you know the answer, just post it.What http://www.joellipman.com/articles/sql/oracle-sql/fix-oracle-tnsping-3511-without-windows-registry.html we learn we share for free, why? because someone else taught us for free... Thank you OpenSource! ArticlesSQLOracle PL/SQLRokStoriesModule Word Cloud Oracle PL/SQL Fix Oracle Tnsping 3511 without Windows Registry Posted on Mar 04, 13 at 11:03 AM Category: Oracle PL/SQL Applies to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits not found on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file for product=NETWORK, facility=TNSMessage 3513 n ot found; No message file for product=NETWORK, facility=TNSMessage 3509 not foun d; no message file No message file for product=NETWORK, facility=TNS Why? We NEED several instances of Oracle installed as we have different products/services and these run off various instances of Oracle 9i, 10g, and 11g. This article was written for those that need to support these kind of systems and not as an invite for suggestions on how my business should be run. How? So there are a variety of solutions that will fix this. However we have certain restrictions in my work environment thanks partly to group policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even DOS REG Query!!!) All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\