第一个ssh
第二个ssh：
原文链接：https://www.f2er.com/oracle/206207.html[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,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>
