oracle基本操作-docker安装.docxVIP

下载

dockerpullwnameless/oracle-xe-11g

参考：dockerpullwnameless/oracle-xe-11g-r2

启动

dockerrun-d-p1521:1521--name=oracle--restart=always-eORACLE_ALLOW_REMOTE=truedocker.io/wnameless/oracle-xe-11g

操作

远程登陆

sid是实例名：xe

root@24642a8f4069:/#sqlplussystem/oracle@10.100.4.54:1521/xeSQL*Plus:Release11.2.0.2.0ProductiononFriJul2607:22:492019Copyright(c)1982,2011,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gExpressEditionRelease11.2.0.2.0-64bitProduction

查看用户表

SQLselectnamefromv$datafile;NAME------------------------------------------