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 
Parameters:oracle:oinstall,dba:process.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/support/metalink/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

According to the previous link,
Sun Solaris OS 10 Information:
The following database products are certified on the Sun Solaris 10
operating system:
Oracle Database 9iR2 (with 9.2.0.4 and 9.2.0.6 Patchsets) for Sun
Solaris SPARC32
Oracle Database 9iR2 (with 9.2.0.5 and 9.2.0.6 Patchsets) for Sun
Solaris SPARC64
Oracle Database 10gR1 (with 10.1.0.3 Patchset) for Sun Solaris SPARC64
Oracle Database 10gR1 (with 10.1.0.3 Patchset) for Sun Solaris x86
When Oracle Database 10gR2 releases on Sun platforms later in 2005, the
following releases will be certified on the Sun Solaris 10 operating
system:
10gR2 Database for Sun Solaris SPARC64
10gR2 Database for Sun Solaris AMD64
10gR2 Database for Sun Solaris x86

So looks like I need to install 9.2.0.5 and 9.2.0.6 patchsets to
install Oracle

HansF wrote:

> - select some versions, select 'Certified Combinations only' & submit

Thanks for the info Hans. Unfortunately you need a support contract with 
  Oracle to download the required patches for Oracle 10g

Thanks and regards,
Andrew

On Mon, 04 Apr 2005 20:55:37 +1000, Andrew Tyson interested us by writing:

> HansF wrote:
> 
>> - select some versions, select 'Certified Combinations only' & submit
> 
> Thanks for the info Hans. Unfortunately you need a support contract with 
>   Oracle to download the required patches for Oracle 10g

You may also need to review the contract you made when you downloaded and
installed Oracle in the first place.  Hint: the free developer's license
is legally limited to development: you agree to purchase licenses to go
into produciton.  (Morals, anyone?)

If this issue is a constraint on development, rather than production, then
your legal option is to contact Oracle and ask for a free 30-day trial
license. You CAN get support and metalink access with that.  But you need
to talk with an Oracle sales rep.

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

Andrew Tyson wrote:

> HansF wrote:
> 
>> - select some versions, select 'Certified Combinations only' & submit
> 
> 
> Thanks for the info Hans. Unfortunately you need a support contract with 
>  Oracle to download the required patches for Oracle 10g
> 
> Thanks and regards,
> Andrew

Buy the license.
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

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 ***

> 
> Buy the license.

Presumably running the DB at home for self education doesn't constitute 
a breach of Oracle's licensing ...

> is legally limited to development: you agree to purchase licenses to go
> into produciton.  (Morals, anyone?)

Huh? It's installed on my machine at home for educational purposes. I 
guess the general Oracle community may not be aware that there are 
hobbyists who run Sun gear in the comfort of their own home.

Thanks again,
AT

On Tue, 05 Apr 2005 20:59:16 +1000, Andrew Tyson interested us by writing:

> 
>> is legally limited to development: you agree to purchase licenses to go
>> into produciton.  (Morals, anyone?)
> 
> Huh? It's installed on my machine at home for educational purposes. I 
> guess the general Oracle community may not be aware that there are 
> hobbyists who run Sun gear in the comfort of their own home.

Huh?  Did you happen to read the license to which you agreed before you
downloaded?  The agreement is not that long & written in language simple
enough for most developers and DBAs - even I can understand it.  Oracle
seems to ignore those people using the downloaded version for education,
but [afaik] that is not what you agreed to.

And yes, Oracle is quite aware that people have different OSs in their
homes.  For example they know that, largely to keep my skills current, I
have an UltraSPARC box running Solaris right beside several Windows and
Linux boxes.

And my boxes that have Oracle on them have paid licences with paid
support.  It's really not all that expensive in the grand scheme of things.

-- 
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 
>Parameters:oracle:oinstall,dba:process.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?
> 

In article <dl9ntg$c9q$1@newsreader3.netcologne.de>,
	Daniel Wetzler <danielwetzler@appleinfo.de> writes:
> 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?

man prctl

-- 
mailto:rlhamil@smart.net  http://www.smart.net/~rlhamil

Lasik/PRK theme music:
    "In the Hall of the Mountain King", from "Peer Gynt"

Besides top posting you are replying to a thread that ( until you
jumped in ) ended more than 6 months ago.