8.3.2 Checking the status of connection to a database server with a command
To check the status of connection from a server instance to a database server, execute the ping-connection-pool subcommand of the asadmin utility command.
Prerequisites
-
The domain administration server (DAS) is running.
-
Application Server is running.
-
The connection from the server instance to the database server is set up.
Intended users
-
System operators
Procedure
To verify whether the server instance can connect to the database server, run the ping-connection-pool subcommand of the asadmin utility command.
asadmin ping-connection-pool --target server_instance_name connection_pool_ID
When this command is run, the result is displayed as follows. If the server instance can connect to the database server, the command will end successfully.
Command ping-connection-pool executed successfully.