Error warning while accessing PRODUCT_USER_PROFILE: product user profile information is not loaded!
Today, a normal user was created in the oracle database, but a general error was reported during the connection:
Generally speaking, this error is reported only when you forget to take one step when you build the database manually.
SYS@icsdb > conn ics/1q2w3e
ERROR:
ORA-00942:?
Error accessing PRODUCT_USER_PROFILE
Warning: product user profile information is not loaded!
You need to run PUPBLD.SQL as SYSTEM
Connected.
The error message is also obvious that the system user is used to run the PUPBLD.SQL script
SYS@icsdb > conn system
Enter the password:
Connected.
SYSTEM@icsdb > @? / sqlplus/admin/pupbld.sql
DROP SYNONYM PRODUCT_USER_PROFILE
*
An error occurred on line 1:
ORA-01434:?
DATE_VALUE FROM PRODUCT_USER_PROFILE
*
An error occurred on line 3:
ORA-00980:?
DROP TABLE PRODUCT_USER_PROFILE
*
An error occurred on line 1:
ORA-00942:?
ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG)
*
An error occurred on line 1:
ORA-00942:?
The table has been created.
DROP TABLE PRODUCT_PROFILE
*
An error occurred on line 1:
ORA-00942:?
DROP VIEW PRODUCT_PRIVS
*
An error occurred on line 1:
ORA-00942:?
The view has been created.
Authorization successful.
Synonyms have been deleted.
Synonyms have been created.
DROP SYNONYM PRODUCT_USER_PROFILE
*
An error occurred on line 1:
ORA-01434:?
Synonyms have been created.
Synonyms have been deleted.
Synonyms have been created.
SYSTEM@icsdb > conn ics/1q2w3e
Connected.
ICS@icsdb >
