Upgrade Apex to 3.2 in Oracle XE

  1. Download apex3.2
  2. Unzip and place it in c:\oraclexe\
  3. In command prompt type cd c:\oraclexe\apex
  4. Then run sqlplus connect – sys as sysdba
  5. Declare oracle_home
  6. Then type 

    @apexins password SYSAUX SYSAUX TEMP /i/

Once you complete the standard install, you need to perform the following steps to complete the upgrade:

  1. Connect to SQL*Plus as SYS
  2. @APEX_HOME/apex/apxldimg.sql APEX_HOME
  3. @APEX_HOME/apex/apxxepwd.sql password
    (where password is the password of the Application Express internal ADMIN account)
  4. For the steps above, APEX_HOME is the directory where the Application Express software was unzipped. In our case c:\oraclexe\

Comments

Post a Comment

Popular posts from this blog

PRKH-1010 : Unable to communicate with CRS services

OS : AIX 5L Oracle 10g RAC Error message on one of the nodes PRKH - 1010 : Unable to communicate with CRS services I faced a typical issue.     The localconfig command has been used for a single instance RDBMS. There is absolutely no requirement to run localconfig on RAC system and it should never be used on RAC system as it will destroy the CRS configuration When the localconfig reset was run on only one system the following things happened. Ocr.loc was created at /etc/oracle/ora.loc. Cat /etc/oracle/ocr.loc is like : Ocrconfig_loc=<$ORACLE_HOME>/cdata/localhost/local.ocr Local_only=true   Cat /etc/inittab is like H1:35:respaw:/etc/init.d/init.evmd run >/dev/null 2>&1</dev/null H3:35:respawn:/etc/init.d/init.crsd run >/dev/null 2>&2 </dev/null H1:35:respawn:/etcc/init.d/init.dcssd run >/dev/null 2>&1 </dev/null<<< this one   As root Run the following scripts $ORA_CRS_HOME/install/rootdelete.sh $ORA_CRS_HOME/install/rootdeinstall...
Read more

vi Commands

What is vi? The default editor that comes with the UNIX operating system is called vi (visual editor). The UNIX vi editor is a full screen editor and has two modes of operation: Command mode commands which cause action to be taken on the file, and Insert mode in which entered text is inserted into the file. In the command mode, every character typed is a command that does something to the text file being edited; a character typed in the command mode may even cause the vi editor to enter the insert mode. In the insert mode, every character typed is added to the text in the file; pressing the (Escape) key turns off the Insert mode. While there are a number of vi commands, just a handful of these is usually sufficient for beginning vi users. To assist such users, this Web page contains a sampling of basic vi commands. The most basic and useful commands are marked with an asterisk (* or star) in the tables below. With practice, these commands should become automatic. NO...
Read more

Dr. Walter Semkiw

I met Dr. Walter Semkiw on Jun 24, 2009. "Yes, reincarnating souls have same facial features", says Walter Semkiw, MD, author of the popular international bestseller BORN AGAIN, which became an instant hit with celebrity cases of Amitabh Bachchan, Shah Rukh Khan, former President Abdul Kalam, Indira Gandhi and a host of other Indian political legends and film stars. I met Mr.Walter Semkiw on his visit to India to promote his new book ORIGIN OF THE SOUL AND THE PURPOSE OF REINCARNATION published by Ritana Books. Walter Semkiw, MD, is a partner and practices medicine at Kaiser Permanente in San Francisco,USA, the largest medical group in the United States. In addition, he is the author of books on objective evidence of reincarnation which have been published in India, Indonesian, Serbia and the United States. In his presentations and book signings at Landmark Bookshops in Gurgaon [24 th June] , Dr Semkiw reviewed independently researched cases that demonstrate objective evide...
Read more