启动oracle11g时报的错误，该如何解决

Question

ERROR:
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on

Answer 1

没有adump目录

oracle启动的时候需要访问adump,bdump,udump,cdump等这些目录
一般是在$ORACLE_BASE/admin/{oracle_sid}/目录下追问

ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 499125840 bytes
..........
????????
????????
这算是启动成功了吗？为啥下面都是问号

追答

估计是失败了，问号是由于字符集的问题。

你试下
SQL> select status from v$instance;
SQL> select open_mode from v$database;
这两条语句查看数据库装态，如果数据正常启动，两条语句返回的结果分别是OPEN和READ WRITE