DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-03121

  1. #1
    Join Date
    Apr 2001
    Posts
    55

    Exclamation

    I recieve the following error when try to connect to a database from my machine:-

    Error while trying to retreive text for error ORA-03121
    Then if you go into detail:-
    Building Oracle HOMES List
    HOME Name DEFAULT_HOME added to list.
    Found multiple homes, searching each HOMEx for valid PATH
    searching in SOFTWARE\ORACLE\HOME0
    Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!
    Using: C:\WINNT\system32\orant71.dll

    This only happens with certain application connecting to the database some applications are perfectly ok

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    did you check the tnsnames.ora file on the server where the applications are trying to connect from?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Apr 2001
    Posts
    55
    yes it seems to be fine as other machines can connect to the server. I'm the only machine that can't

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    can you connect through the sqlplus, go to the dos prompt and type sqlplus.

    sqlplus user_name@tnsname_alias

    Could you confirm this?



    Here is a NOTE from metalink:

    Problem Description:
    ====================

    Getting an ORA-03121 trying to connect on Windows NT.




    Keywords: 32,winnt

    Solution: CONFIRM THAT SQL*NET IS INSTALLED ON THE WINDOWS NT MACHINE


    Solution Description:
    =====================

    Check to see that SQL*Net is installed on the Windows NT machine. Look for
    the SQL*Net product in the orant\orainst\nt.rgs file.

    If SQL*Net is not present, it must be installed at this point.

    If SQLDBA can connect but 16-bit Windows based applications (SQLPlus,
    SQLForms, Reports, Oracle PING, NetTest, etc.) installed on a Windows NT
    machine are returning an ORA-03121 error, then verify that SQL*Net for Windows
    is installed on the NT machine as well.

    You can also get the ORA-03121 error using an incorrect connect string. The
    correct syntax for connecting to SQl*Net Version 1 for these protocols
    are:

    TCP/IP t:hostname
    Namedpipes p:service:

    If you are trying to connect on NT using a Windows Based Application on NT
    review the ORA-3121 bulletin for Windows.






    Solution Explanation:
    =====================

    Windows NT and OS/2 have the ability to emulate Windows.

    In the case of OS/2, this emulation is referred to as a WIN/OS2
    session. SQL*VDM, a product developed for OS/2, will enable 16-bit
    Windows based products to connect from a Win/OS2 session to the
    regular OS/2 session.

    On Windows NT, this product is called Windows-ON-Windows or WOW.
    Unfortunately, there is not a product such as SQL*VDM for Windows NT.
    In order to connect from Windows-On-Windows (16-bit), you must have
    SQL*Net for Windows (16-bit) installed under the orawin default
    directory for Windows on the NT machine.

    SQL*Net for NT is a 32-bit SQL*Net product. It can only be used by 32-bit
    applications such as, sqldba71.exe.


    Sam

    [Edited by sambavan on 09-10-2001 at 12:27 PM]
    Thanx
    Sam



    Life is a journey, not a destination!


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