Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

starting oracle with solaris project

7 views
Skip to first unread message

Wolfgang

unread,
Jul 12, 2007, 5:12:58 PM7/12/07
to
i want to start serveral database under resource control, every instance
with a different solaris project.

the problem is we use a shared listener. is there a way to configure the
instance with a project, so the listener start all client processes in a
project according the project of the instance and not the project of the
listener?

thanks
Wolfgang

DA Morgan

unread,
Jul 12, 2007, 10:59:20 PM7/12/07
to

If you are contemplating using 10g containers ... check with metalink to
see if you will be supported. Last time I looked they were a really bad
idea.
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Wolfgang

unread,
Jul 14, 2007, 4:34:16 AM7/14/07
to
DA Morgan schrieb:

> Wolfgang wrote:
>> i want to start serveral database under resource control, every
>> instance with a different solaris project.
>>
>> the problem is we use a shared listener. is there a way to configure
>> the instance with a project, so the listener start all client
>> processes in a project according the project of the instance and not
>> the project of the listener?
>>
>> thanks
>> Wolfgang
>
> If you are contemplating using 10g containers ... check with metalink to
> see if you will be supported. Last time I looked they were a really bad
> idea.
i want use solaris projects, for every instance one project. It is not a
problem with a dedicated listener for every oracle instance, then i can
start the listener with a project. but a shared listener forks the
clients under his own project.

i hear the first time about 10g containers, but am not a oracle admin
and nevertheless i want to have control over the processes if possible.

is there a possibility to call somthing like pre or post-scripts when
forcing a client process from listeners?

Thanks
Wolfgang

DA Morgan

unread,
Jul 14, 2007, 9:32:05 AM7/14/07
to

There is no such thing as "10g containers" and unless my google searches
are having a problem with such a common phrase there is no such thing as
"Solaris projects" either. Are you sure you are not referring to Solaris
10 Containers? If so they are not truly supported by Oracle and you are
setting yourself up for lots of pain and suffering.

If there is something called "Solaris Projects" please provide a link as
I would like to learn what they are. Thanks.

Andrew Gabriel

unread,
Jul 14, 2007, 11:36:05 AM7/14/07
to
In article <11844199...@bubbleator.drizzle.com>,

DA Morgan <damo...@psoug.org> writes:
>
> If there is something called "Solaris Projects" please provide a link as
> I would like to learn what they are. Thanks.

man project

--
Andrew Gabriel
[email address is not usable -- followup in the newsgroup]

DA Morgan

unread,
Jul 14, 2007, 11:52:18 AM7/14/07
to
Andrew Gabriel wrote:
> In article <11844199...@bubbleator.drizzle.com>,
> DA Morgan <damo...@psoug.org> writes:
>> If there is something called "Solaris Projects" please provide a link as
>> I would like to learn what they are. Thanks.
>
> man project

That requires having Solaris which I not have access to in my lab.

Surely there is some online documentation or mention on the web.

And, again, do they relate do Solaris 10 containers? Is there some
reason no one can state what they are?

Chris Ridd

unread,
Jul 14, 2007, 12:12:19 PM7/14/07
to
On 2007-07-14 16:52:18 +0100, DA Morgan <damo...@psoug.org> said:

> Andrew Gabriel wrote:
>> In article <11844199...@bubbleator.drizzle.com>,
>> DA Morgan <damo...@psoug.org> writes:
>>> If there is something called "Solaris Projects" please provide a link as
>>> I would like to learn what they are. Thanks.
>>
>> man project
>
> That requires having Solaris which I not have access to in my lab.
>
> Surely there is some online documentation or mention on the web.

Sun's manuals (including man pages) are all available online from the
new improved <http://docs.sun.com/>. You should definitely look there.

> And, again, do they relate do Solaris 10 containers? Is there some
> reason no one can state what they are?

I think there's an element here of "do your own homework" ;-) No
offence intended.

Incidentally, the top hit returned by googling for "solaris projects"
looks like a useful article.

Cheers,

Chris

John L

unread,
Jul 14, 2007, 12:44:56 PM7/14/07
to

"DA Morgan" <damo...@psoug.org> wrote in message news:11844283...@bubbleator.drizzle.com...

> Andrew Gabriel wrote:
> > In article <11844199...@bubbleator.drizzle.com>,
> > DA Morgan <damo...@psoug.org> writes:
> >> If there is something called "Solaris Projects" please provide a link as
> >> I would like to learn what they are. Thanks.
> >
> > man project
>
> That requires having Solaris which I not have access to in my lab.
>
> Surely there is some online documentation or mention on the web.
>
> And, again, do they relate do Solaris 10 containers? Is there some
> reason no one can state what they are?

Have a look at this Solaris blueprint about running Oracle in
containers (and projects) which is on-topic for both newsgroups.
http://www.sun.com/blueprints/0505/819-2679.pdf

--
John.


gerryt

unread,
Jul 14, 2007, 1:18:00 PM7/14/07
to
On Jul 14, 8:52 am, DA Morgan <damor...@psoug.org> wrote:
> Andrew Gabriel wrote:
> > In article <1184419924.848...@bubbleator.drizzle.com>,

> > DA Morgan <damor...@psoug.org> writes:
> >> If there is something called "Solaris Projects" please provide a link as
> >> I would like to learn what they are. Thanks.
> > man project
> That requires having Solaris which I not have access to in my lab.
> Surely there is some online documentation or mention on the web.

Indeed
Its online with a little Google assistance:

http://docs.sun.com/app/docs/doc/816-5174/6mbb98uiu?a=view

> And, again, do they relate do Solaris 10 containers? Is there some
> reason no one can state what they are?

man -s 5 zones on Solaris 10

NAME
zones - Solaris application containers

DESCRIPTION
The zones facility in Solaris provides an isolated environ-
ment for running applications. Processes running in a zone
are prevented from monitoring or interfering with other
activity in the system. Access to other processes, network
interfaces, file systems, devices, and inter-process commun-
ication facilities are restricted to prevent interaction
between processes in different zones.

Again available online
(but the usual PITA to find on docs.sun.com : <)

http://docs.sun.com/app/docs/doc/816-5175/6mbba7f4a?a=view#indexterm-345

Whether this a good idea for Oracle in larger installation could be
debateable..

DA Morgan

unread,
Jul 14, 2007, 4:08:22 PM7/14/07
to

Thanks. I just reviewed metalink Doc ID: Note:317257.1

And unless I am misreading it ... they are related to containers and I
wouldn't touch them with an Oracle database.

You might also read Doc ID: Note:399895.1
"Solaris 10 sets the shared memory segments on projects, and it is
suspected to be caused by projects not being setup correctly. Because
of this, there is not sufficient SHMMAX available for Oracle to allocate
the SGA, so startup fails."

The solution recommendation BTW is entries in /etc/system

I understand most SA's don't pay much attention to DBA concerns. But
were I a DBA working with you I'd be very concerned until someone
proved to me that my databases were not being put at risk.

DA Morgan

unread,
Jul 14, 2007, 4:10:02 PM7/14/07
to

Thanks ... helpful ... and now that I know it is part of Containers
it takes me back to my original concern which was Oracle support and
Oracle best practices: I wouldn't touch them and I wouldn't install
an Oracle database using them at this time unless someone could
guarantee Oracle support.

DA Morgan

unread,
Jul 14, 2007, 4:11:31 PM7/14/07
to

Again thank you and again this IS containers and again this is not an
environment supported by Oracle except in a very superficial manner.
It seems you are putting your databases your DBAs, and your organization
at risk.

Alexander Skwar

unread,
Jul 14, 2007, 4:34:12 PM7/14/07
to
· DA Morgan <damo...@psoug.org>:

> Andrew Gabriel wrote:
>> In article <11844199...@bubbleator.drizzle.com>,
>> DA Morgan <damo...@psoug.org> writes:
>>> If there is something called "Solaris Projects" please provide a link as
>>> I would like to learn what they are. Thanks.
>>
>> man project
>
> That requires having Solaris which I not have access to in my lab.
>
> Surely there is some online documentation or mention on the web.

Yes. On docs.sun.com.

