Get access to oracle

Navigation
0

Who understands Oracle ... Are there ways to recover the database password? We have a system that works with Oracle but now we have decided to change the system and we do not have access to the database because the one that made the system did not provide us with the administration password and we need to migrate the data that is in them. Is there any way to recover the password? If someone has had an equal case?

    
asked by Victor Gimenez 14.04.2018 в 16:23
source

1 answer

1

In order to recover the Oracle DB password, you will need access to the Operating System where the DB is installed.

Once inside you must do the following:

  • Start the BD as sysdba. From CMD in Windows or a Terminal in Linux. You must have the environment variables correctly loaded so that the "sqlplus" command is recognized.
    •   

    $ sqlplus "/ as sysdba"

  • Modify the password of the desired schema (in this example the password of the user system is changed)
    •   

    SQL > passw system

  • Exit
    •   

    SQL > quit

        
    answered by 16.04.2018 в 23:02
    Extract external domain xml data with jquery Button that does not work