删除以前的数据库 新建一个之后
数据库启动报错
ora-01078: failure in processing system parameters
lrm-00109: could not open parameter file '/opt/oracle10/db_1/dbs/initcompany.ora'
解决方法:
$ORACLE_BASE/admin/(dbname) /pfile目录下的init.ora(.012009233838)文件复制到
$ORACLE_HOME/dbs目录下即可
[root@phoneDB pfile]# pwd
/home/oracle/admin/phone/pfile
[root@phoneDB pfile]# ls
init.ora.010200882414
[root@phoneDB pfile]#
/home/oracle/admin/phone/pfile
[root@phoneDB pfile]# ls
init.ora.010200882414
[root@phoneDB pfile]#
[root@phoneDB dbs]# pwd
/home/oracle/10.2.0/db_1/dbs
[root@phoneDB dbs]# ls
hc_phone.dat init.ora lkPHONE spfilephone.ora
initdw.ora init.ora.010200882414 orapwphone
/home/oracle/10.2.0/db_1/dbs
[root@phoneDB dbs]# ls
hc_phone.dat init.ora lkPHONE spfilephone.ora
initdw.ora init.ora.010200882414 orapwphone