數(shù)據(jù)庫(kù)啟動(dòng)的相關(guān)問(wèn)題

1、安裝好 安裝好 oracle10g 數(shù)據(jù)庫(kù)，在新建的 數(shù)據(jù)庫(kù)，在新建的 lccx 用戶下，數(shù)據(jù)庫(kù)不能啟動(dòng)，出錯(cuò)信息如下： 用戶下，數(shù)據(jù)庫(kù)不能啟動(dòng)，出錯(cuò)信息如下： [lccx@yx ~]$ sqlplus “/as sysdba“ SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 14 09:53:48 2010 Copyright (c) 1982, 2005, Oracle.

2、All rights reserved. ERROR: ORA-09925: Unable to create audit trail file Linux Error: 13: Permission denied Additional information: 9925 ORA-09925: Unable to create audit trail file Linux Error: 13: Permission denied Add

3、itional information: 9925 Enter user-name: Connection closed by foreign host. Type `help' to learn how to use Xshell prompt. 解決方法如下： 最佳答案 最佳答案 Cause: ORACLE was not able to create the file being used to hold audit

4、trail records. Action: Check the UNIX error number for a possible operating system error. If there is no error, contact ORACLE customer support. *** Important: The notes below are for experienced users - See Note 22080.1

5、 Explanation: This error should only be seen on Unix systems. Oracle tries to create an audit file (in releases 7.1.3 onwards) even if auditing is not enabled. (C2 audit requirement) By default this information is writte

6、n to $ORACLE_HOME/rdbms/audit. Diagnosis: On UNIX: 1) Ensure the directory $ORACLE_HOME/rdbms/audit or the directory specified by the init.ora exists, is writable by the oracle software owner and that the disk is not

7、full. Listener Log File /data/oracle/product/10.2.0.1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168

8、.100.123)(PORT=1522))) Services Summary... Service “PLSExtProc“ has 1 instance(s). Instance “PLSExtProc“, status UNKNOWN, has 1 handler(s) for this service... The command completed successfully LSNRCTL> exit [lccx@yx

9、~]$ sqlplus “/as sysdba“ SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 18 07:25:11 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startuo^H[p^H^H^H^H SP2-0734:

10、unknown command beginning “startu[p...“ - rest of line ignored. SQL> startup ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 100664912 bytes Database Buffers

11、180355072 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL> connected to： oracle database 10g enterprise edition release 10.2.0.1.0 - production with the partitioning . OLAP and Data mining o