z-notes

1.oracle-数据库关闭

sqlplus "/as sysdba"
shutdown immediate;
exit;
lsnrctl stop

2.oracle-数据库启动

sqlplus "/as sysdba"
startup;
exit;
lsnrctl start

3.oracle-日志路径

select * from v$diag_info;

#关注这个文件，这个文件是数据库警告和输出信息
 1 Diag Trace
/opt/oracle/diag/rdbms/itpuxdb/itpuxdb/trace
#主要关注ORA开头的报错信息

4.oracle-表空间创建

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/ITPUXDB/system01.dbf #主路径
/opt/oracle/oradata/ITPUXDB/sysaux01.dbf
/opt/oracle/oradata/ITPUXDB/undotbs01.dbf
/opt/oracle/oradata/ITPUXDB/users01.dbf
#查看数据库的主路径

create tablespace fgedu datafile '/opt/oracle/oradata/ITPUXDB/fgedu01.dbf' size 10M; #路径不能错，注意大小写

5.oracle-用户创建

create user fgedu identified by fgedu123 default tablespace fgedu;
grant dba to fgedu;

6.oracle-创建表

conn fgedu/fgedu123;
create table itpuxt1(id number(12) primary key,name varchar(20));

7.oracle-数据插入

insert into itpuxt1 values(1,'fgedu01');
insert into itpuxt1 values(2,'fgedu02');
commit;

8.oracle-数据查询

SQL> select * from itpuxt1;

    ID NAME
---------- --------------------
     1 fgedu01
     2 fgedu02

9.oracle-卸载

su - oracle
cd $ORALCE_HOME/bin
./dbca
cd $ORACLE_HOME/bin
./netca

root:
yum -y remove oracle-database-ee-19c