docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
docker 下载oracle11g
docker run -d -p 1521:1521 --name oracle11g registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g docker exec -it oracle11g bash [oracle@fed9e5bdd51d /]$ sqlplus /nolog bash: sqlplus: command not found 不可用 su root
输入密码helowin
vi /etc/profile 并在文件最后添加如下命令 export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2 export ORACLE_SID=helowin export PATH=$ORACLE_HOME/bin:$PATH ln -s $ORACLE_HOME/bin/sqlplus /usr/bin 切换到oracle 用户 就可以sqlplus /nolog 了
2.118修改了系统密码如下：
alter user system identified by estar2022; alter user sys identified by estar2022; ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
增加jeecgboot用户
SQL> create user jeecgboot identified by estar20220308; User created. SQL> grant connect,resource,dba to jeecgboot; Grant succeeded. SQL>
下面主要是修改字体
shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 1603411968 bytes Fixed Size 2213776 bytes Variable Size 402655344 bytes Database Buffers 1191182336 bytes Redo Buffers 7360512 bytes Database mounted. SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; System altered. SQL> alter database open; Database altered. SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK; Database altered. SQL> select * from v$nls_parameters;
另外客户端tnsnames.ora增加下面一项
oracle11g-118 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.118)(PORT = 1521)) (CONNECT_DATA = (SID = helowin)) )
