ORA-01078: failure in processing system parameters & LRM-00109: could not open parameter file

简介:

安装了Oracle 12C后,启动数据库的过程中出现如下错误
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0/db_1/dbs/initepps.ora'


[oracle@gettestlnx01 ignite]$ cd /u01/app/oracle/product/12.1.0/db_1/dbs/
发 现在 /u01/app/oracle/product/12.1.0/db_1/dbs/下找不到initepps.ora文件,于是 去$ORACLE_HOME/admin/ignite/pfile下,找到文件init.ora.1242014234024,然后将文件拷贝到 /u01/app/oracle/product/12.1.0/db_1/dbs/目录下,并重命名为initepps.ora后,重启数据,问题解 决!
[oracle@gettestlnx01 dbs]$ cd /u01/app/oracle/admin/ignite/pfile
[oracle@gettestlnx01 pfile]$ ls
init.ora.1242014234024

[oracle@gettestlnx01 pfile]$ cp init.ora.1242014234024  /u01/app/oracle/product/12.1.0/db_1/dbs/initepps.ora
SQL> startup
ORACLE instance started.

Total System Global Area 1870647296 bytes
Fixed Size                  2289640 bytes
Variable Size             587202584 bytes
Database Buffers         1275068416 bytes
Redo Buffers                6086656 bytes
Database mounted.
Database opened.

相关文章
verbose stack FetchError: request to https://registry.npm.taobao.org/md-editor-v3 failed, reason: ce
这篇文章描述了在安装npm包`md-editor-v3`时遇到的淘宝镜像证书过期问题,并提供了解决方案,即通过切换npm镜像源到`https://registry.npmmirror.com/`来解决安装失败的问题。
verbose stack FetchError: request to https://registry.npm.taobao.org/md-editor-v3 failed, reason: ce
|
Linux
WARNING: Re-reading the partition table failed with error 22: Invalid argument
在划分磁盘分区时,遇到错误“WARNING: Re-reading the partition table failed with error 22: Invalid argument” 如下所示: [root@DB-Server u02]# fdisk -l   Disk /dev/sda: 500.
2537 0
2015-03-18 - Deliberately pass a wrong note type for my task creation
2015-03-18 - Deliberately pass a wrong note type for my task creation
95 0
2015-03-18 - Deliberately pass a wrong note type for my task creation
|
SQL 监控
backup log is terminating abnormally because for write on file failed: 112(error not found)
昨天遇到一个案例,YourSQLDba做事务日志备份时失败,检查YourSQLDba输出的错误信息如下:   yMaint.backups backup log [gewem] to disk = 'M:\DB_BACKUP\LOG_BACKUP\xxxx_[2016-11-22_01h11m05_Tue]_logs.
1233 0