{"id":58,"date":"2015-04-16T21:23:33","date_gmt":"2015-04-16T18:23:33","guid":{"rendered":"http:\/\/antyat.ru\/?p=58"},"modified":"2015-04-16T21:23:33","modified_gmt":"2015-04-16T18:23:33","slug":"upgrade-apex-4-0-2-%d0%b4%d0%be-4-2-6","status":"publish","type":"post","link":"http:\/\/antyat.ru\/?p=58","title":{"rendered":"Upgrade APex 4.0.2 \u0434\u043e 4.2.6"},"content":{"rendered":"<div>\n<h2>Oracle Application Express<\/h2>\n<h1>Upgrading Oracle Application Express within Oracle Database Express Edition (XE)<\/h1>\n<p>Oracle Database 11 g Express Edition (Oracle XE) includes Oracle Application Express release 4.0. It is strongly recommended that you upgrade to the latest release of Oracle Application Express to take advantage of all the latest features.<\/p>\n<\/div>\n<div>\n<h3>How to Upgrade<\/h3>\n<p>To install the latest version of Oracle Application Express in your Oracle Database XE, first <a href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/apex\/downloads\/index.html\" target=\"_window\">download<\/a> the latest version of Application Express from the Oracle Technology Network.<\/p>\n<p><strong>1. Unzip the downloadloaded zip file:<\/strong><\/p>\n<ul class=\"oAML\">\n<li><strong>Linux:<\/strong> Unzip &lt;filename&gt;.zip<\/li>\n<li><strong>Windows:<\/strong> Double click &lt;filename&gt;.zip in Windows Explorer<\/li>\n<li>[Note: You should keep the directory tree where you unzip the files short and not under directories that contain spaces.<br \/>\nFor example, within Windows unzip to C:\\.]<\/li>\n<\/ul>\n<p><strong>2. Change your working directory to apex.<\/strong><\/p>\n<p><strong>3. Start SQL*Plus and connect to the Oracle XE database:<\/strong><\/p>\n<ul class=\"oAML\">\n<li><strong>Linux:<\/strong>\n<pre>$ sqlplus \/nolog\r\n\tSQL&gt; CONNECT SYS as SYSDBA\r\n\tEnter Password:\t\r\n\t<em>SYS_Password<\/em><\/pre>\n<\/li>\n<li><strong>Windows:<\/strong>\n<pre>{Command prompt} C:\\apex&gt; sqlplus \/nolog\r\n\tSQL&gt; CONNECT SYS as SYSDBA\r\n\tEnter Password:\t\r\n\t<em>SYS_Password<\/em>\r\n<\/pre>\n<\/li>\n<li>[Note: You should keep the directory tree where you unzip the files short and not under directories that contain spaces.<br \/>\nFor example, within Windows unzip to C:\\.]<\/li>\n<\/ul>\n<p><strong>4. Install Application Express:<\/strong><\/p>\n<ul class=\"oAML\">\n<li>\n<pre>SQL&gt; @apexins SYSAUX SYSAUX TEMP \/i\/<\/pre>\n<\/li>\n<\/ul>\n<p><strong>5. Log back into SQL*Plus (as above) and load images:<\/strong><\/p>\n<ul class=\"oAML\">\n<li>\n<pre>SQL&gt; @apxldimg.sql APEX_HOME<\/pre>\n<\/li>\n<li>[Note: APEX_HOME is the directory you specified when unzipping the file. For example, with Windows &#8216;C:\\&#8217;.]<\/li>\n<\/ul>\n<p><strong>6. Upgrade Application Express password:<\/strong><\/p>\n<ul class=\"oAML\">\n<li>\n<pre>SQL&gt; @apxchpwd\r\nEnter password for Application Express ADMIN account.<\/pre>\n<\/li>\n<\/ul>\n<p><strong>7. In a Web browser, navigate to the Oracle Application Express Administration Services application:<\/strong><\/p>\n<ul class=\"oAML\">\n<li>http:\/\/localhost:8080\/apex\/apex_admin<\/li>\n<li>In Username, enter ADMIN<\/li>\n<li>In Password, enter the password entered in Step 6<\/li>\n<\/ul>\n<\/div>\n<div>\n<h1>Oracle Database 10 g Express Edition Specific Considerations<\/h1>\n<h3>\nInterface Differences between Oracle APEX 2.1 and later versions of Application Express<\/h3>\n<p>Oracle Database 10 g Express Edition (Oracle XE) includes Oracle Application Express release 2.1<\/p>\n<p>When accessing your upgraded Oracle APEX, you will be presented with a login page that prompts for Workspace, Username and Password. Previously, you were only prompted for Username and Password. To login, your Workspace would just be the same as your Username. It is important to note that within Application Express, the change password function changes only your Application Express password, not your database password. Once you upgrade, your schema is associated with your workspace but your database account is now separate. If you create new database users, they will not automatically have access to Application Express.<\/p>\n<p>The Home page will appear different. As noted below, most database administration functions are not part of Application Express. Two exceptions are the Database Monitor and About Database which are found under the Administration menu. There are no icons for the Object Browser and SQL, those functions are part of the SQL Workshop. Other Administration functions pertain mostly to the administration of the workspace, not the database.<\/p>\n<\/div>\n<div>\n<h3>Database Management Differences between Oracle APEX 2.1 and later versions of Application Express<\/h3>\n<p>Once you upgrade Application Express within your Oracle Database XE, you will lose the Oracle APEX interface to perform some of your database management functions. This includes the ability to create and alter users, set database parameters, etc. To perform these functions, you will need to use either <a href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\/overview\/index.html\" target=\"_window\">SQL Developer<\/a> or SQL*Plus.<\/p>\n<p>The following is a list of database management functions that cannot be performed in later versions of Application Express but that were features of Oracle APEX 2.1, the default interface of Oracle Database XE. For each, there is a SQL Statement provided that can be executed either in a SQL Worksheet of Oracle SQL Developer or using SQL*Plus when connected to your Oracle Database XE. Most of these commands need to be executed as the user SYS.<\/p>\n<ul>\n<li><strong>Change my Password<\/strong><br \/>\n<em>Location: <\/em>under Tasks (also under Database Users)<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>alter user [username] identified by [new_password];\r\n<\/pre>\n<p><em>Notes:<\/em> Within SQL Developer, right-click a user under Other Users, select Edit User, use the New Password and Confirm Password.<\/p>\n<p>Please note that this will change your database user password. Once you upgrade, your database account is associated with your Application Express account but the passwords are separate. A change to one does not affect the other.<\/li>\n<li><strong>Manage HTTP Access<\/strong><br \/>\n<em>Location: <\/em>under Tasks<br \/>\n<em>SQL Statement: <\/em><br \/>\n<strong>To set HTTP Access to Local only:<\/strong><\/p>\n<pre>exec dbms_xdb.setListenerLocalAccess\r\n(l_access =&gt; TRUE);<\/pre>\n<p><strong>To set HTTP Access to allow remote connects:<\/strong><\/p>\n<pre>exec dbms_xdb.setListenerLocalAccess\r\n(l_access =&gt; FALSE);<\/pre>\n<\/li>\n<li><strong>Usage Monitor<\/strong><br \/>\n<em>Location: <\/em>LOC<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>select nvl(b.tablespace_name,\r\nnvl(a.tablespace_name,'UNKNOWN'))\r\ntablespace_name,\r\nkbytes_alloc kbytes,\r\nkbytes_alloc-nvl(kbytes_free,0) \r\nsize_alloc_bytes,\r\nround(((kbytes_alloc-nvl(kbytes_free,0))\/\r\nkbytes_alloc)*200) used_chart,\r\nto_char(((kbytes_alloc-nvl(kbytes_free,0))\/\r\nkbytes_alloc)*100,\r\n'999G999G999G999G999G999G990D00') ||'%' used,\r\ndata_files\r\nfrom ( select sum(bytes)\/1024\/1024 Kbytes_free,\r\n\tmax(bytes)\/1024\/1024 largest,\r\n\ttablespace_name\r\nfrom sys.dba_free_space\r\ngroup by tablespace_name ) a,\r\n( select sum(bytes)\/1024\/1024 Kbytes_alloc,\r\n\ttablespace_name, count(*) data_files\r\nfrom sys.dba_data_files\r\ngroup by tablespace_name )b\r\nwhere a.tablespace_name (+) = b.tablespace_name\r\n<\/pre>\n<p><em>Notes:<\/em> You can access a Workspace Utilization report in Oracle APEX 3.0.1 under Administration &gt; Manage Services &gt; Workspace Overview &gt; Detailed Tablespace Utilization Report.<\/li>\n<li><strong>View Logging Status<\/strong><br \/>\n<em>Location: <\/em>Storage<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>select log_mode \r\n  from v$database;\r\n<\/pre>\n<\/li>\n<li><strong>Compact Storage<\/strong><br \/>\n<em>Location: <\/em>Storage<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>exec dbms_space.database_level_shrink;<\/pre>\n<\/li>\n<li><strong>Configure SGA<\/strong><br \/>\n<em>Location: <\/em>Memory<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>alter system \r\n\tset sga_target = sga_target \r\n\tscope=spfile;\r\n<\/pre>\n<\/li>\n<li><strong>Configure PGA<\/strong><br \/>\n<em>Location: <\/em>Memory<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>alter system \r\n\tset pga_aggregate_target = pga_agg_target \r\n\tscope=both;<\/pre>\n<\/li>\n<li><strong>Create Database User<\/strong><br \/>\n<em>Location: <\/em>Database Users<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>create user [username] identified by [password];<\/pre>\n<p><em>Notes:<\/em> Within SQL Developer, right-click on the Other Users node under your XE-SYS connection and select Create User.<\/li>\n<li><strong>Drop Database User<\/strong><br \/>\n<em>Location: <\/em>Database Users<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>drop user [username];<\/pre>\n<p><em>Notes:<\/em> Within SQL Developer, you can also right-click on the Other Users node under your XE connection and select Drop User.<\/li>\n<li><strong>Lock Database Account<\/strong><br \/>\n<em>Location: <\/em>Database Users<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>alter user [username] account lock;<\/pre>\n<p><em>Notes:<\/em> Within SQL Developer, right-click a user under Other Users under your XE-SYS connection. Select edit user and check &#8216;Account is Locked&#8217;.<\/li>\n<li><strong>Unlock Database Account<\/strong><br \/>\n<em>Location: <\/em>Database Users<br \/>\n<em>SQL Statement:<\/em><\/p>\n<pre>alter user [username] account unlock;<\/pre>\n<p><em>Notes:<\/em> Within SQL Developer, right-click a user under Other Users under your XE-SYS connection. Select edit user and uncheck &#8216;Account is Locked&#8217;.<\/li>\n<li><strong>Note<\/strong> The location is within the Home &gt; Administration menu of the Oracle Database XE interface.<\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Application Express Upgrading Oracle Application Express within Oracle Database Express Edition (XE) Oracle Database 11 g Express Edition (Oracle XE) includes Oracle Application Express release 4.0. It is strongly recommended that you upgrade to the latest release of Oracle Application Express to take advantage of all the latest features. How to Upgrade To install [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-58","post","type-post","status-publish","format-standard","hentry","category-1"],"_links":{"self":[{"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/posts\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/antyat.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=58"}],"version-history":[{"count":1,"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":59,"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/posts\/58\/revisions\/59"}],"wp:attachment":[{"href":"http:\/\/antyat.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/antyat.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/antyat.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}