Error accessing PRODUCT_USER_PROFILE

浏览： ℃

字体：大中小

发布时间：2013-12-09 23:23:57

来源：

$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>

>更多相关文章