<\/p>\n
Nos propusimos crear una nueva base de datos Oracle en Docker viendo el siguiente post:<\/p>\n
https:\/\/technology.amis.nl\/2017\/12\/30\/oracle-database-in-a-docker-container-from-oracle-container-registry\/<\/pre>\n<\/p>\n
La verdad es que en la documentaci\u00f3n del Oracle Container Registry da muchas pautas de como hacerlo tambi\u00e9n, as\u00ed que os recomiendo que las le\u00e1is:<\/p>\n
Oracle Container Registry \/ Explore Official Business Areas \/ Database<\/pre>\n<\/p>\n
Nos conectamos al registro de Oracle:<\/p>\n
sergio@sergio-pc:~$ docker login -u sergio_menoyo@yahoo.es -p XXXXX container-registry.oracle.com\r\nLogin Succeeded<\/pre>\n<\/p>\n
Nos creamos un fichero para la instalaci\u00f3n:<\/p>\n
sergio@sergio-pc:~$ cat \/datos\/ARUMEL\/blog\/docker\/container.conf\r\nDB_SID=ORCLCDB\r\nDB_PDB=ORCLPDB1\r\nDB_DOMAIN=localdomain\r\nDB_MEMORY=2GB<\/pre>\n<\/p>\n
Lanzamos la creaci\u00f3n del container (va extremedamente lento):<\/p>\n
sergio@sergio-pc:~$ docker run -d --env-file \/datos\/ARUMEL\/blog\/docker\/container.conf -p 1521:1521 -p 5500:5500 -it --name oracle12.2 container-registry.oracle.com\/database\/enterprise:12.2.0.1-slim\r\nUnable to find image 'container-registry.oracle.com\/database\/enterprise:12.2.0.1-slim' locally\r\n12.2.0.1-slim: Pulling from database\/enterprise\r\ncbb9821ba51c: Downloading [====> ] 7.438MB\/81.5MB\r\n9bd4d110366e: Downloading [==> ] 5.828MB\/143MB\r\naf8b29651e27: Download complete \r\n4c242ab1add4: Download complete \r\n0cdb4333d4a1: Downloading [> ] 8.494MB\/1.385GB\r\n[...]<\/pre>\n<\/p>\n
Terminar\u00e1 as\u00ed:<\/p>\n
cbb9821ba51c: Pull complete \r\n9bd4d110366e: Pull complete \r\naf8b29651e27: Pull complete \r\n4c242ab1add4: Pull complete \r\n0cdb4333d4a1: Pull complete \r\nDigest: sha256:1c199d6e859ed6e0a98b0eaffdc403084aca4d15476b338c632d131cd3227c81\r\nStatus: Downloaded newer image for container-registry.oracle.com\/database\/enterprise:12.2.0.1-slim\r\n3942c74f851e9553f4d4d512784beb493d6893c8525f1305b4dcda1cf1ab8a0a<\/pre>\n<\/p>\n
A partir de aqu\u00ed ya tenemos el contenedor creado (fijaros en el tama\u00f1o!):<\/p>\n
sergio@sergio-pc:~$ docker images\r\nREPOSITORY TAG IMAGE ID CREATED SIZE\r\n[...]\r\ncontainer-registry.oracle.com\/database\/enterprise 12.2.0.1-slim 27c9559d36ec 4 months ago 2.08GB<\/pre>\n<\/p>\n
Podemos cambiarle la password por defecto:<\/p>\n
sergio@sergio-pc:~$ docker exec -it oracle12.2 \/bin\/bash\r\n\r\n[oracle@3942c74f851e \/]$ sqlplus \"\/as sysdba\"\r\n\r\nSQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 10 09:25:08 2018\r\n\r\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\nSQL> alter user sys identified by oracle;\r\n\r\nUser altered.\r\n\r\nSQL> alter user system identified by oracle;\r\n\r\nUser altered.<\/pre>\n<\/p>\n
Para conectarnos podemos hacerlo por ssh al container y luego abrir el sqlplus (como hicimos al cambiar la password), o desde nuestra m\u00e1quina local directamente:<\/p>\n
sergio@sergio-pc:~$ sql system\/oracle@localhost:1521\/orclpdb1.localdomain\r\n\r\nSQLcl: Versi\u00f3n 17.4.0 Production en mi\u00e9 ene 10 10:42:26 2018\r\n\r\nCopyright (c) 1982, 2018, Oracle. Todos los derechos reservados.\r\n\r\nLast Successful login time: Mi\u00e9 Ene 10 2018 10:42:27 +01:00\r\n\r\nConectado a:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\n\r\nSQL> \r\n\r\n\r\n------------------------------------------------------------------------------\r\nsergio@sergio-pc:~$ sql system\/oracle@localhost:1521\/orclcdb.localdomain\r\n\r\nSQLcl: Versi\u00f3n 17.4.0 Production en mi\u00e9 ene 10 10:33:41 2018\r\n\r\nCopyright (c) 1982, 2018, Oracle. Todos los derechos reservados.\r\n\r\nLast Successful login time: Mi\u00e9 Ene 10 2018 10:33:42 +01:00\r\n\r\nConectado a:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\n\r\nSQL> \r\n<\/pre>\n<\/p>\n
Para parar o arrancar:<\/p>\n
sergio@sergio-pc:~$ docker stop oracle12.2\r\noracle12.2\r\n\r\nsergio@sergio-pc:~$ docker ps -a\r\nCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES\r\n3942c74f851e container-registry.oracle.com\/database\/enterprise:12.2.0.1-slim \"\/bin\/sh -c '\/bin\/...\" About an hour ago Exited (137) 5 seconds ago oracle12.2\r\n\r\nsergio@sergio-pc:~$ docker start oracle12.2\r\noracle12.2\r\n\r\nsergio@sergio-pc:~$ docker ps -a\r\nCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES\r\n3942c74f851e container-registry.oracle.com\/database\/enterprise:12.2.0.1-slim \"\/bin\/sh -c '\/bin\/...\" About an hour ago Up 43 seconds (health: starting) 0.0.0.0:1521->1521\/tcp, 0.0.0.0:5500->5500\/tcp oracle12.2\r\n<\/pre>\n<\/p>\n
Si quieres entrar al EM express:<\/p>\n
SQL> SELECT 'https:\/\/'||SYS_CONTEXT('USERENV','SERVER_HOST')||'.'||SYS_CONTEXT('USERENV','DB_DOMAIN')||':'||dbms_xdb_config.gethttpsport()||'\/em\/' from dual;\r\n\r\n'HTTPS:\/\/'||SYS_CONTEXT('USERENV','SERVER_HOST')||'.'||SYS_CONTEXT('USERENV','DB\r\n--------------------------------------------------------------------------------\r\nhttps:\/\/3942c74f851e.localdomain:0\/em\/\r\n\r\n\r\nSQL> exec dbms_xdb_config.sethttpsport(5500);\r\nProcedimiento PL\/SQL terminado correctamente.\r\n\r\n\r\nhttps:\/\/localhost:5500\/em\r\n\r\n\r\n<\/pre>\n<\/p>\n