Shulou(Shulou.com)06/01 Report--

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 >

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.