> And, again, do they relate do Solaris 10 containers? Is there some
> reason no one can state what they are?

Just read the documentation.

Alexander Skwar
--
If dolphins are so smart, why did Flipper work for television?

gerryt

unread,
Jul 14, 2007, 4:33:12 PM7/14/07
to
And I thank you for that!

> It seems you are putting your databases your DBAs, and your organization
> at risk.

I have this little lab.. Pulled down 10g the other day to see what
issues might
crop up as a client of mine has nice shiny new M4000 to configure.
(even before reading the above) I was leaning towards NOT using a
special zone just for Oracle, but I might still look at it.
A special project ID almost certainly.
On Solaris 10 /etc/system hacks are practically deprecated BTW.
Last time I looked even the Oracle install docs were aware of that
amazingly : >

hume.sp...@bofh.ca

unread,
Jul 14, 2007, 5:00:58 PM7/14/07
to
In comp.unix.solaris DA Morgan <damo...@psoug.org> wrote:
> Thanks ... helpful ... and now that I know it is part of Containers
> it takes me back to my original concern which was Oracle support and

They are related, but not bound together. You do not need to touch any
form of container (zones) in order to make use of project resource
controls. Running Oracle inside a zone is NOT the same as running it
inside a project!

There are Metalink documents describing how to set up Oracle 10g using
/etc/project for more dynamic shared memory limits. This avoids needing
to set /etc/system and the foolishness of reboots between changes.

--
Brandon Hume - hume -> BOFH.Ca, http://WWW.BOFH.Ca/

DA Morgan

unread,
Jul 14, 2007, 6:37:50 PM7/14/07
to

Simple question:

Has anyone that is a production DBA ever seen anything official from
Oracle metalink that they will fully support this Solaris capability.
I looked and found nothing. If Oracle supports it UNTIL you open an
SR then it is not truly supported.

gerryt

unread,
Jul 15, 2007, 1:03:27 PM7/15/07
to
On Jul 14, 3:37 pm, DA Morgan <damor...@psoug.org> wrote:
> hume.spamfil...@bofh.ca wrote:

> > In comp.unix.solaris DA Morgan <damor...@psoug.org> wrote:
> >> Thanks ... helpful ... and now that I know it is part of Containers
> >> it takes me back to my original concern which was Oracle support and
>
> > They are related, but not bound together. You do not need to touch any
> > form of container (zones) in order to make use of project resource
> > controls. Running Oracle inside a zone is NOT the same as running it
> > inside a project!
>
> > There are Metalink documents describing how to set up Oracle 10g using
> > /etc/project for more dynamic shared memory limits. This avoids needing
> > to set /etc/system and the foolishness of reboots between changes.

Last time I checked you still had to "fool" the install procedure with
entry or two in /etc/system, but that was version 9 something...

> Simple question:
> Has anyone that is a production DBA ever seen anything official from
> Oracle metalink that they will fully support this Solaris capability.
> I looked and found nothing. If Oracle supports it UNTIL you open an
> SR then it is not truly supported.

But do you mean containers (zones) or projects..? Sorry Im just a
systems
kind of guy not a DBA.
But I work with DBAs so I can ask around, but I have to ask the
"right" question : >


DA Morgan

unread,
Jul 15, 2007, 1:37:33 PM7/15/07
to

The issue, as I understand it, is that Oracle says you can use these
things with one caveat. If something goes wrong they will ask you to
duplicate the problem on hardware not using these capabilities.

As that is likely impossible, and certainly almost impossible in a
timely fashion, it renders the configurations unsupported.

Wolfgang

unread,
Jul 15, 2007, 5:26:54 PM7/15/07
to
gerryt schrieb:


projects are not containers. you can use projects with zones, but
projects are part of resource managment in Solaris, also in Solaris 9.

projects are available also in older Solaris versions, not only Solaris
10. Every process use implicit the default project if not defined
otherwise in /etc/project. Due to that i think projects have to be a
supported thing with Oracle since Solaris is supported.

a definition of a project does no restrict a process unless you define
resource bindings to the project.

maybe solaris 10 has a bug with shared memory, so oracle has problems
with a project other than default, but I used projects with dedicated
listeners without problems, but i wonder if oracle would be problematic
with the.

are there a project configuration in the oracle-agent on Sun Clusters?

but if projects are not the adequate way to look at the resources, how
can I differentiate between the resources used by many instances? I am
not a dba and i have no access to a oracle managment console, but i want
to monitor single instances. how can i say how much resources used
from a instance (e.g. if i run about 10-20 instances on a single server)?


thanks
wolfgang

gerryt

unread,
Jul 15, 2007, 6:55:47 PM7/15/07
to

Yes all know now they are not the same thing : >

> projects are available also in older Solaris versions, not only Solaris
> 10. Every process use implicit the default project if not defined
> otherwise in /etc/project. Due to that i think projects have to be a
> supported thing with Oracle since Solaris is supported.

I think so too. I dont think there is such a thing as a process
running that wont
return something from a ps -o taskid -p ##
Correction there is one:
ps -o taskid -p 0
TASKID
0
prctl -i task 0
prctl: 0: No controllable process found in task, project, or zone.

And with Solaris 10 there is always a global zone.
I think that under these circumstances only non-global zones
might be a support issue.

> a definition of a project does no restrict a process unless you define
> resource bindings to the project.
> maybe solaris 10 has a bug with shared memory, so oracle has problems
> with a project other than default, but I used projects with dedicated
> listeners without problems, but i wonder if oracle would be problematic
> with the.
> are there a project configuration in the oracle-agent on Sun Clusters?

No idea

> but if projects are not the adequate way to look at the resources, how
> can I differentiate between the resources used by many instances?
> I am
> not a dba and i have no access to a oracle managment console, but i want
> to monitor single instances. how can i say how much resources used
> from a instance (e.g. if i run about 10-20 instances on a single server)?

You might have to reverse engineer what you see in oracle managment
console
and write a script for it. If thats even possible : <
Better to get an account on the oracle managment console probably

Last time I helped with an install even root needed a tweak or two
in resources via rctladm. And a couple of deprecated entries had to
be put in
/etc/system just to make the install process happy.

hume.sp...@bofh.ca

unread,
Jul 15, 2007, 8:25:46 PM7/15/07
to
In comp.unix.solaris DA Morgan <damo...@psoug.org> wrote:
> The issue, as I understand it, is that Oracle says you can use these
> things with one caveat. If something goes wrong they will ask you to

The Oracle 10g install documents I read explicitly instructed on how to
set up /etc/project for use with Oracle on Solaris 10. (Projects, not
zones.) There were no visible caveats in the document.

Does Oracle normally direct users toward unsupportable configurations in
their own install documents?

I'm asking honestly, not retorically or mockingly. Some vendors do stupid
things like that.

> As that is likely impossible, and certainly almost impossible in a
> timely fashion, it renders the configurations unsupported.

The traditional /etc/system changes used in previous versions of Solaris
still work in Solaris 10. They're just deprecated and unnecessary.

DA Morgan

unread,
Jul 15, 2007, 9:06:20 PM7/15/07
to

The question I'd like to put on the table is has anyone, anywhere, at
any time gone to metalink, opened an SR with zones or projects and
received support?

If not I will contact a friend at metalink and ask.

iv...@hotmail.com

unread,
Jul 16, 2007, 2:46:37 AM7/16/07
to

I don't think it's possible. You will need to find some other way,
like separate instance processes based on their names and ipcs for
shared memory/semaphores usage.

Regards,
Igor

> Thanks
> Wolfgang


iv...@hotmail.com

unread,
Jul 16, 2007, 3:05:56 AM7/16/07
to
On Jul 16, 10:25 am, hume.spamfil...@bofh.ca wrote:

> In comp.unix.solaris DA Morgan <damor...@psoug.org> wrote:
>
> > The issue, as I understand it, is that Oracle says you can use these
> > things with one caveat. If something goes wrong they will ask you to
>
> The Oracle 10g install documents I read explicitly instructed on how to
> set up /etc/project for use with Oracle on Solaris 10. (Projects, not
> zones.) There were no visible caveats in the document.

