数据库启动的相关问题.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 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 0612: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 ::= [/][@] | /

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 查看驱动状态.