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

Thread: how force password?

  1. 06-18-2004, 02:06 AM #1
    rommel
    rommel is offline Member
    Join Date
    Jan 2002
    Posts
    146

    how force password?

    Hi Friends,

    I've installed Oracle 9i on windows 2000 server (development).
    Unfornately i forgot the SYS and SYSTEM password ( I know I didnt changed them from its default change_on_install and manager).
    How do i force connecting to the internal user?

    In unix...as long as u login to the Oracle owner unix id, you
    can issue the command "sqlplus internal" without asking a password.
    How to do this in windows pls..


    Thank you all
    Reply With Quote Reply With Quote
  2. 06-18-2004, 02:21 AM #2
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: how force password?

    Is SQLNET.AUTHENTICATION_SERVICES = (NTS) in sqlnet.ora?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  3. 06-18-2004, 02:27 AM #3
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Connect to the internal in 9i? No go, neither on unix nor windows.....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  4. 06-18-2004, 03:26 AM #4
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Set SQLNET.AUTHENTICATION_SERVICES = (NTS) in sqlnet.ora and try sqlplus "/ as sysdba"
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  5. 06-18-2004, 05:05 AM #5
    rommel
    rommel is offline Member
    Join Date
    Jan 2002
    Posts
    146
    yes...in worked thanks a lot
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width