having trouble installing 10g

From: George <spam_at_hotmail.com>
Date: Fri, 25 Jun 2004 23:25:21 GMT
Message-ID: <Bv2Dc.9938$E84.6769_at_edtnps89>



cross posted to comp.database.oracle by mistake.

I'm getting the infamous ora 12154 - TNS could not resolve connect identifier error.
My computer is running windows 2000 pro in standalone mode (not connected to a network).
I used the oracle 10g install program to install the software without the database
and everything went fine.
I then used the assistants to set the parameters for the listener etc. Next I attempted to install a database using the database configuration assistant).
I called the database 'test' and used the default values. during the copying database phase I got the following error messages:

ora 12154 - TNS could not resolve connect identifier. ora 01031 - insufficient privileges

Thanks in advance for any assistance in resolving this.

My configuration files are listed below:

hosts file:
127.0.0.1 localhost
10.10.10.10 mycomputer.com # loopBack for oracle

Installed a Microsoft loopback adaptor with a network address of 10.10.10.10 submask: 255.255.255.0

The loopback is configured with tcip, and set as the first connection in the list of connections.

# tnsnames.ora Network Configuration File:

TEST.MYCOMPUTER.COM =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = mycomputer.com)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = test)

    )
  )

# listener.ora Network Configuration File: LISTENER =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mycomputer.com)(PORT = 1521))
  )

TRACE_LEVEL_LISTENER = ADMIN


 sqlnet.ora Network Configuration File:

SQLNET.AUTHENTICATION_SERVICES= (NTS) TRACE_LEVEL_CLIENT = USER NAMES.DIRECTORY_PATH= (HOSTNAME, TNSNAMES, EZCONNECT) TRACE_LEVEL_SERVER = USER NAMES.DEFAULT_DOMAIN = mycomputer.com Received on Sat Jun 26 2004 - 01:25:21 CEST

Original text of this message