This discussion is archived
4 Replies Latest reply: Dec 5, 2012 3:20 AM by 908067 RSS

problems with projects

908067 Newbie
Currently Being Moderated
Hi guys,

I have a Solaris 10 server; it has an Oracle DB 10g running; a project was created for the oracle user:

# projects -l oracle.project
oracle.project
projid : 100
comment: "Oracle Project"
users : oracle
groups : (none)
attribs: process.max-sem-nsems=(privileged,256,deny)
project.max-sem-ids=(privileged,100,deny)
project.max-shm-ids=(privileged,100,deny)
project.max-shm-memory=(privileged,5905580032,deny)

There 2 Oracle DB instances that have SGAs < 4Gb together, so the max-shm-memory is correct (5.5GB).
The DBs ran fine for a long period of time (years) with this setup. Recently I rebooted the server (clean reboot) and when the DBA tries to start both DBs, they get ORA-27102 error at startup (which basically means there's no enough memory).

The strange thing is that I suspect the oracle.project is not applied anymore:
# ps -ef -o user,uid,pid,projid|grep oracle
USER UID PID PROJID
oracle 102 1706 0
oracle 102 15543 0
oracle 102 15549 0
oracle 102 15563 0
oracle 102 17737 0
oracle 102 15514 0
oracle 102 15503 0


Any idea what happened? Why the project is not enforced anymore?

Thank you!
  • 1. Re: problems with projects
    Nik Expert
    Currently Being Moderated
    Hi.

    https://blogs.oracle.com/SAPonSun/entry/running_sap_on_solaris_10
    Check files /etc/user_attr

    Record like:

    oracle::::project=oracle

    ( For example - check number of ":" )

    Regards.
  • 2. Re: problems with projects
    908067 Newbie
    Currently Being Moderated
    bash-3.00# grep oracle /etc/user_attr
    oracle::::project=oracle.project


    that one is correct, too, never touched it..

    And this show that the user oracle is correctly assigned to the project:
    bash-3.00# projects oracle
    default oracle.project

    Edited by: 905064 on Dec 4, 2012 2:10 PM
  • 3. Re: problems with projects
    bigdelboy Pro
    Currently Being Moderated
    I don't have time for a long answer but ....

    su - oracle

    id -p

    and

    prctl $$


    May usually help towards diagnosing a lot of what is going on
  • 4. Re: problems with projects
    908067 Newbie
    Currently Being Moderated
    $ /usr/bin/id -p
    uid=102(oracle) gid=100(oinstall) projid=0(system)
    $ prctl $$
    process: 16030: -ksh
    NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
    process.max-port-events
    privileged 65.5K - deny -
    system 2.15G max deny -
    process.max-msg-messages
    privileged 8.19K - deny -
    system 4.29G max deny -
    process.max-msg-qbytes
    privileged 64.0KB - deny -
    system 16.0EB max deny -
    process.max-sem-ops
    privileged 512 - deny -
    system 2.15G max deny -
    process.max-sem-nsems
    privileged 512 - deny -
    system 32.8K max deny -
    process.max-address-space
    privileged 16.0EB max deny -
    system 16.0EB max deny -
    process.max-file-descriptor
    basic 256 - deny 16030
    privileged 65.5K - deny -
    system 2.15G max deny -
    process.max-core-size
    privileged 8.00EB max deny -
    system 8.00EB max deny -
    process.max-stack-size
    basic 8.00MB - deny 16030
    privileged 8.00EB max deny -
    system 8.00EB max deny -
    process.max-data-size
    privileged 16.0EB max deny -
    system 16.0EB max deny -
    process.max-file-size
    privileged 8.00EB max deny,signal=XFSZ -
    system 8.00EB max deny -
    process.max-cpu-time
    privileged 18.4Es inf signal=XCPU -
    system 18.4Es inf none -
    task.max-cpu-time
    system 18.4Es inf none -
    task.max-lwps
    system 2.15G max deny -
    project.max-contracts
    privileged 10.0K - deny -
    system 2.15G max deny -
    project.max-device-locked-memory
    privileged 494MB - deny -
    system 16.0EB max deny -
    project.max-locked-memory
    system 16.0EB max deny -
    project.max-port-ids
    privileged 8.19K - deny -
    system 65.5K max deny -
    project.max-shm-memory
    privileged 1.93GB - deny -
    system 16.0EB max deny -
    project.max-shm-ids
    privileged 128 - deny -
    system 16.8M max deny -
    project.max-msg-ids
    privileged 128 - deny -
    system 16.8M max deny -
    project.max-sem-ids
    privileged 128 - deny -
    system 16.8M max deny -
    project.max-crypto-memory
    privileged 1.93GB - deny -
    system 16.0EB max deny -
    project.max-tasks
    system 2.15G max deny -
    project.max-lwps
    system 2.15G max deny -
    project.cpu-cap
    system 4.29G inf deny -
    project.cpu-shares
    privileged 1 - none -
    system 65.5K max none -
    zone.max-swap
    system 16.0EB max deny -
    zone.max-locked-memory
    system 16.0EB max deny -
    zone.max-shm-memory
    system 16.0EB max deny -
    zone.max-shm-ids
    system 16.8M max deny -
    zone.max-sem-ids
    system 16.8M max deny -
    zone.max-msg-ids
    system 16.8M max deny -
    zone.max-lwps
    system 2.15G max deny -
    zone.cpu-cap
    system 4.29G inf deny -
    zone.cpu-shares
    privileged 1 - none -
    system 65.5K max none -


    Just noticed a bizarre thing:
    $ /usr/local/bin/id -p
    /usr/local/bin/id: invalid option -- 'p'
    Try `/usr/local/bin/id --help' for more information.
    $ /usr/bin/id -p
    uid=102(oracle) gid=100(oinstall) projid=0(system)

    So I have another default binary for "id" ?!

    Anyways, looking at http://docs.oracle.com/cd/E19683-01/817-1592/rmtaskproj-3/index.html , the conclusion is that the default project SHOULD be oracle.project , because I have a specific entry in this file:
    bash-3.2# grep oracle /etc/user_attr
    oracle::::project=oracle.project

    But this doesn't happen and I don't know why...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points