Enterprise Manager no database

[Lore Leuneog]

Hello.

It's my first experience with an oracle database. (Windows 2000 Server,
Oracle 8i) Installation was just difficult because of the pentium 4 bug with
the 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 is running).

Does anybody have a hint for me what I should look for or check?

[Daniel Morgan]

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 bug withthe 8i version.Now I've got difficulties to discover the database (setup by theinstallation wizard) with the enterprise manager. When I try to discovernodes with the EM I'm getting the VNI 4033 Error - Couldn't obtainrepository session. (I checked the agent service - the service is running).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 connect with.

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Lore Leuneog]

Hallo 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@x.washington.edu> schrieb im Newsbeitrag
news:1067008676.921874@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 bug
withthe 8i version.Now I've got difficulties to discover the database (setup by theinstallation wizard) with the enterprise manager. When I try to discovernodes with the EM I'm getting the VNI 4033 Error - Couldn't obtainrepository session. (I checked the agent service - the service is
running).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 connect
with. -- 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@x.washington.edu (replace 'x' with a 'u' to reply)

[Daniel Morgan]

Lore Leuneog wrote:
Hallo DanielNo, I didn't. I only can see to database instances in the databaseconfiguration assistant:OracleServiceORCL (Installationwizard) and OracleServiceKunden (Copied fromOracle CD). How can I test if the databases are running or how can I startthem without EM.Where could I find the database files? In the database folder of the oraclehome? How are they named - initorcl.ora?Thank youSincerelyLore"Daniel Morgan" <damorgan@x.washington.edu> schrieb im Newsbeitragnews:1067008676.921874@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 theinstallation wizard) with the enterprise manager. When I try to discovernodes with the EM I'm getting the VNI 4033 Error - Couldn't obtainrepository 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 databaseusing SQL*Plus?As what schema owner?Nothing in your post indicates you have a running database to connectwith.--Daniel Morganhttp://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asphttp://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.aspdamorgan@x.washington.edu(replace 'x' with a 'u' to reply)
Start off my opening a DOS window and going to c:\oracle\ora81\bin or
the equivalent bin directory

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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Lore Leuneog]

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

"Daniel Morgan" <damorgan@x.washington.edu> schrieb im Newsbeitrag news:1067014346.563453@yasure...
Lore Leuneog wrote:

Hallo 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@x.washington.edu> schrieb im Newsbeitrag
news:1067008676.921874@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 bug

with

the 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 is

running).

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 connect

with.

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)


Start off my opening a DOS window and going to c:\oracle\ora81\bin or the equivalent bin directory

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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Daniel Morgan]

Lore Leuneog wrote:
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 "Daniel Morgan" <damorgan@x.washington.edu <mailto:damorgan@x.washington.edu>> schrieb im Newsbeitrag news:1067014346.563453@yasure... Lore Leuneog wrote:Hallo DanielNo, I didn't. I only can see to database instances in the databaseconfiguration assistant:OracleServiceORCL (Installationwizard) and OracleServiceKunden (Copied fromOracle CD). How can I test if the databases are running or how can I startthem without EM.Where could I find the database files? In the database folder of the oraclehome? How are they named - initorcl.ora?Thank youSincerelyLore"Daniel Morgan" <damorgan@x.washington.edu> schrieb im Newsbeitragnews:1067008676.921874@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 bug>>with>the 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 is>>running).>Does anybody have a hint for me what I should look for or check?>>>>>First one quick question ... have you logged into the Oracle databaseusing SQL*Plus?As what schema owner?Nothing in your post indicates you have a running database to connectwith.--Daniel Morganhttp://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asphttp://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.aspdamorgan@x.washington.edu(replace 'x' with a 'u' to reply) Start off my opening a DOS window and going to c:\oracle\ora81\bin or the equivalent bin directory 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 Morganhttp://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asphttp://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.aspdamorgan@x.washington.edu(replace 'x' with a 'u' to reply)
At least we now know you have a database, it is open, and accessible.
tab$ is the data dictionary table
that holds metadata about all tables in the database.

