Re: Help please with installation

you could try specifying 2: (that's a numeral two followed by a colon) as the Host String. that worked for the local database with PO7. I'm not sure if that will still work or not.

You could try changing the line in TNSNAMES.ORA from

   Host = localhost
to

   Host = 127.0.0.1

and see if you can get the tcp loopback to work. there may be a sample tcp loopback entry already in the tnsnames.ora.

"Mart Hurst" <Wayfarergenesis_at_Xworldnet.att.net> wrote in message news:7Kyw5.16060$6f1.720436_at_bgtnsc05-news.ops.worldnet.att.net...
> Am currently enrolled in an Oracle class and bought Oracle8i Personal
> Edition for Windows 98 and am having problems getting it to function. Any
> help much appreciated.
>
> I read all of the instructions before trying to install, and seemed to have
> no problems installing; had no warnings or error messages. However when I
> got to the part about configuring Oracle by starting the Oracle Listener I
> began to have problems. Oracle Listner started without a problem, the
> database started, but when I go to the sign on screen where we were to sign
> on according to their installation instructions as user name: system
> password: manager Host String: po8
> I got error message: "Oracle SQL*Plus Error: ORA-12154: TNS:could not
> resolve service name."
>
> I went to their help and found this:
>
> ORA-12154 TNS:could not resolve service name
>
> Cause The service name specified is not defined correctly in the
> TNSNAMES.ORA file.
> Action Make the following checks and correct the error:
>
> · Verify that a TNSNAMES.ORA file exists and is in the proper place and
> accessible. See the operating system specific manual for details on the
> required name and location.
> · Check to see that the service name exists in one of the TNSNAMES.ORA files
> and add it if necessary.
> · Make sure there are no syntax errors anywhere in the file. Particularly
> look for unmatched parentheses or stray characters. Any error in a
> TNSNAMES.ORA file makes it unusable. See Chapter 4 in the SQL*Net V2
> Administrator's Guide. If possible, regenerate the configuration files using
> the Oracle Network Manager.
>
> Copyright (C) 1998, Oracle Corporation
>
> The installation instructions said to navigate to C:\Ora95dev\Net80\Admin
> and highlight and copy the "TcpExample.world" section to the bottom of the
> list and change the copy to:
>
> po8.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = localhost)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>
> which I did before starting the listener. So I don't know what to do from
> here?
>
> Remove X after @ to reply
>
>
>
>
Received on Fri Sep 15 2000 - 22:22:10 CDT