ORA
今天在自己的电脑上面启动数据库的时候把下面的错误,[*]# 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 Area521936896 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
启动数据库正常。
页:
[1]