Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2009
    Posts
    12

    Unanswered: Oracle XE - Resetting Expired Password

    Click image for larger version. 

Name:	j_Oracle Error.JPG 
Views:	1 
Size:	52.4 KB 
ID:	17318

    When attempting to connect to Oracle XE through SQL Developer, I receive the attached error message about the password being expired. I am attempting to log in as SYSTEM. Can someone direct me to a procedure to reset the SYSTEM password?

    Thanks in advance,

    HLeyes

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,113
    Provided Answers: 5
    On the command prompt (in MS Windows, that would be CMD.EXE) type "sqlplus" and press Enter. It'll ask you for username (type "system") and password (type the expired password). You should then be asked for a new password, so - enter it.

  3. #3
    Join Date
    Jan 2009
    Posts
    12
    Lightfoot - thanks for the response. Simple enough, but when I do that, it comes up with "TNS: protocol adapter error".

    Click image for larger version. 

Name:	j_Oracle Password Error Message - Protocol Adapter.JPG 
Views:	4 
Size:	30.9 KB 
ID:	17320

    Since this is 11g XE used as a learning tool, I am not opposed to un- and re-installing. What do you think?

    Thanks.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,113
    Provided Answers: 5
    Well, it depends on what you want to learn If it is (for example) SQL, then reinstallation probably isn't the right choice. If you choose to do it anyway, do it using OUI (Oracle Universal Installer) because - if you do it manually - some stuff might be left behind which would make a new installation difficult. We (both you and me) wouldn't want you to format hard disk to solve that problem, would we?

    Check whether Oracle services are started; on my Windows 7, it is in Control panel - Administrative tools - Services. There should be a few of them; make sure that OracleServiceXE as well as OracleXETNSListener are started. If they are not, start them now and then try to connect again.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,520
    also if you are using sqlplus then you need the tnsnames.ora setup for your connection
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,113
    Provided Answers: 5
    Umm ... no, most probably he does not because XE is installed on his own computer. Have a look: I'm setting the TNS_ADMIN variable to a nonsense value and establish connection without problems:
    Code:
    C:\>set tns_admin=dbforums
    
    C:\>sqlplus scott/tiger
    
    SQL*Plus: Release 11.2.0.2.0 Production on Pon Tra 3 20:59:12 2017
    
    Copyright (c) 1982, 2014, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
    
    SQL>
    I didn't use TNSNAMES.ORA, did I?

  7. #7
    Join Date
    Jan 2009
    Posts
    12
    Thanks Littlefoot (sorry about the misspelling on your name above) and beilstwh!

    Found an answer at: http://www.thatjeffsmith.com/archive...sql-developer/
    This allowed me to reset my SYSTEM password without the protocol adapter error.


    Suchitra Phadke
    November 22, 2015 at 4:49 am


    There is another way to reset the password through command prompt …

    Go to the Oracle Database Folder ( In my case Oracle Database 11g Express Edition) in the START MENU.
    Within that folder click “Run SQL Commandline”

    –> Type “connect username/password” (your old username and password without the quotation marks)

    The message displayed is …

    ERROR:
    ORA-28001: the password has expired

    Changing password for hr
    –> New password:

    Type the new password
    Retype the new password

    Message displayed is …

    Password changed
    Connected.
    SQL>

    GO TO Sql developer –> type the new password

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,113
    Provided Answers: 5
    I'm glad you solved the problem and shared it with us.

    "Run SQL Commandline" seems to be equal to (ran at OS command prompt)
    Code:
    M:\>sqlplus /nolog
    
    SQL*Plus: Release 11.2.0.1.0 Production on Uto Tra 4 07:48:36 2017
    
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    
    SQL>
    This is the SQL*Plus command prompt. However, you still aren't connected to the database:
    Code:
    SQL> select * from dual;
    SP2-0640: Not connected
    SQL>
    so you have to "connect":
    Code:
    SQL> connect scott/tiger
    Connected.
    SQL>
    This is where you got the "the password has expired" message.

    OK then, have a good time with Oracle!

Posting Permissions

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