ERROR at line 1: ORA-01078: failure in processing system parameters LRM-00123: invalid character 158 found in the input file 原来在init$sid.ora的文件, 我自己在注释部分加入了中文. 不能有中文呀, 连注释都不行.
ORA-01078: failure in processing system parameters LRM-00123: invalid character 0 found in the input file 在提交startup命令之后,Oracle会自动按照如下的顺序查找参数文件完成数据库的启动。 1)spfile$ORACLE_SID.ora 2)spfile.ora 3)init$ORACLE_SID.ora 应该是这三个参数文件都找不到,或是有问题导致start...
ORA-01078: failure in processing system parameters LRM-00123: invalid character 0 found in the input file 在提交startup命令之后,Oracle会自动按照如下的顺序查找参数文件完成数据库的启动。 1)spfile$ORACLE_SID.ora 2)spfile.ora 3)init$ORACLE_SID.ora 应该是这三个参数文件都找不到,或是有问题导致start...
只是因为数据库名称没有全是英文造成的，数据库文件路径也必须全是英文
ORA-01078: LRM-00123: 3.0 Mos ID ORA-847Setting LOCK_SGA Parameter to True (文档 ID793284.1) Oracle Database- Enterprise Edition - Version11.1.0.6and later CAUSE LOCK_SGA and MEMORY_TARGET/MEMORY_MAX_TARGET cannot besetat the same timeasthe SGA might grow and shrink due to MEMORY_TARGET ...
50 LRM-00100 to LRM-00123 51 LSX-00001 to LSX-00347 52 MGTCA-01001 to MGTCA-01724 53 NCR-00001 to NCR-04028 54 NDFN-00020 to NDFN-00025 55 NID-00001 to NID-00604 56 NMP-00001 to NMP-00011 57 NNC-00001 to NNC-00501 58 NNF-00001 to NNF-04009 59 NNL-00001 to ...
50 LRM-00100 to LRM-00123 51 LSX-00001 to LSX-00347 52 MGTCA-01001 to MGTCA-01724 53 NCR-00001 to NCR-04028 54 NDFN-00020 to NDFN-00025 55 NID-00001 to NID-00604 56 NMP-00001 to NMP-00011 57 NNC-00001 to NNC-00501 58 NNF-00001 to NNF-04009 59 NNL-00001 to ...
LRM-00123: invalid character 0 found in the input file ORA-01078: failure in processing system parameters What is more interesting is that there are no any additional information in ALERT.LOG file, so You have to guess… Someone will try to restore PFILE/SPFILE from backup, but You have ju...
Connected to an idle instance.SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file'/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora'SQL> exit Disconnected [oracle@localhost dbs]# ls ...
create spfile from pfile * ERROR at line 1: ORA-01078: failure in processing system parameters LRM-00123: invalid character 158 found in the input file 原来在init$sid.ora的文件, 我自己在注释部分加入了中文. 不能有中文呀, 连注释都不行....