Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts

Apr 14, 2009

MAX_DUMP_FILE_SIZE

Limit the size of alert log files with this parameter.

Parameter can be changed at system or session level.
i.e. - alter system or alter session

Options are UNLIMITED or a number with size attributes, i.e.: - K, M, G.

To make life easier set this parameter to UNLIMITED.


http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams129.htm

Aug 21, 2008

ORA-27300: OS system dependent operation:semget failed with status: 28

Found this error when creating a 10.2.0.3 database on solaris 9.

This error can occur on any unix host when starting an oracle database. The error is saying that the semiphore parameters are not set correctly.

In cases like this, the first parameter to look for is SEMMNS

Essentially this parameter tells how many os processes shared memory components can use on the server. So the important oracle database parameter to look at is process.

Use the following calulation to work out what SEMMNS should be set to:

SEMMNS = sum(oracle processes) + num oracle databases + system requirements

This all suggests when setting up a new server you should have an idea of the number of databases running on the server or set the SEMMNS parameter to a fairly high number.

Aug 15, 2008

v$parameter2

This view is slightly different to v$parameter in that it seperates out the values for specific parameters into seperate rows.

Some examples of parameters where this may occur are :
- control_files
- utl_file_dir

Useful when wanting to query specific values, say a particular utl_file_dir or control file.
For this to work, the seperate values for these parameters must be seperated by commas.

i.e.:
alter system set utl_file_dir=

'/u01/ora_utl_file/hpac/',
'/home/sequel/cms/test/socrates/output/',
'/u01/ora_utl_file/contt/' scope=spfile ;