07 diciembre 2014

Notas ORACLE


Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.


Tips

  • 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 9.2.0.1.0 - Production on Mon Apr 5 15:32:09 2004
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - 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



No hay comentarios:

Publicar un comentario

Nota: solo los miembros de este blog pueden publicar comentarios.