5 Replies Latest reply: Apr 2, 2013 7:49 AM by HamidHelal RSS

    ora-12545, Oracle XE, Form 6i

    690743
      Hello friends

      i am using Oracle 10g XE with Forms 6i on WIN 7 ...
      For the past more than a year my application was running quite smootlhly, now i am facing an issue with the listener connection.
      my clients are not communicatin for the reason unknown to me. i have checked the node addresses and my application folder sharing is OK.
      i even tried changing the Names by giving IP addresses...

      kindly help me by taking some time going thru my config files and somebody please suggest me...

      C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\log

      LISTENER.LOG
      ============
      TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-FEB-2012 16:23:16

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

      System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
      Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
      Trace information written to C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
      Trace level is currently 0

      Started with pid=2832
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Rehan-PC.dcs.local)(PORT=1521)))
      Listener completed notification to CRS on start

      TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
      13-FEB-2012 16:23:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=ADMINISTRATOR))(COMMAND=status)(ARGUMENTS=64)

      (SERVICE=LISTENER)(VERSION=169869568)) * status * 0
      No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
      No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Rehan-PC.dcs.local)(PORT=1521)))
      Listener completed notification to CRS on stop
      13-FEB-2012 16:23:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=ADMINISTRATOR))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)

      (VERSION=169869568)) * stop * 0

      SQLNET.LOG
      ==========


      ***********************************************************************
      Fatal NI connect error 12170.

      VERSION INFORMATION:
           TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
           Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
           Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
      Time: 21-MAR-2012 15:35:52
      Tracing not turned on.
      Tns error struct:
      ns main err code: 12535
      TNS-12535: TNS:operation timed out
      ns secondary err code: 12606
      nt main err code: 0
      nt secondary err code: 0
      nt OS err code: 0
      Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.51)(PORT=52220))

      C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN

      LISTENER.ORA
      ============
      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = extproc)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = Rehan-PC.dcs.local)(PORT = 1521))
      )
      )

      DEFAULT_SERVICE_LISTENER = (XE)

      SQLNET.ORA
      ==========
      # This file is actually generated by netca. But if customers choose to
      # install "Software Only", this file wont exist and without the native
      # authentication, they will not be able to connect to the database on NT.

      SQLNET.AUTHENTICATION_SERVICES = (NTS)

      TNSNAMES.ORA
      =============
      XE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Rehan-PC.dcs.local)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )

      C:\orant\NET80\ADMIN
      TNSNAMES.ORA
      ============
      XE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Rehan-PC.dcs.local)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
      )
      )
      Beq-local.world =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS =
      (COMMUNITY = beq.world)
      (PROTOCOL = BEQ)
      (PROGRAM = oracle73)
      (ARGV0 = oracle73ORCL)
      (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
      )
      )
      (CONNECT_DATA = (SID = ORCL)
      )
      )
      Tcp-loopback.world =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS =
      (COMMUNITY = tcp.world)
      (PROTOCOL = TCP)
      (Host = 127.0.0.1)
      (Port = 1521)
      )
      )
      (CONNECT_DATA = (SID = ORCL)
      )
      )
      Example1.world =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS =
      (COMMUNITY = tcp.world)
      (PROTOCOL = TCP)
      (Host = Production1)
      (Port = 1521)
      )
      )
      (CONNECT_DATA = (SID = SID1)
      )
      )
      Example2.world =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS =
      (COMMUNITY = spx.world)
      (PROTOCOL = SPX)
      (Service = Server_lsnr)
      )
      )
      (CONNECT_DATA = (SID = ORCL)
      )
      )
      Example3.world =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS =
      (COMMUNITY = nmp.world)
      (PROTOCOL = NMP)
      (Server = FinanceServer1)
      (Pipe = ORAPIPE)
      )
      )
      (CONNECT_DATA = (SID = ORCL)
      )
      )
      Rep60_REHAN-PC,Rep60_Rehan-PC.world=(ADDRESS=(PROTOCOL=tcp)(HOST=Rehan-PC.dcs.local)(PORT=1949))


      Ping of client, my own PC and LISTENER STATUS @ command prompt
      ===================================================
      Microsoft Windows [Version 6.1.7601]
      Copyright (c) 2009 Microsoft Corporation. All rights reserved.

      Microsoft Windows [Version 6.1.7601]
      Copyright (c) 2009 Microsoft Corporation. All rights reserved.

      DB Owner PC
      ===========
      C:\Users\rehan.DCS>ping 192.168.1.5

      Pinging 192.168.1.5 with 32 bytes of data:
      Reply from 192.168.1.5: bytes=32 time<1ms TTL=128
      Reply from 192.168.1.5: bytes=32 time<1ms TTL=128
      Reply from 192.168.1.5: bytes=32 time<1ms TTL=128
      Reply from 192.168.1.5: bytes=32 time<1ms TTL=128

      Ping statistics for 192.168.1.5:
      Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
      Approximate round trip times in milli-seconds:
      Minimum = 0ms, Maximum = 0ms, Average = 0ms

      client PC
      =========
      C:\Users\rehan.DCS>ping 192.168.1.51

      Pinging 192.168.1.51 with 32 bytes of data:
      Reply from 192.168.1.51: bytes=32 time<1ms TTL=128
      Reply from 192.168.1.51: bytes=32 time<1ms TTL=128
      Reply from 192.168.1.51: bytes=32 time<1ms TTL=128
      Reply from 192.168.1.51: bytes=32 time<1ms TTL=128

      Ping statistics for 192.168.1.51:
      Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
      Approximate round trip times in milli-seconds:
      Minimum = 0ms, Maximum = 0ms, Average = 0ms

      C:\Users\rehan.DCS>lsnrctl status

      LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-APR-2013 08:36
      :26

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
      ction
      Start Date 31-MAR-2013 16:38:01
      Uptime 1 days 15 hr. 58 min. 25 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Default Service XE
      Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
      dmin\listener.ora
      Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
      og\listener.log
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Rehan-PC.dcs.local)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=
      HTTP)(Session=RAW))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "XEXDB" has 1 instance(s).
      Instance "xe", status READY, has 1 handler(s) for this service...
      Service "XE_XPT" has 1 instance(s).
      Instance "xe", status READY, has 1 handler(s) for this service...
      Service "xe" has 1 instance(s).
      Instance "xe", status READY, has 1 handler(s) for this service...
      The command completed successfully

      C:\Users\rehan.DCS>

      Windows COmponent SERvices
      ==========================
      please refer to the attached i
        • 1. Re: ora-12545, Oracle XE, Form 6i
          HamidHelal
          Hi,
          First of all, in most case if you have Antivirus* installed at server, it enabled windows firewall and client didn't get connect. Try to disable firewall and try.

          next >>
          issue the following command from your client CMD and post the result
          tnsping XE
          Hope this helps


          Hamid


          Mark correct/helpful to help others to get right answer(s).*
          • 2. Re: ora-12545, Oracle XE, Form 6i
            690743
            thanks hamid...

            as suggested at client CMD, tnsping XE does nothing...
            result
            C:\Users\ikhtiar>tnsping XE
            'tnsping' is not recognized as an internal or external command,
            operable program or batch file.
            my pc tnsping XE
            C:\Users\rehan.DCS>tnsping XE
            
            TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-APR-2
            013 14:57:29
            
            Copyright (c) 1997, 2005, Oracle.  All rights reserved.
            
            Used parameter files:
            C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora
            
            Used TNSNAMES adapter to resolve the alias
            Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Rehan-PC
            .dcs.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
            OK (150 msec)
            our Default Gateway is the same 192.168.1.1 and
            our IPv4 Address 192.168.1.51 (my pc), whereas clients is 192.168.1.53
            Clients TNSNAMES.ORA
            XE =
              (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = REHAN-PC.dcs.local)(PORT = 1521))
                (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = XE)
                )
              )
            
            Beq-local.world =
              (DESCRIPTION = 
                (ADDRESS_LIST = 
                    (ADDRESS = 
                      (COMMUNITY = beq.world)
                      (PROTOCOL = BEQ)
                      (PROGRAM = oracle73)
                      (ARGV0 = oracle73ORCL)
                      (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
                    )
                )
                (CONNECT_DATA = (SID = ORCL)
                )
              )
            Tcp-loopback.world = 
              (DESCRIPTION = 
                (ADDRESS_LIST = 
                    (ADDRESS = 
                      (COMMUNITY = tcp.world)
                      (PROTOCOL = TCP)
                      (Host = 127.0.0.1)
                      (Port = 1521)
                    )
                )
                (CONNECT_DATA = (SID = ORCL)
                )
              )
            Example1.world = 
              (DESCRIPTION = 
                (ADDRESS_LIST = 
                    (ADDRESS = 
                      (COMMUNITY = tcp.world)
                      (PROTOCOL = TCP)
                      (Host = Production1)
                      (Port = 1521)
                    )
                )
                (CONNECT_DATA = (SID = SID1)
                )
              )
            Example2.world = 
              (DESCRIPTION = 
                (ADDRESS_LIST = 
                    (ADDRESS = 
                      (COMMUNITY = spx.world)
                      (PROTOCOL = SPX)
                      (Service = Server_lsnr)
                    )
                )
                (CONNECT_DATA = (SID = ORCL)
                )
              )
            Example3.world = 
              (DESCRIPTION = 
                (ADDRESS_LIST = 
                    (ADDRESS = 
                      (COMMUNITY = nmp.world)
                      (PROTOCOL = NMP)
                      (Server = FinanceServer1)
                      (Pipe = ORAPIPE)
                    )
                )
                (CONNECT_DATA = (SID = ORCL)
                )
              )
            Note:*
            1) recently we installed CCTV in our office and the technician gave an IP (http://192.168.1.38/ie.html) address to watch the videos through IE,
            for that purpose, they may have done some config re-settings, including firewalls etc. and it is only since that point-on, my clients are not getting connected.
            2) the oracle 10g XE DB and Forms are installed on my PC and NOT the server.
            3) theres is an application developed using MYSQL on my clients PC, which i can use it very well but my oracle application, my clients is not able to use in the currently situation.

            Services and Firewall on my PC*
            http://www.flickr.com/photos/41671539@N05/8612222135/
            http://www.flickr.com/photos/41671539@N05/8612222345/

            Please suggest, i dont have much hand on DBA admin side but i can use the codes suggested in order to trouble shoot..

            Edited by: enlighten on 02-Apr-2013 03:58

            Edited by: enlighten on 02-Apr-2013 04:31

            Edited by: enlighten on 02-Apr-2013 04:36
            • 3. Re: ora-12545, Oracle XE, Form 6i
              HamidHelal
              enlighten wrote:
              thanks hamid...
              Note:*
              1) recently we installed CCTV in our office and the technician gave an IP (http://192.168.1.38/ie.html) address to watch the videos through IE,
              for that purpose, they may have done some config re-settings, including firewalls etc. and it is only since that point-on, my clients are not getting connected.
              2) the oracle 10g XE DB and Forms are installed on my PC and NOT the server.
              3) theres is an application developed using MYSQL on my clients PC, which i can use it very well but my oracle application, my clients is not able to use in the currently situation.

              Services and Firewall on my PC*
              http://www.flickr.com/photos/41671539@N05/8612222135/
              http://www.flickr.com/photos/41671539@N05/8612222345/

              Please suggest, i dont have much hand on DBA admin side but i can use the codes suggested in order to trouble shoot..
              Good to see the image, and it's clearly shows that your firewall in on. For temporary (to test) Turn off the all profile Firewall and try to connect.

              Let me inform the status.

              Hope this helps


              Hamid

              Mark correct/helpful to help others to get right answer(s).*
              • 4. Re: ora-12545, Oracle XE, Form 6i
                690743
                still getting ora-12545 on clients PC...after turning-off all firewalls on my PC..

                can i request you to connect thru Teamviewer to my pc and trouble shoot...???
                if yes then please give me your email i'll send you Teamviewer ID and pwd....

                thanks
                • 5. Re: ora-12545, Oracle XE, Form 6i
                  HamidHelal
                  enlighten wrote:
                  still getting ora-12545 on clients PC...after turning-off all firewalls on my PC..

                  can i request you to connect thru Teamviewer to my pc and trouble shoot...???
                  if yes then please give me your email i'll send you Teamviewer ID and pwd....

                  thanks
                  visit my profile to get mail address..

                  Hamid