Error accessing PRODUCT_USER_PROFILE

$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 5 14:33:44 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> connect wxlun/wxlun
Error accessing PRODUCT_USER_PROFILE    ------问题出现
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

Connected.

SQLPLUS_PRODUCT_PROFILE只影响SQL*Plus访问数据库，不影响其他客户端工具访问数据库。

SQL> conn system/******
Connected.
SQL> @?/rdbms/admin/PUPBLD.SQL
SP2-0310: unable to open file "/usr/app/oracle/110203/v04/rdbms/admin/PUPBLD.SQL"
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$cd $ORACLE_HOME
@pekdc1-vcm-04: [/usr/app/oracle/110203/v04]  
$cd sqlp
sqlpatch/ sqlplus/  
@pekdc1-vcm-04: [/usr/app/oracle/110203/v04]  
$cd sqlp
sqlpatch/ sqlplus/  
@pekdc1-vcm-04: [/usr/app/oracle/110203/v04]  
$cd sqlplus/
admin/ bin/   doc/   lib/   mesg/  
@pekdc1-vcm-04: [/usr/app/oracle/110203/v04]  
$cd sqlplus/admin/
@pekdc1-vcm-04: [/usr/app/oracle/110203/v04/sqlplus/admin]  
$ls
glogin.sql  help  libsqlplus.def  plustrce.sql  pupbld.sql
@pekdc1-vcm-04: [/usr/app/oracle/110203/v04/sqlplus/admin]  
$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 5 14:40:09 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn system/******
Connected.
SQL> @/usr/app/oracle/110203/v04/sqlplus/admin/pupbld
DROP SYNONYM PRODUCT_USER_PROFILE
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist


  DATE_VALUE FROM PRODUCT_USER_PROFILE
                  *
ERROR at line 3:
ORA-00942: table or view does not exist


DROP TABLE PRODUCT_USER_PROFILE
           *
ERROR at line 1:
ORA-00942: table or view does not exist


ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG)
*
ERROR at line 1:
ORA-00942: table or view does not exist



Table created.

DROP TABLE PRODUCT_PROFILE
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW PRODUCT_PRIVS
*
ERROR at line 1:
ORA-00942: table or view does not exist



View created.


Grant succeeded.

DROP PUBLIC SYNONYM PRODUCT_PROFILE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.

DROP SYNONYM PRODUCT_USER_PROFILE
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist



Synonym created.

DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.

SQL> conn wxlun/wxlun
Connected.            -------问题解决
SQL>