{"id":1561,"date":"2021-06-09T17:03:47","date_gmt":"2021-06-09T09:03:47","guid":{"rendered":"http:\/\/www.821121.com\/?p=1561"},"modified":"2021-06-09T17:07:24","modified_gmt":"2021-06-09T09:07:24","slug":"oracle-19c-em-%e6%97%a0%e6%b3%95%e7%99%bb%e9%99%86","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1561","title":{"rendered":"oracle 19c em \u65e0\u6cd5\u767b\u9646"},"content":{"rendered":"

19c em \u65e0\u6cd5\u767b\u9646<\/h1>\n

\u68c0\u67e5\u7aef\u53e3\u914d\u7f6e<\/h4>\n

[oracle@cat1 ~]$ sqlplus \/ as sysdba<\/p>\n

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 9 16:58:11 2021
\nVersion 19.3.0.0.0<\/p>\n

Copyright (c) 1982, 2019, Oracle. All rights reserved.<\/p>\n

Connected to:
\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
\nVersion 19.3.0.0.0<\/p>\n

SQL> select dbms_xdb_config.gethttpsport FROM DUAL;<\/p>\n

GETHTTPSPORT<\/p>\n

<\/p>\n

5500<\/p>\n

SQL> show parameter dispatchers;<\/p>\n

NAME \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TYPE \u00a0 \u00a0 \u00a0 \u00a0VALUE<\/p>\n

\n

dispatchers \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0string \u00a0 \u00a0 \u00a0(PROTOCOL=TCP) (SERVICE=whs1XDB)
\nmax_dispatchers \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0integer
\nSQL> show parameter listen;<\/p>\n

NAME \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TYPE \u00a0 \u00a0 \u00a0 \u00a0VALUE<\/p>\n

\n

forward_listener \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 string
\nlistener_networks \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0string
\nlocal_listener \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 string \u00a0 \u00a0 \u00a0 (ADDRESS=(PROTOCOL=TCP)(HOST=
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0192.168.0.41)(PORT=1521))
\nremote_listener \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0string \u00a0 \u00a0 \u00a0 catscanip:1521
\nSQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

SQL> select dbms_xdb_config.gethttpsport FROM DUAL;<\/p>\n

GETHTTPSPORT<\/p>\n

<\/p>\n

5500<\/p>\n

SQL> exit
\nDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
\nVersion 19.5.0.0.0<\/p>\n

\u4fee\u6539\u6743\u9650<\/h4>\n

[grid@cat1 ~]$ lsnrctl status | grep -i 5500
\n(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=cat1)(PORT=5500))(Security=(my_wallet_directory=\/u01\/app\/oracle\/product\/19.3.0\/db_1\/admin\/whs1\/xdb_wallet))(Presentation=HTTP)(Session=RAW))
\n[root@cat1 ~]$ cd \/u01\/app\/oracle\/product\/19.3.0\/db_1\/admin\/whs1\/xdb_wallet
\n[root@cat1 xdb_wallet]$ ls -l
\ntotal 8
\n-rw------- 1 oracle asmadmin 3880 Nov 24 2020 cwallet.sso
\n-rw------- 1 oracle asmadmin 3835 Nov 24 2020 ewallet.p12<\/p>\n

\u5982\u679c\u4e0d\u4fee\u6539\u6743\u9650\uff0c\u63a7\u5236\u53f0\u65e0\u6cd5\u663e\u793a\u767b\u5f55\u754c\u9762\u3002\u5728\u4e24\u4e2a\u8282\u70b9\u6267\u884c\u4e0b\u9762\u6743\u9650\u540e\uff0c\u518d\u5237\u65b0\u6d4f\u89c8\u5668\u5730\u5740\u53ef\u6b63\u5e38\u663e\u793a\uff1a
\n[root@cat1 xdb_wallet]$ chmod 777 *
\n[root@cat1 xdb_wallet]$ ls -l
\ntotal 8
\n-rwxrwxrwx 1 oracle asmadmin 3880 Nov 24 2020 cwallet.sso
\n-rwxrwxrwx 1 oracle asmadmin 3835 Nov 24 2020 ewallet.p12<\/p>\n","protected":false},"excerpt":{"rendered":"

19c em \u65e0\u6cd5\u767b\u9646 \u68c0\u67e5\u7aef\u53e3\u914d\u7f6e [oracl<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,51],"tags":[],"class_list":["post-1561","post","type-post","status-publish","format-standard","hentry","category-oracle-19c","category--oracle-19c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1561","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1561"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1561\/revisions"}],"predecessor-version":[{"id":1564,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1561\/revisions\/1564"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1561"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}