ORA-12514 error

[Ola Kesh]

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?

[Beksy Kurian]

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]

Thanks,i seem to be okay now.