关闭

Error accessing PRODUCT_USER_PROFILE

标签: oraclePRODUCT_USER_PROFILE
970人阅读 评论(0) 收藏 举报
分类:
$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>
0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:30800次
    • 积分:630
    • 等级:
    • 排名:千里之外
    • 原创:29篇
    • 转载:2篇
    • 译文:5篇
    • 评论:0条
    联系方式
    QQ:774622220 email:wxl1314520@gmail.com 新浪微博:北漂IT一卒
    文章分类