Home » RDBMS Server » Enterprise Manager » DBSNMP login Issue (10.2.0.4,SUN 10)
DBSNMP login Issue [message #433847] Fri, 04 December 2009 08:47 Go to next message
SMOKE
Messages: 3
Registered: December 2009
Junior Member
emca -config dbcontrol db -repos recreate

STARTED EMCA at Jul 16, 2008 12:32:27 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Unable to create EM repo.

Enter the following information:
Database SID: RED
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Invalid username/password.
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):

Dec 4, 2009 7:01:14 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/DB/product/10.2.0/db_1/cfgtoollogs/emca/emca_2009-12-04_07-00-42-PM.log.
Dec 4, 2009 7:01:15 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Database instance unavailable.
Refer to the log file at /oracle/DB/product/10.2.0/db_1/cfgtoollogs/emca/emca_2009-12-04_07-00-42-PM.log for more details.
Could not complete the configuration. Refer to the log file at /oracle/DB/product/10.2.0/db_1/cfgtoollogs/emca/emca_2009-12-04_07-00-42-PM.log for more details.
Re: DBSNMP login Issue [message #433850 is a reply to message #433847] Fri, 04 December 2009 09:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you mis-type the password? Otherwise, reset DBSNMP's password in the database and try again and make sure the database is up.

[Updated on: Fri, 04 December 2009 09:34]

Report message to a moderator

Re: DBSNMP login Issue [message #433939 is a reply to message #433850] Sat, 05 December 2009 03:48 Go to previous messageGo to next message
SMOKE
Messages: 3
Registered: December 2009
Junior Member
From SQLPLUS its working but not from here.
I changed the password but still getting same issue
Re: DBSNMP login Issue [message #433955 is a reply to message #433847] Sat, 05 December 2009 10:29 Go to previous messageGo to next message
BlackSwan
Messages: 21967
Registered: January 2009
Senior Member
>Refer to the log file at /oracle/DB/product/10.2.0/db_1/cfgtoollogs/emca/emca_2009-12-04_07-00-42-PM.log for more details.
Any clues in the log file?
As a long shot, is the DBSNMP schema "unlocked"?
Re: DBSNMP login Issue [message #434089 is a reply to message #433847] Mon, 07 December 2009 02:52 Go to previous messageGo to next message
SMOKE
Messages: 3
Registered: December 2009
Junior Member
No Message Body
Re: DBSNMP login Issue [message #434128 is a reply to message #434089] Mon, 07 December 2009 05:54 Go to previous messageGo to next message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

Error: ORA 604

Cause:  An error occurred while processing a recursive SQL statement.
        A recursive SQL statement is one that applies to internal dictionary 
        tables.
Action: If the situation described in the next message on the stack can be 
        corrected, do so; otherwise, contact customer support.


Have you got any internal error message in alert log?

[Updated on: Mon, 07 December 2009 05:57]

Report message to a moderator

Re: DBSNMP login Issue [message #434129 is a reply to message #434128] Mon, 07 December 2009 05:58 Go to previous message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

Quote:
G: Error accessing inventory.
oracle.sysman.oii.oiii.OiiiInventoryDoesNotExistException: The inventory pointed at location /oracle/OWB/product/10.2.0/db_1/ is not
valid
at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initAreaControl(OiiiInstallAreaControl.java:1716)


Do you have vaild oracle inventory?

- Babu
Previous Topic: java.lang.Exception: IOException in sending Request : Connection refused (merged)
Next Topic: core.hung* files
Goto Forum:
  


Current Time: Wed Apr 23 19:02:55 CDT 2014

Total time taken to generate the page: 0.10550 seconds