問題描述:
現場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用戶賦權,問題得解。