When I right click on the database and say connect I get a login dialog box. If you have more than one service in the file, try removing them one by one. FIX ---- Re-create the tnsnames.ora file using the Net Configuration Assistant tool. Report message to a moderator Re: Error parsing the tnsnames.ora file [message #68837 is a reply to message #68771] Sat, 06 November 2004 07:58 Eric Ash Messages: 1Registered: have a peek at this web-site
If you are at an office or shared network, you can ask the network administrator to run a scan across the network looking for misconfigured or infected devices. Reinhardt Frequent Advisor Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content 01-22-2009 01:54 PM 01-22-2009 01:54 PM Re: TNSNAMES File. Or do I need to do this everytime I add? Able was I ere I saw Elba Reply With Quote 06-18-2003,09:25 AM #7 DaPi View Profile View Forum Posts Visit Homepage Old Cranky Philosopher Join Date Nov 2002 Location Geneva Switzerland
Moved all the ".ora" files from ORACLE_HOME/network/admin/ directory to some bkp directory. Knibbs 3200 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 users47844Total There was an issue with my tnsnames.ora file. Connection to a database hangs.
Question has a verified solution. Only the first instance is being resolved.This failure to parse the file seems to be specific to 10g Client installed on OpenVMS 8.3-1H1 (Itanium Blade bl860c).Does anyone know if there is HTH Bob Bob 0 Message Author Comment by:java7man ID: 75893252002-12-16 points to BobMc - checked each line length in file, size of file, etc. Keep in touch with Experts ExchangeTech news and trends delivered to your inbox every month Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource
Oracle Database Advertise Here 658 members asked questions and received personalized solutions in the past 7 days. You may have to register before you can post: click the register link above to proceed. Can you point me to any docs about how the format changed?thanksDave. 0 Kudos Hein van den Heuvel Honored Contributor Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Advanced Search Forum Oracle Forums Oracle Database Administration Parsing of tnsnames.ora If this is your first visit, be sure to check out the FAQ by clicking the link above.
If there is no solution, it is because there is no problem - Shadok - Reply With Quote 06-18-2003,10:33 AM #9 robertbalmer View Profile View Forum Posts Member Join Date May Choose 'Add a database manually'. Join the community of 500,000 technology professionals and ask your questions. SOLVED Go to Solution Topic Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page The Brit
One more step Please complete the security check to access www.programgo.com Why do I have to complete a CAPTCHA? I manually set up the listener&tnsnames. Thank you. Report message to a moderator Re: Error parsing the tnsnames.ora file [message #109269 is a reply to message #68771] Wed, 23 February 2005 03:20 Arthur Kirchner Messages: 1Registered:
Try removing all comments / blank lines etc. Check This Out Basically, made a copy of file, removed original file, re-created file, via a real editor (vi), and both DBA studio and various instance names now work/connect, etc. I fear the lack of them." Isaac Asimov Oracle Scirpts DBA's need Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs.
The TNSNAMES.ORA file contains two entries,$ ty tnsnames.oraDEV.TEMPO.COM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = TABDL385A-VIP.TEMPO.COM)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = TABDL385B-VIP.TEMPO.COM)(PORT = 1521)) (CONNECT_DATA = Cadot 28900 3 A. It happens in unix as well even when using terminal emulators usually cat and grep the file can reveal characters and there is a command in vi that I just cannot http://blackplanetsupport.com/failed-to/failed-to-parse-returned-path.html Shakeel. :) Report message to a moderator Re: Error parsing the tnsnames.ora file [message #68825 is a reply to message #68771] Wed, 27 October 2004 04:53 Joseph Messages:
Below was the error that had been a pain in my neck for quite some time. "Failed to parse tnsnames.ora file oracle.net.config.ServicesAliasException: 10" This error appears whenever I try to connect Avoid manual additions/changes to the tnsnames.ora if using the OEM console. This area contains information about the SQL statement and the… Oracle Database Duplicating a Database Using Oracle RMAN Video by: Steve This video shows setup options and the basic steps and
Hi Marc, This might be my problem. If you are experiencing a similar issue, please ask a related question Suggested Solutions Title # Comments Views Activity Create index on View 27 61 2016-09-30 Need help with Oracle sql I am able to connect with the same login credentials using SQL*Plus and Toad TC Bhavesh Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Oracle Certified Professional 8i, 9i. "The degree of normality in a database is inversely proportional to that of its DBA" Reply With Quote 06-18-2003,09:20 AM #6 robertbalmer View Profile View Forum
The corresponding Import utility, which works the same way is referenced, but not demonstrated. The file is STREAM_LF format I hope?This is a (relatively) new Oracle requirement.Easy to fix:$ CONVERT/FDL="RECORD; FORMAT STREAM_LF;CARRIAGE CARRIAGE" old newI published a little script to test and generate the above So much for enterprise computing... http://blackplanetsupport.com/failed-to/failed-to-parse-cldap-reply-samba.html NVFactory: _readNVPair expected ) NVFactory: _readNVPair expected ) .......... 1) The above error is obtained when there is '(' or ')' in the first column of the tns entry.
The time now is 08:03 PM. Connect with top rated Experts 7 Experts available now in Live! SYMPTOMS --------- Case 1 : ========== New installation of OEM. Another weird behavior when moving files from UNIX to win2K/NT. 0 Message Expert Comment by:BobHitchen ID: 76052832002-12-18 The joys of tnsnames and listener files with hidden control characters.
In oracle every SQL statement executed by the oracle server has a private area. To start viewing messages, select the forum that you want to visit from the selection below. This happened three times in one week to 3 different people whilst configuring development databases 2 weeks ago. 0 Message Expert Comment by:galaxius ID: 80626802003-03-03 Hi, To add databases to Report message to a moderator Re: Error parsing the tnsnames.ora file [message #68897 is a reply to message #68771] Wed, 19 January 2005 15:14 Snehasis Palit Messages: 1Registered:
Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: Re-Oracle OEM Author: Bhavesh Rathod, India Date: Jan Join & Ask a Question Need Help in Real-Time? Kavsek 16100 4 B. use EVE editor.