I urgently need help with starting enterprise manager. i had my school graduation project implemented using Oracle 10g, this was in 2009.
now, i want to use this project for a job interview presentation but Enterprise manager wouldn't come up.
I try starting it from windows services it didn't work. i discover my service name is "orcl"
i change directory to Oracle_home and try to start it with .\emctl start dbconsole
but it said Oracle_sid is not set.
i set oracle_sid : set oracle_sid=orcl
but when i try staring it again via .\emctl start dbconsole is says "orcl" NOT FOUND.
LASTLY, I tried sqlplus *
SQL > host echo %oracle_sid%
but the command screen pop up and quickly disappear.
but when i run a query on the tables in the database it returns data, this prove to me that the database is working.
NOTE: the only noticeable change on my part is that: at the time i install the database,
i had the java 1.4 (j2sdk 1.4) compiler which i replace with with the current j2sdk 1.6 this year. i wonder if compiler change could pose a problem.
I have since change the compiler back to j2sdk 1.4 buy still it didn't work.