数据库启动的相关问题

《数据库启动的相关问题》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、安装好oracle10g数据库，在新建的lccx用户下，数据库不能启动，出错信息如下：[lccx@yx~]$sqlplus"/assysdba"SQL*Plus:Release10.2.0.1.0-ProductiononThuOct1409:53:482010Copyright(c)1982,2005,Oracle.Allrightsreserved.ERROR:ORA-09925:UnabletocreateaudittrailfileLinuxError:13:PermissiondeniedAdditionalinforma

2、tion:9925ORA-09925:UnabletocreateaudittrailfileLinuxError:13:PermissiondeniedAdditionalinformation:9925Enteruser-name:Connectionclosedbyforeignhost.Type`help'tolearnhowtouseXshellprompt.解决方法如下：最佳答案Cause:ORACLEwasnotabletocreatethefilebeingusedtoholdaudittrailrecords.Ac

3、tion:ChecktheUNIXerrornumberforapossibleoperatingsystemerror.Ifthereisnoerror,contactORACLEcustomersupport.***Important:Thenotesbelowareforexperiencedusers-SeeNote22080.1Explanation:ThiserrorshouldonlybeseenonUnixsystems.Oracletriestocreateanauditfile(inreleases7.1.3on

4、wards)evenifauditingisnotenabled.(C2auditrequirement)Bydefaultthisinformationiswrittento$ORACLE_HOME/rdbms/audit.Diagnosis:OnUNIX:1)Ensurethedirectory$ORACLE_HOME/rdbms/auditorthedirectoryspecifiedbytheinit.oraexists,iswritablebytheoraclesoft

5、wareownerandthatthediskisnotfull.2)Check$ORACLE_HOME/bin/oraclehaspermissionof6755.Ifnot,thencorrectthepermissionsbyexecutingthisfromthe$ORACLE_HOME/bindirectory:chmod6755oracle执行完后，效果如下：启动数据库报错信息RROR:ORA-12545:ConnectfailedbecausetargethostorobjectdoesnotexistERROR:OR

6、A-12541:TNS:nolistenerERROR:ORA-12514:TNS:listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor[lccx@yx~]$lsnrctlLSNRCTLforLinux:Version10.2.0.1.0-Productionon18-DEC-201007:01:51Copyright(c)1991,2005,Oracle.Allrightsreserved.WelcometoLSNRCTL,type"help"forin

7、formation.LSNRCTL>statusConnectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))STATUSoftheLISTENER------------------------AliasLISTENERVersionTNSLSNRforLinux:Version10.2.0.1.0-ProductionStartDate18-DEC-201006:12:32Uptime0days0hr.49min.22secTraceLeveloffSecurit

8、yON:LocalOSAuthenticationSNMPOFFListenerParameterFile/data/oracle/product/10.2.0.1/network/admin/listener.oraListener