Re: TNS:could not resolve service name

Hi Eric,
I can provide pointers only.
First of all, either in $ORACLE_HOME/rdbms/install or in $ORACLE_HOME/orainst there is a file which should have been logging all your installation choices and responses.
Secondly, the 12154 error tells us you try to connect using a servicename which doesn't exist in tnsnames.ora
The tnsnames.ora either resides in /var/opt/oracle or in $ORACLE_HOME/network/admin. Typically the latter one is not touched during installation, it is only copied. It will definitely not contain the correct host name, and as far as I remember it contains references to localhost (127.0.0.1) only. If you don't have localhost in your /etc/hosts, this may be one source of problems. Anyhow, find the tnsnames.ora and verify it. Thirdly, the LCC error refers to a problem in your $ORACLE_HOME/dbs/init<sid>.ora. Somewhere there is a parameter which doesn't have a value associated.

Hth,

Sybrand Bakker, Oracle DBA

eric.indiogine <eric.indiogine_at_mciworld.com> wrote in message news:Ovxm3.265$%L2.42078_at_PM01NEWS...
> We are trying to install Oracle 7 Workgroup Server on Solaris 2.6.
>
> At the end of the installation we get the following messages:
>
> ORA-12154: TNS:could not resolve service name
> LCC-00161: ORACLE error (possible syntax error) parameter [NULL]
> ORA-03114: not connected to ORACLE
>
> We are following the defaults during install and we have all the
> prerequisites in place.
>
> What are we missing? Thanks for the help!
>
> Eric Indiogine
> Parsons Engineering Science, Inc.
> Salt Lake City, UT
>
>
Received on Sun Jul 25 1999 - 01:57:38 CDT