N/APosted on - 06/13/2011
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.
The database is unavailable.
Oracle Database Un-availability Error issue
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.