Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Location
    Ireland, UK & Europe
    Posts
    2

    Unanswered: ORA-01017 : invalid username/password; logon denied

    Hi There,

    I want to be able to start sqlplus by typing 'sqlplus /' at the command line.

    Here's what I've done so far:

    I'm on 9i (9.2 on HPUX) & have set the following values in my initSID.ora:

    remote_login_passwordfile=NONE (have also tried EXCLUSIVE)
    remote_os_authent=TRUE
    os_authent_prefix=""(have also tried OPS$)

    & then have bounced the instance & verified that the values have taken effect by selecting from v$parameter.

    I start sqlplus & 'create user extern identified externally;' & grant the user the dba role.

    However, when I type 'sqlplus /' I get the following error: 'ORA-01017 : invalid username/password; login denied.

    Has anybody got any ideas? What am I missing out on here?

    Thanks for your help.

    Lorcan.

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Have you tried
    sqlplus
    and then typing / as sysdba at the username prompt?

  3. #3
    Join Date
    Oct 2002
    Location
    Ireland, UK & Europe
    Posts
    2

    Unhappy

    Unfortunately I must use 'sqlplus /'. Certainly being able to use

    sqlplus
    username: as sysdba

    would be great, but the brief is to be able to connect as sqlplus /

    Does anybody know if this is a known Oracle 9.2 bug? I've trawled Oracle's OTN & have found nothing on this problem. My users are starting to get frisky, so any suggestions would be greatly appreciated.

    Cheers,

    Lorcan.

  4. #4
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    What user are you logged into the OS as?
    Is there a database user with this same name?
    If you have access to multiple databases, is the ORACLE_SID environment variable set properly?

    remote_login_passwordfile should be EXCLUSIVE


    HTH,
    Patrick

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Oracle changed the security setup since 9i and you must say "as sysdba" if you login w/o password.

    When the CONNECT INTERNAL has been desupported in 9i, now users making DBA-privileged connections to the database must use one of the following syntaxes:

    CONNECT / AS SYSDBA or CONNECT <username/password> AS SYSDBA


    Hope that helps,

    clio_usa
    OCP - DBA

    .

Posting Permissions

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