主机字符串需要配置的。
引自: NinGoo(宁哥) 在oracle服务器上配置listener.ora,格式如下LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 机器名或者IP)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)在客户端配置tnsnames.ora,格式如下
Test = /*此处的Test即在sqlplus中填的主机字符串,可以任意命名
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 服务器机器名或者IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MyTest) /*此处的MyTest为Oracle_SID(一般设置service_name和SID相同)
)
)service_name也可以填入你的oracle的global_name
select * from global_name可以获得
引自: NinGoo(宁哥) 在oracle服务器上配置listener.ora,格式如下LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 机器名或者IP)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)在客户端配置tnsnames.ora,格式如下
Test = /*此处的Test即在sqlplus中填的主机字符串,可以任意命名
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 服务器机器名或者IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MyTest) /*此处的MyTest为Oracle_SID(一般设置service_name和SID相同)
)
)service_name也可以填入你的oracle的global_name
select * from global_name可以获得
在安装的过程中我装了database : lhdev
global name: lhdev.ca.uwo.com
sid: lhdev所有的安装完了以后
提示我可以访问
Enteprise Manager 10g Database Control URL:
http://localhost:5500/em当我进入以后
提示我: database is currently down
要我提供
host credentials
(specify the os user name and password to login to target database machine)
我用的是 windows XP home
我就没有设置我的password 如何才能找出我的os user name and password?另外安装说明上说不能装在windows xp home
必须装在windows XP professional 我现在装在XP home上
是不是有什么影响呢?
我装oracle 10g 只是为了学jdeveloper 10g
上面有很多例子必须要求用oracle 10g是否必须装在XP Pro上呢?
谢谢!
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=lhdev.ca.uwo.com))) 如何设置listner.ora and tnsnames.ora?