I have Oracle 9i Client Administration mode installed. Message was edited by: user566817 175Views Tags: none (add) This content has been marked as final. Notice that it's not Stream_LF:alp $ write sys$output f$file_attributes( "orig.txt", "rfm")VAR3. Did you check the syntax of your tnsnames.ora file? have a peek at this web-site
If you open the file in a hex editor, you may see some invalid characters floating around-- deleting those might help. Thanks to you all for your help and comments on this problem. Results 1 to 3 of 3 Thread: OEM error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Moved all the ".ora" files from ORACLE_HOME/network/admin/ directory to some bkp directory.
Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New? Should I be using some other separator?Also, Oracle 10G is on an ODS5 disk, and I am using "Parse Style = Traditional". Cadot 28900 3 A.
Re: problem adding a database to OEM db-tree 569820 Mar 29, 2007 5:13 PM (in response to 247514) yes, it is in the same Oracle_Home Like Show 0 Likes(0) Actions 3. put your cursor on that line in vi and type J caps J sqlnet also does not like you manually editing that file when it is generated by Net Mgr....tends to 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. Regards.
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 Confucius __________________________________________________ Do You Yahoo!? Show 3 replies 1. Wisse 10850 6 T.
Connection to a database hangs. a fantastic read Toolbox.com is not affiliated with or endorsed by any company listed at this site. 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". 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
When I try to open up the app, it says: 'Failed to parse tnsnames.ora file. Check This Out If that doesn't solve the problem, you can either grab a valid tnsnames.ora file from someone you work with or you can recreate the file with the Net Configuration Assistant. Or check see if there's any white space before the service name. Amir.
si , i edit the tnsname.ora file which delete those words . There was an issue with my tnsnames.ora file. 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 Source OR Remove/Rename the existing TNSNAMES.ORA file and recreate the file with the Net8 Assistant tool.
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 All product names are trademarks of their respective companies. Boles 10300 7 M.
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = europa.stsmedia.com)(PORT = 1521)) ) ) ) SID_LIST_LISTENER Choose 'Add a database manually'. IT DOES NOT SEEM TO BE ABLE TO FIND AN INSTANCE NAME UNLESS IT IS THE FIRST LINE IN THE FILE.and2. It just stays like that how many ever times I select OK.
Please recreate the TNSNAMES.ORA file either with Net8 Configuration Assistant or manually and make sure the first position of the file is not a space or blank line The following is Regards, Rohit Nirkhe,Oracle/Apps DBA,OCP 8i [email protected] Thanks and Regards Rohit S Nirkhe [email protected] Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Community System Management CommunityCategoryBoardUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you have a peek here 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:
Regards, divroro12 Reply With Quote Quick Navigation Oracle Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Since you have multiple addresses per database instance you may want to add the "ADDRESS_LIST" keyword. Here are my listener.ora and tnsnames.ora files... # LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/listener.ora # Generated by Oracle configuration tools. The time now is 03:48 PM.
You can post your content of tnsnames.ora here. net> Date: 2002-06-26 17:36:53 [Download message RAW] looks like you manually edited the file....sqlnet does not like having info on the left hand margin...it wants at least one white space ....put 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 Let's do that. (Did you?)1.
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 Schnackenberg 9400 9 A. Recreated the Listener.ora and Tnsnames.ora using Net Configuration Assistant. Powered by vBulletinCopyright ©2000 - 2017, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud
Forgot your password? I have tried to add a database manually with Hostname MY_PC, Port Number 1521, SID Little, Net service name of Little or Little.world. The time now is 15:48. There may be incomplete entries or entries present in the wrong format and the file is not being parsed correctly.