刚刚开始使用Oracle,觉得好麻烦啊!
一堆的工具,各种各样的配置。。。都快要吐了【%…&¥&×发泄一下先】
本来可以使用其最基本的数据库的。然后,终于。。。
我在企业管理器中加了个新的数据库就挂了。。
不停地报错,刚开始只是找不到对象等等。
我就的搜索,百度。。。发现原来还有Net Configuration Asistant这东东。。
就瞎填了一把,瞎删了一把。
竟然发现原来的LTY『数据库』也不能使用了,要不就是TNS错误,要不就是Server_name,要不就是服务名,要不就是SID。。。
快要疯了。不停地修改,试验。。。。网上的东西很多 也导致走了不少弯路。一些人其实不怎么懂,也给『楼主』瞎指挥。。。。
结果就是诱导我不停修改TNSNames.ora有时候又怀疑Listener.ora 又看看sqlnet.ora。。。
经过了痛苦的过程之后,终于发现
http://blog.csdn.net/seulty/archive/2007/07/18/1697869.aspx
虽然文章很短,但是,我确实根据此文解决了问题
赞一个!!
问题解决了,总结如下:
- 只要1个listener即可,多了似乎也没有用处
- TNSNames.ora还是手动改比较好
- 和SQLNET.orb似乎关系不大。。
贴一下改动的文件:
TNSNames.ora:
# TNSNAMES.ORA Network Configuration File: E:oracleora92 etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http: // HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
LTY.ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
LTY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7 . 1.113 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
14_LTY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7 . 1.113 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
14TEST_ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7 . 1.113 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
LTY_ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7 . 1.113 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http: // HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
LTY.ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
LTY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7 . 1.113 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
14_LTY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7 . 1.113 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
14TEST_ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7 . 1.113 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
LTY_ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7 . 1.113 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
Listener.ora
『这里只用了“Listener”这一个服务』,其他两个停掉了。
# LISTENER.ORA Network Configuration File: E:oracleora92 etworkadminlistener.ora
# Generated by Oracle configuration tools.
LTY_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521 ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ace)(PORT = 2484 ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ACE)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = lty))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521 ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ace)(PORT = 2484 ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ACE)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = lty))
)
)
)
SID_LIST_LTY_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:oracleora92)
(PROGRAM = extproc)
)
)
# Generated by Oracle configuration tools.
LTY_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521 ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ace)(PORT = 2484 ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ACE)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = lty))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521 ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ace)(PORT = 2484 ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ACE)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = lty))
)
)
)
SID_LIST_LTY_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:oracleora92)
(PROGRAM = extproc)
)
)
SQLNET.orb
『也贴一下把』
# SQLNET.ORA Network Configuration File: E:oracleora92 etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)