Page 1 of 1
10 g Error
Posted: Mon Nov 27, 2006 10:17 am
by maga2724
I am getting these errors when I type startup. Actually I made the small changes in the SPFILEPROD. Kindly provide the help abot these errors.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-00600: internal error code, arguments: [733], [538970172], [pga heap], [], [
], [], [], []
SQL>
From,
Mohammed AbdulGaffar
Posted: Wed Nov 29, 2006 1:25 am
by admin
You can not make any changes directly in the spfile. Make changes dynamically with alter command or change in the init.ora and bounce back database by opening using init.ora and then update the spfile and then shutdown the database and open using spfile. thanks
Posted: Tue Dec 05, 2006 3:12 am
by maga2724
kindly bring me out 4m this error. If u need the spfile to be attached then let me know to send u.
Thanx
Posted: Tue Dec 05, 2006 3:23 am
by admin
Startup using init.ora and then create spfile from the active session.The following article is exact solution of your problem.
http://www.oracle.com/technology/oramag ... sktom.html
Posted: Tue Dec 05, 2006 3:54 am
by maga2724
hi,
could u provide the one by one command to do on this stage:
SQL> startup pfile=filename
LRM-00109: could not open parameter file 'filename'
ORA-01078: failure in processing system parameters
SQL>
Thanx
Posted: Tue Dec 05, 2006 4:49 am
by admin
Locate your init.ora file like shown below,
SQL> startup pfile=$ORACLE_HOME\database\initorcl.ora
After startup create spfile and restart your instance by shutting down and then statup and this time your new spfile will be used.
Pl do read,
http://forums.oracle.com/forums/thread. ... 0&tstart=0
Posted: Tue Dec 05, 2006 5:12 am
by maga2724
As you said i did this efforts, still there is problem, kinly help
Thanx
Enter user-name: system/ as sysdba
Enter password:
Connected to an idle instance.
SQL> startup pfile=$ORACLE_HOME\database\initorcl.ora
LRM-00109: could not open parameter file '$ORACLE_HOME\database\initorcl.ora'
ORA-01078: failure in processing system parameters
SQL> create spfile='filename'from pfile='pfilename';
create spfile='filename'from pfile='pfilename'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\PFILENAME'
SQL>
Posted: Tue Dec 05, 2006 5:17 am
by admin
Manually find the path and provide the full path instead of $ORACLE_HOME. Let us know you are on windows or using linux. thanks