资源描述
安装好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 hold audit 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.0 - Production on Sat Dec 18 08:01:53 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL startupORA-01031: insufficient privileges /权限不够SQL exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionslccxyx $ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 18 08:10:35 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL connect /as sysdbSP2-0306: Invalid option.Usage: CONNECT logon AS SYSDBA|SYSOPERwhere := / | /SQL connect /as sysdbaConnected.SQL show userUSER is SYSSQL exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionslccxyx $ sqlplus /as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 18 08:12:32 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL startupORA-01081: cannot start already-running ORACLE - shut it down firstSQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startupORACLE instance started.Total System Global Area 285212672 bytesFixed Size 1218992 bytesVariable Size 109053520 bytesDatabase Buffers 171966464 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.SQL exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options原因 ,检查一下 vi /etc/hostsLsnrctl start 开启驱动Status 查看驱动状态.
展开阅读全文