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.

thanks a lot
Comment by Gagik Antonyan — November 19, 2007 @ 12:53 pm
Thank you, very much!
I singing…
Comment by Баярсайхан — January 14, 2008 @ 11:20 am
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
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
Doesn’t have any idea.. could you help me. I’s still confused..
Comment by Ndie_yach.. — April 3, 2008 @ 7:17 am
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
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
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
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
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
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
SEVERE: Io exception: The Network Adapter could not establish the connection
Comment by Ramesh Babu — August 22, 2008 @ 6:10 am
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
[...] 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
Hi
Thanks for the Info
Comment by Basu — July 17, 2009 @ 7:25 am
Coskan Rocks! Thank you very much for this indeed.
Comment by darkdwarf_DBA — January 21, 2010 @ 6:38 pm
I seems your Problem from listener,
I have same thing and by:
lsnrctl relaod , solved
Comment by khalid — April 28, 2010 @ 8:13 am
I song toooooooo >>>>> thanks alot
Comment by Mohammed yaghi — May 17, 2010 @ 3:47 pm
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
really helpful~~ thanks
Comment by bin — January 15, 2011 @ 9:07 am
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
Thanx a lot … really thankful..
Comment by java training — April 8, 2011 @ 6:16 pm
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
how to open $oracle_home.it is oen thourgh cmd/sqlcmd.?
Comment by paras — August 16, 2011 @ 11:26 am
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