having trouble installing 10g
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