• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Jeanne Boyarsky
  • Tim Cooke
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
Bartenders:

ORA-12514 error

 
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,
i have two challenges:
1) after installing oracle 10g, i do not have the "Oracle Enterprise Manger".
2) i have being working with a database since last week and suddenly today while trying to open the database through SQL*PLUS, i got this error:
ORA-12514: TNS:listener does not currently know of service request in connect descriptor
please, what's wrong?
 
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
1. if you have installed the client, go back to the CD and select the java console. This looks like the old DBA studio which can view and edit the data or do any dba related stuff. If it is the server, you can access the enterprise manager(dbconsole) through the web. URL similar to http://myhost:5500/em

2. a.Check to see if the database instance has registered with the listener.
Restart the listener.

b. You need to add an entry in tnsnames.ora file located under $ORACLE_HOME/network/admin
looking somewhat like

MYSID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = MYSID))
)

Change the myhost and MYSID (or service name).


Hope it helps!
Beksy
[ July 28, 2005: Message edited by: Beksy Kurian ]
 
Ola Kesh
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks,i seem to be okay now.
 
We're being followed by intergalactic spies! Quick! Take this tiny ad!
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic