无法在 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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-09 09:45:51  来源:igfitidea点击:

not able to starting OracleXNTNSListener in windows environment

windowsoracle

提问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.1to localhostin both listener.oraand tnsnames.orahelped me.

我知道它是一个非常古老的线程,但是,更改127.0.0.1localhost两者listener.oratnsnames.ora帮助了我。

回答by srlgrg

My listener.orafile 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)。