Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2011
    Posts
    8

    Unanswered: problem about using Oracle Form 6i to connect Oracle Database 10g express.

    Sorry to interrupt all of you.

    I have encountered a problem about using Oracle Form 6i to connect Oracle Database 10g express.

    As I would like to

    I use Oracle Net8 Easy Config to create a connection.

    According to "tnsnames.ora", the paramater of connection is as follows;

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA = (SID = XE))
    )

    Unfortunately, when I use Oracle Net8 Easy Config to test the connection, an error message is prompted as follows:

    Connecting....

    The test did not succeed.
    ORA-03106: fatal two-task communication protocol error

    There may be an error in the fields entered
    or the server may not be ready for a connection.
    You can check the server and retry, or continue.

    After I google it, I still have no idea how to solve the problem. I would like to ask, could anyone mind providing some hints or solution to address the issues.

    Thanks for your assistance in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have encountered a problem about using Oracle Form 6i to connect Oracle Database 10g express.
    Is Forms installed on the same system which is the DB Server system?

    issue following OS commands from DB server system

    lsnrctl status
    lsnrctl service

    COPY commands & results, then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2011
    Posts
    8

    lsnrctl status

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-OCT-2011 04:46
    :13

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_F OR_XE)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
    ction
    Start Date 08-OCT-2011 21:34:37
    Uptime 0 days 7 hr. 11 min. 36 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\netwo rk\a
    dmin\listener.ora
    Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\netwo rk\l
    og\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC_FOR_XEipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vm)(PORT =1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vm)(PORT =8080))(Presentation=HTTP)(S
    ession=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

  4. #4
    Join Date
    Oct 2011
    Posts
    8

    lsnrctl service

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-OCT-2011 04:49
    :07

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_F OR_XE)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "XEXDB" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:6 refused:0 current:0 max:1002 state:ready
    DISPATCHER <machine: VM, pid: 2976>
    (ADDRESS=(PROTOCOL=tcp)(HOST=vm)(PORT=1032))
    Service "XE_XPT" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:11 refused:0 state:ready
    LOCAL SERVER
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:11 refused:0 state:ready
    LOCAL SERVER
    The command completed successfully

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Why did you not answer the following question?
    Is Forms installed on the same system which is the DB Server system?

    does any type of Operating System Virtualization exist on this system?

    >XE =
    >(DESCRIPTION =
    >(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    >(CONNECT_DATA = (SID = XE))
    >)
    above will fail when DB Server identifies itself as HOST=vm, so correct HOST= above

    issue following OS commands

    ping vm
    tnsping xe

    COPY commands & results then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Oct 2011
    Posts
    8
    Sorry for reply you late.

    Both of Oracle Form 6i and Oracle Database 10g Express are installed on the same system, i.e. Windows XP.

    And Windows XP is installed Oracle VM Virtual Box.

    >>>above will fail when DB Server identifies itself as HOST=vm, so correct HOST= above

    DO you mean that I need to correct the host as 127.0.0.1?

    If yes, I need to modify which part as I am not sure how to correct the host in Oracle database.

    Anyway, thanks for your kindly help.

  7. #7
    Join Date
    Oct 2011
    Posts
    8

    ping vm

    Pinging vm [10.0.2.15] with 32 bytes of data:

    Reply from 10.0.2.15: bytes=32 time<1ms TTL=128
    Reply from 10.0.2.15: bytes=32 time<1ms TTL=128
    Reply from 10.0.2.15: bytes=32 time<1ms TTL=128
    Reply from 10.0.2.15: bytes=32 time<1ms TTL=128

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

  8. #8
    Join Date
    Oct 2011
    Posts
    8

    tnsping xe

    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vm)(PORT
    = 1521)) (CONNECT_DATA = (SERVICE_NAME = XE)))
    OK (40 msec)

  9. #9
    Join Date
    Oct 2011
    Posts
    8
    Now, I have updated the host information in file "C:\oraclexe\app\oracle\product\10.2.0\server\NETW ORK\ADMIN\listener.ora"

    the data is:

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    )

    Also, I have updated the host info. in "C:\oraclexe\app\oracle\product\10.2.0\server\NETW ORK\ADMIN\tnsnames.ora"


    the info is:

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
    (SERVICE_NAME = XE)
    )
    )

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Situation Normal, All Fouled Up!
    when you "ping vm" it shows "Pinging vm [10.0.2.15] with 32 bytes of data:"
    when you tnsping XE it shows "Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vm)"
    where HOST=vm means 10.0.2.15!
    which means that 127.0.0.1 is ignored by both OS (ping) & tnsping
    why do you insist on using 127.0.0.1 when it throws errors & does not work?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •