《数据库启动的相关问题》由会员分享，可在线阅读，更多相关《数据库启动的相关问题（6页珍藏版）》请在金锄头文库上搜索。
1、安装好 oracle10g 数据库，在新建的 lccx 用户下，数据库不能启动，出错信息如下：lccxyx $ sqlplus /as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 14 09:53:48 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-09925: Unable to create audit trail fileLinux Error: 13: Permission deniedAdditional informat
2、ion: 9925ORA-09925: Unable to create audit trail fileLinux Error: 13: Permission deniedAdditional information: 9925Enter 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 holdaudit trail rec
3、ords.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.1Explanation:This error should only be seen on Unix systems.Oracle tries to create an audit fil
4、e (in releases 7.1.3 onwards)even if auditing is not enabled. (C2 audit requirement)By default this information is written 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 softw
5、are owner and that the disk is not full. 2) Check $ORACLE_HOME/bin/oracle has permission of 6755. If not, then correct the permissions by executing this from the $ORACLE_HOME/bin directory: chmod 6755 oracle 执行完后，效果如下：启动数据库报错信息RROR:ORA-12545: Connect failed because target host or object does not exi
6、stERROR:ORA-12541: TNS:no listenerERROR:ORA-12514: TNS:listener does not currently know of service requested in connectdescriptorlccxyx $ lsnrctlLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-DEC-2010 07:01:51Copyright (c) 1991, 2005, Oracle. All rights reserved.Welcome to LSNRCTL, type he
7、lp for information.LSNRCTL statusConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)STATUS of the LISTENER-Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date 18-DEC-2010 06:12:32Uptime 0 days 0 hr. 49 min. 22 secTrace Level offSecurity ON: Local OS Authen
8、ticationSNMP OFFListener Parameter File /data/oracle/product/10.2.0.1/network/admin/listener.oraListener Log File /data/oracle/product/10.2.0.1/network/log/listener.logListening Endpoints Summary.(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.
9、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 successfullyLSNRCTL exitlccxyx $ sqlplus /as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 18 07:25:11 2010Copyright (c) 1982
10、, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL startuoHpHHHHSP2-0734: unknown command beginning startup. - rest of line ignored.SQL startupORACLE instance started.Total System Global Area 285212672 bytesFixed Size 1218992 bytesVariable Size 100664912 bytesDatabase Buffers 1803
11、55072 bytesRedo Buffers 2973696 bytesDatabase 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 options正确启动数据库信息1监听器的错误lccxyx $ lsnrctlLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-D
12、EC-2010 08:27:21Copyright (c) 1991, 2005, Oracle. All rights reserved.Welcome to LSNRCTL, type help for information.LSNRCTL statusConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)STATUS of the LISTENER-Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date
13、18-DEC-2010 07:31:46Uptime 0 days 0 hr. 55 min. 39 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /data/oracle/product/10.2.0.1/network/admin/listener.oraListener Log File /data/oracle/product/10.2.0.1/network/log/listener.logListening Endpoints Summary.(DESCRI
14、PTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.123)(PORT=1522)Services Summary.Service PLSExtProc has 1 instance(s).Instance PLSExtProc, status UNKNOWN, has 1 handler(s) for this service.Service cqmn has 1 instance(s).Instance cqmn, status READY, has
15、 1 handler(s) for this service.Service cqmnXDB has 1 instance(s).Instance cqmn, status READY, has 1 handler(s) for this service.Service cqmn_XPT has 1 instance(s).Instance cqmn, status READY, has 1 handler(s) for this service.The command completed successfullyLSNRCTLexit2正确启动数据库时的信息lccxyx $ sqlplus lccx2002/bcm2002cqmnSQL*Plus: Release 10.2.0.1
