加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 （https://www.lidatong.com.cn/）- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置： 首页 > 百科 > 正文

登录到oracle db 12.2 docker container中方法

发布时间：2020-12-12 14:00:37 所属栏目：百科 来源：网络整理
导读：第一个ssh [root@oradbdocker oradata]# docker container lsCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES976bf80d98e3 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
第一个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,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>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
    相关内容
      推荐文章
        站长推荐
        热点阅读

          【免责声明】本站内容转载自互联网，其发布内容言论不代表本站观点，如果其链接、内容的侵犯您的权益，烦请提交相关链接至邮箱bqsm@foxmail.com我们将及时予以处理。

          建议您使用1920×1080分辨率、谷歌浏览器Google Chrome、Microsoft Edge以获得本站的最佳浏览效果

          Copygight © 2008-2022 https://www.lidatong.com.cn/ All Rights Reserved. 李大同