资源预览内容
第1页 / 共6页
第2页 / 共6页
第3页 / 共6页
第4页 / 共6页
第5页 / 共6页
第6页 / 共6页
亲,该文档总共6页全部预览完了,如果喜欢就下载吧!
资源描述
安装好 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 information: 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 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.1Explanation: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 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 software 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 existERROR: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 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 18-DEC-2010 06:12:32Uptime 0 days 0 hr. 49 min. 22 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.(DESCRIPTION=(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.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, 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 180355072 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-DEC-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 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.(DESCRIPTION=(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 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
收藏 下载该资源
网站客服QQ:2055934822
金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号