Friday, February 25, 2011

ORA-01078: LRM-00109 :

-> hari minggu pagi ini dapet sarapan
#ORA-01078: failure in processing system parameters
#LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initTSH1.ora'
di vbox gw,, karna gw mo yobail biki simulasi oracle to oracle replicte..
tdi mlm gw install oracle di RHEL 05 di vbox, pass beres install oracle na gw startup ehh
keluar error tdi..

ngembah google dulu....

nie solutionnya

-> cari init,pfile atau spfile

[oracle@redhost ~]$ find $ORACLE_BASE -name init*.ora
/u01/app/oracle/product/10.2.0/db_1/srvm/admin/init.ora
/u01/app/oracle/product/10.2.0/db_1/dbs/init.ora <--
/u01/app/oracle/product/10.2.0/db_1/dbs/initdw.ora
/u01/app/oracle/product/10.2.0/db_1/hs/admin/inithsodbc.ora

-> start database
SQL> startup pfile ='/u01/app/oracle/product/10.2.0/db_1/dbs/init.ora'

No comments: