4 Replies Latest reply: Dec 5, 2012 5:20 AM by 908067 RSS

    problems with projects

    908067
      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
          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
            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
              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
                $ /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...