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 ]