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

Thread: OS Authentication ( urgent )

  1. #1
    Join Date
    May 2001
    Location
    India
    Posts
    55

    Arrow

    Hi,

    Problem I'm facing due to OS authentication

    I have installed Oracle 8.1.6 on Sun solaris ( OS 2.8 ) in the
    following ORACLE_HOME

    /oracle/app/oracle/product/8.1.6

    I have installed Forms 6.0.8 ( Developer 6i ) in the following
    ORACLE_HOME

    /oracle/app/oracle/product/8.1.6/d2k


    The init.ora file has the following settings made for
    OS authentication

    remote_login_passwordfile = none
    os_authent_prefix = ops$

    2 oracle users are ops$hcsdevp and ops$hms

    corresponding unix users are 'hcsdevp' and 'hms'

    hms user profile has ORACLE_HOME variable set to
    /oracle/app/oracle/product/8.1.6

    hcsdevp user profile has ORACLE_HOME variable set to
    /oracle/app/oracle/product/8.1.6/d2k

    I can connect to database thr' hms user using OS
    authentication
    $sqlplus /
    gets connected
    sql>


    But when I connect to hcsdevp user using OS authentication
    I get the following error
    $sqlplus /
    I get the following error message :

    ORA-01004 - default username feature not supported; logon
    denied.


    But I can connet using any normal oracle users like
    system/manager or scott tiger .



    Pl. mail me the solution urgently

    Thanks

    my email is shankar_gk@hotmail.com, kgshangs@yahoo.com


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    When the environment is setup with the 8.1.6 HOME, you can connect without specifying an alias. When you set the $OH to the 8.0.6 client (forms), you must specify an alias from your tnsnames.ora file.

    For example:
    sqlplus /@yourdbname

    You can check that you have set the user up correctly by setting hcsdevp 's environment to the 8.1.6 $OH and connecting:
    sqlplus /

    If this works, this means you have set the user up correctly.
    Jeff Hunter

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