ORA

yinian

今天在自己的电脑上面启动数据库的时候把下面的错误,

• # su - oracle
  
• Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
  
• $ sqlplus / as sysdba
  
• 
  
• SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 30 20:09:44 2012
  
• 
  
• Copyright (c) 1982, 2011, Oracle.  All rights reserved.
  
• 
  
• ERROR:
  
• ORA-12578: TNS:wallet open failed
  
• Enter user-name:  
  
• ERROR:
  
• ORA-01017: invalid username/password; logon denied
  
• Enter user-name:  
  
• ERROR:
  
• ORA-01017: invalid username/password; logon denied
  
• SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
  
• 
  
• $
  

可以是wallet出了问题，记得原来做过wallet实验，但是后面mkstore删除了，不知道为什么还报错误。
查看下面文件

• $ vi sqlnet.ora
  
• "sqlnet.ora" 7 lines, 315 characters  
  
• # sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
  
• # Generated by Oracle configuration tools.
  
• 
  
• ADR_BASE = /u01/app/oracle
  
• WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/u01/app/oracle/product/11.2.0/db_1/wallet/htzdg)))
  
• SQLNET.WALLET_OVERRIDE=TRUE
  

查看wallet目录是否存在。

• $ ls -l /u01/app/oracle/product/11.2.0/db_1/wallet/htzdg
  
• /u01/app/oracle/product/11.2.0/db_1/wallet/htzdg: No such file or directory
  
• $  
  

　　由于目录不存在，注视掉wallet相关的参数。启动数据库正常。

• $ vi sqlnet.ora
  
• "sqlnet.ora" 7 lines, 315 characters  
  
• # sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
  
• # Generated by Oracle configuration tools.
  
• 
  
• ADR_BASE = /u01/app/oracle
  
• #WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/u01/app/oracle/product/11.2.0/db_1/wallet/htzdg)))
  
• #SQLNET.WALLET_OVERRIDE=TRUE
  
• 
  
• $ sqlplus / as sysdba
  
• 
  
• SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 30 20:14:31 2012
  
• 
  
• Copyright (c) 1982, 2011, Oracle.  All rights reserved.
  
• 
  
• Connected to an idle instance.
  
• 
  
• SQL> startup
  
• ORACLE instance started.
  
• 
  
• Total System Global Area  521936896 bytes
  
• Fixed Size                  2227576 bytes
  
• Variable Size             352322184 bytes
  
• Database Buffers          163577856 bytes
  
• Redo Buffers                3809280 bytes
  
• Database mounted.
  
• Database opened.
  
• SQL>  
  
• SQL> exit
  
• Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  
• With the Partitioning, OLAP, Data Mining and Real Application Testing options
  

　　启动数据库正常。