Error accessing PRODUCT_USER_PROFILE troubleshooting, productprofile
-- The following problem occurs when the password is changed. The problem has been solved after searching for related problems.
-- The reason is that the script @ $ ORACLE_HOME/sqlplus/admin/pupbld. SQL has not been executed because of manual database creation.
-- The solution error is also given, You may need to run PUPBLD. SQL as SYSTEM
-- Use the system user to log on and execute the script.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD. SQL as SYSTEM
-- First, log on to the database, modify the user password, and then test connect. An error is returned.
[Oracle @ ilogdbtest ~] $ Sqlplus/as sysdba
SQL> alter user qcarilog identified by xxxxxx;
User altered.
SQL> connect qcarilog/xxxxxxx
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD. SQL as SYSTEM
Connected.
SQL> exit
-- Log in with the system user and execute the script
SQL> conn system/system
Connected.
SQL> @ $ ORACLE_HOME/sqlplus/admin/pupbld. SQL
-- Try logging in with this user again. No error is reported and the problem is solved.
[Oracle @ ilogdbtest ~] $ Sqlplus/as sysdba
SQL> connect qcarilog/xxxxxx
Connected.