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

Thread: ORA-01004: default username feature not supported.

  1. #1
    Join Date
    Nov 2001
    Posts
    42

    Question ORA-01004: default username feature not supported.

    Hello everybody,

    Getting error ORA-01004 in personal oracle on win98 and WIN NT.
    I have created user xyz for os authentication.

    Eg: CREATE USER xyz IDENTIFIED EXTERNALLY;

    I changed the param in init ora file OS_AUTHENT_PREFIX = ""

    Now when i am trying to connect sqlplus /

    Same things is working on Unix & linux database..but in nt and win98
    it is not.....Please help...pls don't laugh i am certified oracle dba
    and last time when i tried this for admin paper...i tried on linux...

    somebody sug me to change in sqlnet.ora ...but still prb...is same...

    Thanks in Advance..

    SM
    oracle 8i Certified DBA

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Well, what suggestion was made to you regarding sqlnet.ora? If it was "Set SQLNET.AUTHENTICATION_SERVICES=(NTS) in the "sqlnet.ora" on the client and server" then it was the right suggestion.

    And how is this related to certification?

    And if you are certified, you would know the product name is Oracle8i, not "oracle 8i."

  3. #3
    Join Date
    Nov 2001
    Posts
    42

    Thanks

    Thanks u very much stecal for u r reply.I tried same thing but still it is not working....

    Regarding certification relation, Same things is there in admin paper.But i tried on Linux that time and it was working fine ,it is still working...properly with same setting. But in NT & WIN98 it is giving the problem.

    Anyway i think u had fight with anybody in office thats why even small things like oracle 8i ...u r pointing...never mind...

    Once again thanks for u r reply...

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Whatever. Now that you know it is not "oracle 8i," why are you still using it?

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