That said ... why you can not connect with Intelligent Agent becomes the
next step. Have you checked
in the Windows Control Panel Services to see if its Status is Started?

Have you run through the installation steps to make sure that each
required file exists? Have you looked
at the log files it generates to see what specific errors have been logged?

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Lore Leuneog]

Hello Daniel

This morning the Enterprise Manager didn't show up anymore. I think it was because the Management Server wasn't started. The databases were started. I tried to start the OMS manually. But the error-log I got was (see below). Which file does the OMS get the username/password from? Tank you. Sincerely Lore

*ERROR LOG**************************************
Fehler beim Hochfahren von Oracle Management Server. oemctrl für Windows NT: Version 2.2.0.0.0
Copyright (c) 1998, 2000, Oracle Corporation. Alle Rechte vorbehalten.
Oracle Management Server wird hochgefahren... [main][2003-10-25:12:58:21:234] VdbSession.processError: errorCode >1017<
[main][2003-10-25:12:58:21:234] VdbSession.processError: errorMsg >ORA-01017: invalid username/password; logon denied
<
[main][2003-10-25:12:58:21:234] ORA-01017: invalid username/password; logon denied
: ..../....@jdbc:oracle:oci8:@
[main][2003-10-25:12:58:21:234] VdbSession.processError: invalid connect string

VXA-2018 :
Anmeldung bei OMS-Registrierungsdienst nicht möglichoracle.sysman.vxn.VxnBootstrapException:
at oracle.sysman.vxa.VxaAppServer.startServices(VxaAppServer.java:1353)
at oracle.sysman.vxa.VxaAppServer.main(VxaAppServer.java:2547)

*******************************************************



"Daniel Morgan" <damorgan@x.washington.edu> schrieb im Newsbeitrag news:1067026545.745992@yasure...
Lore Leuneog wrote:

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

"Daniel Morgan" <damorgan@x.washington.edu> schrieb im Newsbeitrag news:1067014346.563453@yasure...
Lore Leuneog wrote:

Hallo 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@x.washington.edu> schrieb im Newsbeitrag
news:1067008676.921874@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 bug

with

the 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 is

running).

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 connect

with.

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)


Start off my opening a DOS window and going to c:\oracle\ora81\bin or the equivalent bin directory

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@x.washington.edu
(replace 'x' with a 'u' to reply)
At least we now know you have a database, it is open, and accessible. tab$ is the data dictionary table
that holds metadata about all tables in the database.

That said ... why you can not connect with Intelligent Agent becomes the next step. Have you checked
in the Windows Control Panel Services to see if its Status is Started?

Have you run through the installation steps to make sure that each required file exists? Have you looked
at the log files it generates to see what specific errors have been logged?

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Daniel Morgan]

Lore Leuneog wrote:
Hello Daniel This morning the Enterprise Manager didn't show up anymore. I think it was because the Management Server wasn't started. The databases were started. I tried to start the OMS manually. But the error-log I got was (see below). Which file does the OMS get the username/password from? Tank you. Sincerely Lore *ERROR LOG************************************** Fehler beim Hochfahren von Oracle Management Server. oemctrl für Windows NT: Version 2.2.0.0.0 Copyright (c) 1998, 2000, Oracle Corporation. Alle Rechte vorbehalten. Oracle Management Server wird hochgefahren... [main][2003-10-25:12:58:21:234] VdbSession.processError: errorCode >1017< [main][2003-10-25:12:58:21:234] VdbSession.processError: errorMsgORA-01017: invalid username/password; logon denied < [main][2003-10-25:12:58:21:234] ORA-01017: invalid username/password; logon denied : ..../....@jdbc:oracle:oci8:@ [main][2003-10-25:12:58:21:234] VdbSession.processError: invalid connect string VXA-2018 : Anmeldung bei OMS-Registrierungsdienst nicht möglichoracle.sysman.vxn.VxnBootstrapException: at oracle.sysman.vxa.VxaAppServer.startServices(VxaAppServer.java:1353) at oracle.sysman.vxa.VxaAppServer.main(VxaAppServer.java:2547) *******************************************************

