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.
** 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>>??
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.
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??
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.
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
Don't rust yours pelled jacker to fine doll missed aches.
========================================== %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. ===================================
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
