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?
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