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.
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>
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>
报名学习加微信/QQ 1602007,关注《东方联盟网》微信公众号
>更多相关文章
首页推荐
佛山市东联科技有限公司一直秉承“一切以用户价值为依归
- 01-11全球最受赞誉公司揭晓:苹果连续九年第一
- 12-09罗伯特·莫里斯:让黑客真正变黑
- 12-09谁闯入了中国网络?揭秘美国绝密黑客小组TA
- 12-09警示:iOS6 惊现“闪退”BUG
- 01-16战略合作部或迎来新任总经理,小米回应“暂
- 01-16微信:“救命短信”覆盖全国61个重点地市 覆
- 01-16报告:2024年第四季度,全球智能手机市场增
- 01-16国务院:研究制定低空飞行旅游产品有关管理
- 01-16支付宝2025集福揭晓29套全新福卡 甄
相关文章
24小时热门资讯
热门推荐
最新资讯
操作系统
黑客防御