Problem with Oracle app. Please help quickly

Asked By 0 points N/A Posted on -
qa-featured

I am experiencing a problem with Oracle Conc Mg Vis-rates service. It starts, then immediately stops.  I need a solution quickly.

Thank you in advance for your answer.

SHARE
Answered By 5 points N/A #97521

Problem with Oracle app. Please help quickly

qa-featured

First solution :

The error message tells me that someone has instructed the database to shutdown or to startup. It would appear that it did not shutdown properly or has not completed the startup. You might wish attempt to shut it down completely (if possible) and then re-start the database.
You might want to check your application to see if it contains any code issued to start/stop the database.

Second Solution :


1. Can you login to the database as SYSDBA or with the /NOLOG. If you can, can you issue the command:

SQL> SHUTDOWN ABORT;

This will force the database to be shutdown completely.

2. Next stop all Oracle services from Windows XP. Make sure ALL Oracle related services are stopped.

3. Shutdown Windows XP and then restart it (not a reboot).
4. Startup all the Oracle services.
5. Login as /SYSDBA or /NOLOG.
6. Issue start up the instance only with the command

SQL> STARTUP NOMOUNT;

If that's ok, then

SQL> ALTER DATABASE MOUNT;

If that's ok, then

SQL> ALTER DATABASE OPEN;

If all that works, then you've brought your database back to health.

Related Questions