I have installed this Docker image today: https://hub.docker.com/_/oracle-database-enterprise-edition
I followed the instructions here: https://www.youtube.com/watch?v=ciYsDbBx80s. Basically I ran the following commands:
docker pull store/oracle/database-enterprise:184.108.40.206 docker run -d -p 1521:1521 --name oracle store/oracle/database-enterprise:220.127.116.11 docker exec -it 0500ab7ee75c bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
Then in sqlpus:
connect sys as sysdba Enter password: anyrandompassword alter session set "_ORACLE_SCRIPT"=true; create user dummy identified by dummy; SQL> GRANT ALL PRIVILEGES TO dummy; SQL>ALTER USER sysdba IDENTIFIED BY Password1 ACCOUNT UNLOCK;
I have two questions:
Why is the SQLDeveloper password for the dummy user: dummy. I have not specified this.
It appears that I can now login to SQL Developer with the following credentials (as described here: https://stackoverflow.com/questions/9129664/unable-to-log-in-to-database-as-sys-with-oracle-sql-developer):
Username: SYS AS SYSDBA Password: Password1
However, when I run the following command in sqlplus
connect sys as sysdba
I am then prompted for a password, however any password appears to work.