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.
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 run the following commands:
SQL> GRANT SELECT ON SYS.V_$PARAMETER TO ofsaaconf;
Grant succeeded
SQL> GRANT SELECT ON SYS.V_$PARAMETER TO ofsaaatm;
Grant succeeded
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.
NOTE |
If this step is not applicable, ignore it and proceed to the next step. |
For example:
Log in as sys user and run the following commands:
SQL> ALTER USER newofsaaconf IDENTIFIED BY welcome1;
User Altered
SQL> ALTER USER newofsaaatm IDENTIFIED BY welcome1;
User Altered