Re: Oracle9iAS: Cache Configuration Assistant Alert - ORA-12154

comments embedded

On 30 Sep 2004 09:06:49 -0700, nomorezpam3_at_hotmail.com (Alan) wrote:

<rant deleted>

>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.

BUT NOT IDENTICAL. The 12154 error points to an incorrect tnsnames.ora

>
>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?

you need to be accurate

Is there some hidden/undocumented statement that
>says that I must use the same unix login to install both products...

I don't think it is hidden. Actually I told you so yesterday

>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

--
Sybrand Bakker, Senior Oracle DBA