Hi,

Having just installed Solaris 10 GA on my SB1K I thought I might attempt
an Oracle 10g install. Despite Sun/Oracle promulgating that the
version of the OS is supported I notice that the installation only
alludes to Solaris 8 and Solaris 9 as compatible platforms.

I managed to overcome the first hurdle of tweaking the runInstaller
script to accept SunOS 5.10, however I notice that the installation
broke once it tried creating the initial sample DB. I got quite a few
errors with regards to the TNS listener, and also to the effect that
various system parameters relating to shared memory and semaphores
weren't set correctly.

In light of the fact that most of the Oracle specified Solaris kernel
tunable parameters are deprecated I attempted to replicate the required
settings by associating a Solaris 'project' with the 'oinstall' group
and setting various parameters this way, extract from /etc/project as
follows

oracle:101:Oracle Project For System
Parametersracleinstall,dbarocess.max-sem-nsems=(privileged, 256,
none);project.max-sem-ids=(privileged, 100,
none);project.max-shm-ids=(privileged, 100,
none);project.max-shm-memory=(privileged, 4294967295b, none)

There is not a direct mapping between the old system tunable parameters
and the new project based parameters as far as I can tell though.

Is there any form of guide for the setup? I could not find anything
useful through NG searches.

I would appreciate any helpful tips anyone might have.

Thanks and regards,
Andrew

I also expericencing same issue for an Oracle9i installation on Solaris
10. I have a 1 GB RAM, 2 GB swap and lot of disk space. I am getting
Ora Err: Out of Memory.

The oracle documentation asks for increased value in shmmax, shmmni etc
in /etc/system. But the Sun docs says those changes are not required as
Solaris 10 uses "rcladm" to manage these resources and by default
shmmax is 1/4 of memory installed and OS will adjust the value
dynamically.

I did not find a simple command to see the existing values for these
shared memory variables or a way to increase it in case I need it. Yes
I agree there are some resource control programs available. But I am
not able to interpret it correctly. Sun needs to come up with a better
tutorial for this feature.
Any tips?

In article <1112551360.804733.119430@l41g2000cwc.googlegroups .com>,
"madhu" <eloormadhu@hotmail.com> wrote:

> I also expericencing same issue for an Oracle9i installation on Solaris
> 10. I have a 1 GB RAM, 2 GB swap and lot of disk space. I am getting
> Ora Err: Out of Memory.
>
> The oracle documentation asks for increased value in shmmax, shmmni etc
> in /etc/system. But the Sun docs says those changes are not required as
> Solaris 10 uses "rcladm" to manage these resources and by default
> shmmax is 1/4 of memory installed and OS will adjust the value
> dynamically.
>
> I did not find a simple command to see the existing values for these
> shared memory variables or a way to increase it in case I need it. Yes
> I agree there are some resource control programs available. But I am
> not able to interpret it correctly. Sun needs to come up with a better
> tutorial for this feature.
> Any tips?

Is Oracle 10g certified to run on Solaris 10 yet?

--
DeeDee, don't press that button! DeeDee! NO! Dee...

On 3 Apr 2005 11:02:40 -0700, "madhu" <eloormadhu@hotmail.com> wrote:

>I also expericencing same issue for an Oracle9i installation on Solaris
>10. I have a 1 GB RAM, 2 GB swap and lot of disk space. I am getting
>Ora Err: Out of Memory.
>
>The oracle documentation asks for increased value in shmmax, shmmni etc
>in /etc/system. But the Sun docs says those changes are not required as
>Solaris 10 uses "rcladm" to manage these resources and by default
>shmmax is 1/4 of memory installed and OS will adjust the value
>dynamically.
>
>I did not find a simple command to see the existing values for these
>shared memory variables or a way to increase it in case I need it. Yes
>I agree there are some resource control programs available. But I am
>not able to interpret it correctly. Sun needs to come up with a better
>tutorial for this feature.
>Any tips?

Downgrade the system to Solaris 9, to find out whether it is an Oracle
/Solaris incompatibility. As someone posted here before Oracle 9i is
NOT certified against Solaris 10, so you are on your own.


--
Sybrand Bakker, Senior Oracle DBA

