cross posted to comp.database.o racle 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_LIS TENER = ADMIN
---------------------
sqlnet.ora Network Configuration File:
SQLNET.AUTHENTI CATION_SERVICES = (NTS)
TRACE_LEVEL_CLI ENT = USER
NAMES.DIRECTORY _PATH= (HOSTNAME, TNSNAMES, EZCONNECT)
TRACE_LEVEL_SER VER = USER
NAMES.DEFAULT_D OMAIN = mycomputer.com
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_LIS TENER = ADMIN
---------------------
sqlnet.ora Network Configuration File:
SQLNET.AUTHENTI CATION_SERVICES = (NTS)
TRACE_LEVEL_CLI ENT = USER
NAMES.DIRECTORY _PATH= (HOSTNAME, TNSNAMES, EZCONNECT)
TRACE_LEVEL_SER VER = USER
NAMES.DEFAULT_D OMAIN = mycomputer.com