windows2008安装oracle19c后监听无法启动

最新推荐文章于 2024-07-08 10:07:04 发布

好记忆不如烂笔头abc

最新推荐文章于 2024-07-08 10:07:04 发布

阅读量4.9k

点赞数 1

分类专栏： oracle19c windows

本文链接：https://blog.csdn.net/jycjyc/article/details/111169202

版权

oracle19c 同时被 2 个专栏收录

171 篇文章 6 订阅

订阅专栏

windows

39 篇文章 2 订阅

订阅专栏

window7和windows2008不支持oracle19c

原先在主机上安装了oracle10.2.0.5然后再安装oracle19c，注册表中能清理的都已经清理，能修改都已经修改，很是奇怪，还以为是冲突，折腾了半天，发现是oracle19c的监听在windows2008上根本不支持。

但依然报错如下：

D:\oracle19c\diag\tnslsnr\WIN-4GQNG01G4AR\listener\trace

以 pid=3164 开始
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-4GQNG01G4AR)(PORT=1521)))
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12557: TNS: 协议适配器不可加载
TNS-12560: TNS: 协议适配器错误
TNS-00527: 协议适配器不可加载

不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-4GQNG01G4AR)(PORT=1521)))

https://blog.csdn.net/lhshu2008/article/details/17529883

处理过程中遇到的其它问题：

C:\Users\Administrator>netca

Oracle Net Services 配置:

配置监听程序：LISTENER

ServiceAliasException: 无法保存服务别名: TNS-04406: 对象已经存在

默认本地命名配置完成。

监听程序配置完成。

成功完成 Oracle Net Services 配置。退出代码是0

解决办法：设定TNS_ADMIN的环境变量。

Oracle Net Services - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.

SYMPTOMS

Attempting to use Net CA or Net Configuration Assistant to create or edit an existing configuration. Upon pressing the finish button, the following error is thrown: ServiceAliasException: Could not save Service Alias: TNS-04415: File I/O error.

CHANGES

It is likely that the $TNS_ADMIN variable was changed recently or the directory to which it pointed has been removed or made inaccessible. It is likely that the Net Manager (Netmgr) tool will successfully create or edit a tnsnames.ora file in this same environment despite the NetCA failure.

CAUSE

The $TNS_ADMIN environment variable pointed to a directory that did not exist. This caused the file I/O error. A check of the $TNS_ADMIN variable: echo $TNS_ADMIN or on Windows: echo %TNS_ADMIN%. If this failure is present, you would see TNS_ADMIN pointing to a non-existent directory location..

SOLUTION

Set the $TNS_ADMIN environment variable to point to the $ORACLE_HOME/network/admin directory or any other existing directory where NetCA can write a file.

Oracle Net Services - Version 8.1.7.0 to 11.2.0.3 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 23-AUG-2013***

SYMPTOMS

Listener start fails with the following errors:

On Solaris:

LSNRCTL> start LISTDPRNRJ
    Starting /oracle10g/product/10.2.0/bin/tnslsnr: please wait...

    TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
    System parameter file is /oracle10g/product/10.2.0/network/admin/listener.ora
    Log messages written to /oracle10g/product/10.2.0/network/log/listdprnrj.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX.X.XXX.XX)(PORT=1523)))
    Error listening on: (ADDRESS=(PROTOCOL=tcp)(IP=LOOPBACK))
    TNS-01191: Failed to initialize the local OS authentication subsystem
     TNS-12545: Connect failed because target host or object does not exist
      TNS-12560: TNS:protocol adapter error
       TNS-00515: Connect failed because target host or object does not exist
        Solaris Error: 126: Cannot assign requested address

On Linux :
----------

