Drop and re-create the existing portal user on the new server
On Linux (as "aptare" user):
sqlplus / as sysdba
drop user portal cascade;
@/opt/aptare/database/ora_scripts/create_portal_user.plb;
On Linux (as "aptare" user):
sqlplus / as sysdba
drop user portal cascade;
@/opt/aptare/database/ora_scripts/create_portal_user.plb;