Prerequisite: The Oracle 12c database is installed, there is already a DB instance XE, login user/password: system/oralce
I'm using a Docker-installed instance of Oracle 12c:
8080:80801521:1521 -v/home/<user>/docker/data/oracle_1521:/u01/app/ Oracle SATH89/ORACLE-12C
Specific reference https://hub.docker.com/r/sath89/oracle-12c/
Note: with "-e vnc_password=<password>" does not seem to work, the connection will require the default password Oracle to connect.
1. Log in to Oracle 12c machine with Oracle user
2. Change the value of Oracle_sid, if you want to create a DB instance MyDB
oracle_sid=mydbexport Oracle_sid
If necessary, modify the login initial file of the Oracle user so that ORACLE_SID is mydb every time you log in
3. Create a DB instance with DBCA MyDB
-emconfiguration LOCAL
Enter Oracle when prompted for password
4. When the creation is complete, connect Oracle with Sqlplus
" /as sysdba "
5. Close the DB instance first (I don't know if I need it or not, I don't understand Oracle, it's not an existing xe, I try)
SHUTDOWN immediate;
6. Start a newly created DB instance
Startup force
"Startup Force" before I also run a "startup Nomount", do not know this step need not, finally is the new mydb SID up after the startup force
7. Connect MyDB SID with system/oracle
Sql> Conn system/oracleconnected.sqlSelect name from V$datafile;name----------------- ---------------------------------------------------------------/u01/app/oracle/oradata/mydb/system01.dbf /u01/app/oracle/oradata/mydb/sysaux01.dbf/u01/app/oracle/oradata/mydb/undotbs01.dbf/u01 /app/oracle/oradata/mydb/users01.dbf
See the tablespace files in the MyDB directory
8. Create a new tablespace DEV1
' /u01/app/oracle/oradata/neuron/dev1.dbf ' size 3000m;
9. Create a new user Dev1
Sql> create user Dev1 identified by password default tablespace DEV1;
10. Assigning Permissions
Sql> Grant Dba,connect to Dev1;
11. Submit Changes
Sql> commit;
12. Exit Sqlplus with new user/password: Dev1/password will be able to log in.
[Email protected]$ sqlplussql*plus:release12.1.0.2.0Production on Wed Oct - xx: +: - .Copyright (c)1982, the, Oracle. All rights reserved. Enter User-Name:dev1enter password:last SuccessfulLogin Time: Tue Oct - . ,: -: -+xx:xxConnected to:oracle Database 12c standard Edition Release12.1.0.2.0-64bit Productionsql>
Oracle 12c creates a new DB instance, user