第一个ssh
第二个ssh:
[root@oradbdocker oradata]# docker container ls
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
976bf80d98e3 oracle/database:12.2.0.1-ee "/bin/sh -c 'exec ..." 11 minutes ago Up 11 minutes (healthy) 0.0.0.0:1521->1521/tcp, 5500/tcp oracle7
[root@oradbdocker oradata]#
第二个ssh:
[root@oradbdocker ~]# docker exec -ti 976bf80d98e3 /bin/bash
[oracle@976bf80d98e3 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 8 09:02:16 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name: ^C^C^C
[oracle@976bf80d98e3 ~]$
[oracle@976bf80d98e3 ~]$
[oracle@976bf80d98e3 ~]$ ps -ef | grep ora_
oracle 2265 1 0 08:56 ? 00:00:00 ora_pmon_ORCLCDB
oracle 2267 1 0 08:56 ? 00:00:00 ora_clmn_ORCLCDB
oracle 2269 1 0 08:56 ? 00:00:00 ora_psp0_ORCLCDB
oracle 2271 1 0 08:56 ? 00:00:00 ora_vktm_ORCLCDB
oracle 2275 1 0 08:56 ? 00:00:00 ora_gen0_ORCLCDB
oracle 2277 1 0 08:56 ? 00:00:00 ora_mman_ORCLCDB
oracle 2281 1 0 08:56 ? 00:00:00 ora_gen1_ORCLCDB
oracle 2285 1 0 08:56 ? 00:00:00 ora_diag_ORCLCDB
oracle 2287 1 0 08:56 ? 00:00:00 ora_ofsd_ORCLCDB
oracle 2291 1 0 08:56 ? 00:00:00 ora_dbrm_ORCLCDB
oracle 2293 1 0 08:56 ? 00:00:00 ora_vkrm_ORCLCDB
oracle 2295 1 0 08:56 ? 00:00:00 ora_svcb_ORCLCDB
oracle 2297 1 0 08:56 ? 00:00:00 ora_pman_ORCLCDB
oracle 2299 1 0 08:56 ? 00:00:00 ora_dia0_ORCLCDB
oracle 2301 1 0 08:56 ? 00:00:00 ora_dbw0_ORCLCDB
oracle 2303 1 0 08:56 ? 00:00:00 ora_lgwr_ORCLCDB
oracle 2305 1 0 08:56 ? 00:00:00 ora_ckpt_ORCLCDB
oracle 2307 1 0 08:56 ? 00:00:00 ora_lg00_ORCLCDB
oracle 2309 1 0 08:56 ? 00:00:00 ora_smon_ORCLCDB
oracle 2311 1 0 08:56 ? 00:00:00 ora_lg01_ORCLCDB
oracle 2313 1 0 08:56 ? 00:00:00 ora_smco_ORCLCDB
oracle 2315 1 0 08:56 ? 00:00:00 ora_reco_ORCLCDB
oracle 2317 1 0 08:56 ? 00:00:00 ora_w000_ORCLCDB
oracle 2319 1 0 08:56 ? 00:00:00 ora_lreg_ORCLCDB
oracle 2321 1 0 08:56 ? 00:00:00 ora_w001_ORCLCDB
oracle 2323 1 0 08:56 ? 00:00:00 ora_pxmn_ORCLCDB
oracle 2327 1 0 08:56 ? 00:00:01 ora_mmon_ORCLCDB
oracle 2329 1 0 08:56 ? 00:00:00 ora_mmnl_ORCLCDB
oracle 2331 1 0 08:56 ? 00:00:00 ora_d000_ORCLCDB
oracle 2333 1 0 08:56 ? 00:00:00 ora_s000_ORCLCDB
oracle 2335 1 0 08:56 ? 00:00:00 ora_tmon_ORCLCDB
oracle 2345 1 0 08:56 ? 00:00:00 ora_tt00_ORCLCDB
oracle 2347 1 0 08:56 ? 00:00:00 ora_tt01_ORCLCDB
oracle 2349 1 0 08:56 ? 00:00:00 ora_tt02_ORCLCDB
oracle 2351 1 0 08:56 ? 00:00:00 ora_aqpc_ORCLCDB
oracle 2355 1 0 08:56 ? 00:00:00 ora_p000_ORCLCDB
oracle 2357 1 0 08:56 ? 00:00:00 ora_p001_ORCLCDB
oracle 2359 1 0 08:56 ? 00:00:00 ora_p002_ORCLCDB
oracle 2361 1 0 08:56 ? 00:00:00 ora_p003_ORCLCDB
oracle 2363 1 0 08:56 ? 00:00:00 ora_p004_ORCLCDB
oracle 2365 1 0 08:56 ? 00:00:00 ora_p005_ORCLCDB
oracle 2367 1 0 08:56 ? 00:00:00 ora_p006_ORCLCDB
oracle 2369 1 0 08:56 ? 00:00:00 ora_p007_ORCLCDB
oracle 2371 1 0 08:56 ? 00:00:00 ora_p008_ORCLCDB
oracle 2373 1 0 08:56 ? 00:00:00 ora_p009_ORCLCDB
oracle 2375 1 0 08:56 ? 00:00:00 ora_p00a_ORCLCDB
oracle 2377 1 0 08:56 ? 00:00:00 ora_p00b_ORCLCDB
oracle 2379 1 0 08:56 ? 00:00:00 ora_p00c_ORCLCDB
oracle 2381 1 0 08:56 ? 00:00:00 ora_p00d_ORCLCDB
oracle 2383 1 0 08:56 ? 00:00:00 ora_p00e_ORCLCDB
oracle 2385 1 0 08:56 ? 00:00:00 ora_p00f_ORCLCDB
oracle 2390 1 0 08:56 ? 00:00:02 ora_cjq0_ORCLCDB
oracle 2591 1 0 08:56 ? 00:00:00 ora_p00g_ORCLCDB
oracle 2593 1 0 08:56 ? 00:00:00 ora_p00h_ORCLCDB
oracle 2595 1 0 08:56 ? 00:00:00 ora_p00i_ORCLCDB
oracle 2599 1 0 08:56 ? 00:00:00 ora_qm02_ORCLCDB
oracle 2603 1 0 08:56 ? 00:00:00 ora_q002_ORCLCDB
oracle 2605 1 0 08:56 ? 00:00:00 ora_q003_ORCLCDB
oracle 2660 1 0 08:57 ? 00:00:00 ora_q004_ORCLCDB
oracle 2723 1 0 08:57 ? 00:00:00 ora_w002_ORCLCDB
oracle 2906 1 0 09:01 ? 00:00:00 ora_p00j_ORCLCDB
oracle 2974 2921 0 09:02 pts/0 00:00:00 grep --color=auto ora_
[oracle@976bf80d98e3 ~]$ export ORACLE_SID=ORCLCDB
[oracle@976bf80d98e3 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 8 09:03:22 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> DEWC DBA_DATA_FILES;
SP2-0734: unknown command beginning "DEWC DBA_D..." - rest of line ignored.
SQL> desc dba_data_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
LOST_WRITE_PROTECT VARCHAR2(7)
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/ORCLCDB/system01.dbf
/opt/oracle/oradata/ORCLCDB/sysaux01.dbf
/opt/oracle/oradata/ORCLCDB/undotbs01.dbf
/opt/oracle/oradata/ORCLCDB/users01.dbf
SQL>