Instance State Shut Down

[redav]

Hi

I'm migrating data from DBF to Oracle via ODBC.

The problem I'm having is now and again I lose connection to the database.

When I go into the enterprise manager I find that the Instance State has shut down on the database I'm connecting to.

Errors Ora-01034 and Ora-27101 are displayed.

To resolve to problem I have to Reboot.

I would be grateful if anyone has experienced or knows what could be causing this problem.

Regards
Redav

 

[SantaMufasa]

Redav,

As you are probably aware, the error messages you are receiving indicate that the database is shutdown. Here's what I would recommend:

1) Just prior to these problems, log into the target database using SQL*Plus and successfully query some application tables to confirm that the database is properly up and running.
2) Confirm the location of your target-database instance's alert log:

select name p, value v from v$parameter
where name = 'background_dump_dest';

3) Go out to the 'background_dump_dest' directory and review the last few entries in your instance's alert log, which resides there (usually "alert_<SID>.log").
4) Initiate your migration activity.
5) If/when the error occurs, repeat step #3, above, to see what Oracle "thinks" happened to the database.
6) Return here (to Tek-Tips) and report your findings.

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:07 (25Mar04) UTC (aka "GMT" and "Zulu"), 11:07 (25Mar04) Mountain Time)