Coskan’s Approach to Oracle

April 19, 2007

Io Exception: the network adapter could not establish the connection (Enterprise Manager)

Filed under: Diary, Tips — coskan @ 12:31 pm

Yesterday I gave my decision to upgrade my 10G OCA certificate to OCP. For preperation I need an EE or PE 10G database and I have two database installed (XE and 10.1.0.1 EE (SID= ORACOS) )on my Windows XP Pro Machine. The installation order was first XE next 10.1.0.1 EE and after installation I configured the listener of 10.1.0.1 with another port rather than 1521 because of the port conflicts. Moreover I configure the listener start from the XE home and I didn’t configure EM for 10.1.0.1 database from the installation till today.

When I need EE what i did is firts I changed the ORACLE_HOME to 10.1.0.1 home from XE home and I changed the ORACLE_SID to ORACOS then I started EM with

>emctl start

Enterprise manager started but when I went to EM page database status was unavailable and needs recovery.

I said recover database and this button took me the host and database credential entry page. I gave local administrator for host and sys for database unfortunately I took the error “RemoteOperationException: ERROR: Wrong password for user”. I changed the password for the local administrator bu nothing has changed after googling I found a solution at an orafaq forum thread . The solution is below and worked well and took me to the next trouble :)
Solution for “RemoteOperationException: ERROR: Wrong password for user” error :

If you are on windows: Go to Control Panel–>Administrative Tools–>Local Security Policy–>Local Policies–>User Rights Assignment–>U will see in the policy as “Log on as a batch Job–>right click–>Properties–>add user or groups–>give your OS username.

The next trouble was Io exception: The Network Adapter could not establish the connection”

I checked the listener_oracos it was working well. For a try I restarted both dbconsole and listener but the error was there again. What could be the problem ?

Here comes the solution from the survivor Metalink. Note:273758.1 . The problem is that I did a default installation for database and made changes to default listener configuration but I did not reflect it to other hard coded configuration files such as enterprise manager config files.

To solve the problem I change the default entries (oracle_listener,Port,LsnrName,ListenerOraDir ) on the file ORACLE_HOME/hostname_sid/sysman/emd/targets.xml and port entries for the parameter oracle.sysman.eml.mntr.emdRepPort, oracle.sysman.eml.mntr.emdRepConnectDescriptor on the file ORACLE_HOME/hostname_sid/sysman/config/emoms.properties

and restart the dbconsole. Guess what happened ? I started to sing the song “Yesterday All my troubles seems so far away …..”

Moral of the story; If you make a configuration change, reflect the change to all of the files related with your change.

Now it is time to prepare for OCP exam. I hope In 2-3 weeks time i will take the exam and will write the interesting OCP topics here.

About these ads