[oracle@testnet shashi]$ lsnrctl start listener_105

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 12-AUG-2009 05:44:37

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /home/oracle/oracle/product/10.2.0.4/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /home/oracle/users/shashi/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0.4/db_1/network/log/listener_105.log
Trace information written to /tmp/list_105g.trc
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname.com)(PORT=1523)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(PORT=1523)))
TNS-12532: TNS:invalid argument
TNS-12560: TNS:protocol adapter error
  TNS-00502: Invalid argument
   Linux Error: 22: Invalid argument

The listener trace shows the following :

[12-AUG-2009 05:44:38:309] nttbnd2addr: using host IP address: 127.0.0.1
[12-AUG-2009 05:44:38:309] snlinFreeAddrInfo: entry
[12-AUG-2009 05:44:38:309] snlinFreeAddrInfo: exit
[12-AUG-2009 05:44:38:309] nttbnd2addr: exit
[12-AUG-2009 05:44:38:309] nttcon: entry
[12-AUG-2009 05:44:38:309] nttcon: toc = 2
[12-AUG-2009 05:44:38:309] nttcnp: entry
[12-AUG-2009 05:44:38:309] nttcnp: creating a socket.
[12-AUG-2009 05:44:38:309] nttcnp: binding an address to a socket.
[12-AUG-2009 05:44:38:309] ntt2err: entry
[12-AUG-2009 05:44:38:309] ntt2err: soc 12 error - operation=1, ntresnt[0]=515, ntresnt[1]=99, ntresnt[2]=0

PS: The ntresnt[1]=126 on Solaris. On linux ntresnt[1]=99

Though the netstat output shows the listener is listening ,

[oracle@testnet ~]$ netstat -an | grep 1523
tcp 0 0 0.0.0.0:1523 0.0.0.0:* LISTEN

Local connections and remote connections to the database fail with ORA-12157 as shown below:

Local connection:
----------------

Local connection:
----------------
[oracle@testnet ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 12 06:25:11 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-12157: TNS:internal network communication error

Remote Connection:
-------------------

[oracle@testnet shashi]$ sqlplus scott/tiger@testnet

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 12 06:30:56 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

ERROR:
ORA-12157: TNS:internal network communication error

CAUSE

The errors are caused by the operating system loopback interface not being started

On Solaris you may see the loopback interface not listed as shown below :

$ ifconfig -a
    lo0:1: flags=1000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4> mtu 8232 index 1
            inet 10.1.0.19 netmask ff000000
    ce0:1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 2
            inet 192.168.0.7 netmask ffffff00 broadcast 192.168.0.255
    ce1:1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 3
            inet 192.168.3.7 netmask ffffff00 broadcast 192.168.3.255

Please note that the loopback interface 'lo0' is not listed in the above ouput . The interface 'lo0:1' is the zone interface which had been plumbed .

On linux operating system , you may see the below output if the loopback interface is down :

#ifconfig -a
lo        Link encap:Local Loopback
          LOOPBACK  MTU:16436  Metric:1
          RX packets:2339794 errors:0 dropped:0 overruns:0 frame:0
          TX packets:2339794 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:159193174 (151.8 MiB)  TX bytes:159193174 (151.8 MiB)

SOLUTION

Involve your system / network administrator and get the loopback interface up and running and restart the listener.

1] Make sure you have the loopback IP address mapped to the localhost as below :

$ cat /etc/hosts
127.0.0.1 localhost
.......
.........

2] On Solaris:
-----------
#ifconfig lo0 up (this brings up the loopback interface)

Once the loopback interface is up , the ifconfig output should show as below :

For example :
------------

[celcsol3]/bin> /sbin/ifconfig -a

lo0: flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> mtu 8232 index 1
inet 127.0.0.1 netmask ff000000

3] On Linux :
----------

#ifup lo (this brings up the loopback interface)

For Example :
--------------

[root@testnet ~]#ifconfig -a

lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:2413323 errors:0 dropped:0 overruns:0 frame:0
          TX packets:2413323 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:165596646 (157.9 MiB)  TX bytes:165596646 (157.9 MiB)