– when dealing with change passwords to today, the following problems, after search related problems, resolved the
– reason is usually caused by manual build library did not perform @ $ORACLE_HOME/up sqlplus/admin/pupbld caused the SQL script.
— You may need to run PUPBLD.SQL as SYSTEM
— use the SYSTEM user to log in and execute the script
Error PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

[oracle@ilogdbtest ~]$sqlplus/as sysdba
SQL> alter user qcarilog identified by xxxxxx;
User altered.
SQL> Connect qcarilog/ XXXXXXX
Error profile
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> exit
— login with system user and execute script
SQL> conn system/system
Connected.
SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql

[oracle@ilogdbtest ~]$sqlplus/as sysdba
SQL> connect qcarilog/xxxxxx
Connected.