重启oracle服务器口令,为oracle数据库创建口令文件

如果从远端以sysdba方式登录oracle数据库服务器的时候报ORA-01031:insufficient privileges

错误，可以通过创建口令文件的方式解决

创建口令文件的方式如下：[@more@]

使用orapwd命令创建口令文件ora_test@oracle[/home/oracle]> orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID

> password=oracle entries=10 force=y

登录数据库，检查REMOTE_LOGIN_PASSWORDFILE参数

如果REMOTE_LOGIN_PASSWORDFILE参数指为none，设置为exclusive，然后重启数据库ora_test@oracle[/home/oracle]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 2 20:47:40 2010

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

sys@CNHTM> alter system set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE scope=spfile;

System altered.

sys@CNHTM> startup force

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1218292 bytes

Variable Size 75499788 bytes

Database Buffers 83886080 bytes

Redo Buffers 7168000 bytes

Database mounted.

Database opened.

--end--