The only German I can read is chemical literature so some of this is
outside of my ability
to read ... but you are supposed to be supplying the valid userid and
password. Which
leads to the question of what you are doing to start it and what userid
and password you
are supplying.

The default userid and password is: SYSMAN and OEM_TEMP. And they should
still
be that unless you changed them.

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Lore Leuneog]

Hello Daniel

Well, wan't force you to understand german any more. I sat the hole day with my xxx!-oracle server and this is where I'm now:
I rebuild the repository. So the OEM started again but still without showing the databases.

I found out (correct me if it's wrong):
The OEM needs only the agent to start (not the listener). The agent executes the script: network\agent\config\nmiconf.tcl if it starts up.
The script is reading listener.ora, and tnsnames.ora files and generates the agent\services.ora file. (It should read also from the oratab - file but I couldn't find this on my windows 2000 system.) The services.ora file is used by the OEM to generate the nodes when choosing "autodetect nodes...".

In my services.ora file is no entry for the databases, that's why databases aren't shown in the OEM Console. If I add something like:
SQLSRV_server.xyz.local = (oracle_sysman_database, server.xyz.local, ???)
The database node is shown in the OEM.

But: 1) I don't know the right syntax for the services.ora entry (->???). How does your oracle_sysman_database entry in services.ora look like???

2) Every documentation warns to edit the services.ora manually. So how can I convince my nmiconf.tcl to generate the right services.ora? (Some entries to add to listener.ora, and tnsnames.ora ???)

Do you've got any hints???
Thank you very much
Sincerely
Lore

P.S. Are you a chemistry professor in washington???

"Daniel Morgan" <damorgan@x.washington.edu> schrieb im Newsbeitrag news:1067097431.237048@yasure...
Lore Leuneog wrote:

Hello Daniel

This morning the Enterprise Manager didn't show up anymore. I think it was because the Management Server wasn't started. The databases were started. I tried to start the OMS manually. But the error-log I got was (see below). Which file does the OMS get the username/password from? Tank you. Sincerely Lore

*ERROR LOG**************************************
Fehler beim Hochfahren von Oracle Management Server. oemctrl für Windows NT: Version 2.2.0.0.0
Copyright (c) 1998, 2000, Oracle Corporation. Alle Rechte vorbehalten.
Oracle Management Server wird hochgefahren... [main][2003-10-25:12:58:21:234] VdbSession.processError: errorCode >1017<
[main][2003-10-25:12:58:21:234] VdbSession.processError: errorMsg >ORA-01017: invalid username/password; logon denied
<
[main][2003-10-25:12:58:21:234] ORA-01017: invalid username/password; logon denied
: ..../....@jdbc:oracle:oci8:@
[main][2003-10-25:12:58:21:234] VdbSession.processError: invalid connect string

VXA-2018 :
Anmeldung bei OMS-Registrierungsdienst nicht möglichoracle.sysman.vxn.VxnBootstrapException:
at oracle.sysman.vxa.VxaAppServer.startServices(VxaAppServer.java:1353)
at oracle.sysman.vxa.VxaAppServer.main(VxaAppServer.java:2547)

*******************************************************
The only German I can read is chemical literature so some of this is outside of my ability
to read ... but you are supposed to be supplying the valid userid and password. Which
leads to the question of what you are doing to start it and what userid and password you
are supplying.

The default userid and password is: SYSMAN and OEM_TEMP. And they should still
be that unless you changed them.

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Daniel Morgan]

