记一次oracle数据库完整复制到另一服务器登陆报错无权限insufficient privileges

乘续远

已于 2022-08-04 14:45:57 修改

阅读量578

点赞数

分类专栏： oracle 文章标签：数据库 oracle

于 2022-08-04 14:45:05 首次发布

本文链接：https://blog.csdn.net/qq_35335755/article/details/126158970

版权

oracle 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

报错：

ERROR:
ORA-01031: insufficient privileges

[oracle@slave01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 4 22:29:40 2022

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:

分析很久才发现原因是新的服务器新建的oracle账号没有放到dba用户组里面

[oracle@slave01 ~]$ groups
oinstall

[root@slave01 ~]# cat /etc/group | grep dba
dba:x:503:
[root@slave01 ~]# cat /etc/group | grep oinstall
oinstall:x:502:
[root@slave01 ~]# cat /etc/passwd | grep oracle
oracle:x:502:502::/home/oracle:/bin/bash
[root@slave01 ~]# id oracle
uid=502(oracle) gid=502(oinstall) groups=502(oinstall)

将oracle用户添加到dba用户组

[root@slave01 ~]# gpasswd -a oracle dba
Adding user oracle to group dba
[root@slave01 ~]# id oracle
uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)

再次登录数据库启动正常

[oracle@slave01 ~]$ groups
oinstall dba
[oracle@slave01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 4 22:42:12 2022

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2.0284E+10 bytes
Fixed Size                  2056872 bytes
Variable Size            2415922520 bytes
Database Buffers         1.7851E+10 bytes
Redo Buffers               14716928 bytes
Database mounted.
Database opened.
SQL>