![](/uploads/1/2/7/6/127638871/399713181.jpg)
Feb 06, 2010 Hi, I have to upgrade the database from 8.1.7.3 to 10.2.0.4.1(Does 10.2.0.4.1 reflects cpu/psu patch status?) OS =HP-UNIX 11.11 Does cpu/psu patch comes along with 10.2.0.4 patchset?What is the best way to upgrade the database? Below is the steps what I am thinking to implement: (1) apply patchset8.1.7.4 and upgrade database by running catalog.sql and catproc.sql. Aug 14, 2008 I am in the process of upgrading it to 10.2.0.4From the above statement I understand that the steps performed was just sequentials: 1. Installed the base release 2. Created a database (not using a pre-defined structure - just a general purpose db) 3. Trying to upgrade to 10.2.0.4 Considering this scenario, my suggested plan is 100% applicable.
I have problem with installing Oracle 10.2.0.4 on Windows Server 2012 R2.We are running old 10.2.0.4 instance on Windows Server 2008 R2. Now I have to migrate it to the Windows Server 2012 R2. Because the application using the db is old and without support, it is very risky to migrate the db to 11g or 12c.
![Oracle xe patch 10.2.0.4 1 Oracle xe patch 10.2.0.4 1](http://www.hhutzler.de/blog/wp-content/uploads/2017/05/Install_MemberCluster_p41.jpg)
This blog post shows you how to upgrade APEX Version 4.0.2 on a default Oracle Database 11g XE instance to APEX 5.1.2. O was just a bit too short and missed some details. It divided into five parts.
The first part confirms your starting point. The second part downloads and positions the extracted software.
The third part installs APEX 5. The fourth part configures APEX 5. The fifth part shows you how to access and get to the APEX 5 home page.Confirm APEX 4 Installation. Verify the database version by connecting as the system user through SQL.Plus and running the following query.
NAME TYPE VALUE-memorytarget big integer 1GNAME TYPE VALUE-memorytarget big integer 1G. Oracle’s instructions qualify that APEX 5 will install into the APEX050000 schema. Oracle creates the new APEX050000 schema with a default of the sysaux and temp table space. You can verify these as the system user through SQL.Plus by running the following two queries.
The first one checks for the tablespaces and the second for available space and auto extensibility. Tablespace Available AutoName File Name Space MB Extensible-SYSAUX /u01/app/oracle/oradata/XE/sysaux.dbf 32,027.98 YESSYSTEM /u01/app/oracle/oradata/XE/system.dbf 200.00 YESTablespace Available AutoName File Name Space MB Extensible-SYSAUX /u01/app/oracle/oradata/XE/sysaux.dbf 32,027.98 YESSYSTEM /u01/app/oracle/oradata/XE/system.dbf 200.00 YESDownload APEX 5. Download the APEX software from the Oracle web site. Assuming you download the software as the student user, you can save it in your Downloads directory.You should open a Terminal session and connect as the oracle user. If you’ve setup your instance correctly, you will need to first become the root user and then the oracle user. As the oracle user, you source the Oracle environment and copy the apexx.x.x.zip file from the student/Downloads directory to the /u01/app/oracle directory.
You copy the file from the student user’s Downloads directory with the following command. COLUMN username FORMAT A18 HEADING 'User Name' COLUMN accountstatus FORMAT A10 HEADING 'Account Status' SELECT username, accountstatusFROM dbausersWHERE username IN ( 'APEXPUBLICUSER', 'ANONYMOUS' );COLUMN username FORMAT A18 HEADING 'User Name'COLUMN accountstatus FORMAT A10 HEADING 'Account Status'SELECT username, accountstatusFROM dbausersWHERE username IN ('APEXPUBLICUSER','ANONYMOUS');It should return the following when you’re upgrading the Oracle Database 11g XE but the anonymous user name may be open if you’ve previously unlocked it. DEFAULTTABLESPACE TEMPORARYTABLESPACE- -SYSAUX TEMPDEFAULTTABLESPACE TEMPORARYTABLESPACE- -SYSAUX TEMP. Open a Terminal session, connect as the oracle user, source the Oracle environment file, and change your active directory to the /u01/app/oracle/apex directory, and open a SQL.Plus connection as the sys user. You need superuser privileges, which means you need to connect to the Oracle database with the “ sys as sysdba” syntax.
APIVersion Number Compatibility Patch Applied-5.1.2.08.24 APPLIEDAPIVersion Number Compatibility Patch Applied-5.1.2.08.24 APPLIEDConfigure APEX 5. At this point, you need to set the internal password, which you can do by navigating to the /u01/app/oracle/apex directory. In that directory, you should open a SQL.Plus session as the sys user with the “ sys as sysdba” privilege. Run the following script to set the APEX Administrator’s credentials. This script can be used to change the password of an Application Expressinstance administrator.
If the user does not yet exist, a user record will becreated.Enter the administrator's username ADMIN ADMINUser 'ADMIN' exists.Enter ADMIN's email ADMIN [email protected] ADMIN's password Changed password of instance administrator ADMIN.This script can be used to change the password of an Application Expressinstance administrator. If the user does not yet exist, a user record will becreated.Enter the administrator's username ADMIN ADMINUser 'ADMIN' exists.Enter ADMIN's email ADMIN [email protected] ADMIN's password Changed password of instance administrator ADMIN. The next task requires you to run the apexepgconfig.sql script with one directory parameter. You should be connect to the sys user with the “ sys as sysdba” privilege. Should display the following login. The password is the one you entered when you ran the apxchpwd.sql script in the configuration section of this post.After you enter proper credentials, click the Sign in to Administration button to proceed. It should display the following APEX 5 home page.You can now work in APEX 5 Administration and setup a individual workspaces.Cleanup APEX 4Migrating functionality to APEX 5 is possible but reworking the existing design in the context of new features is better.
After you have migrated your applications and upgraded your production instance, you can drop the APEX040000 user/schema and remove any APEX 4 workspaces. This segment of shows you how to remove an APEX 4 workspace and drop the APEX040000 user/schema. The following anonymous PL/SQL block will remove an APEX 4 workspace from a user schema. It’s designed for you to run it inside the target schema but you can change it to run it as the system user against multiple schemas. DECLARE /.
Cursor for all APEX 4 tables and sequences. Recent Posts.Things Written About Things Written About Pages.Blogroll.Archives.
![](/uploads/1/2/7/6/127638871/399713181.jpg)