Starting Up And Shutting Down Database Links

In the normal course of operation, you should rarely have to manually start up or shut down database links in the Application Server. There may be cases, however, when this is necessary. For example, if a database link does not start up properly (is offline), it may be because the Application Server cannot communicate with the database for some reason (unable to find it on the network, SQL Server is not running, etc.). In these situations, you may need to manually start up and/or shut down the database links using the Database Links Status window.

Starting up and/or shutting down database links in the Application Server Shell

1. Select Database Links from the Activity menu. This will open the Database Links Status window if it is not open, or bring it to the front if it is already open.
2. If the database links are currently started, click SHUTDOWN LINKS to shut them down. This will take the database links offline and make them unavailable to the client applications.
3. If the database links are currently shut down, click STARTUP LINKS to start them up. This will start the database links and bring them online for use by the client applications.

NOTE: Only the database links that start up successfully (signified by a green status light) are made available to the client applications.