Oracle配置
oracle\product\10.1.0\Db_1\NETWORK\ADMIN下的listener.ora
连接Oracle数据库的时候突然出现了listener does not currently know of service requested in connect descriptor
错误,刚才还连得上数据库的,现在已经不行了,初次接触Oracle,感觉非常的不适应,只能从网上找解决方法了.
解决方法:
将
SID_LIST_LISTENER = | |
(SID_LIST = | |
(SID_DESC = | |
(SID_NAME = PLSExtProc) | |
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1) | |
(PROGRAM = extproc) | |
) |
改为
SID_LIST_LISTENER = | |
(SID_LIST = | |
(SID_DESC = | |
(SID_NAME = PLSExtProc) | |
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1) | |
(PROGRAM = extproc) | |
) | |
(SID_DESC = | |
(GOLBAL_DBNAME= oracle10) | |
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1) | |
(SID_NAME=oracle10) | |
) | |
) |
整体结构如下
1 | # listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora |
2 | # Generated by Oracle configuration tools. |
3 | |
4 | SID_LIST_LISTENER = |
5 | (SID_LIST = |
6 | (SID_DESC = |
7 | (SID_NAME = PLSExtProc) |
8 | (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1) |
9 | (PROGRAM = extproc) |
10 | ) |
11 | (SID_DESC = |
12 | (GOLBAL_DBNAME= oracle10) |
13 | (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1) |
14 | (SID_NAME=oracle10) |
15 | ) |
16 | ) |
17 | |
18 | LISTENER = |
19 | (DESCRIPTION_LIST = |
20 | (DESCRIPTION = |
21 | (ADDRESS_LIST = |
22 | (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) |
23 | ) |
24 | (ADDRESS_LIST = |
25 | (ADDRESS = (PROTOCOL = TCP)(HOST = Richard-PC)(PORT = 1521)) |
26 | ) |
27 | ) |
28 | ) |
29 |
问题又出现了
![image image](https://images.cnblogs.com/cnblogs_com/wheeloffate/WindowsLiveWriter/Oracle_F233/image_6.png)
![image image](https://images.cnblogs.com/cnblogs_com/wheeloffate/WindowsLiveWriter/Oracle_F233/image_5.png)
平时用SQL写的最基本的更新在这里竟然不能用.
UPDATE CUS_PLAN_MONTH SET |
MYear='2010', |
MMonth='11', |
MFillPerId='709所', |
CusId='C105', |
MLinkTel='87534398', |
MCusPlanId='MC105201007', |
MFillDate='2010/7/1' |
WHERE MCusPlanId='MC105201007' |
最终找到原因,竟然是一个触发器,最近用起来也与Sql Server差不多,感觉更强的地方就是所有的字段都有智能感知系统,只是界面看起来有点乱.毕竟现在的大中型企业都用的Oracle,在此Mark一下,就当什么也没写.