ORA-01078 LRM0-00109
故障如下:
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn sys/hiss as sysdba
已连接到空闲例程。
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: ???????????????? 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\INITSYSG9.OR
A'
SQL>
SQL> exit
已断开连接
已连接到空闲例程。
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: ???????????????? 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\INITSYSG9.OR
A'
SQL>
SQL> exit
已断开连接
解决办法:
复制参数文件:
C:\Documents and Settings\Administrator>copy D:\oracle\product\10.2.0\admin\sysg
9\pfile\init.ora.6102009155632 D:\oracle\product\10.2.0\db_1\database\INITSYSG9.
ORA
已复制 1 个文件。
9\pfile\init.ora.6102009155632 D:\oracle\product\10.2.0\db_1\database\INITSYSG9.
ORA
已复制 1 个文件。
C:\Documents and Settings\Administrator>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.4.0 - Production on 29-7月 -2009 11:0
8:34
8:34
Copyright (c) 1991, 2007, Oracle. All rights reserved.
TNS-01106: 使用名称LISTENER的监听程序已经启动
C:\Documents and Settings\Administrator>sqlplus system/hiss
SQL*Plus: Release 10.2.0.4.0 - Production on 星期三 7月 29 11:08:41 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show sga
Total System Global Area 167772160 bytes
Fixed Size 1295608 bytes
Variable Size 71305992 bytes
Database Buffers 88080384 bytes
Redo Buffers 7090176 bytes
SQL>
Fixed Size 1295608 bytes
Variable Size 71305992 bytes
Database Buffers 88080384 bytes
Redo Buffers 7090176 bytes
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/18941195/viewspace-610704/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
没有了~
请登录后发表评论
登录
全部评论
