Message-Id: <10746.127162@fatcity.com> From: "Walter K" Date: Fri, 19 Jan 2001 10:37:54 -0800 Subject: Change Licensing Parameters (part 2) This is a multi-part message in MIME format. ------=_NextPart_000_008F_01C08203.E13B8160 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Interestingly, the values for these parameters are not being updated in = v$parameter whether I change them dynamically or via the init.ora. = HOWEVER, the values are reported correctly when I do a SHOW PARAMETERS = LICEN command. What's up with that? Lastly, I am seeing the database control the number of concurrent = sessions relative to the value I have set for LICENSE_MAX_SESSIONS. But, = the warning message is not being displayed at connect time when the = LICENSE_SESSIONS_WARNING threshold is reached. Any ideas? Thanks again. -w ----- Original Message -----=20 From: Walter K=20 To: oracle-l=20 Sent: Friday, January 19, 2001 10:08 AM Subject: Change Licensing Parameters Hi, I was playing with the licensing parameters (init.ora) today and I don't = seem to be having any luck trying to change the values. By the way, this = is just a play database (NT/Win2000 v8.1.7 EE) Currently, the database reports that I have the following values: license_max_sessions 14 license_sessions_warning 15 license_max_users 298 I did not set the above values, they were there after creation of the = database. I cannot change any of these values (up or down) dynamically = with ALTER SYSTEM, even though I am supposed to be able to, nor did I = have any success changing them (up or down) in the init.ora file and = restarting the database. Any suggestions? I downloaded the database executables from Technet--is = this the problem? Thanks! -w ------=_NextPart_000_008F_01C08203.E13B8160 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Interestingly, the values for these = parameters are=20 not being updated in v$parameter whether I change them dynamically or = via the=20 init.ora. HOWEVER, the values are reported correctly when I do a SHOW = PARAMETERS=20 LICEN command. What's up with that?
 
Lastly, I am seeing the database = control the number=20 of concurrent sessions relative to the value I have set for=20 LICENSE_MAX_SESSIONS. But, the warning message is not being displayed at = connect=20 time when the LICENSE_SESSIONS_WARNING threshold is reached. Any=20 ideas?
 
Thanks again.
-w
 
----- Original Message -----=20
From: Walter = K=20
To: oracle-l
Sent: Friday, January 19, 2001 10:08 AM
Subject: Change Licensing Parameters

Hi,
 
I was playing with the licensing = parameters=20 (init.ora) today and I don't seem to be having any luck trying to change = the=20 values. By the way, this is just a play database (NT/Win2000 v8.1.7=20 EE)
 
Currently, the database reports that I = have the=20 following values:
    license_max_sessions = 14
    = license_sessions_warning=20 15
    license_max_users=20 298
 
I did not set the above values, they = were there=20 after creation of the database. I cannot change any of these values (up = or down)=20 dynamically with ALTER SYSTEM, even though I am supposed to be able to, = nor did=20 I have any success changing them (up or down) in the init.ora file and=20 restarting the database.
 
Any suggestions? I downloaded the = database=20 executables from Technet--is this the problem?
 
Thanks!
-w
------=_NextPart_000_008F_01C08203.E13B8160-- __________________________________________________