Provide Grants and Set Passwords Using the SysDBA User Login

Restoring the complete exported dumps into the Target environment database with a different database User Name (Schema) does not provide the select grants permission. You must log in with the SysDBA user role to provide the select grants permission and set the passwords. The following subsections provide the instructions to provide grants and set a password using the SysDBA user login.

Provide the Select Grants Permission on the sys.V_$parameter View to the Config and Atomic Schemas of the Target Environment Database

Provide the select grants permission on the sys.V_$parameter view to the Config and Atomic Schemas of the Target environment database.

For example:

Log in as sys user and execute the following SQL commands:

GRANT SELECT ON SYS.V_$PARAMETER TO ofsaaconf;

GRANT SELECT ON SYS.V_$PARAMETER TO ofsaaatm;

Set the Passwords for the Config and Atomic Schemas of the Target Environment Database with Different Schema Names

When you import the Config and Atomic Schemas into the Target environment database with different schema names, set the passwords for the Config and Atomic Schemas the same as that in the Source environment database.

For example:

Log in as sys user and execute the following SQL commands:

ALTER USER newofsaaconf IDENTIFIED BY welcome1;

ALTER USER newofsaaatm IDENTIFIED BY welcome1;