Upgrade to Apex 4.0

Hi again
After installing Oracle 10g Express Edition , let's upgrade apex to apex 4.0.
But first, we need to check if SQL plus can be called normally from the terminal ,so open the terminal and type sqlplus. If any problem happened you need to do the yellow steps first, if not skip the yellow steps.

1. Fix language error :

Type the following in terminal

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/./oracle_env.sh

If the following error message appeared

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found

Then you need to modify the file oracle_env.sh , the lines from 114,you need to remove the if statements and leave the line "locale=$LANG" using the following command

sudo nano /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh

Then remove if statements then press Ctrl+x to exit and save the file.

2. Set ORACLE_HOME variable:

You need to type the following commands in terminal
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export NLS_LANG
PATH=$ORACLE_HOME/bin:$
PATH
export PATH

3. Download apex 4.0:

4. Unzip the folder in   /tmp/   directory.

5. Type the following commands

cd /tmp/apex
sqlplus / as sysdba
SQL> @apexins SYSAUX SYSAUX TEMP /i/

6. Wait for 10-15 minutes

7.  Finish upgrading phase:

Type the following:
sqlplus / as sysdba
SQL>@apxldimg.sql /tmp

8. Login

Go to http://127.0.0.1:8080/apex , user name :ADMIN  ,password:oracle
if any problem happened and you cannot login , then do the following

sqlplus / as sysdba
SQL>@apxchpwd.sql

and set the ADMIN password.

THE END
Good luck every one.