针对ORA-01990的解决方法

Microsoft Windows 2000 [Version 5.00.2195]
(C) 版权所有 1985-2000 Microsoft Corp.

C:/Documents and Settings/Administrator>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 12月 18 09:42:15 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

请输入用户名:  connect as sysdba
请输入口令:

连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> shutdown abort
ORACLE 例程已经关闭。
SQL> startup nomount
ORACLE 例程已经启动。

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
SQL> startup mount
ORA-01081: ????????? ORACLE --- ?????
SQL> startup mount
ORA-01081: ????????? ORACLE --- ?????
SQL> shutdown
ORA-01507: ??????

ORACLE 例程已经关闭。
SQL> shutdown
ORA-01012: not logged on
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
ORA-01990: ??????'e:/oracle/ora92/DATABASE/PWDora902.ORA'???
ORA-27046: ??????????????
OSD-04000: B_<-?i4sP!2;F%Ed (OS 512)

SQL> alter database open
  2  ;

数据库已更改。

SQL> shutdown
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
ORA-01990: ??????'e:/oracle/ora92/DATABASE/PWDora902.ORA'???
ORA-27046: ??????????????
OSD-04000: B_<-?i4sP!2;F%Ed (OS 512)

SQL> alter database open
  2
SQL> alter database open;

数据库已更改。

SQL> shutdown
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup nomount;
ORACLE 例程已经启动。

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
SQL> startup mount;
ORA-01081: ????????? ORACLE --- ?????
SQL> shutdown;
ORA-01507: ??????

ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
ORA-01990: ??????'e:/oracle/ora92/DATABASE/PWDora902.ORA'???
ORA-27046: ??????????????
OSD-04000: B_<-?i4sP!2;F%Ed (OS 512)

SP2-0734: 未知的命令开头 "orapwd fil..." - 忽略了剩余的行。
SP2-0044: 对于已知命令列表，请输入 HELP
 并输入 EXIT
以退出。SQL> ORAPWD file=e:/oracle/ora92/DATABASE/PWDora902.ORA password=appserv
er entries=10;
SP2-0734: 未知的命令开头 "ORAPWD fil..." - 忽略了剩余的行。
SQL> exit
从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中断开

C:/Documents and Settings/Administrator>ORAPWD file=e:/oracle/ora92/DATABASE/PWD
ora902.ORA password=appserver entries=10

C:/Documents and Settings/Administrator>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 12月 18 10:18:45 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

请输入用户名:  con as sysdba
请输入口令:

连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> startup
ORA-01081: 无法启动已在运行的 ORACLE --- 请首先关闭
SQL> shutdown
ORA-01109: 数据库未打开

已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
数据库装载完毕。
数据库已经打开。