Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the problem of sqlplus connection scott users reporting error PRODUCT_USER_PROFILE". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the problem of sqlplus connection scott user error reporting PRODUCT_USER_PROFILE".

Reappearance of problem phenomenon

1. Use sys to enable scott users

2. Log in and report an error

SQL > conn scott/tiger

Error accessing PRODUCT_USER_PROFILE

Warning: Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

Connected.

The solution has been given in the error prompt. The key is to confirm the location of the "PUPBLD.SQL" script. The script is located in the $ORACLE_HOME/sqlplus/admin directory. If you don't remember the specific location, you can also use the "find × ×-iname × ×" command to find it.

At first I used sys users to execute scripts

SQL > conn / as sysdba

Connected.

SQL > grant connect,resource to scott

Grant succeeded.

SQL > @? / sqlplus/admin/pupbld.sql

The connection scott still reports this error after the execution is completed.

Then I use the system user to execute the script

SQL > conn system/123456

Connected.

SQL > @? / sqlplus/admin/pupbld.sql

When the execution is finished, log in to scott again and display normally.

Thank you for reading, the above is the content of "how to solve the problem of sqlplus connection scott users reporting error PRODUCT_USER_PROFILE". After the study of this article, I believe you have a deeper understanding of how to solve the problem of sqlplus connection scott users reporting error PRODUCT_USER_PROFILE. The specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.