Windows XP Windows 7 Windows 2003 Windows Vista Windows教程綜合 Linux 系統教程
Windows 10 Windows 8 Windows 2008 Windows NT Windows Server 電腦軟件教程
 Windows教程網 >> Linux系統教程 >> Linux教程 >> /etc/hosts權限不足導致數據庫啟動失敗 解決方案

/etc/hosts權限不足導致數據庫啟動失敗 解決方案

日期:2017/2/7 14:34:47      編輯:Linux教程
 

問題描述:

現場SUSE9SP3下安裝oracle9208數據庫,數據庫安裝完成後,啟動監聽和數據庫時都有報錯,無法正常啟動

1,啟動監聽報錯:

$ lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production on 09-SEP-2009 16:22:17
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /home/oracle/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
System parameter file is /home/oracle/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/app/oracle/diag/tnslsnr/oracle15/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle15)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
IBM/AIX RISC System/6000 Error: 13: Permission denied
Listener failed to start. See the error message(s) above...


2,啟動和關閉數據庫時候,都會報如下錯誤。
$ sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Sep 9 16:24:36 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected.
SQL> startup
ORA-00000: normal, successful completion
SQL> shutdown immediate;
ORA-00000: normal, successful completion
 

經檢查,oracle啟動時要求對/etc/hosts文件有執行權限,

執行chmod 777 /etc/hosts命令對oracle用戶賦權,問題得解。

Copyright © Windows教程網 All Rights Reserved