• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 16727
  • Last Modified:

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\admin\tnsnames.ora
# 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\admin\listener.ora
# 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))
    )
  )

0
cpursley1979
Asked:
cpursley1979
  • 5
  • 3
  • 3
3 Solutions
 
actonwangCommented:
>>  I had to diable the loopback adapter to get interenet service.

      Why did you disable that? You don't need to, you can use loopback adapter while you use internet connection. look at this:

     http://blogs.msdn.com/virtual_pc_guy/archive/2005/10/04/477195.aspx

   1. On the host operating system go to 'Control Panel'
   2. Go to 'Network Connections'
   3. Right click on the network connection that you use for Internet connectivity and select 'Properties'
   4. Click on the 'Advanced' tab
   5. Check the option to 'Allow other network users to connect through this computer's Internet connection'
   6. If you have multiple network adapters you will need to also specify that you are sharing the Internet connection with the Microsoft Loopback Adapter.
   7. Click 'OK'

Acton
0
 
actonwangCommented:
bring your loopback adaptor back and enable the internet connectoin as above and you should be back to where you were.

Acton
0
 
paquicubaCommented:
You need to startup the instance, see below:

SQL> conn /as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.


Try to connect to SQL*Plus:

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247876 bytes
Variable Size              79693180 bytes
Database Buffers           79691776 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.

Enter user-name: paqui
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

PAQUI@PROD >   <<--------- I'm connected
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
cpursley1979Author Commented:
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?
0
 
actonwangCommented:
>>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
0
 
cpursley1979Author Commented:
I did what tose direction on the loopback adapter saidand I get a warning that my internet connection is intermitant
0
 
paquicubaCommented:
Is your instance up and running?

0
 
actonwangCommented:
you only turn the option on net work connecion you use for internet connection NOT on loopback adapter:


>>Right click on the network connection that you use for Internet connectivity
0
 
paquicubaCommented:
The loopback address must be updated here:

Add a line to the C:\windows\system32\drivers\etc\hosts file

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.
0
 
actonwangCommented:
he could still keep the original loop back adaptor there ...
0
 
cpursley1979Author Commented:
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.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 5
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now