Oracle DBA Corner

Did you install Enterprise manger? What OS are you running on (cos i can see something about XP)?
if you did, try the following
set ORACLE_SID= 'your sid'
cd $ORACLE_HOME/agent10/home (i dont know your exact path but cd to the Agent home on your OS.
cd /bin
At the prompt
./emctl status agent.

This will tell you the status of the agent, if any xml fimes are being uploaded and how many are pending.

From the error you posted I would think you SID is Db_1.

type ./emctl stop agent
then do
./emctl start agent

instead of using the set option for the Oracle sid, use
export ORACLE_SID=sid.

Besides, how many times have you installed and unistalled Oracle on the computer. Because, even when you do an install, OUI does no clean up the registry, so EM might still be pointing to a previous intallation.
In this case you might have to do a manual registry clean up (please be careful when cleaning up your registry.

@Le Moor
But sometimes the reward is always worth the trouble dont you think?I am still waiting on your materials

@jimblaze
Maybe its the CD? is it original?

@A-40,the cd is not original but despite that i have been using EM b4 this happened,
@ Le Moor i know my sid is orcl,even though i still ran select name from v$database and it gave me orcl,i then set the oracle_sid as orcl, but after that it still gave me the error, EM configuration issue C:\ORACLE\PRODUCT\10.1.0\DB_1\JIMSPC_ORCL NOT FOUND, now the answers to your question

1)i did not start it after a clean install, all the services were started,and i never stopped it,i just woke up one day and found out i could not log on to EM,so i then checked services and found out that oracledbconsoleorcl was stopped,which is strange because it starts automatically,i then tried to start it to no avail
2)checked dba_users and did not see any sysman account ,but the dbsnmp account is there and its open,and the listener points to the right database

I know you know that name of your sid. I was just running a process of elimination, since i am not there to see the machine. And I was kindda hoping, it might have been a case of misspelling.
I find it strange that you don't have a sysman user. Because by default, the sysman account is the owner of enterprise manager and grid control. And you really cant do anything without it. Whilst the dbsnmp account is the 'gateway' for gathering metrics from targets.

Do you get an TZ errors? timezone issues

hmmm,
something isnt right.
How many Oracle Services do you have in you registry?

Are they all started now? And while you were installing, did you get any errors in the preconfig check you ignored?

I have working knowedge of some ETL tools. But not Globus. We presently use Informatica for our data warehouse and reporting needs.
OWB is one of those tools that hasnt really garnared much recognition as an in-built oracle tool by larger firms. Mainly because of scalability issues.

What proposals do you want to send forward. Dataware housing is different from DBA, although related, they have different concepts. If you already use Globus, (which i believe a lot of banks in Nigeria use), then there is already a building block of the business requirements, and you probably won have to start from scratch.

@Le Moor all my services are started except dbconsoleorcl which refuses to start and thats the main reason i cant run EM
@A-40 yea i know what u r going through
@ Le Moor,hey have u got anything on Globus?by the way whats Globus?  :)heared bout it when i asked a banker for a job and he said i should learn globus first

there are Various methods to add new users in a database:

CREATE USER user_name IDENTIFIED BY password;

CREATE USER uwclass IDENTIFIED BY uwclass;

CREATE USER user IDENTIFIED {BY password |
EXTERNALLY}

[DEFAULT TABLESPACE tablespace]
[TEMPORARY TABLESPACE tablespace]
[ { QUOTA {n [K|M] | UNLIMITED} ON
tablespace } [, ,  ] ]
[PROFILE profile]
} [ ,  ];

u have to apply caution while doing this,i can also assist with the dumps, ukwuomakk@yahoo.com

@Le Moor
Maybe he means you should be careful with the system and object privileges you give them.Did you see my email i sent you a few questions?

Hey guys its been quite a while, how are we all doing missed ya, i just read up the DBA corner and saw that i have missed alot well i hope i fit in.

Now if your having a problem startin your EM and its associated with an oracle file there a probability that the file has been deleted, in most instance the file is already associated with the database so it impossible to replace. but there are options, lets say 3 of which one is a little bit tricky and if anybody has an opinion on these options please feel free to state them. After configuring routers and VPN concentrator for the past 6 to 7 months i might just be a little rusty.

1) If a database that you use practicem, you can as well delete it and create a new database using your DBCA (sounds very easy)

2)  if you have data you cant afford to loose, You can delete the database after you have used OS commands to backup the datafiles and after you create  a new database you can import your files back into the database using DP utility (advance and a little bit time comsuming)

3) Uninstall oracle using oracle universal installer, make sure that you delete all datafiles and directory, also make sure that you removes all oracle entries from your registry and the install a fresh copy of oracle.


there might be other solutions but as for me am very sure about this becasue i havebeen in the same situation b4,


thanks

Do you know that www. o-mattwealthlynks. webnode. com is giving free online wealth creation coaching?Visit them to have a teastof what financial freedom is all about

hey guys i have done it oooo!i got EM working again,it miight seem small to all you oracle pros but hey am on my way oooo!by the grace of God

ENTERPRISE MANAGER PROBLEMS I ENCOUNTERED AND HOW I SOLVED THEM
PROBLEM:
Oracle EM was not opening anytime I tried to  open it through internet explorer. I checked oracle services and found out that oracledbconsoleorcl was stopped which was unusual because its startup type is automatic. I tried to start it manually but it would not yield. I  went to command prompt and ran  EMCTL   START  and I got the following error   : ORACLE_SID NOT DEFINED……PLS DEFINE IT, so I defined with the following command : SET ORACLE_SID=ORCL, I then tried to start emctl again but I got the following error: EM CONFIGURATION ISSUE NOT LOCATE  C:\ORACLE\, 127.0.0.1_ORCL   which was strange because there is no such folder in  C:\oracle\product\10.1.0\Db_1 and the closest folder to it was localhost_orcl.
SOLUTION
Anyway I guessed that EM could not start because for some reason  it was looking for the folder 127.0.0.1_orcl  instead of  localhost_orcl, 127.0.0.1 being my IP address (will confirm when next am online).
I then made a copy of the folder localhost_orcl and  changed the name to 127.0.0.1 and pasted it in the same folder being Db_1.When back to command prompt and typed EMCTL START but I got another EM configuration issue saying that EM  could not locate folder   C:\oracle\product\10.1.0\Db_1\oc4j\j2ee\OC4J_DBConsole_127.0.0.1_orcl, by the grace of our almighty GOD I figured out that I had to replace any folder name that had localhost to my IP address being 127.0.0.1, so as above I created duplicate folder and changed OC4J_DBCONSOLE_LOCALHOST_ORCL TO OC4J_DBConsole_127.0.0.1_orcl.When back to services and started oracledbconsoleorcl, when to internet explorer and  PRAISE THE LORD! 
Enterprise manager opened and I logged on.HALLELUYAH!

Congrats Man i guess you have learnt something new.Besides have you written your OCP's yet? I am also having problems with my EM but i am sure it has to do with my OS Oracle on Vista is a mess

@Le Moor
thanks bros for the encouragement u've been giving we young and upcoming dba's. keep it up.i have a redhat linux version 4, running on my laptop, but want to install oracle 10g on it, but don't know how to go about the configuration of linux for oracle 10g. can i get any help, link or material for doing that. thanks.my e-mail deebsman@yahoo.co.uk