david

0 积分	0 好友	2 主题

发消息

[升级] 求助：ORA-01031: insufficient privileges

1^#

发表于 2013-12-12 16:36:04 | 查看: 3791| 回复: 4

起因：
      某开发在测试库上，将数据文件不小心删除了（具有较大权限的人），之后尝试自己恢复，以下是他的操作

CREATE CONTROLFILE REUSE DATABASE "KOBRA" RESETLOGS  NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1168
LOGFILE
  GROUP 1 '/home/oracle/app/oracle/oradata/kobra/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/home/oracle/app/oracle/oradata/kobra/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/home/oracle/app/oracle/oradata/kobra/redo03.log'  SIZE 50M BLOCKSIZE 512
DATAFILE
  '/home/oracle/app/oracle/oradata/kobra/system01.dbf',
  '/home/oracle/app/oracle/oradata/kobra/sysaux01.dbf',
  '/home/oracle/app/oracle/oradata/kobra/undotbs01.dbf',
  '/home/oracle/app/oracle/oradata/kobra/users01.dbf'
CHARACTER SET ZHS16GBK
;

以上他操作完成之后，reboot了系统

重新登录系统后

问题：

SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges

我尝试了几次，没有成功，以下是我收集的信息

1.
more listener.ora
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.xxx.xxx)(PORT = 1521))
)
  )

ADR_BASE_LISTENER = /home/oracle/app/orac

2.
more sqlnet.ora
# sqlnet.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /home/oracle/app/oracle

3.
uid=501(oracle) gid=501(oinstall) 组=501(oinstall),506(ora_dba) »·¾³=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

more /etc/group | grep oracle
ora_dba:x:506:oracle
more /etc/group | grep 501
oinstall:x:501:

4.strace -o /tmp/strace_sysdba.output -cfT sqlplus / as sysdba生成的文件

% time    seconds  usecs/call    calls errors syscall
------ ----------- ----------- --------- --------- ----------------
47.23 0.003505          3    1185    191 open
17.11 0.001270          0    5381       4 read
14.07 0.001044       65       16          socket
13.48 0.001000       14       72       63 shmget
  5.96 0.000442       147       3          clone
  1.27 0.000094          0    1040          mmap
  0.49 0.000036          0    409          munmap
  0.40 0.000030          0    165          shmat
  0.00 0.000000          0    125          write
  0.00 0.000000          0    1035          close
  0.00 0.000000          0    193       63 stat
  0.00 0.000000          0    170          fstat
  0.00 0.000000          0       29       4 lstat
  0.00 0.000000          0       67          lseek
  0.00 0.000000          0    108          mprotect
  0.00 0.000000          0       31          brk
  0.00 0.000000          0    178          rt_sigaction
  0.00 0.000000          0       38          rt_sigprocmask
  0.00 0.000000          0       3       1 ioctl
  0.00 0.000000          0       30       21 access
  0.00 0.000000          0       6          pipe
  0.00 0.000000          0       3          dup
  0.00 0.000000          0       12       12 connect
  0.00 0.000000          0       4          bind
  0.00 0.000000          0       4          execve
  0.00 0.000000          0       37          uname
  0.00 0.000000          0    165          shmdt
  0.00 0.000000          0       55          fcntl
  0.00 0.000000          0       2          getdents
  0.00 0.000000          0       18          getcwd
  0.00 0.000000          0       3          chdir
  0.00 0.000000          0       80       80 mkdir
  0.00 0.000000          0       2          readlink
  0.00 0.000000          0       5          chmod
  0.00 0.000000          0       36          getrlimit
  0.00 0.000000          0       7          getrusage
  0.00 0.000000          0       28          times
  0.00 0.000000          0       28          getuid
  0.00 0.000000          0       2          getgid
  0.00 0.000000          0       10          geteuid
  0.00 0.000000          0       1          getegid
  0.00 0.000000          0       3          getppid
  0.00 0.000000          0       6       3 setsid
  0.00 0.000000          0       3          sigaltstack
  0.00 0.000000          0       4          arch_prctl
  0.00 0.000000          0       9          setrlimit
  0.00 0.000000          0       3          gettid
  0.00 0.000000          0       13       4 futex
  0.00 0.000000          0       1          io_setup
  0.00 0.000000          0       4          set_tid_address
  0.00 0.000000          0       4          set_robust_list
------ ----------- ----------- --------- --------- ----------------
100.00 0.007421                10836    446 total

5.密码文件名称
orapwkobra

刘大有空帮忙看下，谢谢！

分享0