On Sun, 03 Apr 2005 13:29:58 -0700, Michael Vilain interested us by
writing:

> Is Oracle 10g certified to run on Solaris 10 yet?

Self-help for Oracle certifications:

Go to http://OTN.oracle.com
expand under Services (menu item)
click on Support
click on Product Certifications
(aka http://www.oracle.com/technology/sup...ink/index.html)

There are some interesting notes against Solaaris OS 10 for both 9iR2 and
10g (which are both certified). To see them,

- click link "View Certifications by Platform"
- select "Solaris Operating System (SPARC)" & submit
- select "Oracle Database/Server" & submit
- select "Oracle Database - Enterprise Server" & submit
- select some versions, select 'Certified Combinations only' & submit
- click 'Yes' under Additional Information'

(Followup kept to cdo.server)
/Hans
--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

> Downgrade the system to Solaris 9, to find out whether it is an
Oracle
> /Solaris incompatibility. As someone posted here before Oracle 9i is
> NOT certified against Solaris 10, so you are on your own.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

I had Oracle9i on Solaris9 running on this box till this Solaris 10
install

I fixed the problem by adding the the shmmax and semmni related entries
in /etc/system in contradictory to the SUN documentation

After adding the following entries, I was able to create database
without the Out of Memory error.

set shmsys:shminfo_shmmax=1073741824
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=2000
set semsys:seminfo_semmsl=1000
set semsys:seminfo_semmni=100

Solaris 10 kernel tuning docs mentioned that these above entries are
not needed for Solaris 10 as those are allocated dynamically using
rcladm.

My Oracle version is 9.2.0.1.0

Could some kernel expert comment about this

On Mon, 04 Apr 2005 21:49:35 -0700, madhu interested us by writing:


> Solaris 10 kernel tuning docs mentioned that these above entries are
> not needed for Solaris 10 as those are allocated dynamically using
> rcladm.

My guess ...

Yes, Solaris 10 allocates on demand, probably in response to a system
call. However Oracle presumes that it has already been allocated and tries
to use it - it ain't been allocated when Oracle wants it and so you have a
race.

I suspect this will be an ongoing problem that tracks Oracle history:
Ever notice that you need to pre-allocate the tablespace (or grow it in
pre-defined chunks), even though a lot of other RDBMSs grow on demand?
Oracle likes to have things presized so there are no (or minimal) delays
to accomodate expansion.


--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

In article <424f6a0a$0$5595$afc38c87@news.optusnet.com.au>,
Andrew Tyson <atyson@optus.please.refrain.from.spamming.net> wrote:
>tunable parameters are deprecated I attempted to replicate the required
>settings by associating a Solaris 'project' with the 'oinstall' group

Does id -p show that the oracle user is in the project?

>and setting various parameters this way, extract from /etc/project as
>follows
>
>oracle:101:Oracle Project For System
>Parametersracleinstall,dbarocess.max-sem-nsems=(privileged, 256,
>none);project.max-sem-ids=(privileged, 100,
>none);project.max-shm-ids=(privileged, 100,
>none);project.max-shm-memory=(privileged, 4294967295b, none)

resource_controls(5)
Note that unit modifiers (for example, 5G) are accepted by
the prctl(1), projadd(1M), and projmod(1M) commands. You
cannot use unit modifiers in the project database itself.

John
groenveld@acm.org

Hi,

I had the same problem on my Solaris 10 mashine.
I had to increase the swap space on it.


Best regards,

Daniel





madhu wrote:

> I also expericencing same issue for an Oracle9i installation on Solaris
> 10. I have a 1 GB RAM, 2 GB swap and lot of disk space. I am getting
> Ora Err: Out of Memory.
>
> The oracle documentation asks for increased value in shmmax, shmmni etc
> in /etc/system. But the Sun docs says those changes are not required as
> Solaris 10 uses "rcladm" to manage these resources and by default
> shmmax is 1/4 of memory installed and OS will adjust the value
> dynamically.
>
> I did not find a simple command to see the existing values for these
> shared memory variables or a way to increase it in case I need it. Yes
> I agree there are some resource control programs available. But I am
> not able to interpret it correctly. Sun needs to come up with a better
> tutorial for this feature.
> Any tips?
>