Apart of wrong utility (prctl) and wrong project name. They use
project.root in the installation guide, it should be project.oracle of
course.

> Does Oracle normally direct users toward unsupportable configurations in
> their own install documents?

No, it normally doesn't. I would say, since projects are in the
install doco it _must_ be supported.

> I'm asking honestly, not retorically or mockingly. Some vendors do stupid
> things like that.
>
> > As that is likely impossible, and certainly almost impossible in a
> > timely fashion, it renders the configurations unsupported.
>
> The traditional /etc/system changes used in previous versions of Solaris
> still work in Solaris 10. They're just deprecated and unnecessary.

While we are on this. Anybody knows why project limits seem to start
working only after su'ing to oracle, not in the initial session?
E.g.
- define higher-than-default shared memory limit as part of oracle
project
- log in as oracle
- try to startup database
- startup fails (couldn't allocate shared memory) if total shared
memory for oracle exceeds a default value
- su - oracle (from already oracle's session)
- do the same and instance happily starts up.

What am I missing here, maybe some patching?

> --
> Brandon Hume - hume -> BOFH.Ca,http://WWW.BOFH.Ca/

Regards,
Igor

Roger Johnson

unread,
Jul 16, 2007, 6:54:35 PM7/16/07
to

Assign the oracle user a special default project:
projadd -U oracle -K "project.max-shm-memory=(priv,2048MB,deny)" user.oracle

This works, but from the man pages it sounds like you are suppose to be
able to assign a user a default project upon login using usermod (?)
after the fact, resulting in the same effect, but I couldn't get it to
work until stumbling accros this guys post.

Here is the link that the code snippet come from:
http://forum.java.sun.com/thread.jspa?threadID=5074218&start=0&tstart=0

joel garry

unread,
Jul 16, 2007, 7:21:42 PM7/16/07
to
On Jul 16, 12:05 am, i...@hotmail.com wrote:
> On Jul 16, 10:25 am, hume.spamfil...@bofh.ca wrote:
>
> > In comp.unix.solaris DA Morgan <damor...@psoug.org> wrote:
>
> > > The issue, as I understand it, is that Oracle says you can use these
> > > things with one caveat. If something goes wrong they will ask you to
>
> > The Oracle 10g install documents I read explicitly instructed on how to
> > set up /etc/project for use with Oracle on Solaris 10. (Projects, not
> > zones.) There were no visible caveats in the document.
>
> Apart of wrong utility (prctl) and wrong project name. They use
> project.root in the installation guide, it should be project.oracle of
> course.
>
> > Does Oracle normally direct users toward unsupportable configurations in
> > their own install documents?
>
> No, it normally doesn't. I would say, since projects are in the
> install doco it _must_ be supported.

There have been rare instances of discovering things don't in fact
work and are retro-unsupported. Of course, there are not-so-rare
instances of things not working through many releases, and it is so
common to hear "fixed in the next release" that that is now a very old
joke.

Still, my favorite that I've personally observed was the Oracle
install guide for SunOS 1.2 (BSD) that had the 2.x (SYSV) instructions
in it...

>
> > I'm asking honestly, not retorically or mockingly. Some vendors do stupid
> > things like that.

It takes a computer to make BIG misteaks. (printed on gigantic pink
pearl eraser, circa 1980)

>
> > > As that is likely impossible, and certainly almost impossible in a
> > > timely fashion, it renders the configurations unsupported.
>
> > The traditional /etc/system changes used in previous versions of Solaris
> > still work in Solaris 10. They're just deprecated and unnecessary.
>
> While we are on this. Anybody knows why project limits seem to start
> working only after su'ing to oracle, not in the initial session?
> E.g.
> - define higher-than-default shared memory limit as part of oracle
> project
> - log in as oracle
> - try to startup database
> - startup fails (couldn't allocate shared memory) if total shared
> memory for oracle exceeds a default value
> - su - oracle (from already oracle's session)
> - do the same and instance happily starts up.
>
> What am I missing here, maybe some patching?

It's my understanding that's what the /etc/system changes workaround,
I haven't touched Solaris for a long time though, just from following
this at a distance.

jg
--
@home.com is bogus.
Malicious Straight White Females. http://www.zdnetasia.com/news/security/0,39044215,62028443,00.htm

DA Morgan

unread,
Jul 16, 2007, 9:39:14 PM7/16/07
to

Here's the official word from Oracle copied from an email I just received

=================================================================
Hi Daniel - Answers to the first question:

1. RDBMS (i.e. non RAC): yes we support containers, i.e. projects and zones
See Note 317257.1 in MetaLink

2. RAC/CRS/PCW: we support only limited containers, i.e. projects yes
but local zones NO, i.e. all RAC/CRS products MUST be running in the
global zone.
See Note 435464.1 in MetaLink

3. GRID: doesn't support projects and doesn't support zones.
There is an Enhancement Request logged on this one.

Hope that this helps.

Dave
=================================================================

So there it is ... you can use them ... but best pay attention to
when and where.

gerryt

unread,
Jul 17, 2007, 12:18:10 PM7/17/07
to
On Jul 16, 6:39 pm, DA Morgan <damor...@psoug.org> wrote:

> Here's the official word from Oracle copied from an email I just received
> =================================================================
> Hi Daniel - Answers to the first question:
> 1. RDBMS (i.e. non RAC): yes we support containers, i.e. projects and zones
> See Note 317257.1 in MetaLink
> 2. RAC/CRS/PCW: we support only limited containers, i.e. projects yes
> but local zones NO, i.e. all RAC/CRS products MUST be running in the
> global zone.
> See Note 435464.1 in MetaLink
> 3. GRID: doesn't support projects and doesn't support zones.
> There is an Enhancement Request logged on this one.
> Hope that this helps.
> Dave
> =================================================================
> So there it is ... you can use them ... but best pay attention to
> when and where.

You cant escape "projects" on Solaris 10
cat /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::

So the last answer (3) makes no sense to me : >
I could fire up my one remaining 9 box which has projects as well
but Im going to assume that 10g Grid Control for Solaris 10 SPARC is
supported
but I cant tell: "MetaLink Network or Page Error".. when I try to look
up
www.oracle.com/technology/support/metalink/index.html

DA Morgan

unread,
Jul 17, 2007, 3:19:20 PM7/17/07
to

It may not make sense but I'd serious recommend getting clarification
before bumping into the restriction. Personally I'd put it on Oracle's
Linux as a first choice.

agt

unread,
Jul 17, 2007, 5:25:11 PM7/17/07
to

On Tue, 17 Jul 2007, DA Morgan wrote:

DM : gerryt wrote:
DM : > On Jul 16, 6:39 pm, DA Morgan <damor...@psoug.org> wrote:
DM : >
DM : >> Here's the official word from Oracle copied from an email I just received
DM : >> =================================================================
DM : >> Hi Daniel - Answers to the first question:
DM : >> 1. RDBMS (i.e. non RAC): yes we support containers, i.e. projects and zones
DM : >> See Note 317257.1 in MetaLink
DM : >> 2. RAC/CRS/PCW: we support only limited containers, i.e. projects yes
DM : >> but local zones NO, i.e. all RAC/CRS products MUST be running in the
DM : >> global zone.
DM : >> See Note 435464.1 in MetaLink
DM : >> 3. GRID: doesn't support projects and doesn't support zones.
DM : >> There is an Enhancement Request logged on this one.
DM : >> Hope that this helps.
DM : >> Dave
DM : >> =================================================================
DM : >> So there it is ... you can use them ... but best pay attention to
DM : >> when and where.
DM : >
DM : > You cant escape "projects" on Solaris 10
DM : > cat /etc/project
DM : > system:0::::
DM : > user.root:1::::
DM : > noproject:2::::
DM : > default:3::::
DM : > group.staff:10::::
DM : >
DM : > So the last answer (3) makes no sense to me : >
DM : > I could fire up my one remaining 9 box which has projects as well
DM : > but Im going to assume that 10g Grid Control for Solaris 10 SPARC is
DM : > supported
DM : > but I cant tell: "MetaLink Network or Page Error".. when I try to look
DM : > up
DM : > www.oracle.com/technology/support/metalink/index.html
DM :
DM : It may not make sense but I'd serious recommend getting clarification
DM : before bumping into the restriction. Personally I'd put it on Oracle's
DM : Linux as a first choice.

Posting via Google is impossible today so..
Never Lie-nux! Nuff said I guess : >

But I will check into this - its like saying yes we support Solaris 10 but
not if you use projects (which cant be avoided)
The best vendor copout Ive ever heard and Ive seen/heard of some pretty
"good" ones : > But is this just Grid Control only??

All I care about is 10gR2 Enterprise

According to the matrix I can get at it says:
Operating System: Solaris Operating System (SPARC) Version 10
Oracle Database - Enterprise Edition Version 10gR2 64-bit
N/A Version N/A
Status: Certified

Product Version Note:
None available for this product.

Certification Note:

Existing Patch Sets:
10.2.0.2 Requires patch 5117016
10.2.0.3

Jay G. Scott

unread,
Jul 18, 2007, 12:29:31 PM7/18/07
to
In article <11844199...@bubbleator.drizzle.com>,
DA Morgan <damo...@psoug.org> wrote:

>Wolfgang wrote:
>> DA Morgan schrieb:
>>> Wolfgang wrote:
>>>> i want to start serveral database under resource control, every
>>>> instance with a different solaris project.
>>>>
>>>> the problem is we use a shared listener. is there a way to configure
>>>> the instance with a project, so the listener start all client
>>>> processes in a project according the project of the instance and not
>>>> the project of the listener?
>>>>
>>>> thanks
>>>> Wolfgang
>>>
>>> If you are contemplating using 10g containers ... check with metalink to
>>> see if you will be supported. Last time I looked they were a really bad
>>> idea.
>> i want use solaris projects, for every instance one project. It is not a
>> problem with a dedicated listener for every oracle instance, then i can
>> start the listener with a project. but a shared listener forks the
>> clients under his own project.
>>
>> i hear the first time about 10g containers, but am not a oracle admin
>> and nevertheless i want to have control over the processes if possible.
>>
>> is there a possibility to call somthing like pre or post-scripts when
>> forcing a client process from listeners?
>>
>> Thanks
>> Wolfgang
>
>There is no such thing as "10g containers" and unless my google searches
>are having a problem with such a common phrase there is no such thing as
>"Solaris projects" either. Are you sure you are not referring to Solaris
>10 Containers? If so they are not truly supported by Oracle and you are
>setting yourself up for lots of pain and suffering.

ahhh.... if we're talking about the same thing and not just
the same words... putting oracle db and at least certain bits
of the app server are certified to work in solaris zones (nee containers),
and i have done that. i didn't have any issues putting them in zones
which were different from putting them on an ordinary solaris 9 machine,
for example.

j.

>
>If there is something called "Solaris Projects" please provide a link as
>I would like to learn what they are. Thanks.

>--
>Daniel A. Morgan
>University of Washington
>damo...@x.washington.edu (replace x with u to respond)
>Puget Sound Oracle Users Group
>www.psoug.org


--
Jay Scott 512-835-3553 g...@arlut.utexas.edu
Head of Sun Support, Sr. Operating Systems Specialist
Applied Research Labs, Computer Science Div. S224
University of Texas at Austin

Jay G. Scott

unread,
Jul 18, 2007, 12:36:35 PM7/18/07
to
In article <11844526...@bubbleator.drizzle.com>,

DA Morgan <damo...@psoug.org> wrote:
>hume.sp...@bofh.ca wrote:
>> In comp.unix.solaris DA Morgan <damo...@psoug.org> wrote:
>>> Thanks ... helpful ... and now that I know it is part of Containers
>>> it takes me back to my original concern which was Oracle support and
>>
>> They are related, but not bound together. You do not need to touch any
>> form of container (zones) in order to make use of project resource
>> controls. Running Oracle inside a zone is NOT the same as running it
>> inside a project!
>>
>> There are Metalink documents describing how to set up Oracle 10g using
>> /etc/project for more dynamic shared memory limits. This avoids needing
>> to set /etc/system and the foolishness of reboots between changes.
>
>Simple question:
>
>Has anyone that is a production DBA ever seen anything official from
>Oracle metalink that they will fully support this Solaris capability.
>I looked and found nothing. If Oracle supports it UNTIL you open an
>SR then it is not truly supported.

yes, i've definitely opened SRs with .... well, probably not the db
but with the app server running in solaris zones. the ___workflow___
stuff is a bucket of worms, but it was an identical bucket of
worms under a conventional solaris 9 machine. we ultimately ditched it.

there's some certification matrix out there which tells you what
part of oracle works with zones and so on. last i looked it
was 10.1 of the db, not 10.2. that was a while ago. app server i
don't recall offhand.

FWIW.

j.


>--
>Daniel A. Morgan
>University of Washington
>damo...@x.washington.edu (replace x with u to respond)
>Puget Sound Oracle Users Group
>www.psoug.org

Jay G. Scott

unread,
Jul 18, 2007, 12:46:41 PM7/18/07
to
In article <f7edua$ssa$1...@Kil-nws-1.UCIS.Dal.Ca>,

<hume.sp...@bofh.ca> wrote:
>In comp.unix.solaris DA Morgan <damo...@psoug.org> wrote:
>> The issue, as I understand it, is that Oracle says you can use these
>> things with one caveat. If something goes wrong they will ask you to
>
>The Oracle 10g install documents I read explicitly instructed on how to
>set up /etc/project for use with Oracle on Solaris 10. (Projects, not
>zones.) There were no visible caveats in the document.
>
>Does Oracle normally direct users toward unsupportable configurations in
>their own install documents?
>
>I'm asking honestly, not retorically or mockingly. Some vendors do stupid
>things like that.

and i take your question at face value.

it wouldn't surprise me at all. i've seen oracle docs which insisted,
hammered on the desk and shouting, that everything be done exactly
as they specify or else, yet there would be an obvious typo or
other obvious screw-up which made the whole thing nonsense.
as a mild example, i'll bet the installation docs still insist
two variables be set in /etc/system which have been obsolete since
solaris 8. but their installation scripts still check for them
and fail if they aren't. i'll drop this lest i begin ranting.

j.

>
>> As that is likely impossible, and certainly almost impossible in a
>> timely fashion, it renders the configurations unsupported.
>
>The traditional /etc/system changes used in previous versions of Solaris
>still work in Solaris 10. They're just deprecated and unnecessary.
>
>--
>Brandon Hume - hume -> BOFH.Ca, http://WWW.BOFH.Ca/

Jay G. Scott

unread,
Jul 18, 2007, 12:49:10 PM7/18/07
to
In article <11845479...@bubbleator.drizzle.com>,

DA Morgan <damo...@psoug.org> wrote:
>hume.sp...@bofh.ca wrote:
>> In comp.unix.solaris DA Morgan <damo...@psoug.org> wrote:
>>> The issue, as I understand it, is that Oracle says you can use these
>>> things with one caveat. If something goes wrong they will ask you to
>>
>> The Oracle 10g install documents I read explicitly instructed on how to
>> set up /etc/project for use with Oracle on Solaris 10. (Projects, not
>> zones.) There were no visible caveats in the document.
>>
>> Does Oracle normally direct users toward unsupportable configurations in
>> their own install documents?
>>
>> I'm asking honestly, not retorically or mockingly. Some vendors do stupid
>> things like that.
>>
>>> As that is likely impossible, and certainly almost impossible in a
>>> timely fashion, it renders the configurations unsupported.
>>
>> The traditional /etc/system changes used in previous versions of Solaris
>> still work in Solaris 10. They're just deprecated and unnecessary.
>
>The question I'd like to put on the table is has anyone, anywhere, at
>any time gone to metalink, opened an SR with zones or projects and
>received support?

i have. my news reader is a little primitive so my replies are
scattered, sorry.

j.

>
>If not I will contact a friend at metalink and ask.
>--
>Daniel A. Morgan
>University of Washington
>damo...@x.washington.edu (replace x with u to respond)
>Puget Sound Oracle Users Group
>www.psoug.org

0 new messages