tnsname.ora 内容如下:TEST.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SID = test))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SID = test))
)
C:>lsnrctl start
看到底报什么错误?
安装oracle数据库时,系统自动配置如下:
... ...
(ADDRESS = (PROTOCOL = TCP)(HOST = MyComputer)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
... ...
其中MyComputer是我的计算机名,所以我将
(ADDRESS = (PROTOCOL = TCP)(HOST = MyComputer)(PORT = 1521))删除
后便能正常启动ORACLE数据库侦听服务了。