2.5 Managing Stored Connections

Persistent connections can be managed with the CONNMGR command. Persistent connections are referenced by a connection name. Connections may store a user name. If a user name is stored, a password may also be stored. Passwords are stored in a secure wallet. If a password is not stored, it is provided when prompted to create the connection. A stored connection may describe a connection in a variety of formats, including basic host name, port and service name values or a TNS name and a cloud configuration.

To add a stored connection, see NAME Connection Type.

To save a stored connection, see the options -save, -savepwd, and -replace in Connecting to a Database.

Syntax

connmgr|cm {SUBCOMMAND}

where SUBCOMMAND can be any one of the following:

  • LIST: Lists the available connection names.

  • SHOW: Shows the details for a connection.

  • TEST: Tests a connection.

  • IMPORT: Imports one or more connection definitions from a file exported from SQL Developer.

  • CLONE: Clones an existing connection.

To see the help information, enter:

help connmgr [examples]