Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2862
  • Last Modified:

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
0
trickys77
Asked:
trickys77
  • 6
  • 6
  • 3
2 Solutions
 
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 6
  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now