Re: Enterprise Manager no database
From: Lore Leuneog <Lore.Leuneog_at_gmx.net>
Date: Fri, 24 Oct 2003 19:19:20 +0200
Message-ID: <bnbmku$pal$05$1_at_news.t-online.com>
Date: Fri, 24 Oct 2003 19:19:20 +0200
Message-ID: <bnbmku$pal$05$1_at_news.t-online.com>
Hello Daniel
1) The listener started without a
problem.
2) The svrmgrl-select-statement
returned:
count(*)
----------
334
1 row selected
(By the way what did I count? What means
tab$?)
3) Connection with system/manager suceeded also.
But why can't I connect with the new user I created with the oracle
administration assistent for windows nt?
4) The Database is still not found by the
Enteprise Service. Do I've to install an intelligent agent on the database? And
how can I see where (on which objects) intelligent agents are
installed?
Thank you very much
Sincerely
Lore
Received on Fri Oct 24 2003 - 19:19:20 CEST"Daniel Morgan" <damorgan_at_x.washington.edu> schrieb im Newsbeitrag news:1067014346.563453_at_yasure...Lore Leuneog wrote:
Start off my opening a DOS window and going to c:\oracle\ora81\bin or the equivalent bin directoryHallo Daniel No, I didn't. I only can see to database instances in the database configuration assistant: OracleServiceORCL (Installationwizard) and OracleServiceKunden (Copied from Oracle CD). How can I test if the databases are running or how can I start them without EM. Where could I find the database files? In the database folder of the oracle home? How are they named - initorcl.ora? Thank you Sincerely Lore "Daniel Morgan" <damorgan_at_x.washington.edu> schrieb im Newsbeitrag news:1067008676.921874_at_yasure...Lore Leuneog wrote:Hello. It's my first experience with an oracle database. (Windows 2000 Server, Oracle 8i) Installation was just difficult because of the pentium 4 bugwiththe 8i version. Now I've got difficulties to discover the database (setup by the installation wizard) with the enterprise manager. When I try to discover nodes with the EM I'm getting the VNI 4033 Error - Couldn't obtain repository session. (I checked the agent service - the service isrunning).Does anybody have a hint for me what I should look for or check?First one quick question ... have you logged into the Oracle database using SQL*Plus? As what schema owner? Nothing in your post indicates you have a running database to connectwith.-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)
First try this at the DOS prompt:
lsnrctl status
If the listener is running it will report back a time that it has been running. If not try:
lsnrctl start
and then try the status again. If you get any error messages copy off the complete message. Don't
just tell us what you think it said and means.
If the listener is running, and still at the DOS prompt try this:
Log in Server Manager ... svrmgrl
Then type: CONNECT INTERNAL
Then try this SQL statement: SELECT COUNT(*) FROM tab$;
If you get any error messages post the complete message.
If that works try logging in through SQL*Plus using userid SYSTEM and password MANAGER,
While logged on as SYSTEM do not create any objects or perform any inserts, updates, or deletes.
Just to this to check whether things are working.-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)