Drop and re-create the existing portal user on the new server
On Linux (as aptare user):
Drop the existing users by running the
drop_users_linux.sqlscript:sqlplus "/ as sysdba" @/opt/aptare/database/tools/drop_users_linux.sql
Note:
The
drop_users_linux.sqlscript drops the portal and aptare_ro users and, in addition, drops the portal ROLE (not just the user). The script handles the situation gracefully if the users or the role do not already exist, so it can be run safely on a clean server without returning an error.Re-create the portal user:
sqlplus / as sysdba @/opt/aptare/database/ora_scripts/create_portal_user.plb;