oracle安装时遇到的一些问题

(1)JDBC连接oracle11g时遇到：

connect error Info:Io 异常: The Network Adapter could not establish the connection

然后就查看oracle11g的实例状态

su - oracle 

sqlplus /nolog

conn /as sysdba

startup

(2)又出现这样的报错提示：

ORA-00845: MEMORY_TARGET not supported on this system

解决办法：http://yangtingkun.itpub.net/post/468/408235

（3）找不到ORCL SID

于是就在/opt/oracle/product/OraHome/network/admin/listener.ora添加

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.61)(PORT = 1521))

    )

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = orcl)

      (ORACLE_HOME= /opt/oracle/product/OraHome)

      (SID_NAME = orcl)

    )

  )

这里其实也遇到一个问题

一开始(ORACLE_HOME= /opt/oracle/oracle/product/OraHome)写错了！！

于是就会报这样的错误TNS01201

（5）

oracle连接异常shared memory realm does not exist

http://mengshuangcom.iteye.com/blog/963837

(6)ORCLE连接字符串用户名为sys as sysdba