LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 222.173.27.117)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /opt/ora111、运行安装时提示屏幕颜色问题，需要安装XHOST
yum install xhost
执行xhost命令
xhost local:oracle
2、重装Oracle时提示SID已存在
vi /etc/oratab
删除SID行即可
3、出现ORA-12514错误
LISTENER LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 222.173.27.117)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/ora11/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = souask)
(ORACLE_HOME = /opt/ora11/oracle)
(SID_NAME = souask)
)
)
ADR_BASE_LISTENER = /opt/ora11
iptables -A INPUT -p tcp --dport 1521 -j ACCEPT
service iptables save
posted on 2010-06-06 09:33
蓝剑 阅读(1643)
评论(0) 编辑 收藏 所属分类:
Oracle