数据库启动的相关问题.doc

资源描述

安装好oracle10g数据库，在新建的lccx用户下，数据库不能启动，出错信息如下： [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. 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 Additional 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 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 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 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 <parameter:AUDIT_FILE_DEST> 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 exist ERROR: ORA-12541: TNS:no listener ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [lccx@yx ~]$ lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-DEC-2010 07:01:51 Copyright (c) 1991, 2005, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 18-DEC-2010 06:12:32 Uptime 0 days 0 hr. 49 min. 22 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/10.2.0.1/network/admin/listener.ora 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.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 ~]$ 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: 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 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 options 正确启动数据库信息 1．监听器的错误 [lccx@yx ~]$ lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-DEC-2010 08:27:21 Copyright (c) 1991, 2005, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 18-DEC-2010 07:31:46 Uptime 0 days 0 hr. 55 min. 39 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/10.2.0.1/network/admin/listener.ora 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.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 successfully LSNRCTL>exit 2．正确启动数据库时的信息 [lccx@yx ~]$ sqlplus lccx2002/bcm2002@cqmn SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 18 08:01:53 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> startup ORA-01031: insufficient privileges //权限不够 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options [lccx@yx ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 18 08:10:35 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> connect /as sysdb SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] | / SQL> connect /as sysdba Connected. SQL> show user USER is "SYS" SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options [lccx@yx ~]$ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 18 08:12:32 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> startup ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 109053520 bytes Database Buffers 171966464 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options 原因 ,检查一下 vi /etc/hosts Lsnrctl start 开启驱动 Status 查看驱动状态.

展开阅读全文