不可不说
随心所欲,无往不利!
posts - 88,  comments - 92,  trackbacks - 0
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 蓝剑 阅读(1552) 评论(0)  编辑  收藏 所属分类: Oracle

只有注册用户登录后才能发表评论。


网站导航:
 


<2010年6月>
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

常用链接

留言簿(6)

随笔分类(62)

随笔档案(90)

文章档案(9)

相册

友情链接

搜索

  •  

积分与排名

  • 积分 - 305082
  • 排名 - 162

最新评论

阅读排行榜

评论排行榜