oracle01990,针对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_

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_

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_

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

数据库装载完毕。

数据库已经打开。