ORA-01031: insufficient privileges

原创

marvelyu 2010-08-31 10:58:04 博主文章分类：Oracle ©著作权

文章标签 职场休闲 ORA-01031: insuffici 文章分类 数字化转型

©著作权归作者所有：来自51CTO博客作者marvelyu的原创作品，请联系作者获取转载授权，否则将追究法律责任

昨天在做数据复制需要配置TNS连接，多次实验不行

gxnmsdb% sqlplus "sys/system as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on 星期二 8月 31 10:33:42 2010

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

这样可以，但是通过服务名就不行

gxnmsdb% sqlplus "sys/system@gxdbc as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on 星期二 8月 31 10:33:10 2010

ERROR:
ORA-01031: insufficient privileges

Enter user-name:

本来以为数据库安装的问题，结果重装问题依旧，挡住了一下午的时间，一直徘徊在监听和网络服务问题上，今天突然发现还是会在密码问题上。

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

SQL> select * from v$pwfile_users;

no rows selected

SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
gxnmsdb% sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on 星期二 8月 31 10:47:40 2010

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

SQL> shutdown abort
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
gxnmsdb%
gxnmsdb% ls
init.ora initgxdbc.ora spfilegxdbc.ora
initdw.ora orapwgxdbc sqlnet.log
gxnmsdb% rm orapwgxdbc
gxnmsdb% orapwd file=orapwgxdbc password=system entries=10
gxnmsdb% sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on 星期二 8月 31 10:49:06 2010

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 4298086048
bytes

Fixed Size 734880
bytes

Variable Size 1610612736
bytes

Database Buffers 2684354560
bytes

Redo Buffers 2383872

bytes

SQL> select * from v$pwfile_users;

USERNAME SYSDBA
------------------------------------------------------------ ----------
SYSOPER
----------
SYS TRUE
TRUE

SQL*Plus: Release 9.2.0.8.0 - Production on 星期二 8月 31 10:49:52 2010

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production