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
10 g Error
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
http://www.oracle.com/technology/oramag ... sktom.html
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
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
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>
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>
Who is online
Users browsing this forum: No registered users and 2 guests