oracle 新建账号ORA-01078与LRM-00109报错解决

启动数据库时报如下错误:
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/orac/orahome/app/oracle/product/10.2.0/db_1/dbs/initjason.ora'
解决方法:
cp $ORACLE_BASE/admin/$ORACLE_SID/pfile/init.ora.7152011037 $ORACLE_BASE/product/10.2.0/db_1/dbs/initjason.ora
SQL> !
[oracle@jason ~]$ cp /orac/orahome/app/oracle/admin/JASON/pfile/init.ora.71520110373 /orac/orahome/app/oracle/product/10.2.0/db_1/dbs/initjason.ora
[oracle@jason ~]$ exit
exit
SQL> startup
ORACLE instance started.
Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              62916852 bytes
Database Buffers          100663296 bytes
Redo Buffers   &nboracle账号sp;            2973696 bytes
Database mounted.
Database opened.
SQL>
 
本文出自 “用心品位生活!” 博客

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。