Docker oracle相关

进入docker的oracle_11g 容器

docker exec -it --user root 容器ID /bin/bash

加载环境变量

source /home/oracle/.bash_profile

登录sqlplus

sqlplus /nolog

connect /as sysdba

查看实例

SELECT instance_name FROM v$instance;

instance_name是oracle数据库参数。而ORACLE_SID是操作系统的环境变量,ORACLE_SID必须与instance_name的值一致

查看global_name

select * from global_name;

修改global_name

update global_name set global_name = 'LOCALDB';

commit;

查看do_main

 show parameter db_domain;

关闭数据库实例

shutdown immediate

启动数据库实例

startup

查看service_name

show parameter service_name;

查看db_name

show parameter db_name;

查看instance_name

SELECT instance_name FROM v$instance;

清除缓存

alter system flush shared_pool;

修改schame

select user#,name,password from user$ where name ='settlement';

     USER# NAME 			  PASSWORD
---------- ------------------------------ ------------------------------
	92 settlement		  63124632E34C626B


update user$ set name='SETTLEMENT' where user#=92;
commit;
alter system flush shared_pool;

查看所有的表空间

SELECT *  from user_tablespaces;
SELECT TABLESPACE_NAME FROM DBA_TABLESPACES ;