Oracle创建空间-用户流程
1.创建表空间
create tablespace dbcms logging datafile
‘/u01/app/oracle/oradata/orcl/dbcms.DBF’
size 32m autoextend on next 32m maxsize unlimited extent management local;
2.创建用户,密码对应表空间
create user dbcms identified by oracle default tablespace dbcms;
3.对用户授权
grant dba to dbcms;
grant create view to dbservice;
grant all privileges to dbcms;
Oracle删除空间-用户流程
1.删除表空间及用户
drop user dbcms cascade;
drop tablespace dbcms including contents and datafiles;
Oracle查询空间-用户
1.查询表空间
select tablespace_name from dba_tablespaces;
2.查询用户
select username from dba_users;
Oracle停止归档模式
如果需要停止归档模式,此处使用:
alter database noarchivelog命令
Oracle12C CDB与PDB指令
1.CDB和PDB之间的切换方式
alter session set container = ORCLPDB;
alter session set container = cdb$root;
2.进入pdb流程:
sqlplus / as sysdba;
show pdbs;
alter session set container = ORCLPDB;
3.12c试用wmconcat需要对解锁用户
grant create session to wmsys;
查看Oracle字符集:
select * from nls_database_parameters where parameter=‘NLS_CHARACTERSET’;
给Oracle虚拟路径授权及备份
1、查询oracle虚拟路径
select * from dba_directories;
给虚拟路径授权及备份:
Grant read,write on directory DATA_PUMP_DIR to dbcms;
DIRECTORY的管理步骤:
1、创建:CREATE [OR REPLACE] DIRECTORY directory AS ‘pathname’ ;
例如:CREATE OR REPLACE DIRECTORY DIR AS ‘F:\expbak’;
2、赋权:GRANT READ[,WRITE] ON DIRECTORY directory TO username;
例如:grant read, write on directory exp_dir to john;
3、查询directory的方法
select * from dba_directories;
Linux常用指令
查看监听器状态:lsnrctl status
启动监听器: lsnrctl start
关闭监听器:lsnrctl stop
关闭防火墙: sudo service iptables stop
编辑防火墙: vi /etc/sysconfig/iptables
重启防火墙: sudo service iptables restart
保存配置: sudo service iptables save
查看防火墙规则: sudo iptables -L -n
设置DNS
vi /etc/resolv.conf
查看cpu个数:
#cat /proc/cpuinfo | grep “physical id” | uniq | wc -l
查看CPU核数:
#cat /proc/cpuinfo | grep “cpu cores” | uniq
查看cpu型号:
#cat /proc/cpuinfo | grep ‘model name’ |uniq
查看内存总数:
#cat /proc/meminfo | grep MemTotal
查看硬盘大小:
#fdisk -l | grep Disk
设置静态ip:
vi /etc/sysconfig/network-scripts/ifcfg-ethx
更改hostname:
vi /etc/sysconfig/network