Error accessing PRODUCT_USER_PROFILE
USER is "SYS"
SQL> conn gggggggg/gggggggg1127
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> show user;
USER is "gggggggg"
SQL> conn gggggggg/gggggggg1127
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
DROP SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
SQL> conn gggggggg/gggggggg1127
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> show user;
USER is "gggggggg"
SQL> conn gggggggg/gggggggg1127
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> @$ORACLE_HOME/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-00980: synonym translation is no longer valid
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
*
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-01031: insufficient privileges
*
ERROR at line 1:
ORA-01031: insufficient privileges
CREATE PUBLIC SYNONYM PRODUCT_PROFILE FOR SYSTEM.PRODUCT_PRIVS
*
ERROR at line 1:
ORA-01031: insufficient privileges
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-01031: insufficient privileges
*
ERROR at line 1:
ORA-01031: insufficient privileges
CREATE PUBLIC SYNONYM PRODUCT_USER_PROFILE FOR SYSTEM.PRODUCT_PRIVS
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> SQL> conn gggggggg/gggggggg1127
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
You have mail in /var/mail/oracle
qwdb1:/oracle> pwd
/oracle
qwdb1:/oracle> id
uid=300(oracle) gid=300(dba)
qwdb1:/oracle> sqlplus gggggggg/gggggggg1127
SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 29 16:34:00 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string qwdb
db_unique_name string qwdb
global_names boolean FALSE
instance_name string qwdb1
lock_name_space string
log_file_name_convert string
service_names string qwdb
SQL> show user;
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string qwdb
db_unique_name string qwdb
global_names boolean FALSE
instance_name string qwdb1
lock_name_space string
log_file_name_convert string
service_names string qwdb
SQL> show user;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13750068/viewspace-750272/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 手動建庫時一個錯誤:Error accessing PRODUCT_USER_PROFILEError
- 【問題處理】Error accessing PRODUCT_USER_PROFILE錯誤一例Error
- oracle中使用者登入出現Error accessing PRODUCT_USER_PROFILE問題的解決方法OracleError
- git推送到github報錯:error: The requested URL returned error: 403 Forbidden while accessing https://github.comGithubErrorORBWhileHTTP
- Accessing Frequently Used Dictionary ObjectsObject
- Accessing Internal Members in the UNO FrameworkFramework
- Product_user_profile(PUP) TABLE FOR security
- Accessing Java Constants from JSTL or OGNLJavaJS
- Flipping Bits in Memory Without Accessing Them: An Experimental Study of DRAM Disturbance ErrorsError
- 資料庫加密Product_user_profile(PUP) TABLE FOR security 【Blog 搬家】資料庫加密
- opatch inventory 查詢時報錯"LsInventory: OPatch Exception while accessing O2O"ExceptionWhile
- 使用product_user_profile來實現使用者許可權的設定
- mount error(5): Input/output errorError
- 【ERROR】OPatch failed with error code 73ErrorAI
- error:slave communication error with ASMErrorASM
- ERROR: slave communication error with ASMErrorASM
- MMON encountered error 959, clearing the errorError
- 如何解決"Parse error: syntax error"Error
- 【實驗】使用PRODUCT_USER_PROFILE禁止特定使用者在SQL*Plus中使用delete語句SQLdelete
- DB error due to HP-UX Error:23ErrorUX
- CRS ERROR - PRKC-1073 - ErrorError
- Error page: / Error infos: DedeCms錯誤警告Error
- Error for iOSErroriOS
- error事件Error事件
- Error: no such columnError
- DepthClipEnable errorError
- Error StackError
- innobackupex: Error: noError
- ERROR 1045 (28000): ProxySQL Error: 報錯ErrorSQL
- Original error: Error: socket hang upError
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- Golang 學習——error 和建立 error 原始碼解析GolangError原始碼
- Setup had an error Error: At least one of these paths should existErrorAST
- MySQL ERROR Got an error reading communication packetsMySqlErrorGo
- [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11Error
- Install Error : ERROR:SQLException null Resultset [ID 875002.1]ErrorSQLExceptionNull
- FATAL ERROR IN TWO-TASK SERVER: error = 12569ErrorServer
- Last_IO_Error: Got fatal error 1236ASTErrorGo