7、删除 undo 表空间
查看 undo 表空间,并删除节点 2 (在此不使用)的 undo 表空间
1. SQL> sho parameter undo;
2. NAMETYPE VALUE
3.
8. SQL> select tablespace_name from dba_tablespaces where contents=*UNDO
,
;
9. TABLESPACE_NAME
10. -------------------------------
11. UNDOTBS1
12. UNDOTBS2
13. SQL> drop tablespace UNDOTBS2 including contents and datafiles;删除节点 28、创立 temp 表空间
1. SQL> select name from v$tempfile;
2. NAME
3.
4. /u01/app/oracle/oradata/ECOLOGY/ECOLOGY/datafile/o1_mf_tempjbg3tlg5_.tmp
5. SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';
6. TABLESPACE_NAME
7.
8. TEMP
9. SQL> create temporary tablespace TEMPI tempfile 7u01/app/oracle/oradata/ECOLOGY/datafile/tempO
l. dbf size 100M;
10. Tablespace created.
11. SQL> alter database default temporary tablespace TEMPI;
12. Database altered.
13. SQL> drop tablespace TEMP including contents and datafiles;
14. Tablespace dropped.
9、数据库更改 IP 地址
数据库里的配置文件,还是 RAC 集群地址,因此要改为 Oracle 单机服务器的 IP
监听 IP 更改:vim/uOl/app/oracle/product/19. 0.
0/db_l/network/admin/listener. ora
1. LISTENER =
2. (DESCRIPTION_LIST =
5. undo_management
6. undo_retention
7. undo_tablespace
8. undo_management
9. undo_retention
10. undo_tablespace
string AUTO
integer 900
string UNDOTBS1