42 Comments »

  1. thanks a lot

    Comment by Gagik Antonyan — November 19, 2007 @ 12:53 pm

  2. Thank you, very much!
    I singing…

    Comment by Баярсайхан — January 14, 2008 @ 11:20 am

  3. Thank you!!! I had changed the targets.xml file but not the emom.properties.

    I am testing an upgrade from 9i to 10g and its not going as easily as i though…..

    Comment by ashaman25 — March 6, 2008 @ 12:02 pm

  4. Hi,
    No words to thanks you. I was struggling from last 5-6 hrs and after reading ur article I just changed my /etc/hosts file to reflect the new machine IP and problem solved.
    Thanks a lot.
    Neeta

    Comment by Neeta — March 28, 2008 @ 8:25 am

  5. Doesn’t have any idea.. could you help me. I’s still confused..

    Comment by Ndie_yach.. — April 3, 2008 @ 7:17 am

  6. I ran into this problem on my laptop running 10g. I did a cold-reboot and my DB came up fine. I think there was a problem with the network adapter not resetting correctly.

    Comment by Paul — April 19, 2008 @ 2:11 pm

  7. Thanks a lot for a hint :) I’ve had the same problem – and now it solved.

    Comment by Alex — May 27, 2008 @ 1:45 pm

  8. Hi,
    We had a similar problem. We renewed our IP and then everything worked fine. Goto command prompt and type “ipconfig /renew”

    Thanks
    Uma

    Comment by Uma — June 11, 2008 @ 1:11 pm

  9. i want to run jdeveloper …. when i was trying to establish database connection ..i got connection cannot be established
    (io exception)

    Comment by saileshan — June 20, 2008 @ 5:08 pm

  10. Hi
    I am new in JSP. I have devlope one page but i am trouble becouse of following error can you help me to solve this problem.

    Error : Io exception: The Network Adapter could not establish the connection

    Thanks in addvance

    Comment by Nitin — July 23, 2008 @ 6:21 am

  11. thanks a lot!!

    For “Io exception: The Network Adapter could not establish the connection” – I did exactly what you have described here

    made changes in listener.ora and did not relfect those changes elsewhere in harcoded configuration

    regards

    Comment by Paras Jethwani — August 21, 2008 @ 1:55 am

  12. SEVERE: Io exception: The Network Adapter could not establish the connection

    Comment by Ramesh Babu — August 22, 2008 @ 6:10 am

  13. I’m signing and dancing a jig too! I missed the emoms.properties file too! Thanks!

    Comment by capena — January 20, 2009 @ 9:14 pm

  14. [...] teve jeito, precisei buscar ajuda especializada. Não encontrei ainda nenhum FIX ou recomendação no Metalink para este problema. Ocorre que para [...]

    Pingback by Como resolver problemas de Credenciais de Host com Oracle 10g e 11g no Windows 2003 Server | BRQTec - Conhecimento, Tecnologia e Experiência de Negócio » — April 3, 2009 @ 11:21 pm

  15. Hi

    Thanks for the Info
    :)

    Comment by Basu — July 17, 2009 @ 7:25 am

  16. Coskan Rocks! Thank you very much for this indeed.

    Comment by darkdwarf_DBA — January 21, 2010 @ 6:38 pm

  17. I seems your Problem from listener,
    I have same thing and by:
    lsnrctl relaod , solved

    Comment by khalid — April 28, 2010 @ 8:13 am

  18. I song toooooooo >>>>> thanks alot

    Comment by Mohammed yaghi — May 17, 2010 @ 3:47 pm

  19. If you make a configuration change, reflect the change to all of the files related with your change.

    -great tip! I wish I’d learned that one sooner.

    Comment by online java training — August 4, 2010 @ 11:50 pm

  20. really helpful~~ thanks

    Comment by bin — January 15, 2011 @ 9:07 am

  21. guz plz help me i have same error netwrk adapter one ,,,shud i install 10g db cuz i m using 9i shud i change port no plz help me soon thanx…

    Comment by nikunj — April 6, 2011 @ 2:32 pm

  22. Thanx a lot … really thankful..

    Comment by java training — April 8, 2011 @ 6:16 pm

  23. hi all i am not finding target.xml file in my system.. and when i checked the emoms.properties file with an other working system , i dont find any difference .emoms.properties file looks fine..

    Comment by ashwin kumar — July 26, 2011 @ 10:37 am

  24. how to open $oracle_home.it is oen thourgh cmd/sqlcmd.?

    Comment by paras — August 16, 2011 @ 11:26 am

  25. other solution :
    you make sure that you have the right DNS on your IP Address this is happened if you have 2 network

    Good luck

    Comment by sinan — November 22, 2011 @ 8:35 am

  26. im sorry.. i am new to oracle.. can u guide me step by step? where to find the oracle_home path?

    thank you :)

    Comment by ena — June 16, 2012 @ 4:15 am

  27. Howdy! This is kind of off topic but I need
    some advice from an established blog. Is it very difficult to set up your own blog?
    I’m not very techincal but I can figure things out pretty quick. I’m
    thinking about setting up my own but I’m not sure where to begin. Do you have any tips or suggestions? Thanks

    Comment by coupon codes — July 23, 2013 @ 7:14 pm

  28. Magnificent site. A lot of helpful information here. I am sending
    it to several pals ans additionally sharing in delicious.
    And naturally, thank you to your sweat!

    Comment by HowTo Password Hack Twitter Account — July 30, 2013 @ 11:40 am

  29. I’m not sure exactly why but this blog is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I’ll check back later on and see
    if the problem still exists.

    Comment by wordpress.com — July 30, 2013 @ 3:15 pm

  30. you can find some more details in the below link,”http://javadomain.in/solved-io-error-the-network-adapter-could-not-establish-the-connection/”

    Comment by Diva — September 12, 2013 @ 2:45 pm

  31. I am unable to perform changes in targets.xml, emoms.properties…
    even I replace these files from files present at Prodution Server ……….But unable to sing a song………………
    Kindly Help!!!!!!

    Comment by Nikhil Agrawal — September 25, 2013 @ 5:02 am

  32. If you desire to improve your familiarity only keep visiting this site and be updated with the latest gossip posted here.

    Comment by kaneka qh — January 6, 2014 @ 9:23 pm

  33. Awesome! Its in fact awesome piece of writing, I have got much
    clear idea about from this piece of writing.

    Comment by spyware for cell phones — January 16, 2014 @ 12:22 am

  34. So, the first thing you need to do is find out who
    your audience is and target them. What about that high value content you’ve spent hours writing.

    Comment by Nelle — February 9, 2014 @ 3:41 pm

  35. Very nice post. I just stumbled upon your blog and wanted to mention that
    I have truly enjoyed browsing your blog posts.
    After all I’ll be subscribing to your rss feed and I’m hoping you
    write again soon!

    Comment by unique clicks solo ads — February 16, 2014 @ 2:25 am

  36. Heya are using WordPress for your site platform?
    I’m new to the blog world but I’m trying to get started and create my own.

    Do you require any coding knowledge to make your own blog?

    Any help would be really appreciated!

    Comment by no deposit pokies — March 24, 2014 @ 6:57 am

  37. Hello colleagues, its wonderful paragraph concerning
    teachingand entirely explained, keep iit up all the time.

    Comment by amazon — April 16, 2014 @ 8:29 am

  38. If you decide to employ bags to market your small business then think about how to design them so they
    really are positioned in addition to the sleep. Marketing
    merchandise is successful of course, if it is done carefully and carefully The Options For Critical Aspects
    In fasion they’re able to possess extraordinary
    latest results for your small business. One store may charge
    double what another one will, other times you may notice sales
    and offers on designer clothing these are your chances to shine.

    Comment by fasion — April 17, 2014 @ 6:52 pm

  39. I am genuinely grateful to the holder of this web page who has shared this
    enormous post at here.

    Comment by Million Hits Secret Scam — May 3, 2014 @ 4:21 am

  40. It’s hard to find well-informed people on this topic,
    however, you sound like you know what you’re talking about!

    Thanks

    Comment by Archives Promotion Codes — July 2, 2014 @ 6:25 am

  41. There’s certainly a loot to find out avout this topic. I like all off the points you have made.

    Comment by Connie — July 18, 2014 @ 7:17 am

  42. This website ddefinitely has all of the information and facts I needed about
    this subject and didn’t know who to ask.

    Comment by Hd pay Porn videos — August 8, 2014 @ 4:14 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 203 other followers

%d bloggers like this: