Is there an entry in the tnsnames in the home you are running "sqlplus system/******@test" from? If so, I have also seen a situation where everything appeared proper but the db gave an ORA-12514 and the fix was to manually (no copy/paste) rewrite the listener.ora entry. Apparently it had some hidden character/space/other format glitch that caused issues as the rewrite fixed it. (Manually rewriting the tnsnames entry is worth trying as well.) -- //www.freelists.org/webpage/oracle-l