1 2 3 Previous Next 30 Replies Latest reply on Dec 28, 2006 12:14 PM by orafad Go to original post
      • 15. Re: OS authentication related problem
        orafad
        compare, using both os logins:

        $ env | egrep '^ORA|^PATH'
        $ echo $ORACLE_SID | od -a


        Also, have you made sure the instance is up? E.g. what's output from ps -ef | grep pmon
        • 16. Re: OS authentication related problem
          464759
          IMHO your problem is more likely related to an unlikely problem with ORACLE_HOME, ORACLE_SID setup or to a unlikely bug that would occur when SQL*Plus tries to check that the ORACLE_SID instance is running.

          Can you try to trace SQL*Plus with:
          strace -fo /tmp/sqlplus.strace sqlplus '/ as sysdba'
          Your problem has some similarity with the following one (only for 10.2.0.1 and RAC):

          Subject:      Cannot Connect To Instance If Started Via Srvctl
               Doc ID:      Note:341846.1      Type:      PROBLEM
               Last Revision Date:      03-MAR-2006      Status:      MODERATED


          Can you also post following file contents /etc/security/limits.conf: ?
          • 17. Re: OS authentication related problem
            523455
            Hi,

            As System Admin Login:

            DSS-BIWPRD:bp3adm 3% id
            uid=206(bp3adm) gid=101(sapsys)
            DSS-BIWPRD:bp3adm 4% sqlplus /nolog

            SQL*Plus: Release 10.2.0.2.0 - Production on Thu Dec 28 14:18:36 2006

            Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

            SQL> conn /
            Connected.
            SQL>

            As Database Admin Login:

            DSS-BIWPRD:bp3adm 2% su - orabp3
            Password:
            Sun Microsystems Inc. SunOS 5.10 Generic January 2005
            DSS-BIWPRD:orabp3 1% sqlplus /nolog

            SQL*Plus: Release 10.2.0.2.0 - Production on Thu Dec 28 14:17:32 2006

            Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

            SQL> conn /
            ERROR:
            ORA-01034: ORACLE not available
            ORA-27121: unable to determine size of shared memory segment
            SVR4 Error: 13: Permission denied

            SQL>

            The above ORA errors are posted on Metalink, and the solution suggested is to check permissions (SETUID) on both the oracle binary and the file system :

            https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1056155.6

            Our Oracle base folder (/oracle) is mounted with SETUID option OFF:
            /oracle on /dev/vx/dsk/DSS_BIW_DATA/ora read/write/nosetuid/nodevices/delaylog/largefiles/ioerror=mwdisable/dev=4b1bd50 on Thu Dec 21 13:41:10 2006

            The oracle binary at $ORACLE_HOME/bin has setuid ON:
            SQL> !ls -l $ORACLE_HOME/bin/oracle
            -rwsr-s--x 1 orabp3 dba 110302936 Nov 2 12:49 /oracle/BP3/102_64/bin/oracle

            Now we think that after mounting the /oracle folder with SETUID option ON shall solve this problem. Any suggestions are most welcome.

            Regards, Rajesh
            • 18. Re: OS authentication related problem
              orafad
              I'm not too friendly with Sun's unix, but maybe you got something there...

              You said bp3adm started the instance, right? What's the output from ipcs -m?
              • 19. Re: OS authentication related problem
                464759
                Oracle® Database Installation Guide
                10g Release 2 (10.2) for Solaris Operating System (SPARC 64-Bit) says the same
                http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15690/app_nas.htm#CHDIAGAD
                • 20. Re: OS authentication related problem
                  523455
                  Hi orafad,

                  The instance was started by bp3adm.

                  The ipcs -m output is as follows:

                  IPC status from <running system> as of Thu Dec 28 15:51:49 IST 200
                  T ID KEY MODE OWNER GROUP
                  Shared Memory:
                  m 16777548 0x4562 rw-r--- root root
                  m 16777547 0x4563 rw-r--- root root
                  m 16777546 0x4534 rw-r--- root root
                  m 16777545 0x27b3 rw-r--- bp3adm sapsys
                  m 16777436 0x27ac rw-r--- bp3adm sapsys
                  m 16777435 0x27bd rw-r--- bp3adm sapsys
                  m 16777424 0x27ae rw-r--- bp3adm sapsys
                  m 16777423 0x2796 rw-r--- bp3adm sapsys
                  m 16777422 0x2792 rw-r--- bp3adm sapsys
                  m 16777421 0x277a rw-r--- bp3adm sapsys
                  m 16777419 0x27b4 rw-r--- bp3adm sapsys
                  m 16777418 0x27b5 rw-r--- bp3adm sapsys
                  m 16777417 0x27aa rw-r--- bp3adm sapsys
                  m 16777416 0x2795 rw-r--- bp3adm sapsys
                  m 16777415 0x2787 rw-r--- bp3adm sapsys
                  m 67108959 0x279d rw-r--- bp3adm sapsys
                  m 67108958 0x2789 rw-r--- bp3adm sapsys
                  m 67108957 0x2778 rw-r--- bp3adm sapsys
                  m 67108956 0x277b rw-r--- bp3adm sapsys
                  m 67108955 0x279c rw-r--- bp3adm sapsys
                  m 83886170 0x2786 rw-r--- bp3adm sapsys
                  m 83886169 0x277c rw-r--- bp3adm sapsys
                  m 83886168 0x277d rw-r--- bp3adm sapsys
                  m 83886167 0x2782 rw-r--- bp3adm sapsys
                  m 83886166 0x27b9 rw-r--- bp3adm sapsys
                  m 83886165 0x27b8 rw-r--- bp3adm sapsys
                  m 486 0x27b2 rw-r--- bp3adm sapsys
                  m 485 0x27a7 rw-r--- bp3adm sapsys
                  m 484 0x2793 rw-r--- bp3adm sapsys
                  m 483 0x27a8 rw-r--- bp3adm sapsys
                  m 482 0x2777 rw-r--- bp3adm sapsys
                  m 481 0x2776 rw-r--- bp3adm sapsys
                  m 480 0x2775 rw-r--- bp3adm sapsys
                  m 479 0x277e rw-r--- bp3adm sapsys
                  m 375 0x27ad rw-r--- bp3adm sapsys
                  m 374 0 --rw-rw-rw-   bp3adm   sapsys
                  m 373 0x2732 rw-r--- bp3adm sapsys
                  m 372 0 --rw-rw-rw-   bp3adm   sapsys
                  m 371 0x42d03c48 rw-r--- bp3adm sapsys
                  m 370 0 rw-r--- bp3adm sapsys
                  m 369 0 rw-r--- bp3adm sapsys
                  m 368 0 rw-r--- bp3adm sapsys
                  m 367 0 rw-r--- bp3adm sapsys
                  m 366 0 rw-r--- bp3adm sapsys
                  m 50331725 0xcace --rw-rw-rw-     root     root
                  m 33 0x382be85 --rw-rw-rw-   bp3adm   sapsys
                  m 30 0x382be84 --rw-rw-rw-   bp3adm   sapsys
                  m 28 0x4dbe --rw-rw-rw-   bp3adm   sapsys

                  Thanks,
                  • 21. Re: OS authentication related problem
                    orafad
                    ... while the binary "owner" is orabp3. The oracle software owner should be the user running the software (process) and creating shared memory segments.

                    Also, per info from docu given by Pierre, the suid option is required (on nas/nfs mounts according to docu, but I assume it applies to all mounts that set uid/gid must be allowed).
                    • 22. Re: OS authentication related problem
                      orafad
                      Still, I wonder why, in the "sysdba" case that instead of giving an error it says connected to idle instance.

                      A strace output from sysdba connection as suggested above would be interesting...
                      • 23. Re: OS authentication related problem
                        464759
                        It seems you have a mismatch between the Unix group of the Unix account that has started the database instance (sapsys) and the Unix group of the Oracle software owner (dba).
                        Is bp3adm also member of the Unix "dba" group ?

                        If you would change bp3adm group to "dba" or if Oracle software would be owned by bp3adm account, you should not have these connection problems.
                        But these installation changes that would require carefull testing. See http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b15658/admin_ora.htm#sthref115
                        • 24. Re: OS authentication related problem
                          523455
                          Hi orafad/pierre,

                          The trace command has generated a huge file. I am attaching a part of the trace file. Shall be obliged if you guys can get some hint from here. Thanks ...

                          12320:     execve("/oracle/BP3/102_64/bin/sqlplus", 0xFFFFFFFF7FFFFAB8, 0xFFFFFFFF7FFFFAD0) argc = 2
                          12320:     mmap(0x00000000, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFFFFFFFF7F500000
                          12320:     resolvepath("/usr/lib/sparcv9/ld.so.1", "/lib/sparcv9/ld.so.1", 1023) = 20
                          12320:     resolvepath("/oracle/BP3/102_64/bin/sqlplus", "/oracle/BP3/102_64/bin/sqlplus", 1023) = 30
                          12320:     stat("/oracle/BP3/102_64/bin/sqlplus", 0xFFFFFFFF7FFFF6C0) = 0
                          12320:     open("/var/ld/64/ld.config", O_RDONLY)          Err#2 ENOENT
                          12320:     stat("/usr/sap/BP3/SYS/exe/run/libsqlplus.so", 0xFFFFFFFF7FFFEDC0) Err#2 ENOENT
                          12320:     stat("/oracle/BP3/102_64/lib/libsqlplus.so", 0xFFFFFFFF7FFFEDC0) = 0
                          12320:     resolvepath("/oracle/BP3/102_64/lib/libsqlplus.so", "/oracle/BP3/102_64/lib/libsqlplus.so", 1023) = 36
                          12320:     open("/oracle/BP3/102_64/lib/libsqlplus.so", O_RDONLY) = 3
                          12320:     mmap(0x00100000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_ALIGN, 3, 0) = 0xFFFFFFFF7F400000
                          12320:     mmap(0x00100000, 1900544, PROT_NONE, MAP_PRIVATE|MAP_NORESERVE|MAP_ANON|MAP_ALIGN, -1, 0) = 0xFFFFFFFF7F200000
                          12320:     mmap(0xFFFFFFFF7F200000, 805782, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_TEXT, 3, 0) = 0xFFFFFFFF7F200000
                          12320:     mmap(0xFFFFFFFF7F3C4000, 47520, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_INITDATA, 3, 802816) = 0xFFFFFFFF7F3C4000
                          12320:     munmap(0xFFFFFFFF7F2C6000, 1040384)          = 0
                          12320:     memcntl(0xFFFFFFFF7F200000, 76408, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
                          12320:     close(3)                         = 0
                          12320:     stat("/usr/sap/BP3/SYS/exe/run/libclntsh.so.10.1", 0xFFFFFFFF7FFFEDC0) Err#2 ENOENT
                          12320:     stat("/oracle/BP3/102_64/lib/libclntsh.so.10.1", 0xFFFFFFFF7FFFEDC0) = 0
                          12320:     resolvepath("/oracle/BP3/102_64/lib/libclntsh.so.10.1", "/oracle/BP3/102_64/lib/libclntsh.so.10.1", 1023) = 40
                          12320:     open("/oracle/BP3/102_64/lib/libclntsh.so.10.1", O_RDONLY) = 3
                          12320:     mmap(0xFFFFFFFF7F400000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFFFFFFFF7F400000
                          12320:     mmap(0x00100000, 19611648, PROT_NONE, MAP_PRIVATE|MAP_NORESERVE|MAP_ANON|MAP_ALIGN, -1, 0) = 0xFFFFFFFF7DC00000
                          12320:     mmap(0xFFFFFFFF7DC00000, 17558938, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_TEXT, 3, 0) = 0xFFFFFFFF7DC00000
                          12320:     mmap(0xFFFFFFFF7EDBE000, 930424, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_INITDATA, 3, 17555456) = 0xFFFFFFFF7EDBE000
                          12320:     mmap(0xFFFFFFFF7EEA2000, 71040, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_ANON, -1, 0) = 0xFFFFFFFF7EEA2000
                          12320:     munmap(0xFFFFFFFF7ECC0000, 1040384)          = 0
                          12320:     memcntl(0xFFFFFFFF7DC00000, 1909928, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
                          12320:     close(3)                         = 0
                          12320:     stat("/usr/sap/BP3/SYS/exe/run/libnnz10.so", 0xFFFFFFFF7FFFEDC0) Err#2 ENOENT
                          12320:     stat("/oracle/BP3/102_64/lib/libnnz10.so", 0xFFFFFFFF7FFFEDC0) = 0
                          12320:     resolvepath("/oracle/BP3/102_64/lib/libnnz10.so", "/oracle/BP3/102_64/lib/libnnz10.so", 1023) = 34
                          12320:     open("/oracle/BP3/102_64/lib/libnnz10.so", O_RDONLY) = 3
                          12320:     mmap(0xFFFFFFFF7F400000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFFFFFFFF7F400000
                          12320:     mmap(0x00000000, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFFFFFFFF7F100000
                          12320:     mmap(0x00100000, 3522560, PROT_NONE, MAP_PRIVATE|MAP_NORESERVE|MAP_ANON|MAP_ALIGN, -1, 0) = 0xFFFFFFFF7D800000
                          12320:     mmap(0xFFFFFFFF7D800000, 2221848, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_TEXT, 3, 0) = 0xFFFFFFFF7D800000
                          12320:     mmap(0xFFFFFFFF7DB1E000, 241454, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_INITDATA, 3, 2220032) = 0xFFFFFFFF7DB1E000
                          12320:     mmap(0xFFFFFFFF7DB5A000, 1392, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_ANON, -1, 0) = 0xFFFFFFFF7DB5A000
                          12320:     munmap(0xFFFFFFFF7DA20000, 1040384)          = 0
                          12320:     memcntl(0xFFFFFFFF7D800000, 293264, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
                          12320:     close(3)                         = 0
                          12320:     stat("/usr/sap/BP3/SYS/exe/run/libkstat.so.1", 0xFFFFFFFF7FFFEDC0) Err#2 ENOENT
                          12320:     stat("/oracle/BP3/102_64/lib/libkstat.so.1", 0xFFFFFFFF7FFFEDC0) Err#2 ENOENT
                          12320:     stat("/opt/SUNWcluster/lib/sparcv9/libkstat.so.1", 0xFFFFFFFF7FFFEDC0) Err#2 ENOENT
                          12320:     stat("/oracle/BP3/102_64/lib/libkstat.so.1", 0xFFFFFFFF7FFFEDC0) Err#2 ENOENT
                          12320:     stat("/opt/ORCLcluster/lib//libkstat.so.1", 0xFFFFFFFF7FFFEDC0) Err#2 ENOENT
                          12320:     stat("/lib/64/libkstat.so.1", 0xFFFFFFFF7FFFEDC0) = 0
                          12320:     resolvepath("/lib/64/libkstat.so.1", "/lib/sparcv9/libkstat.so.1", 1023) = 26
                          12320:     open("/lib/64/libkstat.so.1", O_RDONLY)          = 3
                          12320:     mmap(0xFFFFFFFF7F400000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFFFFFFFF7F400000
                          12320:     mmap(0x00100000, 1064960, PROT_NONE, MAP_PRIVATE|MAP_NORESERVE|MAP_ANON|MAP_ALIGN, -1, 0) = 0xFFFFFFFF7EF00000
                          12320:     mmap(0xFFFFFFFF7EF00000, 3990, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_TEXT, 3, 0) = 0xFFFFFFFF7EF00000
                          12320:     mmap(0xFFFFFFFF7F002000, 1256, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_INITDATA, 3, 8192) = 0xFFFFFFFF7F002000
                          12320:     munmap(0xFFFFFFFF7EF02000, 1048576)          = 0
                          12320:     memcntl(0xFFFFFFFF7EF00000, 1968, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
                          12320:     close(3)                         = 0
                          • 25. Re: OS authentication related problem
                            464759
                            Could you please post the end of the trace file so that we can see a possible system call error ? You could also grep the full trace file for lines containing "shm".
                            • 26. Re: OS authentication related problem
                              orafad
                              My guess is that you need to allow set user and group id on the oracle software mount point and restart the instance.

                              The trace command has generated a huge file. I am
                              attaching a part of the trace file.
                              That part does not tell me much, no more than loading library files. Output right before sqlplus outputs "connected to idle instance" is perhaps more useful but on the other hand I suspect analyzing the output is hard to do over the forum.

                              Message was edited by:
                              orafad
                              • 27. Re: OS authentication related problem
                                523455
                                Hi Pierre,

                                Thanks for your kind response ...

                                Grepping for shm:

                                12321: shmget(124061612, 0, 0) Err#2 ENOENT
                                12321: shmget(124061613, 0, 0) Err#2 ENOENT
                                12321: shmget(124061614, 0, 0) Err#2 ENOENT
                                12321: shmget(124061615, 0, 0) Err#2 ENOENT
                                12321: shmget(1120943176, 0, 0) = 26
                                12321: shmctl(26, IPC_STAT, 0xFFFFFFFF7FFFDBE8) Err#13 EACCES [ipc_dac_r
                                ead]
                                12321: shmget(1120943176, 0, 0) = 26
                                12321: shmctl(26, IPC_STAT, 0xFFFFFFFF7FFF9758) Err#13 EACCES [ipc_dac_r
                                ead]

                                End part of trace file:

                                12692:     getcontext(0xFFBFF698)
                                12692:     getrlimit(RLIMIT_STACK, 0xFFBFF678)          = 0
                                12692:     getpid()                         = 12692 [12522]
                                12692:     setustack(0xFF3A2088)
                                12692:     brk(0x0002A600)                         = 0
                                12692:     brk(0x0002C600)                         = 0
                                12692:     stat("/platform/SUNW,Sun-Fire-V890/lib/libc_psr.so.1", 0xFFBFEFE8) = 0
                                12692:     resolvepath("/platform/SUNW,Sun-Fire-V890/lib/libc_psr.so.1", "/platform/sun4u-us3/lib/libc_psr.so.1", 1023) = 37
                                12692:     open("/platform/SUNW,Sun-Fire-V890/lib/libc_psr.so.1", O_RDONLY) = 3
                                12692:     mmap(0x00010000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_ALIGN, 3, 0) = 0xFF390000
                                12692:     close(3)                         = 0
                                12692:     mmap(0x00000000, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF380000
                                12692:     stat("/usr/lib/locale/en_US.ISO8859-15/en_US.ISO8859-15.so.3", 0xFFBFECC8) = 0
                                12692:     resolvepath("/usr/lib/locale/en_US.ISO8859-15/en_US.ISO8859-15.so.3", "/usr/lib/locale/en_US.ISO8859-15/en_US.ISO8859-15.so.3", 1023) = 54
                                12692:     open("/usr/lib/locale/en_US.ISO8859-15/en_US.ISO8859-15.so.3", O_RDONLY) = 3
                                12692:     mmap(0x00010000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_ALIGN, 3, 0) = 0xFF270000
                                12692:     mmap(0x00010000, 90112, PROT_NONE, MAP_PRIVATE|MAP_NORESERVE|MAP_ANON|MAP_ALIGN, -1, 0) = 0xFF250000
                                12692:     mmap(0xFF250000, 14378, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_TEXT, 3, 0) = 0xFF250000
                                12692:     mmap(0xFF262000, 8338, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_INITDATA, 3, 8192) = 0xFF262000
                                12692:     munmap(0xFF254000, 57344)               = 0
                                12692:     memcntl(0xFF250000, 6576, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
                                12692:     close(3)                         = 0
                                12692:     stat("/usr/sap/BP3/SYS/exe/run/libc.so.1", 0xFFBFEB98) Err#2 ENOENT
                                12692:     stat("/oracle/BP3/102_64/lib/libc.so.1", 0xFFBFEB98) Err#2 ENOENT
                                12692:     munmap(0xFF270000, 8192)               = 0
                                12692:     fstat64(1, 0xFFBFFAC8)                    = 0
                                12692:     open64("/tmp/sqlplus.strace", O_RDONLY)          = 3
                                12692:     fstat64(3, 0xFFBFFA30)                    = 0
                                12692:     llseek(3, 0, SEEK_CUR)                    = 0
                                12692:     mmap64(0x00000000, 1734085, PROT_READ, MAP_SHARED, 3, 0) = 0xFF080000
                                12692:     read(3, " 1", 1)                    = 1
                                12522:     waitid(P_ALL, 0, 0xFFBFF5F0, WEXITED|WTRAPPED|WSTOPPED|WCONTINUED|WNOWAIT) (sleeping...)
                                12692:     write(1, 0xFF080000, 1734085)     (sleeping...)
                                12692:     write(1, " 1 2 3 2 0 :\t e x e c v".., 1734085)     = 1734085
                                12692:     llseek(3, 1734085, SEEK_SET)               = 1734085
                                12692:     munmap(0xFF080000, 1734085)               = 0
                                12692:     llseek(3, 0, SEEK_CUR)                    = 1734085
                                12692:     close(3)                         = 0
                                12692:     close(1)                         = 0
                                12692:     _exit(0)
                                12522:     waitid(P_ALL, 0, 0xFFBFF5F0, WEXITED|WTRAPPED|WSTOPPED|WCONTINUED|WNOWAIT) = 0
                                12522:     times(0xFFBFF530)                    = 52895418
                                12522:     waitid(P_ALL, 0, 0xFFBFF540, WEXITED|WTRAPPED|WSTOPPED|WCONTINUED|WNOHANG) = 0
                                12522:     times(0xFFBFF520)                    = 52895418
                                12522:     times(0xFFBFF530)                    = 52895418
                                12522:     waitid(P_ALL, 0, 0xFFBFF540, WEXITED|WTRAPPED|WSTOPPED|WCONTINUED|WNOHANG) Err#10 ECHILD
                                12522:     lwp_sigmask(SIG_SETMASK, 0x00020002, 0x00000000) = 0xFFBFFEFF [0x0000FFFF]
                                12522:     lwp_sigmask(SIG_SETMASK, 0x00000002, 0x00000000) = 0xFFBFFEFF [0x0000FFFF]
                                12522:     lwp_sigmask(SIG_SETMASK, 0x00000002, 0x00000000) = 0xFFBFFEFF [0x0000FFFF]
                                12522:     lwp_sigmask(SIG_SETMASK, 0x00000000, 0x00000000) = 0xFFBFFEFF [0x0000FFFF]
                                12522:     _exit(0)
                                12320:     waitid(P_PID, 12522, 0xFFFFFFFF7FFFD620, WEXITED|WTRAPPED) Err#10 ECHILD
                                12320:     sigaction(SIGINT, 0xFFFFFFFF7FFFD790, 0x00000000) = 0
                                12320:     sigaction(SIGQUIT, 0xFFFFFFFF7FFFD790, 0x00000000) = 0
                                12320:     sigaction(SIGCLD, 0xFFFFFFFF7FFFD790, 0x00000000) = 0
                                12320:     write(1, "\n", 1)                    = 1
                                12320:     write(1, " S Q L > ", 5)               = 5
                                12320:     read(0, 0xFFFFFFFF7CEF36D8, 1024) (sleeping...)
                                12320:     read(0, " e x i t\n", 1024)               = 5
                                12320:     write(10, "\0\r\0\006\0\0\0\0\003\t".., 13)     = 13
                                12321:     read(9, "\0\r\0\006\0\0\0\0\003\t".., 32783)     = 13
                                12320:     read(11, "\011\0\006\0\0\0\0\0\t\0".., 32783)     = 17
                                12321:     write(12, "\011\0\006\0\0\0\0\0\t\0".., 17)     = 17
                                12320:     lseek(4, 512, SEEK_SET)                    = 512
                                12320:     read(4, "17A5\0\0\0\0\0\0\0\0\0\0".., 512)     = 512
                                12320:     lseek(4, 1024, SEEK_SET)               = 1024
                                12320:     read(4, "\016\0 *\0 R\0 h\081\09E".., 512)     = 512
                                12320:     lseek(4, 15872, SEEK_SET)               = 15872
                                12320:     read(4, "\0\n02A3\0\0\0 D02A4\0\0".., 512)     = 512
                                12320:     write(1, " D i s c o n n e c t e d".., 13)     = 13
                                12320:     write(10, "\0\n\0\006\0\0\0\0 @", 10)          = 10
                                12321:     read(9, "\0\n\0\006\0\0\0\0 @", 32783)          = 10
                                12320:     close(10)                         = 0
                                12321:     close(12)                         = 0
                                12320:     close(11)                         = 0
                                12321:     close(9)                         = 0
                                12320:     close(8)                         = 0
                                12321:     lwp_sigmask(SIG_SETMASK, 0x00002000, 0x00000000) = 0xFFBFFEFF [0x0000FFFF]
                                12320:     close(6)                         = 0
                                12321:     sigaction(SIGALRM, 0xFFFFFFFF7FFFEB80, 0xFFFFFFFF7FFFEC78) = 0
                                12321:     lwp_sigmask(SIG_SETMASK, 0x00000000, 0x00000000) = 0xFFBFFEFF [0x0000FFFF]
                                12321:     sigaction(SIGQUIT, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12320:     close(5)                         = 0
                                12321:     sigaction(SIGILL, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGTRAP, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGABRT, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12320:     close(3)                         = 0
                                12321:     sigaction(SIGFPE, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12320:     close(4)                         = 0
                                12321:     sigaction(SIGBUS, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGSEGV, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGSYS, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGXCPU, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGXFSZ, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGLOST, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGHUP, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGPIPE, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGTERM, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGVTALRM, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGPROF, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12320:     _exit(0)
                                12321:     sigaction(SIGUSR1, 0xFFFFFFFF7FFFED10, 0xFFFFFFFF7FFFEE08) = 0
                                12321:     sigaction(SIGUSR2, 0xFFFFFFFF7FFFEDC0, 0xFFFFFFFF7FFFEEB8) = 0
                                12321:     _exit(0)

                                Thanks and Regards ...
                                • 28. Re: OS authentication related problem
                                  464759
                                  For shm system calls, you have some system calls that look OK and some that fail. Difficult to say whether this is OK or not: this is something more for Oracle support.

                                  I would also recommend you what orafad is telling you. And to carefully review how you want to install your system from Oracle point of view using Oracle and SAP documentation:
                                  - which account/group must be the owner of the Oracle software
                                  - which account/group must be the owner of the Oracle processes = database instance
                                  Oracle requires at least that these 2 accounts must belong to the same group (generic name is OSDBA in Oracle documentation).
                                  • 29. Re: OS authentication related problem
                                    523455
                                    Thanks ORAFAD and PIERRE for your valuable time .We shall go by your suggestions and whenever we have a chance to mount database again we will make changes suggested by you.
                                    Regards