- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- SYSGEN problem while installing Oracle10g !!
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 06:27 PM
07-11-2007 06:27 PM
SYSGEN problem while installing Oracle10g !!
$ @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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 08:11 PM
07-11-2007 08:11 PM
Re: SYSGEN problem while installing Oracle10g !!
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 08:57 PM
07-11-2007 08:57 PM
Re: SYSGEN problem while installing Oracle10g !!
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 09:01 PM
07-11-2007 09:01 PM
Re: SYSGEN problem while installing Oracle10g !!
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.
Purely Personal Opinion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 09:30 PM
07-11-2007 09:30 PM
Re: SYSGEN problem while installing Oracle10g !!
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 09:49 PM
07-11-2007 09:49 PM
Re: SYSGEN problem while installing Oracle10g !!
using the
MIN_
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 10:19 PM
07-11-2007 10:19 PM
Re: SYSGEN problem while installing Oracle10g !!
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 10:46 PM
07-11-2007 10:46 PM
Re: SYSGEN problem while installing Oracle10g !!
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 11:16 PM
07-11-2007 11:16 PM
Re: SYSGEN problem while installing Oracle10g !!
Purely Personal Opinion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2007 11:37 PM
07-11-2007 11:37 PM
Re: SYSGEN problem while installing Oracle10g !!
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2007 12:34 AM
07-12-2007 12:34 AM
Re: SYSGEN problem while installing Oracle10g !!
When you want to change the parameters do
$ @SYS$UPDATE:AUTOGEN SAVPARAMS SETPARAMS FEEDBACK
Check for any errors and then reboot.
Purely Personal Opinion