14 Replies Latest reply: May 27, 2013 5:50 AM by Nicolas.Gasparotto RSS

    not able to connect as sysdba after clean installation ora-27300, ora-27301

    User9546505-Oracle
      We installed oracle database 11.2.0.3 enterprise edition on solaris 5.11 sparc server and catch ORA-12547: TNS:lost contact when trying to connect as sysdba
      -bash-4.1$ sqlplus / as sysdba
      
      SQL*Plus: Release 11.2.0.3.0 Production on Fri May 10 08:45:40 2013
      
      Copyright (c) 1982, 2011, Oracle.  All rights reserved.
      
      ERROR:
      ORA-12547: TNS:lost contact
      we followed Ora-12547: Tns:Lost Contact Creating Database After Clean Installation [Article ID 744512.1]
      here is part of the truss output
      14736:  mmap(0x00010000, 65536, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON|MAP_ALIGN, -1, 0) = 0xFFFFFFFF7BC00000
      14736:  munmap(0xFFFFFFFF7BC00000, 65536)               = 0
      14736:  brk(0x10D4AC000)                                = 0x00000000
      14736:  brk(0x10D4B0000)                                = 0x00000000
      14736:  lseek(0, 0, SEEK_CUR)                           = 1982
      14736:  close(0)                                        = 0
      14736:  open("/dev/null", O_RDONLY)                     = 0
      14736:  close(1)                                        = 0
      14736:  open("/dev/null", O_WRONLY|O_CREAT|O_TRUNC, 0666) = 1
      14736:  close(2)                                        = 0
      14736:  open("/dev/null", O_WRONLY|O_CREAT|O_TRUNC, 0666) = 2
      14736:  open("/dev/null", O_RDONLY)                     = 3
      14736:  fcntl(3, F_DUPFD, 0x00000000)                   = 4
      14736:  getrlimit(RLIMIT_NOFILE, 0xFFFFFFFF7FFFF110)    = 0
      14736:  setrlimit(RLIMIT_NOFILE, 0xFFFFFFFF7FFFF110)    Err#1 EPERM [sys_resource]
      trace file
      ORA-00600: internal error code, arguments: [kgepop: no error frame to pop to], [], [], [], [], [], [], [], [], [], [], []
      ORA-27143: OS system call failure
      ORA-27300: OS system dependent operation:setrlimit failed with status: 1
      ORA-27301: OS failure message: Not owner
      ORA-27302: failure occurred at: skgpinit2
      the stack size meet the oracle database requirement.
      -bash-4.1$ ulimit -a
      core file size          (blocks, -c) 0
      data seg size           (kbytes, -d) unlimited
      file size               (blocks, -f) unlimited
      open files                      (-n) 16384
      pipe size            (512 bytes, -p) 10
      stack size              (kbytes, -s) 32768
      cpu time               (seconds, -t) unlimited
      max user processes              (-u) 29995
      virtual memory          (kbytes, -v) unlimited
      we have no clue with this so far, any hint would be highly appreciated.