cpursley1979
asked on
ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
I had the install up and running months before my network was moved to a different location. This is Oracle 10g Personal Edition, so of course it required a Loopback Adapter. When I moved the ip address of my home network got shuffled around. I had to diable the loopback adapter to get interenet service. I have created another loopback adapter with an ip addres I believe to be free on my network.
I am trying to use the SQL*Plus utility, and it gave this error: ORA-12514:TNS:listener does not currently know of service requested in connect descriptor.
In my services:
the tns listerner is started
My tnsnames.ora:
# tnsnames.ora Network Configuration File: C:\oracle10g\ora92\network
# Generated by Oracle configuration tools.
LMS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = EMERALD)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LMS)
)
)
CS335 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = emerald)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cs335)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
my listener.ora:
# listener.ora Network Configuration File: C:\oracle10g\ora92\network
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle10g\ora92)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = EMERALD)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
I am trying to use the SQL*Plus utility, and it gave this error: ORA-12514:TNS:listener does not currently know of service requested in connect descriptor.
In my services:
the tns listerner is started
My tnsnames.ora:
# tnsnames.ora Network Configuration File: C:\oracle10g\ora92\network
# Generated by Oracle configuration tools.
LMS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = EMERALD)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LMS)
)
)
CS335 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = emerald)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cs335)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
my listener.ora:
# listener.ora Network Configuration File: C:\oracle10g\ora92\network
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle10g\ora92)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = EMERALD)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In the advance tab I set the ip address for the loopback adapter as 192.168.0.5 even though my computers ip is 192.168.0.1.3 Is this wrong?
>>192.168.0.1.3
? is it 192.168.0.13
look at the aritcle, if you are using xp, you might need to switch your home network to 192.168.1.xx or others
? is it 192.168.0.13
look at the aritcle, if you are using xp, you might need to switch your home network to 192.168.1.xx or others
ASKER
I did what tose direction on the loopback adapter saidand I get a warning that my internet connection is intermitant
Is your instance up and running?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The loopback address must be updated here:
Add a line to the C:\windows\system32\driver
IP_address hostname
I.E.
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
180.15.10.128 123.mysite.com.
192.168.100.100 paquicuba.mysite.com.
Add a line to the C:\windows\system32\driver
IP_address hostname
I.E.
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
180.15.10.128 123.mysite.com.
192.168.100.100 paquicuba.mysite.com.
he could still keep the original loop back adaptor there ...
ASKER
You helped a bunch, solution was as you said to bring back the loop back adapter and change the right click on loopback adapter in Network Connections and goto properties > Configure > Advanced Tab > change the 'medium' to the item in the drop down box to ARCNET and give the item 'Network Address' a value outside the range on the router.
Acton