{"id":627,"date":"2017-03-14T21:48:24","date_gmt":"2017-03-14T13:48:24","guid":{"rendered":"http:\/\/www.rao-bing.cn\/?p=627"},"modified":"2020-01-06T16:13:32","modified_gmt":"2020-01-06T08:13:32","slug":"install-oracle-apex-51-on-12-2","status":"publish","type":"post","link":"http:\/\/www.rao-bing.cn\/index.php\/2017\/03\/14\/627\/","title":{"rendered":"\u5b89\u88c5Oracle APEX\uff08Application Express\uff095.1"},"content":{"rendered":"

<\/h3>\n

Oracle APEX \u7684\u6700\u65b0\u7248\u672c\u662f5.1\uff0c\u8fd9\u4e2a\u7248\u672c\u5f15\u5165\u4e86\u4e00\u4e9b\u65b0\u7279\u6027\uff0c\u6bd4\u5982Oracle JET Chart\uff0c\u5305\u542b\u4e86\u5f88\u591a\u65b0\u7684\u6570\u636e\u53ef\u89c6\u5316\u7684\u56fe\u8868\u7ec4\u4ef6\uff0c\u53ef\u4ee5\u8ba9\u5f00\u53d1\u8005\u5f88\u65b9\u4fbf\u5730\u5f00\u53d1\u4ea4\u4e92\u6027\u5f88\u5f3a\u7684\u56fe\u8868\u5e94\u7528\uff0c\u4f46\u662f\u76ee\u524d\u968f\u7740Oracle Database\u4e00\u8d77\u63d0\u4f9b\u7684APEX \u662f12.2 DB\u5e26\u76845.0.4\u7248\u672c\uff0c\u6240\u4ee5\uff0c\u8981\u60f3\u4f53\u9a8c\u65b0\u529f\u80fd\uff0c\u53ea\u80fd\u5b89\u88c5APEX standalone 5.1\u3002<\/p>\n

\"clip_image001\"<\/a><\/p>\n

APEX\u7b80\u5355\u8bf4\u5c31\u662f\u5b89\u88c5\u5728Oracle\u6570\u636e\u5e93\u4e2d\u4e00\u7cfb\u5217PL\/SQL\u7a0b\u5e8f\u5305\u53ca\u5176\u4ed6\u652f\u6301\u5bf9\u8c61+PL\/SQL gateway\uff0cPL\/SQL Gateway\u548cweb\u670d\u52a1\u5668\u96c6\u6210\u5728\u4e00\u8d77\uff0c\u5c06\u7528\u6237\u7684web\u8bf7\u6c42\u8f6c\u6362\u6210\u5bf9PL\/SQL\u5305\u7684\u8c03\u7528\uff0c\u88ab\u8c03\u7528\u7684PL\/SQL\u7a0b\u5e8f\u5305\uff08\u4e5f\u5c31\u662fAPEX\u7684\u7a0b\u5e8f\uff09\uff0c\u8d1f\u8d23\u54cd\u5e94\u8bf7\u6c42\uff0c\u5e76\u7528PL\/SQL\u8bed\u6cd5\u751f\u6210web\u5185\u5bb9\uff0c\u8fd4\u56de\u7ed9\u5ba2\u6237\uff0c\u6700\u65e9\u5b83\u4e5f\u53ebPSP\uff08PL\/SQL Server Page\uff09\uff0c\u548cJSP\uff08Java Server Page\uff09\u5bf9\u7167\u7740\u770b\uff0c\u5927\u5bb6\u5c31\u660e\u767d\u5b83\u7684\u672c\u8d28\u4e86\u3002<\/p>\n

\u5b89\u88c5APEX\u7684\u8fc7\u7a0b\u4e3b\u8981\u5206\u4e24\u90e8\u5206\uff0c\u7b2c\u4e00\u90e8\u5206\u662f\u5b89\u88c5APEX\u7a0b\u5e8f\uff0c\u5305\u62ec\u4e00\u5217PL\/SQL\u7a0b\u5e8f\u5305\u548c\u5176\u4ed6\u652f\u6301\u5bf9\u8c61\uff0c\u7b2c\u4e8c\u90e8\u5206\u662f\u9009\u62e9\u5e76\u914d\u7f6eweb server\u3002<\/p>\n

\u6570\u636e\u5e93\u5b89\u88c5<\/h4>\n

\u672c\u6b21\u4ee5Oracle Linux 7.1 \u4e0a\u5b89\u88c5\u7684Oracle 12.2.0.1.0\u4e3a\u4f8b\uff0c\u5b89\u88c5\u8fc7\u7a0b\u7701\u7565\u3002<\/p>\n

\u5b89\u88c5APEX\u7a0b\u5e8f<\/h4>\n

\u4ee512.2\u4e3a\u4f8b\uff0c\u4e00\u822c\u662f\u628aAPEX\u5b89\u88c5\u5728CDB\uff0c\u8fd9\u6837\u6240\u6709PDB\u4f7f\u7528\u7684APEX\u90fd\u662f\u540c\u4e00\u7248\u672c\uff0c\u5178\u578b\u7684\u4f8b\u5b50\u5c31\u662fOracle Cloud Service\u91cc\u9762\u7684\u6570\u636e\u5e93\uff0cAPEX\u4e5f\u53ef\u4ee5\u5b89\u88c5\u5728PDB\uff0c\u53ef\u4ee5\u8ba9\u540c\u4e00CBD\u4e0b\u7684\u4e0d\u540cPDB\u7528\u4e0d\u901a\u7684\u7248\u672c\u7684APEX\u3002\uff08\u6211\u4eec\u4f1a\u628aAPEX\u5b89\u88c5\u5728CDB\uff0c\u5c06APEX\u5b89\u88c5\u5728PDB\u7684\u65b9\u6cd5\uff0c\u4ee5\u540e\u5728\u5176\u4ed6\u6587\u7ae0\u4ecb\u7ecd\uff09<\/p>\n

APEX 5.1 \u4e0b\u8f7d\u5730\u5740\uff1ahttp:\/\/www.oracle.com\/technetwork\/developer-tools\/apex\/downloads\/index.html<\/a><\/p>\n

\u5c06\u73b0\u5728\u7684zip\u89e3\u538b\u7f29\uff0c\u8fdb\u5165\u89e3\u538b\u540e\u7684\u76ee\u5f55\uff0c\u6bd4\u5982\/home\/oracle\/apex<\/p>\n

\u4f7f\u7528sys\u7528\u6237\u767b\u5f55\u6570\u636e\u5e93\uff1a<\/p>\n

\u6267\u884cSQL\u811a\u672c\uff1a<\/p>\n

@apexins.sql <tablespace_apex> <tablespace_files> <tablespace_temp> <images><\/p>\n

1) tablespace_apex \u662f\u6307\u5b89\u88c5apex\u7a0b\u5e8f\u7684\u8868\u7a7a\u95f4<\/p>\n

2) tablespace_file\u662f\u6307apex \u6587\u4ef6\u5b58\u653e\u7684\u8868\u7a7a\u95f4\uff08\u56fe\u7247\uff0cccs\u7b49web\u5185\u5bb9\uff09<\/p>\n

