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

bestv_xiaolian

大家好~


小弟在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和童鞋们帮忙出出主意，谢谢~

botang

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

初步看一下，口令是123! orapwd用起来弄一个复杂密码，至少字母大头。