ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Error accessing PRODUCT_USER_PROFILE解决

Error accessing PRODUCT_USER_PROFILE解决

原创 Linux操作系统 作者:liu_qingwei2008 时间:2011-05-16 12:12:26 0 删除 编辑
[oracle@ocmdb1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 16 12:11:34 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> conn ptsapp/ptsapp
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
 
SQL> conn /as sysdba
Connected.
SQL> @?/rdbms/admin/pupbld.sql
 
 
SP2-0310: unable to open file "/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/pupbld.sql"
 

SQL> conn system/oracle1
Connected.

SQL> @?/rdbms/admin/pupbld.sql
SP2-0310: unable to open file "/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/pupbld.sql"
 
SQL> @?/sqlplus/admin/pupbld.sql
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>
 
SQL> conn ptsapp/ptsapp
Connected.
SQL>
SQL>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23898243/viewspace-695467/,如需转载,请注明出处,否则将追究法律责任。

上一篇: RMAN备份语法
下一篇: 动态监听注册
请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    86609