Error creating database link @11g

If you are getting a “ ORA-1017:  invalid username/password; logon denied” when creating a database link, and you ensured to enter the correct password, you probably try it against a 11g database version. In this version is a new feature the “case sensitivity rules”. This statement worked from a 11g db to a 10g database, and threw a exception from 10g to 11g.

create database link testdblink
connect to TESTUSER identified by “testpw”
using ‘tns_for_test’;

Use double-quotes, and check these documents;
What Are the Oracle Database Built-in Password Protections?
http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/authentication.htm#CHDBBGFG

Enabling or Disabling Password Case Sensitivity
http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/authentication.htm#CHDJDCGI

Apex 3.2 upgrade and Image Loading

Before installing, check this requirement documentation according to your environment.

Note that, if your Apex version is lower than 3.1, make shared_pool_size 100M

Steps in installing Oracle Application Express 3.2:

1. Download apex zip file
2. Unzip
3. Copy extracted directory “apex” to $ORACLE_HOME\
   ex. $ORACLE_HOME or C:\\oracle\\product\\10.2.0\\db_1\\
4. Change working directory to apex (on cmd)
   ex. cd C:\\oracle\\product\\10.2.0\\db_1\\apex
5. start sqlplus and connect as SYS
   ex. sqlplus sys/ as sysdba
6. run apexins.sql with the following arguments
   - tablespace_apex – tablespace to be used by Application Express (ex. SYSAUX)
   - tablespace_files – file tablespace to be used by Application Express (ex. SYSAUX)
   - tablespace_temp – temporary table space to be used by Application Express (ex. TEMP)
   - images – the images folder for Application Express (ex./i/)
   ex. @apexins SYSAUX SYSAUX TEMP /i/
7. Load Images & JS:   @apexldimg c:\oracle <apex location>
8. To Change Admin PWD:   @apxchpwd
9. Shutdown immediate & Startup force
10. Enjoy your Application Express 3.2!

If you have any troubles, get the documentation; Oracle Application Express Installation Guide

Good luck.