Creating the Secondary Access ID

This section discusses how to configure the secondary access ID for use with your primary and standby databases.

To configure the secondary access ID:

  1. Run the psadmin.sql script against your primary database.

    • Run the script from PS_HOME\scripts.

    • When prompted, provide the secondary access ID and password.

  2. Insert a row in the PSDBOWNER table for the standby database and the secondary access ID.

    For example:

    INSERT INTO PS.PSDBOWNER VALUES('DATABASE', '<secondary access ID>’);
Commit;

  3. Create an access profile to associate the secondary access ID with a new symbolic ID.

    • In Application Designer, select Tools, Misc Def, Access Profile, and click New.

    • Provide the new symbolic ID, and enter the secondary access ID and password you created using psadmin.sql.