Win a copy of Beginning Java 17 Fundamentals: Object-Oriented Programming in Java 17 this week in the Java in General forum!
  • 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:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

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.
 
WHAT is your favorite color? Blue, no yellow, ahhhhhhh! Tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic