Bo's Oracle Station

查看: 1892|回复: 1

口令文件验证startup数据库报错“insufficient privileges”

[复制链接]

4

主题

5

帖子

36

积分

新手上路

Rank: 1

积分
36
发表于 2017-5-22 20:41:30 | 显示全部楼层 |阅读模式
大家好~


小弟在centos6.5安装oracle grid后,再安装oracle软件,打算通过duplicate database方式建库
安装gi与oracle软件都使用同一个用户oracle,
[root@ft ~]# id oracle
uid=20000(oracle) gid=20000(oinstall) groups=20000(oinstall),20001(dba),20002(asmdba),20003(asmadmin)


以操作系统认证登陆oracle 能startup nomount,

如果以口令文件认证或ezconnect也可以登陆成功
[oracle@ft ~]$ sqlplus sys/123@db1_b as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 22 20:22:36 2017

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

Connected to an idle instance.

SQL>


----------------
[oracle@ft ~]$ sqlplus sys/123@192.168.100.110:1521/db1 as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 22 20:23:25 2017

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

Connected to an idle instance.


但此时都是显示Connected to an idle instance.
不管数据库处于nomount还是未启动的状态,通过这两种方式登陆数据库都是显示Connected to an idle instance.”


此时startup nomount就弹出报错“ORA-01031: insufficient privileges”
[oracle@ft ~]$ sqlplus sys/123@192.168.100.110:1521/db1 as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Mon May 22 20:23:25 2017


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


Connected to an idle instance.


SQL> startup nomount
ORA-01031: insufficient privileges
SQL>


如果以操作系统认证是可以startup nomount

[oracle@ft ~]$ export ORACLE_SID=db1
[oracle@ft ~]$ export ORACLE_BASE=/u01/app/oracle
[oracle@ft ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@ft ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus  / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 22 20:29:26 2017

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2253664 bytes
Variable Size             989858976 bytes
Database Buffers          603979776 bytes
Redo Buffers                7319552 bytes




小弟尝试了修改sqlnet.ora文件
不管SQLNET.AUTHENTICATION_SERVICES= (ALL)或者(NONE)都解决不了这个怪问题,还请唐SIE和童鞋们帮忙出出主意,谢谢~

回复

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-5-22 21:03:23 | 显示全部楼层
[oracle@ft ~]$ sqlplus sys/123@192.168.100.110:1521/db1 as sysdba

初步看一下,口令是123! orapwd用起来弄一个复杂密码,至少字母大头。
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 04:30 , Processed in 0.034369 second(s), 33 queries .

快速回复 返回顶部 返回列表