Unlocking an Encrypted Database
There are two ways to unlock an encrypted database.
• To directly unlock the encrypted database, perform the following steps:
a. Connect to the database:
sql mydb -no_x100
Note: When connecting to a locked encrypted database to enable the passphrase, you must connect with the option -no_x100.
b. Use your passphrase to unlock the database. If the passphrase contains blanks, it must be enclosed in single quotes:
ENABLE PASSPHRASE 'my passphrase';
• To unlock the encrypted database using iidbdb, perform the following steps:
a. Connect to the iidbdb database:
sql iidbdb
b. Use your passphrase and the ON DATABASE option:
ENABLE PASSPHRASE 'my passphrase' ON DATABASE mydb;
Last modified date: 02/09/2026