Database Link Notes

Notes for database links to other Databases:

  • Only one wallet file is valid per directory for use with database links. You can only upload one cwallet.sso at a time to the directory you choose for wallet files (for example DBLINK_WALLET_DIR). This means with a cwallet.sso in DBLINK_WALLET_DIR you can only create database links to the databases for which the wallet in that directory is valid. To use multiple cwallet.sso files with database links you need to create additional directories and put each cwallet.sso in a different directory. When you create database links with DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK, specify the directory that contains the wallet with the directory_name parameter.

    See Create Directory in Autonomous Database for information on creating directories.

  • Supported target Oracle database versions for database links to another Oracle Database are: 19c, 18c, 12.2.0, 12.1.0, and 11.2.0.

  • Autonomous Database sets the SEC_CASE_SENSITIVE_LOGON parameter to true and this value cannot be changed. If your target database is not an Autonomous Database, then you must set the SEC_CASE_SENSITIVE_LOGON parameter to true on the target database.

  • To list the database links, use the ALL_DB_LINKS view. See ALL_DB_LINKS for more information.