$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访问数据库,不影响其他客户端工具访问数据库。
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>