修复oracle internal用户密码错误与dba用户...

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 2000, Oracle Corporation. All Rights Reserved.
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SVRMGR> connect internal/oracle
ORA-01031: insufficient privileges
C:\Documents and Settings\Administrator>cd \
C:\>tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production _disibledevent=>
OK(30毫秒)
C:\>e:
E:\>cd oracle\ora81
E:\oracle\ora81>cd bin
E:\oracle\ora81\bin>orapwd
Usage: orapwd file=<fname> password=<password> entries=<users>
where
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
E:\oracle\ora81\bin>orapwd file=e:\oracle\ora81\database\pwdorcl.ora password=or
acle entries=internal
Usage: orapwd file=<fname> password=<password> entries=<users>
where
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
E:\oracle\ora81\bin>orapwd file=e:\oracle\ora81\database\pwdorcl.ora password=or
acle
OPW-00005: 存在相同名称的文件 - 请删除或重命名
E:\oracle\ora81\bin>orapwd file=e:\oracle\ora81\database\pwdorcl.ora password=or
acle
E:\oracle\ora81\bin>svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 2000, Oracle Corporation. All Rights Reserved.
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SVRMGR> connect internal/oracle
连接成功。
------------------------------------------------------------------------------------------------------------------
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>sqlplus internal/oracle
SQL*Plus: Release 8.1.7.0.0 - Production on 星期三 7月 27 10:07:17 2011
(c) Copyright 2000 Oracle Corporation. All rights reserved.
连接到:
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL> shutdown immediate
ORA-01507: ??????
ORACLE 例程已经关闭。
SQL>
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 237856796 bytes
Fixed Size 75804 bytes
Variable Size 80416768 bytes
Database Buffers 157286400 bytes
Redo Buffers 77824 bytes
ORA-00214: ???? 'E:\ORACLE\ORADATA\ORCL\CONTROL02.CTL' ?? 12436 ???
'E:\ORACLE\ORADATA\ORCL\CONTROL01.CTL' ?? 12430 ???
【CONTROL02.CTL文件】
SQL> startup mount
ORA-01081: ????????? ORACLE --- ?????
SQL> shutdown immediate
ORA-01507: ??????
ORACLE 例程已经关闭。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 237856796 bytes
Fixed Size 75804 bytes
Variable Size 80416768 bytes
Database Buffers 157286400 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
SQL> alter database open;
数据库已更改。
SQL>
Tags: 

延伸阅读

最新评论

发表评论