Lore Leuneog wrote:
Hello Daniel Well, wan't force you to understand german any more. I sat the hole day with my xxx!-oracle server and this is where I'm now: I rebuild the repository. So the OEM started again but still without showing the databases. I found out (correct me if it's wrong): The OEM needs only the agent to start (not the listener). The agent executes the script: network\agent\config\nmiconf.tcl if it starts up. The script is reading listener.ora, and tnsnames.ora files and generates the agent\services.ora file. (It should read also from the oratab - file but I couldn't find this on my windows 2000 system.) The services.ora file is used by the OEM to generate the nodes when choosing "autodetect nodes...". In my services.ora file is no entry for the databases, that's why databases aren't shown in the OEM Console. If I add something like: SQLSRV_server.xyz.local = (oracle_sysman_database, server.xyz.local, ???) The database node is shown in the OEM. But: 1) I don't know the right syntax for the services.ora entry (->???). How does your oracle_sysman_database entry in services.ora look like??? 2) Every documentation warns to edit the services.ora manually. So how can I convince my nmiconf.tcl to generate the right services.ora? (Some entries to add to listener.ora, and tnsnames.ora ???) Do you've got any hints??? Thank you very much Sincerely Lore P.S. Are you a chemistry professor in washington??? "Daniel Morgan" <damorgan@x.washington.edu <mailto:damorgan@x.washington.edu>> schrieb im Newsbeitrag news:1067097431.237048@yasure... Lore Leuneog wrote: Hello Daniel This morning the Enterprise Manager didn't show up anymore. I think it was because the Management Server wasn't started. The databases were started. I tried to start the OMS manually. But the error-log I got was (see below). Which file does the OMS get the username/password from? Tank you. Sincerely Lore *ERROR LOG************************************** Fehler beim Hochfahren von Oracle Management Server. oemctrl für Windows NT: Version 2.2.0.0.0 Copyright (c) 1998, 2000, Oracle Corporation. Alle Rechte vorbehalten. Oracle Management Server wird hochgefahren... [main][2003-10-25:12:58:21:234] VdbSession.processError: errorCode >1017< [main][2003-10-25:12:58:21:234] VdbSession.processError: errorMsg >ORA-01017: invalid username/password; logon denied < [main][2003-10-25:12:58:21:234] ORA-01017: invalid username/password; logon denied : ..../....@jdbc:oracle:oci8:@ [main][2003-10-25:12:58:21:234] VdbSession.processError: invalid connect string VXA-2018 : Anmeldung bei OMS-Registrierungsdienst nicht möglichoracle.sysman.vxn.VxnBootstrapException: at oracle.sysman.vxa.VxaAppServer.startServices(VxaAppServer.java:1353) at oracle.sysman.vxa.VxaAppServer.main(VxaAppServer.java:2547) ******************************************************* The only German I can read is chemical literature so some of this is outside of my ability to read ... but you are supposed to be supplying the valid userid and password. Which leads to the question of what you are doing to start it and what userid and password you are supplying. The default userid and password is: SYSMAN and OEM_TEMP. And they should still be that unless you changed them.--Daniel Morganhttp://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asphttp://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.aspdamorgan@x.washington.edu(replace 'x' with a 'u' to reply)
Can anyone else help Lore? It is Sunday and I have no access to my usual
resources on this
for a few days. My thinking is two-fold. First that AI is not required
to use OEM so if you
don't need AI ... ignore it. The other is that you still need to track
down the log files that, as I
recall are stored in $ORACLE_HOME/network/log and/or
$ORACLE_HOME/network/agent/log
and read those log files to find out what is happening.

Sorry I can't help more today.

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Harald Maier]

