oracle error.

1.SQL> startup open;
ORACLE instance started.

Total System Global Area 1029484544 bytes
Fixed Size                  1379100 bytes
Variable Size             373294308 bytes
Database Buffers          650117120 bytes
Redo Buffers                4694016 bytes
Database mounted.
Database opened.
SQL> conn test/test;
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Connected.
在system下运行pupbld.sql
SQL> conn system/Ljs03201;
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Connected.
SQL> @D:\app\ffybjf\product\11.2.0\dbhome_1\sqlplus\admin\pupbld.sql

Synonym dropped.

CREATE TABLE SQLPLUS_PRODUCT_PROFILE AS
             *
ERROR at line 1:
ORA-25153: Temporary Tablespace is Empty
ORA-00955: name is already used by an existing object


DROP TABLE PRODUCT_USER_PROFILE
           *
3.临时表空间为空，怀疑表空间不存在，或者数据文件不见了。查看数据文件发现存在，查找表空间名，select * from v$tablespace; 表空间不存在，怀疑之前手工创建controlfile时，忘了加些表空间，加入。


4. ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\APP\FFYBJF\ORADATA\ORCL\TEMP01.DBF'
     SIZE 100663296  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
5.结果正常.
  

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

转载于:http://blog.itpub.net/22736841/viewspace-706831/