解决方案 »
- ORCLE10G数据库有几张业务表经常锁,如何跟踪锁业务时正在执行的sql语句
- 求解 同表同字段触发器
- 如下存储过程哪个地方错了?望高手解疑
- Oracle11g之实用技术--将数据插入Oracle数据库时如何得到其rowId
- JOB 不能重复调用,运行一次就没有了,有无例子
- (急的不能再急了100分拿出来)Oracle
- 数据库里建表.有一项是Nullable这一项是什么意思?
- 问个定时自动导出数据的问题,分不够再加
- 使用了DBA Studio的分析向导对一个表进行了分析以后,检索速度明显加快。可是录入新的数据以后,是否需要重新对表进行分析,才能提高检索
- DELPHI6+BDE+ORACLE8下无法显示汉字表和汉字字段
- 主机是否宕机
- 银行卡号正则表达式
1、机器和虚拟机网络是否连通
2、虚拟机中数据库服务是否启动
3、虚拟中监听是否配置正确,并且正常启动
4、外面机器的tns是否配置正确
5、兼容性问题,试试其他的数据库连接工具是否能连上,某些程序和64位是不兼容的
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\My-PC\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\My-PC\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIRpc)(PORT = 1521))
)
)ADR_BASE_LISTENER = C:\app\My-PC
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)
host=127.0.0.1试下
# tnsnames.ora Network Configuration File: D:\MyDrivers\ORACLE\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.41)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
# listener.ora Network Configuration File: D:\MyDrivers\ORACLE\product\11.2.0\client_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.41)(PORT = 1521))
)ADR_BASE_LISTENER = D:\MyDrivers\ORACLE