This discussion is archived
5 Replies Latest reply: Apr 2, 2013 5:49 AM by HamidHelal RSS

ora-12545, Oracle XE, Form 6i

690743 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points