From: spam@hotmail.com   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)