Oracle9iAS: Cache Configuration Assistant Alert - ORA-12154

I am so sick of Oracle's installation instructions; I've struggled totally with Oracle9iDB but have got through it in 2-3 days only to find that Oracle9iAS has just as bad a guide and I'm 2 days into this now.

I've installed the majority of the product (I think - I hope) but I'm running into problems with the "Cache Configuration Assistant, step 1 of 1 : Origin Database Credentials" screen (when running $ORACLE_HOME/bin/wtacca).

I exited out of the standard (runInstaller) installer to have a look around before re-starting the install using wtacca - but immediately ran into JRE problems which through random problem solving came down to having JAVA_HOME set (not that any documentation ever said anything about this!). But now I'm getting a "Cache Configuration Assistant Alert" stating "Connecting to the Origin Database failed. Reason: ORA-12154: TNS: could not resolve service name".

I'm installing Oracle9iAS Enterprise on a Solaris8 using an "orac9ias" unix login that has oinstall as a group, having already installed Oracle9i DB as "orac9i" unix login that also has oinstall as its group.

The Oracle9i DB install used a different $ORACLE_HOME setting to the Oracle9iAS install but both $ORACLE_HOME/network/admin directories contain similar listener.ora and tnsnames.ora files.

If I use the orac9i (db) login to access my test database (through sqlplus) - it works fine (once I've startup the db), but the same sqlplus does not seem to work using the orac9ias login (different ORACLE_HOME I guess)

Why is this not easy? Is there some hidden/undocumented statement that says that I must use the same unix login to install both products... surely this exposes permission risks? Can anyone tell me why I get this 12154 error in the Cache Configuration Assistant?

Any help would be much appreciated.
Thanks
Alan Received on Thu Sep 30 2004 - 11:06:49 CDT