我用symantec be去备份 redhat5.5上的 oracle 11g ebs 的实例……
然后在./AgentConfig 配置本地实例的时候输入实例名提示:
This user account does not have the privileges that are required to log on to the Oracle database然后去查看错误日志:
b24c0600 Mon Jun 27 21:53:52 2011 : OCI_ERROR: ORA-01031: insufficient privileges
b24c0600 Mon Jun 27 21:53:52 2011 : Oracle Logon Failure, insufficient privileges: Error code (1031)
b24c0600 Mon Jun 27 21:53:52 2011 : Returning E_RMAN_LOGON_INSUFFICIENT_PRIVILEGES error (0xe000100d然后去看了下:
[oraprod@cliviadb dbs]$ pwd
/ebs/oracle/CLIVIA/db/tech_st/11.1.0/dbs
[oraprod@cliviadb dbs]$ ls
CLIVIA_cliviadb_ifile.ora initCLIVIA_noaq.ora init.ora lkCLIVIA
hc_CLIVIA.dat initCLIVIA.ora initR1211BLN.ora.10262008222132 spfileCLIVIA.ora
hc_DBUA0.dat initdw.ora initR1211XB4.ora.0142009231150 spfileR1211XB4.ora.bak
[oraprod@cliviadb dbs]$ 再到目录$ORACLE_HOME/network/SID_hostname/admin[oraprod@cliviadb CLIVIA_cliviadb]$ pwd
/ebs/oracle/CLIVIA/db/tech_st/11.1.0/network/admin/CLIVIA_cliviadb
[oraprod@cliviadb CLIVIA_cliviadb]$ ls
listener_ifile.ora listener.ora sqlnet_ifile.ora sqlnet.ora tnsnames.ora
oraprod@cliviadb CLIVIA_cliviadb]$ more sqlnet.ora
###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
#$Header: NetServiceHandler.java 120.19.12010000.6 2010/03/09 08:11:36 jmajumde ship $
#
###############################################################NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
SQLNET.INBOUND_CONNECT_TIMEOUT =60
DIAG_ADR_ENABLED=ON
ADR_BASE=/ebs/oracle/CLIVIA/db/tech_st/11.1.0/admin/CLIVIA_cliviadb
SEC_USER_AUDIT_ACTION_BANNER = /ebs/oracle/CLIVIA/db/tech_st/11.1.0/appsutil/template/txkDBSecUserAuditActionBanner.txt
IFILE=/ebs/oracle/CLIVIA/db/tech_st/11.1.0/network/admin/CLIVIA_cliviadb/sqlnet_ifile.ora
[oraprod@cliviadb CLIVIA_cliviadb]$ 接下来,去$ORACLE_HOME/bin/
[oraprod@cliviadb bin]$ pwd
/ebs/oracle/CLIVIA/db/tech_st/11.1.0/bin
[oraprod@cliviadb bin]$ ls orapwd*
orapwd orapwdO
[oraprod@cliviadb bin]$然后再到数据库里查了下:
SQL> select * from v$pwfile_users;no rows selected
然后在./AgentConfig 配置本地实例的时候输入实例名提示:
This user account does not have the privileges that are required to log on to the Oracle database然后去查看错误日志:
b24c0600 Mon Jun 27 21:53:52 2011 : OCI_ERROR: ORA-01031: insufficient privileges
b24c0600 Mon Jun 27 21:53:52 2011 : Oracle Logon Failure, insufficient privileges: Error code (1031)
b24c0600 Mon Jun 27 21:53:52 2011 : Returning E_RMAN_LOGON_INSUFFICIENT_PRIVILEGES error (0xe000100d然后去看了下:
[oraprod@cliviadb dbs]$ pwd
/ebs/oracle/CLIVIA/db/tech_st/11.1.0/dbs
[oraprod@cliviadb dbs]$ ls
CLIVIA_cliviadb_ifile.ora initCLIVIA_noaq.ora init.ora lkCLIVIA
hc_CLIVIA.dat initCLIVIA.ora initR1211BLN.ora.10262008222132 spfileCLIVIA.ora
hc_DBUA0.dat initdw.ora initR1211XB4.ora.0142009231150 spfileR1211XB4.ora.bak
[oraprod@cliviadb dbs]$ 再到目录$ORACLE_HOME/network/SID_hostname/admin[oraprod@cliviadb CLIVIA_cliviadb]$ pwd
/ebs/oracle/CLIVIA/db/tech_st/11.1.0/network/admin/CLIVIA_cliviadb
[oraprod@cliviadb CLIVIA_cliviadb]$ ls
listener_ifile.ora listener.ora sqlnet_ifile.ora sqlnet.ora tnsnames.ora
oraprod@cliviadb CLIVIA_cliviadb]$ more sqlnet.ora
###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
#$Header: NetServiceHandler.java 120.19.12010000.6 2010/03/09 08:11:36 jmajumde ship $
#
###############################################################NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
SQLNET.INBOUND_CONNECT_TIMEOUT =60
DIAG_ADR_ENABLED=ON
ADR_BASE=/ebs/oracle/CLIVIA/db/tech_st/11.1.0/admin/CLIVIA_cliviadb
SEC_USER_AUDIT_ACTION_BANNER = /ebs/oracle/CLIVIA/db/tech_st/11.1.0/appsutil/template/txkDBSecUserAuditActionBanner.txt
IFILE=/ebs/oracle/CLIVIA/db/tech_st/11.1.0/network/admin/CLIVIA_cliviadb/sqlnet_ifile.ora
[oraprod@cliviadb CLIVIA_cliviadb]$ 接下来,去$ORACLE_HOME/bin/
[oraprod@cliviadb bin]$ pwd
/ebs/oracle/CLIVIA/db/tech_st/11.1.0/bin
[oraprod@cliviadb bin]$ ls orapwd*
orapwd orapwdO
[oraprod@cliviadb bin]$然后再到数据库里查了下:
SQL> select * from v$pwfile_users;no rows selected
解决方案 »
- 如何验证oracle性能是否正常?
- 请问一个用VM当生产库然后导出数据到物理机的问题~!
- 没见过的安装oracle8.1.7的问题
- 请问ORACLE用户可以改名吗?
- utl_file包的问题
- 简单的存储过程中使用参数或变量的问题
- 程序能够运行, 但当连接到SQL/PLUS出现提示:ORA-12514 : TNS: listener could not resolve SERVICE_NAME given in connect
- 关于Oracle中数据锁定的问题
- 关于透明网关的问题
- 如何将oracle数据库转换(导入)mysql数据库??请指点!
- 存储过程创建没问题,但在执行的时候报错
- 请问下这句exp导出语句什么意思?
用sys用户连接的?然后再到数据库里查了下:
SQL> select * from v$pwfile_users;
no rows selected-- 没有创建口令文件,用orapwd 命令创建一个就ok了。 注意文件名称格式。Oracle OS认证 口令文件 密码丢失处理
http://blog.csdn.net/tianlesoftware/archive/2009/10/19/4698293.aspx