sqlplus相关命令1 留个记录

■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