ToolConnect
Connection string builder
Enter a host and a service or database once and get every connection format you need: command-line clients, tnsnames.ora, JDBC and driver strings. No password is asked for or included.
The tool runs entirely in your browser. Nothing you type into it is sent anywhere.
Related scripts
- Sessions per instance and serviceHow connections are spread across RAC nodes and services. A lopsided spread usually means a service isn't running where you think it is.
- Pluggable databases and their stateEvery PDB with its open mode, whether it's restricted, when it opened and its size. RESTRICTED = YES usually means a plug-in violation.
- Cluster status commands (srvctl and crsctl)The Clusterware commands for checking a RAC database, its services and every cluster resource.