(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
(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
(6)ORCLE连接字符串用户名为sys as sysdba