ora_p002_oracle,登录到oracle db12.2dockercontainer中的几种方法介绍-Oracle

第一个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>