Need to alter number of sessions in init.ora or spfile...

I am trying to increase the number of session in my init.ora file.  I'm running Oracle 9i and I'm doing the following:

alter system sessions=300 scope=both;

I'm getting the following error:
Ora-02065: illegal option for ALTER SYSTEM

 was able to do the alter system command to increase the number of cursors...so can someone tell me why this doesn't work for sessions?  And how to increase that parameter....

Thanks!
jl1884Asked:
Who is Participating?
 
DonFreemanConnect With a Mentor Commented:
From what I'm reading, the parameter is static. Looking at the command reference it looks like you can't do it on-line. Where did you get the syntax for the command you are
trying?

0
 
jl1884Author Commented:
I got the command from an oracle book I have on 9i fundamentals.  I think the problem might be that the parameter is not listed in my SPFILE....if I use the alter system command, the parameter has to already exist in order to be altered....

Now I'm thinking that I might recreate my spfile from my pfile (and add a line that has session=300)...then restart the db.

Does that sound like it would fix the problem?
0
 
jl1884Author Commented:
I got the command from an oracle book I have on 9i fundamentals.  I think the problem might be that the parameter is not listed in my SPFILE....if I use the alter system command, the parameter has to already exist in order to be altered....

Now I'm thinking that I might recreate my spfile from my pfile (and add a line that has session=300)...then restart the db.

Does that sound like it would fix the problem?
0
 
DonFreemanCommented:
I would try it and find out. I didn't find anything like the command you are trying in the Oracle 9i reference. But, I'm not a guru. It looks like it has to be in the file.
0
All Courses

From novice to tech pro — start learning today.