系统重新安装,oracle数据文件在D盘,安装Oracle时选择自定义,为了装那个什么透明网关,
手动dbca创建数据库,痛苦,得一个一个的吧{ORACLE_HOME}该成原先的路径
然后听到所有oracle 服务,将原来的oracle 文件还原
启动oracle的时候报 ora-01991 错误,重建oracle的密码文件okay
orapwd的格式
代码
SQL> host orapwd /help
Usage: orapwd file=<fname> password=<password> entries=<users>
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
Usage: orapwd file=<fname> password=<password> entries=<users>
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
del c:\oracle\ora92\database\pwdorcl.ora
C:\oracle\ora92\bin\orapwd.exe file=C:\oracle\ora92\database\PWDORCL.ora password=sys
sql>alter database open
okay

浙公网安备 33010602011771号