3) tablespace_temp\u662f\u6307apex\u7a0b\u5e8f\u8fd0\u884c\u65f6\u6240\u4f7f\u7528\u4e34\u65f6\u8868\u7a7a\u95f4<\/p>\n

4) image\u662f\u6307\u56fe\u7247\u5bf9\u5e94\u865a\u62df\u76ee\u5f55\uff0c\u503c\u4e00\u822c\u4f7f\u7528\u201d\/i\/\u201d<\/p>\n

\u5b9e\u9645\u6267\u884c\u7684\u4f8b\u5b50\uff1aSQL> @apexins.sql SYSAUX SYSAUX TEMP \/i\/<\/p>\n

\u811a\u672c\u5b89\u88c5\u6b63\u5e38\u7684\u7ed3\u675f\u5e94\u8be5\u7c7b\u4f3c\u8fd9\u6837\uff1a<\/p>\n

Thank you for installing Oracle Application Express 5.1.0.00.45\r\n\r\nOracle Application Express is installed in the APEX_050100 schema.\r\n\r\nThe structure of the link to the Application Express administration services is as follows:\r\n\r\nhttp:\/\/host:port\/pls\/apex\/apex_admin (Oracle HTTP Server with mod_plsql)\r\n\r\nhttp:\/\/host:port\/apex\/apex_admin (Oracle XML DB HTTP listener with the embedded PL\/SQL gateway)\r\n\r\nhttp:\/\/host:port\/apex\/apex_admin (Oracle REST Data Services)\r\n\r\nThe structure of the link to the Application Express development interface is as follows:\r\n\r\nhttp:\/\/host:port\/pls\/apex (Oracle HTTP Server with mod_plsql)\r\n\r\nhttp:\/\/host:port\/apex (Oracle XML DB HTTP listener with the embedded PL\/SQL gateway)\r\n\r\nhttp:\/\/host:port\/apex (Oracle REST Data Services)\r\n\r\ntiming for: Phase 3 (Switch)\r\n\r\nElapsed: 00:02:01.85\r\n\r\ntiming for: Complete Installation\r\n\r\nElapsed: 00:13:52.44\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\n1 row selected.\r\n\r\n...null1.sql\r\n\r\nSYS&gt;<\/pre>\n
\u521b\u5efa\u53ca\u66f4\u65b0APEX\u7ba1\u7406\u5458\u53e3\u4ee4<\/h4>\n
\u8fdb\u5165apex\u89e3\u538b\u76ee\u5f55\uff0c\u4ee5sys\u7528\u6237\u8eab\u4efd\u767b\u9646\uff0c\u8fd0\u884c apxchpwd.sql \u811a\u672c\uff0c<\/p>\n
SYS> @apxchpwd.sql\r\n\r\n================================================================================\r\n\r\nThis script can be used to change the password of an Application Express\r\n\r\ninstance administrator. If the user does not yet exist, a user record will be\r\n\r\ncreated.\r\n\r\n================================================================================\r\n\r\nEnter the administrator's username [ADMIN]\r\n\r\nUser \"ADMIN\" does not yet exist and will be created.\r\n\r\nEnter ADMIN's email [ADMIN] raobing@163.com\r\n\r\nEnter ADMIN's password []\r\n\r\nCreated instance administrator ADMIN.\r\n\r\n<\/pre>\n
\u6ce8\u610f\uff0c\u8bbe\u7f6e\u7684\u53e3\u4ee4\u8981\u7b26\u5408\u590d\u6742\u5ea6\u89c4\u5219\uff0c\u6709\u5927\u5199\u53ca\u5c0f\u5199\u5b57\u7b26\uff0c\u6709\u6570\u5b57\u548c\u7279\u6b8a\u7b26\u53f7\uff0c\u81f3\u5c118\u4f4d\u957f\u3002<\/p>\n
Unlock APEX_PUBLIC_USER , change password<\/h4>\n
SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK<\/p>\n
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password<\/p>\n
\u8bb0\u4f4f\u65b0\u8bbe\u7f6e\u7684\u53e3\u4ee4\uff0c\u540e\u9762\u7684web server\u914d\u7f6e\u4f1a\u7528\u5230\u3002<\/p>\n
\u9009\u62e9web listener<\/h4>\n
\u53ef\u9009\u62e9\u7684web listener\u6709\u4e09\u79cd\uff1a<\/p>\n
1\uff09 Oracle REST Data Services \uff08ORDS\uff09<\/p>\n
2\uff09 Oracle HTTP Server with mod_plsql<\/p>\n
3\uff09 Embedded PL\/SQL Gateway<\/p>\n
ORDS\u7684\u524d\u8eab\u65f6APEX Listener\uff0c\u7b80\u5355\u8bf4\uff0c\u5b83\u65e2\u53ef\u4ee5\u5355\u72ec\u4f7f\u7528\uff0c\u6784\u6210web listener + PL\/SQL Gateway\u7684\u5b8c\u6574\u529f\u80fd\uff0c\u4e5f\u53ef\u4ee5\u5f53\u4f5c\u4e00\u4e2a\u5e94\u7528\uff0c\u53d1\u5e03\u5230WebLogic\u4e0a\uff0c\u8ba9WebLogic\u8d1f\u8d23web listener\u7684\u804c\u8d23\uff0cORDS\u53ea\u8d1f\u8d23\u505aPL\/SQL Gateway\u65b9\u9762\u7684\u5de5\u4f5c\u3002<\/p>\n
Oracle HTTP Server\u5927\u5bb6\u90fd\u77e5\u9053\uff0c\u5c31\u662fOracle\u5b9a\u5236\u7684Apache web server\uff0c\u800cmod_plsql\u5c31\u662f\u65f6\u9650PL\/SQL Gateway\u529f\u80fd\u7684\u7ec4\u4ef6\uff0c\u8fd9\u4e2a\u4e5f\u5305\u542b\u5728Oracle HTTP Server\u8f6f\u4ef6\u7684\u53d1\u5e03\u5305\u91cc\u9762\u3002<\/p>\n
Embedded PL\/SQL Gateway\u987e\u540d\u601d\u4e49\uff0c\u5c31\u662f\u5185\u5d4c\u5728\u6570\u636e\u5e93\u79cd\u7684PL\/SQL Gateway\uff0c\u8fd9\u4e2a\u529f\u80fd\u4ece11g\u5f00\u59cb\u51fa\u73b0\uff0c\u8fd9\u662f\u6700\u7b80\u5355\uff0c\u6613\u4e8e\u642d\u5efa\u7684web listener\u5b9e\u73b0\u65b9\u5f0f\uff0c\u4f46\u662f\u4e5f\u6709\u5f88\u591a\u9650\u5236\uff0c\u4e09\u8005\u5177\u4f53\u7684\u5dee\u5f02\uff0c\u89c1\u4e0b\u8868\uff1a<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Capabilities<\/b><\/td>\nOracle REST Data Services<\/b><\/td>\nOracle HTTP Server with mod_plsql<\/b><\/td>\nEmbedded PL\/SQL Gateway<\/b><\/td>\n<\/tr>\n
Image location<\/td>\nFile system<\/td>\nFile system<\/td>\nWithin the database<\/td>\n<\/tr>\n
Configuration options<\/td>\nGUI interface (Release 2.0.3 or later); Administration pages<\/td>\nDatabase Access Descriptor (DAD)<\/td>\nDatabase initialization parameters<\/td>\n<\/tr>\n
Connection Pool settings<\/td>\nJDBC parameters<\/td>\nMin\/MaxSpareServers; MaxClients<\/td>\nSHARED_SERVERS; MAX_SHARED_SERVERS<\/td>\n<\/tr>\n
Emit RESTful Web Services<\/td>\nYes (Release 2.0.3 or later)<\/td>\nNo<\/td>\nNo<\/td>\n<\/tr>\n
Support multi-databases<\/td>\nYes, including Oracle RAC<\/td>\nYes, including Oracle RAC<\/td>\nNo<\/td>\n<\/tr>\n
Virus scan files<\/td>\nYes, with integration of ICAP server<\/td>\nNo<\/td>\nNo<\/td>\n<\/tr>\n
PDF printing<\/td>\nYes, included FOP support<\/td>\nNo<\/td>\nNo<\/td>\n<\/tr>\n
Environment recommendations<\/td>\nAll<\/td>\nAll<\/td>\nDevelopment only<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u8fd9\u6b21\u6211\u4eec\u4e3b\u8981\u4ecb\u7ecdORDS\u642d\u914dWebLogic\u7684\u914d\u7f6e\u65b9\u6cd5\u3002<\/p>\n
\u5b89\u88c5JDK\uff0cWebLogic<\/h4>\n
\u6211\u9009\u7528\u7684JDK \u662f1.8.0_101\uff0c weblogic\u7248\u672c\u662f12.1\uff0c\u5b89\u88c5\u8fc7\u7a0b\u7565\u3002<\/p>\n
Configuring RESTful Services & Static File Support<\/h4>\n
\u8fd9\u4e24\u4e2a\u4e8b\u90fd\u662f\u4f7f\u7528sys\u7528\u6237\uff0c\u6267\u884capex_rest_config.sql\uff08APEX\u89e3\u538b\u76ee\u5f55\u4e0b\uff09\u5c31\u53ef\u4ee5\u4e86\uff0c\u4f1a\u521b\u5efa\u4e24\u4e2a\u7528\u6237\uff0c\u8981\u6c42\u7528\u6237\u7ed9\u51fa\u53e3\u4ee4\uff0c\u6309\u7167\u63d0\u793a\u8f93\u5165\u5c31\u53ef\u4ee5\u4e86\uff0c\u53e3\u4ee4\u8981\u8bb0\u4f4f\uff0c\u540e\u9762\u914d\u7f6e\u65f6\u4f1a\u7528\u5230\u3002<\/p>\n
\u914d\u7f6eORDS<\/h4>\n
\u9996\u5148\u8981\u4f7f\u7528\u547d\u4ee4\u884c\uff0c\u8fdb\u884c\u914d\u7f6e\uff0c\u914d\u7f6e\u8fc7\u7a0b\u4f1a\u521b\u5efa\u51e0\u4e2a\u6570\u636e\u5e93\u7528\u6237\uff0c\u5b89\u88c5\u5fc5\u8981\u7684\u5bf9\u8c61\uff0c\u5e76\u5c06\u914d\u7f6e\u4fe1\u606f\u4fdd\u5b58\u5728params\/ords_params.properties\u6587\u4ef6\u4e2d\u3002<\/p>\n
\u6267\u884c\uff1ajava -jar ords.war install advanced\uff0c\u5e76\u6309\u7167\u63d0\u793a\u8f93\u5165\u4fe1\u606f\u3002<\/p>\n
\r\n[oracle@ol71vm3 ords]$ java -jar ords.war install advanced\r\n\r\nThis Oracle REST Data Services instance has not yet been configured.\r\n\r\nPlease complete the following prompts\r\n\r\nEnter the location to store configuration data:\/home\/oracle\/ords\r\n\r\nEnter the name of the database server [localhost]:\r\n\r\nEnter the database listen port [1521]:\r\n\r\nEnter 1 to specify the database service name, or 2 to specify the database SID [1]:\r\n\r\nEnter the database service name:orcl.hthorizon.com\r\n\r\nEnter 1 if you want to verify\/install Oracle REST Data Services schema or 2 to skip this step [1]:\r\n\r\nEnter the database password for ORDS_PUBLIC_USER:\r\n\r\nConfirm password:\r\n\r\nPlease login with SYSDBA privileges to verify Oracle REST Data Services schema.\r\n\r\nEnter the username with SYSDBA privileges to verify the installation [SYS]:\r\n\r\nEnter the database password for SYS:\r\n\r\nConfirm password:\r\n\r\nPasswords do not match, try again\r\n\r\nEnter the database password for SYS:\r\n\r\nConfirm password:\r\n\r\nEnter the default tablespace for ORDS_METADATA [SYSAUX]:\r\n\r\nEnter the temporary tablespace for ORDS_METADATA [TEMP]:\r\n\r\nEnter the default tablespace for ORDS_PUBLIC_USER [USERS]:\r\n\r\nEnter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:\r\n\r\nEnter 1 if you want to use PL\/SQL Gateway or 2 to skip this step.\r\n\r\nIf using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:\r\n\r\nEnter the PL\/SQL Gateway database user name [APEX_PUBLIC_USER]:\r\n\r\nEnter the database password for APEX_PUBLIC_USER:\r\n\r\nConfirm password:\r\n\r\nEnter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:\r\n\r\nEnter the database password for APEX_LISTENER:\r\n\r\nConfirm password:\r\n\r\nEnter the database password for APEX_REST_PUBLIC_USER:\r\n\r\nConfirm password:\r\n\r\nMar 14, 2017 5:29:40 PM\r\n\r\nINFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt\r\n\r\nInstalling Oracle REST Data Services version 3.0.9.348.07.16\r\n\r\n... Log file written to \/home\/oracle\/ords\/logs\/ords_install_core_2017-03-14_172940_00481.log\r\n\r\n... Verified database prerequisites\r\n\r\n... Created Oracle REST Data Services schema\r\n\r\n... Created Oracle REST Data Services proxy user\r\n\r\n... Granted privileges to Oracle REST Data Services\r\n\r\n... Created Oracle REST Data Services database objects\r\n\r\n... Log file written to \/home\/oracle\/ords\/logs\/ords_install_datamodel_2017-03-14_172958_00872.log\r\n\r\nCompleted installation for Oracle REST Data Services version 3.0.9.348.07.16. Elapsed time: 00:00:20.182\r\n\r\nEnter 1 if you wish to start in standalone mode or 2 to exit [1]:2\r\n<\/pre>\n
\u90e8\u7f72\u5230weblogic\u4e0a<\/h4>\n
\u9996\u5148\u751f\u6210\u56fe\u7247\u8d44\u6e90war\u5305\uff1a<\/p>\n
java -jar ords.war static <apex directory>\\images<\/p>\n
$ java \u2013jar ords.war static \/home\/oracle\/apex\/images<\/p>\n
\u8fd9\u4e2a\u547d\u4ee4\u4f1a\u5728\u5f53\u524d\u76ee\u5f55\u751f\u6210i.war\u5305\uff0c\u547d\u4ee4\u4e5f\u4f1a\u63d0\u793a\uff0c\u8981\u4fdd\u8bc1\/home\/oracle\/apex\/images\u4e00\u76f4\u5b58\u5728\u3002<\/p>\n
\u7136\u540e\u90e8\u7f72ords.war\u548ci.war\u5230weblogic server\u4e0a\uff0c\u7528\u7f3a\u7701\u914d\u7f6e\u521b\u5efa\u4e00\u4e2abase_domain\uff0c\u76f4\u63a5\u90e8\u7f72\u8fd9\u4e24\u4e2a\u5e94\u7528\u5230admin server\u4e0a\u3002<\/p>\n
\u6ce8\u610f\uff0c\u5176\u4ed6\u90fd\u7528\u7f3a\u7701\u503c\uff0c\u53ea\u6709\u201c\u5b89\u5168\u201d\uff0c\u9009\u7b2c\u4e8c\u9879\uff0c\u5982\u4e0b\u56fe\uff1a<\/p>\n
\"clip_image003\"<\/a><\/p>\n
i.war\u4e5f\u662f\u4e00\u6837\uff0c\u53ea\u6709\u5b89\u5168\u9009\u9879\u9009\u7b2c\u4e8c\u9879\uff0c\u7136\u540e\u201c\u6fc0\u6d3b\u66f4\u6539\u201d\uff0c\u542f\u52a8\u4e24\u4e2a\u5e94\u7528\uff1a<\/p>\n
\"clip_image005\"<\/a><\/p>\n
\u91cd\u542fWebLogic\uff0c\u6d4b\u8bd5APEX<\/h4>\n
\u8bbf\u95ee\u5730\u5740\uff1ahttp:\/\/<host>:<port>\/ords\/<\/p>\n
\"clip_image007\"<\/a><\/p>\n
\u4f7f\u7528\u524d\u9762\u8bbe\u7f6e\u7684admin\u8d26\u6237\u767b\u5f55\uff0c\u8fdb\u5165\u7ba1\u7406\u754c\u9762\u65f6\uff0cworkspace\u8981\u5199internal<\/p>\n
\"clip_image009\"<\/a><\/p>\n
\u7b2c\u4e00\u4ef6\u4e8b\u662f\u521b\u5efa\u4e00\u4e2aworkspace\uff1a<\/p>\n
\"clip_image011\"<\/a><\/p>\n
\u6211\u8fd9\u91ccreuse SOE\u8fd9\u4e2a\u7528\u6237\uff1a<\/p>\n
\"clip_image013\"<\/a><\/p>\n
\u8f93\u5165\u7ba1\u7406\u5458\u4fe1\u606f\uff1a<\/p>\n
\"clip_image015\"<\/a><\/p>\n
\u4e0b\u4e00\u6b65\uff0c\u786e\u8ba4\u521b\u5efaworkspace\u3002\u7136\u540e\u63a8\u51fa\u767b\u5f55\uff0c\u91cd\u65b0\u767b\u5f55test workspace<\/p>\n
\"clip_image016\"<\/a><\/p>\n
\u8fdb\u5165workspace\uff0c\u5b89\u88c5\u4e00\u4e2apackaged application\uff0c\u6bd4\u5982sample chart\uff0c\u770b\u770b\u73b0\u5728Oracle JET Chart\u6709\u5565\u65b0\u4e1c\u897f\uff1a<\/p>\n
\"clip_image018\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle APEX \u7684\u6700\u65b0\u7248\u672c\u662f5.1\uff0c\u8fd9\u4e2a\u7248\u672c\u5f15\u5165\u4e86\u4e00\u4e9b\u65b0\u7279\u6027\uff0c\u6bd4\u5982Oracle JET Chart\uff0c\u5305\u542b\u4e86\u5f88\u591a\u65b0\u7684\u6570\u636e\u53ef\u89c6\u5316\u7684\u56fe\u8868\u7ec4\u4ef6\uff0c\u53ef\u4ee5\u8ba9\u5f00\u53d1\u8005\u5f88\u65b9…<\/p>\n
 Read More  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":607,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[6],"tags":[30],"class_list":["post-627","post","type-post","status-publish","format-aside","has-post-thumbnail","hentry","category-oracle","tag-apex","post_format-post-format-aside"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"http:\/\/www.rao-bing.cn\/wp-content\/uploads\/2017\/03\/clip_image001.png","jetpack_shortlink":"https:\/\/wp.me\/p8gSFq-a7","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":518,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/22\/518\/","url_meta":{"origin":627,"position":0},"title":"Oracle Database 12c Data Redaction","author":"raobing","date":"2017-01-22","format":"aside","excerpt":"\u00a0 \u4ec0\u4e48\u662fData Redaction Data Redaction\u662fOracle Dat\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image034_thumb-1.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image034_thumb-1.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image034_thumb-1.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":331,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/19\/331\/","url_meta":{"origin":627,"position":1},"title":"\u57fa\u4e8eOracle\u5b89\u88c5Zabbix","author":"raobing","date":"2017-01-19","format":"aside","excerpt":"\u8f6f\u4ef6\u7248\u672c Oracle Enterprise Linux 7.1 64bit Oracle Ente\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image002.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image002.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image002.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image002.jpg?resize=700%2C400 2x"},"classes":[]},{"id":174,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/07\/174\/","url_meta":{"origin":627,"position":2},"title":"\u4f7f\u7528Oracle\u5b98\u65b9\u5de1\u68c0\u5de5\u5177ORAchk\u5de1\u68c0\u6570\u636e\u5e93","author":"raobing","date":"2017-01-07","format":false,"excerpt":"ORAchk\u6982\u8ff0 ORAchk\u662fOracle\u5b98\u65b9\u51fa\u54c1\u7684Oracle\u4ea7\u54c1\u5065\u5eb7\u68c0\u67e5\u5de5\u5177\uff0c\u53ef\u4ee5\u4eceMOS\uff08M\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1313_OracleO14.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1313_OracleO14.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1313_OracleO14.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1313_OracleO14.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1313_OracleO14.png?resize=1050%2C600 3x"},"classes":[]},{"id":136,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/07\/136\/","url_meta":{"origin":627,"position":3},"title":"\u4f7f\u7528\u6280\u672f\u624b\u6bb5\u9650\u5236DBA\u7684\u5371\u9669\u64cd\u4f5c","author":"raobing","date":"2017-01-07","format":"aside","excerpt":"\u6982\u8ff0 \u4f17\u6240\u5468\u77e5\uff0c\u5728\u4e1a\u52a1\u9ad8\u5cf0\u671f\uff0c\u67d0\u4e9b\u9488\u5bf9Oracle\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u5177\u6709\u5f88\u9ad8\u7684\u98ce\u9669\uff0c\u6bd4\u5982\u4fee\u6539\u8868\u7ed3\u6784\u3001\u4fee\u6539\u5b9e\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1123_1.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":182,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/07\/182\/","url_meta":{"origin":627,"position":4},"title":"Database Replay\u548cConsolidated Database replay","author":"raobing","date":"2017-01-07","format":false,"excerpt":"\u7b80\u4ecb \u5728\u6570\u636e\u5e93\u7684\u8fc1\u79fb\u548c\u5347\u7ea7\u573a\u666f\u4e2d\uff0c\u6211\u4eec\u7ecf\u5e38\u4f1a\u9047\u5230\u4e00\u4e2a\u95ee\u9898\uff1a\u5728\u505a\u538b\u529b\u6d4b\u8bd5\u65f6\uff0c\u5982\u4f55\u6a21\u62df\u771f\u5b9e\u7684\u4e1a\u52a1\u538b\u529b\uff0c\u89e3\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=525%2C300 1.5x"},"classes":[]},{"id":848,"url":"http:\/\/www.rao-bing.cn\/index.php\/2018\/01\/11\/848\/","url_meta":{"origin":627,"position":5},"title":"\u4f7f\u7528Oracle EM13c\u7ba1\u7406\u6570\u636e\u5e93\u79c1\u6709\u4e91","author":"raobing","date":"2018-01-11","format":"aside","excerpt":"\u5b9e\u73b0Oracle\u6570\u636e\u5e93\u79c1\u6709\u4e91\u7684\u65b9\u5f0f\u6709\u4e24\u7c7b\uff1aIaaS\u548cPaaS\uff0c\u56e0\u4e3aIaaS\u4f1a\u4f7f\u7528\u57fa\u7840\u67b6\u6784\u865a\u62df\u5316\u6280\u672f\uff0c\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2018\/01\/clip_image044_thumb.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2018\/01\/clip_image044_thumb.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2018\/01\/clip_image044_thumb.jpg?resize=525%2C300 1.5x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/627","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/comments?post=627"}],"version-history":[{"count":4,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/627\/revisions"}],"predecessor-version":[{"id":744,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/627\/revisions\/744"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/media\/607"}],"wp:attachment":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/media?parent=627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/categories?post=627"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/tags?post=627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}