1. 登录oracle
su - oracle
sqlplus / as sysdba
2.查看库里存在的用户,防止冲突
SELECT username FROM all_users ORDER BY username;
3.查看库里存在的表空间,防止冲突
select
tablespace_name, file_id, file_name,
round(bytes/(1024*1024),0) total_space_MB
from
dba_data_files
order
by
tablespace_name;
4.查看CDB的名称
SQL> select name from v$database;
5.查看tnsname
-----------
$ more $ORACLE_HOME/network/admin/tnsnames.ora
[oracle@oracle01 admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /data