2 tnsnames.ora to choose from
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: 2 tnsnames.ora to choose from

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    2 tnsnames.ora to choose from

    Hi Friends,

    Our (Visual Basic) appds developer is using OLEDB/ODBC to connect
    to our Oracle 8i database which resides on RS6000 AIX . He uses the
    Win2K server as the middle tier for his MTS. On the middle tier server
    we have also a 10g DB and 10g client installed on different home.
    Thay have their respective net manager and tnsnames.ora.
    My question is how can i direct hist VB programs ODBC to use the
    connect id of the tnsnames.ora of the 10gDB and not the tnsnames.ora
    10g client.

    Thanks a lot

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    1. Set the oracle_home to that of the DB
    2. make both files the same
    3. uninstall the client as you dont need it
    4. set TNS_ADMIN

  3. #3
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thanks dear, but this VB programmer is troubling me about his
    program error using a OLE DB. He said his program works fine in
    8i client, but when we used 9i client he got error related to
    distributed trasaction coordinator. The work around he got on 9i
    client is to install the MSVCRTD.DLL as what oracle forum suggested:
    Heres the qoute for one forum related to the problem:

    quote********************************************************quote

    Hi,
    Can anyone help me to solve this problem?
    When we set the TRANSACTION attribute to REQUIRED
    TRANSACTION for our components. We hit the
    following error.

    Error: -2147168246
    Error Description: "New transaction cannot enlist in the
    specified transaction coordinator. "

    Our scenario:
    Our components are set to "REQUIRES TRANSACTION".

    Here is our current configuration :

    Machine 1: (Hosts our COM+ components)
    (a)Oracle Net Client 9.2.0.1.0
    (b)Oracle Services per Microsoft Transaction Server
    (c)Oracle OLEDB Providers 9.2.0.2.0
    (OraOLEDB.Oracle)
    (d)Windows 2000 COM+ Services
    (e)COM Components deployed under MTS that use ADO to talk
    to the Oracle
    (f)OS: Windows 2000 Professional

    Machine 2: (Hosts Oracle 9i Server 9.2.0.1.0)
    (a) Oracle 9i Server 9.2.0.1.0
    (b) Windows 2000 Advanced Server

    The Oracle MTS Recovery Service is started successfully.

    Whenever we choose our components to enlist in a
    transaction by choosing
    the MTS 'Requires a transaction' attribute, we get back
    the following
    error
    from the provider :

    Error: -2147168246
    Error Description: "New transaction cannot enlist in the
    specified
    transaction coordinator. "

    With the Microsoft OleDB Provider MSDAORA we get back no error.
    The test program msdtcora.Exe works with success.


    Any help will be appreciated.
    thanks,
    Domenico

    Anser for Oracle ======================================

    The ORAMTS component that originally shipped with Oracle 9i Release 2 was a debug version of the actual ORAMTS.DLL component.
    The incorrect component has a dependency on msvcrtd.dll (a debugging component included in Microsoft Visual C++) and will not
    function correctly on any machine that does not have msvcrtd.dll installed.

    The problem can be resolved via one of the following solutions:

    Obtain and install Oracle 9i Patch 2428356
    (HIGHLY Recommended Solution)

    Oracle is aware of this problem and is providing a patch that contains the correct version of ORAMTS.DLL. Customers with a valid
    Oracle support contract may obtain this patch directly from Oracle.

    Install msvcrtd.dll on the Oracle server
    (Alternative Solution)

    In the event that the Oracle patch cannot be obtained, the server may be patched with msvcrtd.dll. This solution has not been
    extensively tested and may cause instability or loss of performance.

    Note: The Microsoft development EULA forbids the redistribution of the msvcrtd.dll component! Production servers MUST be patched
    with the official Oracle patch!
    =====================================

    Quote
    " Obtain and install Oracle 9i Patch 2428356"

    Iive searched for this patch# in the metalink but to no avail.
    Is this a patch fot the database of for the client?
    What should i do in the 10g connections?

    Thanks a lot
    Did u encounter anything similar to this?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    I just found that patch quite easily - didnt look hard enough I guess - or in the right place

  5. #5
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi dear,

    I login to metalink,
    then click patch & updates,
    then click simple seach,
    -(search by) patch no,
    -entered the patch no 2428356
    -(platform or language) MS Wimdows (32-bit) Client
    then go,
    no patches found

    Where did i go wrong?

    Thanks a lot

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Log onto metalink
    Click Patches and Updates
    Click Simple Search
    Enter 2428356 into the wee little text box
    Select Micrsoft Windows (32 Bit) from the platform bit.
    Click on the little go button
    gee whizz I have a match!

  7. #7
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Ooh dear...But thats what i exactly did?
    Maybe the site likes u better than me?
    Or does it concern our maintenance. It will
    lapsed this coming May.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    try reading a bit harder - you chose client. It isn't a client patch
    Last edited by davey23uk; 04-06-2005 at 06:25 AM.

  9. #9
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Originally posted by davey23uk
    Log onto metalink
    Click Patches and Updates
    Click Simple Search
    Enter 2428356 into the wee little text box
    Select Micrsoft Windows (32 Bit) from the platform bit.
    Click on the little go button
    gee whizz I have a match!
    waaa...
    u r confusing me again, theres no option to choose from there about
    database only platform or language, and thats what u said also

    makauwi na nga, gabi na eh

  10. #10
    Join Date
    Oct 2002
    Posts
    807
    Originally posted by kris123
    makauwi na nga, gabi na eh
    ??

Posting Permissions

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



Click Here to Expand Forum to Full Width