This discussion is archived
1 2 3 Previous Next 37 Replies Latest reply: Jan 30, 2013 7:00 AM by Udo RSS

New XE Install on Linux 5 - ORA-01017 Login Error

985518 Newbie
Currently Being Moderated
This is in a Linux VM image on Win 7.
The listener is up and the database appears to be up.
I, "su - oracle" and the the various env var are set.
I have the various groupid's setup and oracle is a member of them.
I also did a, "ssh systemname", to verify the login passwd.
oracle is in the sudo file.
I have uninstalled and installed a few times.
Restarting the Linux image does seem to start Oracle and the TNS listener.
I've tried sqlplus login with oracle, sys, system and as sysdba. I've checked my group id's and it contains: oracle, dba, oinstall, oper.
The files all have 755 and owned by oracle:dba.
I have searched all over the web and I have not been able to find anything that helps.
Any help would be great!

if I,
sqlplus /nolog
conn sys/passwd@xe

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

----
sqlplus / as sysdba
ERROR:
ORA-01031: insufficient privileges

Edited by: 982515 on Jan 17, 2013 9:39 AM
  • 1. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    Udo Guru
    Currently Being Moderated
    Hello, and welcome to the OTN forums!

    It seems you have two different issues here...
    conn sys/passwd@xe
    ORA-01017: invalid username/password; logon denied
    This is usally the case when you've either actually entered the wrong password, or your password contains "invalid" characters, such as the @-sign.
    I've tried sqlplus login with oracle, sys, system and as sysdba. I've checked my group id's and it contains: oracle, dba, oinstall, oper.
    It seems you have more than just an XE install in your VM, as "oinstall" and "oper" are usually not created by the XE installer.
    Possibly, there are a few other environment variables that don't fit to your XEs ORACLE_HOME...
    You should also try to make "dba" the primary group of your oracle user.

    -Udo
  • 2. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    Thanks for the welcome!

    My password is a total of 9 characters, of which two are numbers. No punctuation or special characters.
    My default group id is dba. If I do a, "touch x", it is owned by oracle:dba.
    No, that's it, I just have Oracle XE installed. I added the other groups to make sure I covered my bases.

    If I can perform a, "sqlplus /nolog" okay, does that indicate that the Oracle database is up? I believe the listener is working okay.

    What else can I try next?

    ~Tom
  • 3. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    When I tried the browser, I was able to bring up the Oracle Application Express admin login, but I was not able to login. http://hostname:8080/apex/apex_admin
    I used admin/my_passwd.

    I received an, "Invalid Login Credentials".

    I wanted to throw this out there, in case the information was useful in troubleshooting the sqlplus login issue.

    ~Tom
  • 4. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    Udo Guru
    Currently Being Moderated
    conn sys/passwd@xe
    Just found out I missed one piece here: The user "sys" can't login with a default role, but needs to login as "SYSDBA". Try
    conn sys/passwd@xe as sysdba
    instead.
    If I can perform a, "sqlplus /nolog" okay, does that indicate that the Oracle database is up?
    No, it just means you start sqlplus.This alone does not connect you to any database.
    I believe the listener is working okay.
    I think so too, as you say you are able to access APEX. This would also mean that your database is up.

    So, this leaves us with...
    sqlplus / as sysdba
    ERROR:
    ORA-01031: insufficient privileges
    My default group id is dba. If I do a, "touch x", it is owned by oracle:dba.
    ... where the questions would be:
    - Have you really been logged in with "oracle" and being member of group dba when you received this?
    - Has your environment actually been set properly at this moment?
    - Are you sure you haven't disabled OS authentication?
    When I tried the browser, I was able to bring up the Oracle Application Express admin login, but I was not able to login. http://hostname:8080/apex/apex_admin
    I received an, "Invalid Login Credentials".
    Probably you either connect to a different dabase instance you actually enter a different password than the one you've entered in the installer.
    To change it, you need to be able to login as sysdba, either with password or OS authentication.

    -Udo
  • 5. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    Udo, thanks for the reply!

    The one thing that you mentioned was, OS authentication. I don't know if OS authentication is enabled or disabled.
    My understanding is that you have to be able to login into sqlplus to be able to turn this on or off. In my case, I running a Linux vm image on Win 7.
    My Linux 5 image is running stand alone and not using any system for authentication. My understanding is that Oracle XE is NOT using OS authentication by default, so that could be the issue here.

    How can I turn on OS authentication, if I can login with sqlplus?

    Thanks,
    Tom
  • 6. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    Udo Guru
    Currently Being Moderated
    My understanding is that you have to be able to login into sqlplus to be able to turn this on or off.
    On Linux, this is true. On Windows, you'd also have the sqlnet.ora in your network configuration.
    My understanding is that Oracle XE is NOT using OS authentication by default, so that could be the issue here.
    No, you should be able to use it after a fresh XE install - if everything went well.
    In my case, I running a Linux vm image on Win 7.
    The host OS should not be relevant, unless you've installed sqlplus on your host and you are actually trying to connect to the VM that way. If I didn't get you wrong, all your attempts have been locally, i. e. inside the VM.
    How can I turn on OS authentication, if I can login with sqlplus?
    So the login using
    sqlplus sys/password@xe as sysdba
    is working now?
    If you didn't reconfigure anything in your instance yet, I'd still think there is some piece missing/wrong in your environment variables.
    Could you post the output of
    env | egrep 'PATH|ORA|LC|LANG|NLS'
    And could you also check the install logs in /u01/app/oracle/product/11.2.0/xe/config/log ?

    -Udo
  • 7. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    Here's my env vars:

    -bash-3.2$ env | egrep 'PATH|ORA|LC|LANG|NLS'
    LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/xe/lib64:/lib:/usr/lib
    ORACLE_SID=XE
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOSTNAME=my-hostname-55.xx.xxxxx.com
    PATH=/u01/app/oracle/product/11.2.0/xe/bin:/usr/sbin:/x/opt/pp/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin
    LANG=en_US.UTF-8
    ORACLE_TERM=xterm
    CLASSPATH=/u01/app/oracle/product/11.2.0/xe/JRE:/u01/app/oracle/product/11.2.0/xe/jlib:/u01/app/oracle/product/11.2.0/xe/rdbms/jlib
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
    --------------------
    -bash-3.2$ sqlplus sys/mypasswd@xe as sysdba

    SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 18 05:53:16 2013

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

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


    Enter user-name:
    --------------------

    I haven't reconfigured anything in the env today yet. I did move a copy of sqlnet.ora under $ORACLE_HOME/network/admin, but no changes have been made to the file and the server has not been restarted.

    --------------------
    I don't see any errors here:
    cloneDBCreation.log
    oracle@my-hostname-55 (MMON)
    --

    I don't see any errors here:
    CloneRmanRestore.log
    PL/SQL procedure successfully completed.
    --

    I see a failure here, but I doubt that is a problem:
    postDBCreation.log"
    begin
    *
    ERROR at line 1:
    ORA-31112: fail to unregister for HTTP port using xdb configuration
    ORA-06512: at "XDB.DBMS_XDB", line 528
    ORA-06512: at "XDB.DBMS_XDB", line 667
    ORA-06512: at line 2

    File created.

    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    ORACLE instance started.

    Total System Global Area 1068937216 bytes
    Fixed Size 2233344 bytes
    Variable Size 616565760 bytes
    Database Buffers 444596224 bytes
    Redo Buffers 5541888 bytes
    Database mounted.
    Database opened.

    'UTL_RECOMP_BEGIN:'||TO_CH
    --------------------------
    utl_recomp_begin: 02:20:14

    PL/SQL procedure successfully completed.

    'UTL_RECOMP_END:'||TO_CH
    ------------------------
    utl_recomp_end: 02:20:15
    --

    I don't see any errors here:
    postScripts.log
    PL/SQL procedure successfully completed.

    Commit complete.
    --

    I've tried logging in with: sqlplus oracle/mypasswd@host_name.com
    ORA-01017: invalid username/password; logon denied

    Should I uninstall / reinstall again?

    Please advise next steps Udo.

    Thanks,
    Tom

    Edited by: 982515 on Jan 18, 2013 6:38 AM
  • 8. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    I have uninstalled and reinstalled Oracle XE using the root user.
    I have entered a different password, but I still have the same login errors.

    If anyone has any other ideas, please let me know.

    Thanks,
    Tom
  • 9. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    Can someone let me know if the default Oracle XE Database install uses oracle database for the authentication? I doubt it tries to use OS authentication, by default.

    When you execute this script, "/etc/init.d/oracle-xe configure", it suppose to setup the password you give it for the oracle, sys and system id's, right?
    I hadn't tried it, but if you enter a 2nd passwd, that doesn't match the first, will the script catch that? I'm trying to figure out why the login or password does not match.
    Now days, we consider it a security issue by telling you whether it is the login or passwd that is incorrect. I wish I could tell which one was the problem.

    ~Tom
  • 10. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    orafad Oracle ACE
    Currently Being Moderated
    Log in as oracle user (in Linux os).

    $ id

    $ sqlplus / as sysdba

    (exit from sqlplus if applicable)

    $ sqlplus system

    Provide install password at the pw prompt.
  • 11. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    -bash-3.2$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 19 04:39:14 2013

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

    ERROR:
    ORA-01031: insufficient privileges


    Enter user-name:
    ----------
    -bash-3.2$ sqlplus system

    SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 19 04:44:23 2013

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

    Enter password:
    ERROR:
    ORA-01017: invalid username/password; logon denied


    Enter user-name:
  • 12. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    orafad Oracle ACE
    Currently Being Moderated
    What does XE's sqlnet.ora contain?

    Does any other sqlnet.ora files exist?

    Again, show output from

    $ id
  • 13. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    cd /
    [root /]# find . -name sqlnet.ora
    ./x/home/oracle/app/oracle/product/11.2.0/xe/network/admin/samples/sqlnet.ora
    All lines are commented out.
    Only this file exist on the system.

    -bash-3.2$ id
    uid=969(oracle) gid=533(dba) groups=100(users),107(xxusers),533(dba),40010(oinstall),40011(oper)

    Thanks,
    Tom
  • 14. Re: New XE Install on Linux 5 - ORA-01017 Login Error
    985518 Newbie
    Currently Being Moderated
    I'm running out of time and things to try and make this work. The only thing I can think to do is to start mucking with the sqlnet.ora file and turning things on for OS authentication.

    I've changed all files/directories to oracle:dba and opened up all perms where Oracle install lives. Still I have the same login errors. What could be the problem here?

    My company does have Oracle support, is there some place/person I could contact at Oracle for additional help?

    ~Tom
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points