"Lore Leuneog" <Lore.Leuneog@gmx.net> writes:
Hello Daniel Well, wan't force you to understand german any more. I sat the hole day with my xxx!-oracle server and this is where I'm now: I rebuild the repository. So the OEM started again but still without showing the databases. I found out (correct me if it's wrong):
The OEM needs only the agent to start (not the listener). The agent executes the script: network\agent\config\nmiconf.tcl if it starts up. The script is reading listener.ora, and tnsnames.ora files and generates the agent\services.ora file. (It should read also from the oratab - file but I couldn't find this on my windows 2000 system.) The services.ora file is used by the OEM to generate the nodes when choosing "autodetect nodes...". In my services.ora file is no entry for the databases, that's why databases aren't shown in the OEM Console. If I add something like: SQLSRV_server.xyz.local = (oracle_sysman_database, server.xyz.local, ???) The database node is shown in the OEM. But: 1) I don't know the right syntax for the services.ora entry (->???). How does your oracle_sysman_database entry in services.ora look like??? 2) Every documentation warns to edit the services.ora manually. So how can I convince my nmiconf.tcl to generate the right services.ora? (Some entries to add to listener.ora, and tnsnames.ora ???)

Normally Oracle uses dynamic database registration by the listener.
But not in the case of agentctl. Agentctl needs static entries in the
listener.ora file. Here an excerpt from one of my nodes listener.ora
file.

,----
| SID_LIST_LISTENER =
| (SID_LIST =
| (SID_DESC =
| (SID_NAME = PLSExtProc)
| (ORACLE_HOME = /O2/oracle/9.2.0)
| (PROGRAM = extproc)
| )
| (SID_DESC =
| (GLOBAL_DBNAME = nine)
| (ORACLE_HOME = /O2/oracle/9.2.0)
| (SID_NAME = nine)
| )
`----

You can either edit the listener.ora file with your most favorite
editor or use the netca, netassist or netmgr (9.2) tool.

Harald

[Lore Leuneog]

Thank you very much for your help!!! :-)

The database finally shows up in the OEM. When I had a look into the nmiconf.log file then error message said:
<Warning : No Listener found for SID ORCL. ORCL will be skipped>

When I added the listener entry to the listener.ora file the database was finally added to the services.ora file:

listener.ora:
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=ORCL)
(ORACLE_HOME=F:\ora8)
(SID_NAME=ORCL)
)
)

services.ora:
ORCL = (ORACLE_DATABASE, server.xyz.local, (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521)))(CONNECT_DATA=(SID=ORCL)(SERVER=DEDICATED))), listener_server.xyz.local)

The agent has to be started to use the autodiscovery option of the OEM. But it doesn't have to be started if the databases were added to the navigator tree in the last session.
The listener has to be started to connect the OEM to the database.

So once again: Thank you very much for your help.
Sincerely
Lore

P.S.: The next question I'D like to resolve is: How to store the repository separate from the data tables. Is this possible? But I will start a new thread with this.

[Frank van Bortel]

Lore Leuneog wrote:
Thank you very much for your help!!! :-) The database finally shows up in the OEM. When I had a look into the nmiconf.log file then error message said: <Warning : No Listener found for SID ORCL. ORCL will be skipped> When I added the listener entry to the listener.ora file the database was finally added to the services.ora file: listener.ora: SID_LIST_LISTENER = (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=ORCL) (ORACLE_HOME=F:\ora8) (SID_NAME=ORCL) ) ) services.ora: ORCL = (ORACLE_DATABASE, server.xyz.local, (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521)))(CONNECT_DATA=(SID=ORCL)(SERVER=DEDICATED))), listener_server.xyz.local) The agent has to be started to use the autodiscovery option of the OEM. But it doesn't have to be started if the databases were added to the navigator tree in the last session. The listener has to be started to connect the OEM to the database. So once again: Thank you very much for your help. Sincerely Lore P.S.: The next question I'D like to resolve is: How to store the repository separate from the data tables. Is this possible? But I will start a new thread with this.

create a new database instance. This is the preferred way
(as documented).
You only really need 1 instance with your OEM data for all
instances you want to maintain throughout the company

--
Regards, Frank van Bortel