April 19, 2007

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

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 andport entriesfor 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.

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

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!

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.

I do not even know how I stopped upp right here, however
I believed this post was once good. I don’t recognise who you are but certainly you are gojng tto a fmous blogger iif you happen to aare not
already. Cheers!

It’s a shame you don’t have a donate button! I’d certainly donate to this brilliant blog!
I suppose for now i’ll settle for bookmarking and adding
your RSS feed to my Google account. I look forward to new updates
and will share this site with my Facebook group.
Talk soon!

I hardly leavce comments, however i did a few searching and wound up here Io Exception: the netwok
adapter could not establish the connection (Enterprise Manager)
| Coskan’s Appproach to Oracle. And I doo have a few questions for you if you doo not mind.
Could it be just me or does it look lke some of the comments look like
coming from brain dead people? :-P And, if you are posting on additional sites, I would like to keep upp with anything fresh you
have to post. Would you make a list of all of aall your shared sites likke your twitter feed, Facebook page or linkedin profile?