无法在 Windows 环境中启动 OracleXNTNSListener
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/11776367/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
not able to starting OracleXNTNSListener in windows environment
提问by NPKR
I have installed oracleXE in my local meachine.
我已经在本地机器上安装了 oracleXE。
I have changed the services of Oracle level Automatic to Manual. Know when i start the Oracle Services all are getting started except the OracleXNTNSListener service.
我已将 Oracle 级别的自动服务更改为手动。知道当我启动 Oracle 服务时,除 OracleXNTNSListener 服务外,所有服务都已启动。
It saying some times below mentioned 1 error or 2 error
它说下面提到了 1 个错误或 2 个错误
1>Windows could not start OracleXETNSListner service on Local Computer.
1>Windows 无法在本地计算机上启动 OracleXETNSListner 服务。
Error 1067:The process terminated unexpectedly.
错误 1067:进程意外终止。
OR
或者
2>The OracleXNTNSListener service on Local Computer startred and then stopped.Some services stop automatically if they are not in use by other services or programs.
2>本地计算机上的OracleXNTNSListener服务启动然后停止。如果其他服务或程序未使用某些服务,它们会自动停止。
回答by NPKR
After some trials the listener got started.
经过一些试验,听众开始了。
What I did is for this, I have edited the listener.ora file.
我所做的就是为此,我编辑了 listener.ora 文件。
In this line intialy HOST = hostname was there, I changed that to localhost ip i.e 127.0.0.1
在这一行中,最初 HOST = 主机名在那里,我将其更改为 localhost ip,即 127.0.0.1
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(地址 = (协议 = TCP)(主机 = 127.0.0.1)(端口 = 1521))
回答by Nirmal Mangal
I know its a very old thread but, changing 127.0.0.1
to localhost
in both listener.ora
and tnsnames.ora
helped me.
我知道它是一个非常古老的线程,但是,更改127.0.0.1
为localhost
两者listener.ora
并tnsnames.ora
帮助了我。
回答by srlgrg
My listener.ora
file was like this
我的listener.ora
文件是这样的
(ADDRESS = (PROTOCOL = TCP)(HOST = my_computer_name)(PORT = 1521))
I changed to
我改为
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
and then it worked.
然后它起作用了。
回答by Do Nhu Vy
I face this problem, because I have installed Oracle 12c previous, then I try to install Oracle 11g express.
我遇到这个问题,因为我之前安装了Oracle 12c,然后我尝试安装Oracle 11g express。
Check this registry key to ensure ORACLE_HOME is configured for the service:
检查此注册表项以确保为服务配置了 ORACLE_HOME:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_XE\ORACLE_HOME
If that doesn't exist, check here:
如果不存在,请检查这里:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_XE\ORACLE_HOME
Also make sure this other key isn't pointing to your old client registry key:
还要确保这个其他键没有指向您的旧客户端注册表键:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_XE\ORACLE_HOME_KEY
or
或者
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_XE\ORACLE_HOME_KEY
- Check if the system variable ORACLE_HOME is set to
C:\oraclexe\app\oracle\product\11.2.0\server
(or similar).
- 检查系统变量 ORACLE_HOME 是否设置为
C:\oraclexe\app\oracle\product\11.2.0\server
(或类似)。
回答by Aady
this might be caused because you changed your PC-NAME. Make sure in "listener.ora" file HOST = PC-NAME (eg: admin-PC).
这可能是因为您更改了 PC-NAME。确保在“listener.ora”文件中 HOST = PC-NAME(例如:admin-PC)。