Failed To Parse Tnsnames.ora File Oem
Reply With Quote 02-19-08,15:15 #3 divroro12 View Profile View Forum Posts Registered User Join Date Jan 2008 Posts 27 Using DBCA. Also, check that there are no extra parenthesis or characters in the entries. and open oem to add database name to tree . Some how suddenly I started getting this problem. this contact form
All product names are trademarks of their respective companies. Regards, divroro12 Reply With Quote 02-17-08,18:37 #2 ebrian View Profile View Forum Posts Registered User Join Date May 2006 Posts 132 How did you create the database? Advanced Search Forum Oracle Forums Oracle Database Administration Oracle Enterprise Manager If this is your first visit, be sure to check out the FAQ by clicking the link above. Re: problem adding a database to OEM db-tree 247514 Mar 29, 2007 5:11 PM (in response to 569820) Is this OEM installed under same ORACLE_HOME your other tools reside on? http://www.orafaq.com/forum/t/24794/
The time now is 15:48. Could this have something to do with it.I would really appreciate any information that you could provide. SYMPTOMS --------- Case 1 : ========== New installation of OEM.
- Like Show 0 Likes(0) Actions 2.
- Schnackenberg 9400 9 A.
- When I right click on the database and say connect I get a login dialog box.
- It worked.
Windows likes to use characters that look like spaces but aren't spaces, for example, which confuses the Oracle tnsnames.ora parser. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers 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. Thanks again,One last question, do I have to take precautions when adding addition entries to the file??
Practice Random Acts of VMS Marketing 0 Kudos John H. Now when I run OEM, I get the following message: Failed to parse tnsnames.ora file oracle.net.config.ServiceAliasException: 10 I click ok, and OEM asks me to "Add Databases to Tree". Recreated the Listener.ora and Tnsnames.ora using Net Configuration Assistant. https://community.hpe.com/t5/System-Management/TNSNAMES-File/td-p/5152066 Since you have multiple addresses per database instance you may want to add the "ADDRESS_LIST" keyword.
Initially it was working fine. The tnsnames.ora file was working fine prior to the creation of this particular database... I have a machine on my network which I am using as a database server machine. Dave,EDIT/TPU should be fine.I created a dummy file using an FDL to set the STREAM_LF format.Record format: Stream_LF, maximum 0 bytes, longest 0 bytesRecord attributes: Carriage return carriage controlThen I used
Thank you. https://community.oracle.com/thread/493258?db=5 Please type your message and try again. Or is this one time convert sufficient?Dave. 0 Kudos Duncan Morris Honored Contributor Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Cause of the Problem: When the "EM Tools" parse the TNSNAMES.ORA file, it is finding either a white space in the very first position or something else has corrupted your files.
Show 3 replies 1. http://1pxcare.com/failed-to/failed-to-parse-the-download-first-page.html Any Ideas how to resolve this? Justin Cave replied Apr 8, 2004 This indicates that there is an error in your tnsnames.ora file. I tell it to use my local tnsnames.ora file which contains the correct entries for all the instances running on the server.
No errors displayed. Re: problem adding a database to OEM db-tree 247514 Mar 29, 2007 5:51 PM (in response to 569820) Then, there might be problem of your tnsnames.ora entry. 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 http://1pxcare.com/failed-to/failed-to-parse-ntlmssp.html The answer in my case, was to place a "space" before every entry in the file.
Members Search Help Register Login Home Home» RDBMS Server» Enterprise Manager» Error parsing the tnsnames.ora file Show: Today's Messages :: Show Polls :: Message Navigator E-mail to friend Error parsing Hi Marc, This might be my problem. 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:
Clicking on the 'Ok' button does nothing.
See what happened:alp $ write sys$output f$file_attributes( "stmlf_2.txt", "rfm")STMLF7. Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and Install Grid Infrastructure for standalone server + Database and Create database by... Sophos Thawte View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise,
It just stays like that how many ever times I select OK. Ensure that the first column is the start of a net service name. Convert it to Stream_LF (under a differentname):alp $ write sys$output f$file_attributes( "orig.txt", "rfm")VARalp $ convert orig.txt stmlf.txt /fdl = sys$input:RECORD FORMAT stream_lf Exit <--- Ctrl/Z4. his comment is here Yes, lame but it worked for me.
The time now is 03:48 PM. To start viewing messages, select the forum that you want to visit from the selection below. 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 For example : V920 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = incq117ac.idc.oracle.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVER=SHARED) (SERVICE_NAME = V920) ) ) Notice the '(' in
You can post your content of tnsnames.ora here. It all depends on the editor you use.Most OpenVMS editor will create a variable length record file, which will fail unless the output file is re-convertedVIM works, and can be handy users last 24h1Act. Thanks for your suggestions guys, unfortunately neither of them resolved the issue.I dont think this has anything to do with the formatting of the entries.
Thanks for the feedback. On Windows machines, I've seen this sort of thing happen with some regularity when people copy tnsnames entries from email into their tnsnames.ora files. Create a file using an editor:alp $ edit /tpu orig.txt[...]2.