{"id":17911,"date":"2025-11-24T09:18:27","date_gmt":"2025-11-24T08:18:27","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=17911"},"modified":"2025-11-26T08:05:59","modified_gmt":"2025-11-26T07:05:59","slug":"apex-ords-install","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2025\/11\/24\/apex-ords-install\/","title":{"rendered":"Apex &amp; Ords install"},"content":{"rendered":"\n<p><strong>Verify the validity of an&nbsp;Oracle APEX&nbsp;installation by running a query.<\/strong><\/p>\n\n\n\n<p>SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = &#8216;APEX&#8217;;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"82\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image.png\" alt=\"\" class=\"wp-image-17914\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image.png 570w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-300x43.png 300w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/figure>\n\n\n\n<p><strong>Unzip software, connect to the pdb database<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"633\" height=\"196\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-3.png\" alt=\"\" class=\"wp-image-17917\" style=\"width:567px;height:auto\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-3.png 633w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-3-300x93.png 300w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Check apex tablespace<\/strong><\/p>\n\n\n\n<p>SELECT a.file_name,<br>substr(A.tablespace_name,1,14) tablespace_name,<br>trunc(decode(A.autoextensible,&#8217;YES&#8217;,A.MAXSIZE-A.bytes+b.free,&#8217;NO&#8217;,b.free)\/1024\/1024) free_mb,<br>trunc(a.bytes\/1024\/1024) allocated_mb,<br>trunc(A.MAXSIZE\/1024\/1024) capacity,<br>a.autoextensible ae<br>FROM (<br>SELECT file_id, file_name,<br>tablespace_name,<br>autoextensible,<br>bytes,<br>decode(autoextensible,&#8217;YES&#8217;,maxbytes,bytes) maxsize<br>FROM dba_data_files<br>GROUP BY file_id, file_name,<br>tablespace_name,<br>autoextensible,<br>bytes,<br>decode(autoextensible,&#8217;YES&#8217;,maxbytes,bytes)<br>) a,<br>(SELECT file_id,<br>tablespace_name,<br>sum(bytes) free<br>FROM dba_free_space<br>GROUP BY file_id,<br>tablespace_name<br>) b<br>WHERE a.file_id=b.file_id(+)<br>AND A.tablespace_name=b.tablespace_name(+)<br>ORDER BY A.tablespace_name ASC;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"833\" height=\"42\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/slika-apex.png\" alt=\"\" class=\"wp-image-17918\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/slika-apex.png 833w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/slika-apex-300x15.png 300w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/slika-apex-768x39.png 768w\" sizes=\"auto, (max-width: 833px) 100vw, 833px\" \/><\/figure>\n\n\n\n<p><strong>Install APEX <\/strong><\/p>\n\n\n\n<p><strong>@apexins.sql APEX APEX TEMP \/i\/<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"649\" height=\"305\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-4.png\" alt=\"\" class=\"wp-image-17922\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-4.png 649w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-4-300x141.png 300w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/figure>\n\n\n\n<p><strong>Misc<\/strong><\/p>\n\n\n\n<p>@apxchpwd.sql<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"148\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-5.png\" alt=\"\" class=\"wp-image-17923\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-5.png 640w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-5-300x69.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>@apex_rest_config.sql<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"626\" height=\"301\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-6.png\" alt=\"\" class=\"wp-image-17924\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-6.png 626w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/image-6-300x144.png 300w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><\/figure>\n\n\n\n<p>Accounts settings<\/p>\n\n\n\n<p>SQL&gt; ALTER USER apex_public_user IDENTIFIED BY \u201cOraPassword11!!\u201d ACCOUNT UNLOCK;<br>SQL&gt; CREATE PROFILE password_unlimited LIMIT PASSWORD_LIFE_TIME UNLIMITED;<br>SQL&gt; ALTER USER apex_public_user PROFILE password_unlimited;<br>SQL&gt; exit<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"50\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/slika-apex-3.png\" alt=\"\" class=\"wp-image-17925\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/slika-apex-3.png 631w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2025\/11\/slika-apex-3-300x24.png 300w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>More info:<\/p>\n\n\n\n<p>Links: <a href=\"https:\/\/medium.com\/@fathi.ria\/installing-apex-19-1-on-a-19c-multitenant-database-running-in-oracle-cloud-infrastructure-oci-36229156326\">https:\/\/medium.com\/@fathi.ria\/installing-apex-19-1-on-a-19c-multitenant-database-running-in-oracle-cloud-infrastructure-oci-36229156326<\/a><\/p>\n\n\n\n<p><strong>Uinstall ords <\/strong><\/p>\n\n\n\n<p>1. Run the uninstall command to remove the related database components:<\/p>\n\n\n\n<p>ords uninstall &#8211;log-folder ORDS_LOGS<\/p>\n\n\n\n<p>2. Remove the ORDS configuration directories\/files.<br>For this example, remove the \\databases and \\global directories under D:\\ORDS_config directory.<\/p>\n\n\n\n<p>3. Remove the directories and files under the ORDS product folder.<br>In this example, remove the directories\/files under D:\\ORDS_product directory.<\/p>\n\n\n\n<p>4. Unzip the ORDS 22.1 distribution zip file to get a clean copy of the installation media to ensure that it does not contain residual information that could interfere with the install.<br>That is, unzip to D:\\ORDS_product.<\/p>\n\n\n\n<p>5. Rerun the ORDS install:<\/p>\n\n\n\n<p>ords install &#8211;interactive &#8211;log-folder ORDS_LOGS<\/p>\n\n\n\n<p>More info:<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-rest-data-services\/22.1\/ordig\/installing-and-configuring-oracle-rest-data-services.html#GUID-64480B8A-784E-44D0-912B-07B0924C06D5\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-rest-data-services\/22.1\/ordig\/installing-and-configuring-oracle-rest-data-services.html#GUID-64480B8A-784E-44D0-912B-07B0924C06D5<\/a><\/p>\n\n\n\n<p><strong>How to check if ORDS is running<\/strong><\/p>\n\n\n\n<p>jps -mlv | grep ords<\/p>\n\n\n\n<p>or<\/p>\n\n\n\n<p><span style=\"background-color: rgb(245, 245, 245); color: rgb(56, 56, 56); font-family: Monaco, Consolas, &quot;Andale Mono&quot;, &quot;DejaVu Sans Mono&quot;, monospace; font-size: 18px;\">ps -ef | grep ords.war<\/span><\/p>\n\n\n\n<p><strong>ORDS repair<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>export ORDS_HOME=\/opt\/ords<br>export ORDS_CONFIG=\/opt\/config\/ords<br>export ORDS_LOGS=${ORDS_CONFIG}\/logs<\/p>\n\n\n\n<p>${ORDS_HOME}\/bin\/ords &#8211;config ${ORDS_CONFIG} install repair &#8211;interactive &#8211;log-folder ${ORDS_LOGS}<\/p>\n\n\n\n<p><strong>ORDS install<\/strong><\/p>\n\n\n\n<p>${ORDS_HOME}\/bin\/ords &#8211;config ${ORDS_CONFIG} install &#8211;interactive &#8211;log-folder ${ORDS_LOGS}<\/p>\n\n\n\n<p><strong>ORDS start standalone<\/strong><\/p>\n\n\n\n<p>ords &#8211;config \/opt\/ords\/config serve<\/p>\n\n\n\n<p><strong>ORDS start  as service<\/strong><\/p>\n\n\n\n<p>For a production deployment we should start ORDS as a background process and push the output to a log file. For example, we could create a file called &#8220;\/opt\/ords\/ords_start.sh &#8221; with the following contents. Remember to adjust paths as required.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>!\/bin\/bash<\/p>\n\n\n\n<p>export PATH=\/usr\/sbin:\/usr\/local\/bin:\/usr\/bin:\/usr\/local\/sbin:$PATH<br>export JAVA_HOME=\/u01\/java\/latest<br>export ORDS_HOME=\/opt\/ords<br>export ORDS_CONFIG=\/opt\/ords\/config<br>LOGFILE=\/home\/oracle\/scripts\/logs\/ords-<code>date +\"%Y\"\"%m\"\"%d\"<\/code>.log<br>export _JAVA_OPTIONS=&#8221;-Xms1126M -Xmx1126M&#8221;<br>nohup ${ORDS_HOME}\/bin\/ords &#8211;config ${ORDS_CONFIG} serve >> $LOGFILE 2>&amp;1 &amp;<br>echo &#8220;View log file with : tail -f $LOGFILE&#8221;<\/p>\n\n\n\n<p>cat \/etc\/systemd\/system\/ords.service<\/p>\n\n\n\n<p><br>[Unit]<br>Description=Oracle REST Data Services<br>After=network.target remote-fs.target<br>[Service]<br>User=oracle<br>Group=oinstall<br>Type=oneshot<br>ExecStart=\/opt\/ords\/ords_start.sh start<br>ExecReload=\/opt\/ords\/ords_start.sh restart<br>ExecStop=\/opt\/ords\/ords_start.sh stop<br>RemainAfterExit=yes<br>[Install]<br>WantedBy=multi-user.target graphical.target<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>#systemctl enable ords<br><\/p>\n\n\n\n<p>Created symlink \/etc\/systemd\/system\/multi-user.target.wants\/ords.service \u2192 \/etc\/systemd\/system\/ords.service.<br>Created symlink \/etc\/systemd\/system\/graphical.target.wants\/ords.service \u2192 \/etc\/systemd\/system\/ords.service.<br><\/p>\n\n\n\n<p># systemctl start ords<\/p>\n\n\n\n<p>More info:<\/p>\n\n\n\n<p><a href=\"https:\/\/oracle-base.com\/articles\/misc\/oracle-rest-data-services-ords-standalone-mode-22-onward\">https:\/\/oracle-base.com\/articles\/misc\/oracle-rest-data-services-ords-standalone-mode-22-onward<\/a><\/p>\n\n\n\n<h6 class=\"wp-block-heading\">First login<\/h6>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In earlier installs of APEX (or some sample\/demo setups) a workspace named <strong><code>INTERNAL<\/code><\/strong> often exists by default. <a href=\"https:\/\/oracle-base.com\/articles\/misc\/apex-tips-basic-apex-management?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">oracle-base.com+1<\/a><\/li>\n\n\n\n<li>From user-forums and Q\/A\u2019s: some note that \u201cINTERNAL\u201d + user \u201cADMIN\u201d works as a default for accessing APEX. <a href=\"https:\/\/dba.stackexchange.com\/questions\/25078\/how-do-i-discover-the-oracle-express-workspace-name?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">Database Administrators Stack Exchange+1<\/a><\/li>\n<\/ul>\n\n\n\n<p>More info:<\/p>\n\n\n\n<p><a href=\"https:\/\/oracle-base.com\/articles\/misc\/apex-tips-basic-apex-management\">https:\/\/oracle-base.com\/articles\/misc\/apex-tips-basic-apex-management<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Verify the validity of an&nbsp;Oracle APEX&nbsp;installation by running a query. SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = &#8216;APEX&#8217;; Unzip software, connect to the pdb database Check apex tablespace SELECT a.file_name,substr(A.tablespace_name,1,14) tablespace_name,trunc(decode(A.autoextensible,&#8217;YES&#8217;,A.MAXSIZE-A.bytes+b.free,&#8217;NO&#8217;,b.free)\/1024\/1024) free_mb,trunc(a.bytes\/1024\/1024) allocated_mb,trunc(A.MAXSIZE\/1024\/1024) capacity,a.autoextensible aeFROM (SELECT file_id, file_name,tablespace_name,autoextensible,bytes,decode(autoextensible,&#8217;YES&#8217;,maxbytes,bytes) maxsizeFROM dba_data_filesGROUP BY file_id, file_name,tablespace_name,autoextensible,bytes,decode(autoextensible,&#8217;YES&#8217;,maxbytes,bytes)) a,(SELECT file_id,tablespace_name,sum(bytes) freeFROM dba_free_spaceGROUP BY file_id,tablespace_name) bWHERE a.file_id=b.file_id(+)AND A.tablespace_name=b.tablespace_name(+)ORDER BY A.tablespace_name ASC;&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2025\/11\/24\/apex-ords-install\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Apex &amp; Ords install<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":17945,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[35],"tags":[],"class_list":["post-17911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/17911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=17911"}],"version-history":[{"count":9,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/17911\/revisions"}],"predecessor-version":[{"id":17947,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/17911\/revisions\/17947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media\/17945"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=17911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=17911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=17911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}