10 g Error

[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

[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

[maga2724]

kindly bring me out 4m this error. If u need the spfile to be attached then let me know to send u.
Thanx

[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

[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

[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

[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>

[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