■sqlplus连接
sqlplus aa/aa@192.168.1.2:1521/ORCL
sqlplus aa/aa@192.168.1.2:1521/ORCL2
■插入式db连接
sqlplus C##aa/aa@192.168.1.2:1521/ORCL
■SQLPLUS「sql.log」出力
spool sql.log
spool off
host dir
■SQLPLUS 执行sql乱码
chcp 65001
set NLS_LANG=JAPANESE_JAPAN.AL32UTF8
■ORA-12514:
[oracle@localhost ~]$ lsnrctl stop
[oracle@localhost ~]$ lsnrctl start
[oracle@localhost ~]$ sqlplus / as sysdba
SQL> shutdown immediate
SQL> startup
SQL> exit
SQL> sqlplus scott/tiger@192.168.78.130/orcl
SQL> show con_name
# sqlplus / as sysdba
SQL> alter system register ;
conn sys as sysdba
alter pluggable database pdborcl open;
alter session set container = pdborcl;
conn aa/aa@192.168.1.1:1521/pdborcl