topic Re: SYSGEN problem while installing Oracle10g !! in Operating System - OpenVMS

SYSGEN problem while installing Oracle10g !!

Manesh Sasankan — Thu, 12 Jul 2007 01:27:02 GMT

i'm trying to install Oracle 10g to OpenVMS itanium 8.2-1. i have created a seperate accoundt for installing & this is the error i'm getting while running the RUNINSTALLER.COM

$ @runinstaller

Checking OpenVMS quota settings...
-------------------------------
ERROR: One or more of your OpenVMS SYSGEN parameters is lower than
the minimum requirements for running Oracle 10g databases.

Parameter - Quota - Minimum Recommended
PQL_MPGFLQUOTA - 512000 - 32768 - 1500000 <<
PQL_MASTLM - 100 - 100 - 250 <<
PQL_MBYTLM - 128000 - 100000 - 750000 <<
PQL_MENQLM - 300 - 300 - 2000 <<
PQL_MFILLM - 100 - 100 - 250 <<
CHANNELCNT - 512 ** - 2048 << - 2048

** The OpenVMS SYSGEN parameter(s) indicated must be adjusted to
at least the miniumum values shown. You are, however, urged
to implement all of the recommended values.

%SYSTEM-F-ABORT, abort

How can i change these sysgen parameter? using MC sysman>>??

Please help !!

Thanks,
Manesh

Re: SYSGEN problem while installing Oracle10g !!

Daniel Fernandez Illan — Thu, 12 Jul 2007 03:11:07 GMT

Hi Manesh

You can change parameters using $mc SYSGEN (they are dinamics) except for CHANNELCNT parameter.
The best option is to modify SYS$SYSTEM:MODPARAMS.DAT adding lines similar to:
MIN_parameter = recommended value
and execute AUTOGEN utility.

Saludos.
Daniel.

Re: SYSGEN problem while installing Oracle10g !!

Manesh Sasankan — Thu, 12 Jul 2007 03:57:51 GMT

Thanks Daniel..

Small doubt on that.. if i want to change
PQL_MASTLM from 100 to 250, then the info on modparams.dat should be like this or wat:

MIN_PQL_MASTLM = 250 [ i read this info in oracle install guide that

The MIN prefix indicates that you are setting a lower limit for the specified parameter. To use the MIN prefix, identify the current value of the specified parameter (using SYSGEN) and the amount by which you want to increase the parameter. The sum of these two values is used for the MIN_parameter entry.

And after changing this particular value in MODPARAMS.DAT, how to run the AUTOGEN utility & do i have to reboot the system??

Manesh

Re: SYSGEN problem while installing Oracle10g !!

Ian Miller. — Thu, 12 Jul 2007 04:01:13 GMT

If the procedure for changing the parameters is not described in the installation manual (it should be) then see the VMS System Managers manual

http://h71000.www7.hp.com/doc/82FINAL/aa-pv5nj-tk/00/00/10-con.html

Note that OpenVMS itanium 8.3 is a significant improvement over V8.2-1 and it is recommended you upgrade.

Re: SYSGEN problem while installing Oracle10g !!

Daniel Fernandez Illan — Thu, 12 Jul 2007 04:30:45 GMT

Hi Manesh
This link describes how use AUTOGEN on Oracle 10g installation:

http://download.oracle.com/docs/cd/B19306_01/install.102/b25414/pre_inst.htm#BHAJHICE

I think that you need only indicates MIN_parameter=value with value equal to recommended by Oracle, and execute AUTOGEN as is indicated on installation manual.
MIN_PQL_MPGFLQUOTA = 1500000
MIN_PQL_MASTLM = 250
MIN_PQL_MBYTLM = 750000
MIN_PQL_MENQLM = 2000
MIN_PQL_MFILLM = 250
MIN_CHANNELCNT = 2048
And yes, you need reboot because CHANNELCNT is not a dynamic paramater.

Saludos.
Daniel.

Re: SYSGEN problem while installing Oracle10g !!

Jan van den Ende — Thu, 12 Jul 2007 04:49:40 GMT

Manesh,

using the
MIN_ = construct makes it possible for some other product to specify a different minimal value, and then the highest minimum will be used, sa as not to have one product enforce a value that is LOWER than the minimum for another product.
So that is a wise thing to do.

After you have editted MODPARAMS.DAT to comply, do
$ @SYS$UPDATE:AUTOGEN SAVPARAMS TESTFILES FEEDBACK

It will produce a report, please check that for any weird changes.

It satisfied, do
$ @SYS$UPDATE:AUTOGEN SETPARAMS REBOOT

--- you did not indicate if this is a cluster. If so, do this on every node!

--- BTW, have you considered upgrading VMS to 8.3 before installing Oracle? If you do not have very good reasons to stay at 8.2(-1) moving forward really is the wise thing to do!

Success.

Proost.

Have one on me.

jpe

Re: SYSGEN problem while installing Oracle10g !!

Manesh Sasankan — Thu, 12 Jul 2007 05:19:12 GMT

Thanks for all ur replies.

when i ran this

$ @SYS$UPDATE:AUTOGEN SAVPARAMS TESTFILES FEEDBACK

i got the below error:

==========================================
%AUTOGEN-I-BEGIN, TESTFILES phase is beginning.

Calculations for page, swap, and dump files.
--------------------------------------------

Errorlog dumpfile calculations:

No errorlog dump file modifications should be made.
Errorlog dumpfile will remain at 466 blocks.

Dump file calculations:

A 457776 block dump file should be created.

Page file calculations:

PAGEFILE1_SIZE information (for SYS$SYSTEM:PAGEFILE.SYS):
Feedback information.
Old value was 2104600, New value is 2104600
Maximum observed usage: 0
PAGEFILE1 will not be modified. The file size is within 10%

Swap file calculations:

SWAPFILE1_SIZE information (for SYS$SYSTEM:SWAPFILE.SYS):
Feedback information.
Old value was 53100, New value is 42500
Maximum observed usage: 0
SWAPFILE1_SIZE will be modified to hold 42500 blocks

******************
%AUTOGEN-W-REPORT, Warnings were detected by AUTOGEN. Please review the
information given in the file SYS$SYSTEM:AGEN$PARAMS.REPORT
******************

%AUTOGEN-I-REPORT, AUTOGEN has produced some informational messages which
have been stored in the file SYS$SYSTEM:AGEN$PARAMS.REPORT. You may
wish to review the information in that file.
===================================

Any comments on this??

/Manesh

Re: SYSGEN problem while installing Oracle10g !!

Karl Rohwedder — Thu, 12 Jul 2007 05:46:59 GMT

Manesh,

I usally prefer to disable handling of page/Swapfiles by AUTOGEN by setting:

Pagefile = 0
Swapfile = 0
Dumpfile = 0

I then adjust the sizes manually taking AUTOGEN's recommendations into account.

regards Kalle

Re: SYSGEN problem while installing Oracle10g !!

Ian Miller. — Thu, 12 Jul 2007 06:16:34 GMT

What are the informational messages in SYS$SYSTEM:AGEN$PARAMS.REPORT?

Re: SYSGEN problem while installing Oracle10g !!

Manesh Sasankan — Thu, 12 Jul 2007 06:37:44 GMT

Thanks for ur reply.

So do i have add this in modparams.dat like this

Pagefile = 0
Swapfile = 0
Dumpfile = 0
MIN_PQL_MPGFLQUOTA = 1500000
MIN_PQL_MASTLM = 250
MIN_PQL_MBYTLM = 750000
MIN_PQL_MENQLM = 2000
MIN_PQL_MFILLM = 250
MIN_CHANNELCNT = 2048

& then run this

$ @SYS$UPDATE:AUTOGEN SAVPARAMS TESTFILES FEEDBACK

Ian,

i have lookded into the the SYS$SYSTEM:AGEN$PARAMS.REPORT & here are its output

WINDOW_SYSTEM parameter information:
- AUTOGEN parameter calculation has been overridden.
The calculated value was 0. The value 1
will be used in accordance with the following requirements:
WINDOW_SYSTEM has been specified by a hard-coded value of 1.

Calculations for page, swap, and dump files.
--------------------------------------------

Errorlog dumpfile calculations:

No errorlog dump file modifications should be made.
Errorlog dumpfile will remain at 466 blocks.

Dump file calculations:

A 457776 block dump file should be created.

Page file calculations:

PAGEFILE1_SIZE information (for SYS$SYSTEM:PAGEFILE.SYS):
Feedback information.
Old value was 2104600, New value is 2104600
Maximum observed usage (blocks): 0
PAGEFILE1 will not be modified. The file size is within 10%

Swap file calculations:

SWAPFILE1_SIZE information (for SYS$SYSTEM:SWAPFILE.SYS):
Feedback information.
Old value was 53100, New value is 42500
Maximum observed usage (blocks): 0
SWAPFILE1_SIZE will be modified to hold 42500 blocks

Thanks,
Manesh

Re: SYSGEN problem while installing Oracle10g !!

Ian Miller. — Thu, 12 Jul 2007 07:34:25 GMT

OK. How big is your system dump file?

When you want to change the parameters do

$ @SYS$UPDATE:AUTOGEN SAVPARAMS SETPARAMS FEEDBACK

Check for any errors and then reboot.