1 Reply Latest reply: Sep 5, 2013 7:02 PM by HDeiby RSS

    ORA-01078: failure in processing system parameters

    ora-seeker

      hi

      i am unable to startup database in SQL after i tried to increase the memory size .

      i have followed the below process

       

      SQL> conn sys/manager as sysdba;
      Connected.
      SQL> alter system set processes=1000 scope=spfile;

      System altered.

      SQL> alter system set sga_target=360M scope=spfile;

      System altered.

      SQL> alter system set sga_max_size=360M scope=spfile;

      System altered.

      SQL> shutdown;
      Database closed.
      Database dismounted.
      ORACLE instance shut down.
      SQL> startup;
      ORA-01078: failure in processing system parameters
      ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3
      72M

      .

      .

      ..i tried changing MEMORY_TARGET  with different values but unable to start up

      ..

       

      and

      i am using a 32-bit machine with windows-vista operating system

      ;;

      ;;please help me out .....thanks in advance