Enterprise Manager :: Failed To Connect To Database Instance
Oct 27, 2011
When login i'm getting error : Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin).
I have checked DBCONSOLE & AGENT are running properly.
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_SID=infoddp
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOME=/opt/oracle/product/11.2.0
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOSTNAME=liteningv
litening:/opt/oracle/product/11.2.0/bin>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
[code].....
View 10 Replies
ADVERTISEMENT
Dec 12, 2010
I've checked ALL the parameters. It seems to be OK.The db is running and OK.But when I try to configure the EM I get the following error Says that the databse instance is not available.But, tnsping works ok, and I can connect as sys without problems. the DB is OK.
EMCA iniciado en 12-dic-2010 12:54:17
Asistente de Configuraci¾n EM, Versi¾n 11.2.0.0.2 Producci¾n
Copyright (c) 2003, 2005, Oracle. Todos los Derechos Reservados.
[code]....
View 3 Replies
View Related
Jun 4, 2012
I'm have in Oracle version Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production:
while enter in a command
$emctl status dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Oracle Enterprise Manager 10g is running.
----------------------------------------------------------------------------------
$emctl stop dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
-----------------------------------------------------------------------------------
$emctl start dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
-----------------------------------------------------------------------------------
View 1 Replies
View Related
Nov 17, 2012
I have intsalled oracle client 9i.I add my services into tnsnames.ora .I could connect in sqlplus but in Enterprise manager i receive error ora12154 tns could not resolve service name!
View 4 Replies
View Related
Sep 13, 2011
I have to apply monitoring template on my databases. Databases are already added and configured into OEM. They are visible under Databases tab and also under Groups where I have added them.
But when I try applying monitoring template and look for database in search window, it doesn't appear there.
View 1 Replies
View Related
Nov 11, 2011
I am Not able to connect to the Database through the web Browser,
I have started Listener, EM, and i have checked the port number is in Listen mode all is working but not connecting to the EM through web browser.
View 8 Replies
View Related
Dec 20, 2010
i have already give the grant option cnnect,resource to scott but it is not connecting to enter prise manager console of Oracle database 11gR1. i am getting this error while connecting "The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information"
when i am giving scott the dba rights then it is connecting. but i cann't give dba rights to scott.so, how/what is the specific command to give permission scott for connecting to enter prise manager console.
View 1 Replies
View Related
Jul 29, 2013
when i install a db using the Assistant Configuartion Database i get no error exept this:
Enterprise manager configuration failed due to the following error - Listener is not up. Start the listener and run EM configuration again. Refer to the log file at C:\Oracle\cfgtoollogs\dbca\emConfig. Log for more details. You can retry configuring this database with Enterprise Manager later by manually running C:\Oracle\product\11.1.0\db_1\bin\emca script.
So I try lsnrctl start and i get:
C:\Windows\system32>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:26:25
Copyright © 1991, 2010, Oracle. All rights reserved.
TNS-01106: Il listener con nome LISTENER � stato gi� avviato
So I try lsnrctl status and i get:
C:\Windows\system32>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:23:34
Copyright © 1991, 2010, Oracle. All rights reserved.
Connessione a (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
[code]...
The file "server.xml" in E:\app\Andrea.Rimoldi\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\ does not exist...
Is there any way to retrieve or recover this file?
View 11 Replies
View Related
Jan 20, 2010
I create an instance with oracle scripts,.. postDBCreation.sql :
-SERVICE_NAME cag1.crick.cagis.gov should be cag1.mycrof.cagis.gov .... ultraSearchCfg.sql SERVICE_NAME=cag1.crick.cagis.gov should be ca1.mycrof.cagis.gov .. Impact: All DBlinks show as LINKNAME.CRICK.CAGIS.GOV and this instance is labeled CAG1.CRICK.CAGIS.GOV in the Grid Control Console.
View 5 Replies
View Related
Mar 30, 2011
I have created a new instance with address
[URL].......
Now ideally I would like to change this so I can access this from another a machine. Is this possible? Or do I have start from scratch?
View 4 Replies
View Related
Apr 26, 2007
When i am trying to start dbconsole, it throughs error:
oracle@aaa:aaa:>emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.4
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://aaa:5500/em/console/aboutApplication
[Code].....
View 9 Replies
View Related
Sep 14, 2013
I have configured OEM and is up and running but, I am getting below error message when open the OEM URL.
Error Message:
Secure Connection Failed / an error occurred during a connection to rhel6:1158.
The page you are trying to view can not be shown because the authenticity of the received data could not be verified.
View 2 Replies
View Related
Jul 6, 2010
I've experienced an error while installing the Application Management Pack 3 on Linux Machine (OS: Oracle Enterprise Linux 5.3 32-bit) with EM Grid Control 10g Release 5. I want to install the Grid Control Plug-in Oracle E-Business Suite Management Pack 3 to manage our EBS Oracle Apps R12, but it was failed due to error. Below was the logs for error:
Log: /u01/app/oraInventory/logs/installActions2010-07-06_03-00-11PM.log
RepManager was not able to run successfully.
/applications/em/em/WEB-INF/lib/myjar.jar:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emCfg.jar:/u01/a
pp/oracle/OracleHomes/oms10g/jlib/ojmisc.jar:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emUpgrade.jar
:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emagentSDK.jar oracle.apps.oms_extn.util.EBSOUIUtil RepMa
[code].....
View 1 Replies
View Related
Oct 3, 2010
At the end of my installation I received the following error message:
Sep 11, 2010 4:20:49 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
Refer to the log file at /u01/app/oracle/cfgtoollogs/dbca/orcl/emConfig.log for more details.
Sep 11, 2010 4:20:49 PM oracle.sysman.emcp.EMConfig perform
[code]....
I found a thread that reported a similar issue and was directed to Oracle Support Document 353843.1 . The suggestion was to adjust the /etc/hosts file, but I don't see anything wrong in the file:
[oracle@jhlinux etc]$ cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
127.0.0.1 localhost.localdomain localhost
192.168.1.254 jhlinux.home.com jhlinux
View 9 Replies
View Related
Jul 16, 2008
Is that possible to make Oracle Enterprise Manager of 10gr2 connect to multiple oracle database?
View 1 Replies
View Related
Jul 19, 2012
I am running ORACLE 10.2.0 on Windows Virtual PC. System: Microsoft Windows XP SP3.
Yesterday I wanted to make a copy of my Virtual Machine Hard Drive Image. I directly copied all the files to my external hard drive, but I forgot shutting down my virtual machine when I was doing this.
Today I found my instance failed startup.
In OEM, it is showing:
Agent Connection to Instance
Status: Failed
Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
In SQLPlus:
SQL> connect sys/password as sysdba
Connected to an idle instance
SQL> startup
ORACLE instance started.
[code]....
View 3 Replies
View Related
Oct 31, 2012
I cant able to connect to my local DB instance. Oracle service for DB instance will be started running when the system boots automatically.I faced this problem before, I was instructed to boot my system without network connection. It worked for few days. Suddenly I cant able to connect to my local DB instance again, even though I am booting my system without network connection.
This is the configuration I have in tnsnames.ora in my local machine.I have the host as localhost, because local machine is laptop and IP will change periodically.
CSS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CSS)
[code]....
View 14 Replies
View Related
Aug 21, 2010
I am having a database running in my windows 2003 server and I want to configure Enterprise manager for that database to check the resource utilization during the peak hours and also the number of transactions...
View 1 Replies
View Related
Feb 2, 2010
We have the Oracle Enterprise Manager Grid Control 10.2.0.5. We recently upgraded our Databases from 10.2.0.3 to 10.2.0.4 and since then we are having this problem.
Whenever i click an Agent on the Grid Control it gives me this error: "Communication between the Oracle Management Service host to the Agent host is unavailable. Any functions or displayed information requiring this communication link will be unavailable. For example: deleting/configuring/adding targets, uploading metric data, or displaying Agent home page information such as Agent to Management Service Response Time (ms)."
I get the same error when i try to configure a host or a database.
Don't know what is wrong
View 4 Replies
View Related
Sep 4, 2013
I have an issue with restoring a RMAN backup that i have with me to a new database instance. What i have with me are: 1. Backup of SPFile.
(O1_MF_NCNNF_CTLFILE_BU_92DVGYO2_.BKP)2. Backup of Control file (O1_MF_NNSNF_SPFILE_BU_92DVGW9H_.BKP)3. Full database backup (O1_MF_NNSNF_FULLPROD_BU_92DVGW9H_.BKP)
I have received these files from a customer environment and I need to restore these to a new database instance in a local machine. I have given a attempt as follows (in Oracle 10g): 1, Created a new database instance (Test75) using Oracle Database Configuration Assistant2. SET ORACLE_SID = Test753. Connected to this instance using RMAN4. Tried to restore the SPFILE from the received BKP file.I am getting errors and cannot proceed. I am not sure whether I am executing the correct steps.
View 6 Replies
View Related
Apr 20, 2012
I have two differenct databases with nsame name. Database 1 named DBX is on server SERVERX used for dev Database 2 named DBX is on server SERVERY used for test
I want to install OEM Agent on both server and access from one single OEM 11g Grid control.
What I find is that, the OEM seems to get confused when I try to login to the A database from OEM.
How should I configure OEM or Agent so that OEM can be used to login to both DBs?
View 3 Replies
View Related
Jul 6, 2010
I have oracle9i installed on my system.. i have created a database using enterprise manger console..
Now i want to export this database for the purpose of backup.. so that i can import it later.
View 1 Replies
View Related
Feb 1, 2013
What database version is supported as a repository for 10g OMS?
View 5 Replies
View Related
Aug 12, 2010
I have installed OUI( Oracle universal insaller) and the with DBCA(Database Configuration Assistant) i have installed the database. Before DBCA completion of Database it give error message like database control not running. When i press OK the DBCA completed and database installed but where it shows the database control url it shows database url is null. when i try to give this url http://sweetdba:1158/em it shows error. why the url is not working. 11g database is working and connected.
View 4 Replies
View Related
Jul 25, 2012
I would like to export my whole database every evening. How can I do this using enterprise manager.
View 4 Replies
View Related
Jul 28, 2012
I installed Oracle database 11g enterprise edition. I can connect it through sql plus but Database control is not starting. I have checked dbconsole service which is running.
the address is [URL]...
but mozilla and chrome both are unable to start the application. after installation it started only once. but it is not starting now.
second thing is how can i confirm what is the port of my listener is it 1158 or something else.
View 2 Replies
View Related
Mar 24, 2011
I need to copy all the database objects from one database to another database.I have 32 bit windows environment I tried export and put it in a dump file but dump file size exceeds the limit, my database size is about 300 GB.
What would be efficient way to replicate all the database objects move to another box ..?
View 22 Replies
View Related
Mar 28, 2010
On our test database server, we restore a copy of the production database from the rman backup. The process worked well and we could connect and do the processing with sqlplus, or any other third party tools like Toad.
Strange enough, Database Configuration Assistant (DBCA) does not recognize it. So if we like to drop the database from the DBCA, it is not there. Also we could not get the DBCONSOLE to work with.
The all powerful command: emca -repos recreate generates a list of errors.
View 3 Replies
View Related
Mar 11, 2012
I always thought that Database control and Enterprise manager was synonyms...But I am reading a mock about OCA exam and there it said:
QUOTE You just can apply the pacth binaries using the Database Control and with the oPatch utility, but not with the Enterprise Manager...
But to me Database Control and Enterprise Manager are the same thing...
Are there difference between them?
View 1 Replies
View Related
Jan 20, 2010
I have two database in my system but when i open
[URL].....it always defaults for one database..in the service name also there is dbconsoledba1 written....my other database is dba2...do i need to create another service for dbconsole
View 1 Replies
View Related