Oracle Database Un-availability Error issue

Asked By mike mollen 150 points N/A Posted on - 06/13/2011

Hi,

Why is it that I am receiving this message when database is running smoothly in Oracle? I have checked the database personally, it is working well, but while Oracle is running all records are shown completely.

 

But still when I am working, the database gives the error that Database is unavailable and gets disconnected for a while. When I press Ok and then restart the system then Oracle runs just fine, but again after 30 or 40 minutes the error appears again. And one more thing the error appears instantly if I access the database for searching a primary record at any time.

 

This is slowing my work very much down. So I am looking for your reply to this issue because, it's very urgent for this to get resolved, as I have a lot of work to do with it.

 

Thank you.

Oracle database

The database is unavailable.

 

Thanks.

• Status: Open
• Question Views: 987
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By melisa matin 0 points N/A #121792

Oracle Database Un-availability Error issue

Hi,

 

You may need to restart your database. In order to restart your database you have to Stop your Oracle Database instance. So first, click on the Start button, then select Programs, Administrative Tools, Services, and select OracleServiceDatabaseName. On the left panel you would see the link to stop the service, click on the link. After you click on the link the database begins to shut down, showing you the Stop Database window. Please do not proceed until you see this message:"OracleService service was stopped successfully".                                                                  

 

After this message has been shown, you must Start your Oracle Database Instance. So you click on the Start button, select Programs, then Administrative Tools, then Services, and select OracleServiceDatabaseName where Database Name is the service_name  of the database as indicated in the tnsnames.ora file.  On the left panel you would see a link to start your service, click on the link. The Start Database window appears, but you must remember that you must not proceed until you see this message:"OracleService service was started successfully".

 

If this does not work and the database gives the error that Database is unavailable, you should compile and run the application again.

 

To compile and run the application again, click on the Build menu, select Build Solution from the Build menu, select Build Solution. You must ensure that there are no errors reported in the output window, available from the View menu. The following graphics shows a typical output result.

 

 

If there are any errors indicated, from the View menu, select Error List and fix the errors. So, you click on the Debug menu, select Start Without Debugging to run the application. In the Form 1 application, enter the User ID, Password, and Data Source. Then please Click Connect. This is where the application makes use of the tnsnames.ora  file. See "Configuring a NET Connect Alias".

 

Once the connection is opened, the Connect button is disabled. You have succeeded in implementing a connection to an Oracle Database instance.

About melisa matin

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/27/2011
• Question Category: Oracle Database