07 diciembre 2014


Oracle Database 11g Express Edition Release - Production.


  • Recuperar la contraseña del usurario administrador o system:

    "Log into the database server as a user belonging to ‘dba’ [unix ] or ‘ora_dba’ [windows ] group , typically ‘oracle’, or an administrator on your windos machine. You are able to log into Oracle as SYS user, and change the SYSTEM password by doing the following:
    $ sqlplus "/ as sysdba"
    SQL*Plus: Release - Production on Mon Apr 5 15:32:09 2004
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    Connected to:
    Oracle9i Enterprise Edition Release - Production
    With the OLAP and Oracle Data Mining options
    JServer Release - Production
    SQL> show user
    USER is "SYS"
    SQL> passw system
    Changing password for system
    New password:
    Retype new password:
    Password changed 
    SQL> quit"

    Esta información ha sido extraída de: Rolfe