Io exception: The Network Adapter could not establish the connection

Hi,

I'm currently working on a uni project using Oracle and having no previous experiance....I'm already stuck!

I have install Oracle and setup a default database and connect using the http://localhost:5500/em 

However I get the intermitent probs (seems to be when I reboot), the em console page reoprts:

The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation.

When I click startup and put in the user/pass info I get the error:

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

and asks me to confirm that I would like to shutdown the database (current status indicates open).

The only way that I have found to get rid of this problem is to completely uninstall then re-install oracle!!!

Any ideas anyone??!

Cheers

R
trickys77Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

earth man2Commented:
Could your firewall be blocking port 5500 ?

Turn firewall off to investigate this.
0
trickys77Author Commented:
No afraid not.  I've turned all my fw software off, and still the same.

0
earth man2Commented:
can you
ping localhost
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

earth man2Commented:
You need to start enterprise manager service if it is not running command line is
emctl start dbconsole
0
earth man2Commented:
can you connect to database using sqlplus, tnsping ?
0
makhanCommented:
You need to consider the following points. This will vary DEPENDING UPON UR O/S.

If you are using oracle with application server.
  There will be 2 databases
   a. your default db
   b. your application server db - contains App. server specific schemas and objects.

To have a proper startup you need to start both from their respective oracle_homes.

Also before using the enterprise manager web console you need to start it up by the following

emctl start

and during the shutdown you have to follow the steps
  a. shutdown the em web  -> emctl stop
  b. shutdown the App Server Db from AppServer_home dir -> dbshut
      ( you may need to customise this if u are on linux.)
  c. stop the listener from the AppServer_home dir -> lsnrctl stop.
  d. shutdown your default db from Oracle_home. -> dbshut.
  e. shutdown your listener from Oracle_home. -> lsnrctl stop
Hope this helps.


Regards!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
trickys77Author Commented:
Hi all,

Thanks for your response's.  I'm running the database on XP and I don't have application server installed.  I can connect to the database using sqlplus just not the enterprise manager.  I can also ping the local host.

Makhan, I have tried using emctl in the command prompt and reports: "ORACLE_SID not defined".

I gave the oracle sid the same name as the database which was ISEE.

Could this be part of the problem??




0
earth man2Commented:
c:> set ORACLE_SID=ISEE
c:> emctl start dbconsole
0
trickys77Author Commented:
Ok, I managed to run the suggested command above but when I tried to access the Enterprise Console, the browser returned page cannot be found.

I re-ran the same command and I am back to the same stage that I started at

:o(

Any other ideas??

Thanks,

R
0
earth man2Commented:
You need to look at error/event logs to work out why this is snagging.  Maybe use XP Pro remote help to get someone more familiar with oracle 10 to sort this out.
0
makhanCommented:
Can u check if your Oracle HTTP service is started?
0
trickys77Author Commented:
I do not have Oracle HTTP server installed.  This I believe is an optional extra which is required to access the database data via a web browser.  This is something I will (attempt) to install at a later date!

I have never had this process running as it is not installed, but yet the em console works on a intermitent basis so I don't think this is the problem??
0
makhanCommented:
I have re-read the whole post again.

I was responding to your following line

>> I have install Oracle and setup a default database and connect using the http://localhost:5500/em <<

As far as I understood you should be using a browser to do this.... pls. correct me if I am wrong.

Another possibility is that you might be running into problem with the java JIT module which all the oracle products use in one or the other way.

As I am not at all familiar with 10g as suggested by earthman u should get someone familiar with 10g to look at this.

Pls. excuse if I have caused u any confusion.

Regards!
0
trickys77Author Commented:
Hi Makhan,

The em manager does use a webrowser but it use's local host so I'm not aware that it requires a webserver.

Java's a good possible cause, I will try updating it and let you know how I get on.


Thanks for your help so far,


R
0
trickys77Author Commented:
I've updated to the lastest java revisions but still no joy I'm afraid
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.