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))
)
