Enterprise Manager Is Not Working - Handle Is Invalid?
May 31, 2013
Recently I noticed EM web wasn't working, I suspect it happened because i configured EM before adding server to domain. Anyway I decided to drop de repository and re-create it but now i am facing a some errors:
C:\>echo %ORACLE_SID%
orcl
C:\>echo %ORACLE_HOME%
C:\oracle\product\10.2.0\db_1
[code]....
Enter the following information:
Database SID: orcl
java.io.IOException: The handle is invalid
at java.io.FileInputStream.close0(Native Method)
at java.io.FileInputStream.close(FileInputStream.java:245)
at sun.nio.cs.StreamDecoder$CharsetSD.implClose(StreamDecoder.java:505)
[code]....
You have specified the following settings
Database ORACLE_HOME ................ c:\oracle\product\10.2.0\db_1
Database hostname ................ ora01
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
[code]....
So now i am facing all these java errors and my EM isn't working.
S.O. = Windows Server 2003 SP 2 x64
Oracle 10.2.0.4.0
View 2 Replies
ADVERTISEMENT
Sep 24, 2010
I tried to start my oem managing but got the following error.
[oracle@Eagle2 ~]$ emctl start dbconsole
OC4J Configuration issue. /home/oracle/app/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_Eagle_boomiedb not found.
View 19 Replies
View Related
Oct 21, 2010
I'm not a DBA, but I've inherited an Oracle 11g database on a Linux Red Hat 5 box that I am now responsible for. I've had to relocate it, and my host name has changed. I've muddled through a few changes (network & listener changes), and the database seems to be working a- ok.
My problem is that the OEM doesn't seem to be working now. I don't think the dbconsole is running. When I try to launch it, I'm using the command line:
su - oracle - c "export Oracle_SID=databasename;/u01/app/oracle/product/11.1.0/db1/bin/emctl start dbconsole"
I'm getting the error: EM Configuration issue /u01/app/oracle/product/11.1.0/db1/hostname_databasename not found (obviously replace the hostname and database name with the appropriate names)
The hostname however, contains the OLD hostname.I tried a quick method of copying the folder, and changing the name to include the new hostname, but that didn't work.
View 1 Replies
View Related
Apr 12, 2012
I have an installation Oracle 11.2 RAC on Oracle Linux 5.5 on VirtualBox 3.2.8, Enterprise Manager Startup Log In does not recognize the SYSMAN username / password.
Log's (I changed // for /):
[oracle@rac1 log]$ tail -10 emagent.trc
2012-04-12 14:31:08,327 Thread-1148807488 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https:/rac1.localdomain:1158/em/upload/: retStatus=-1
2012-04-12 14:32:09,333 Thread-1148807488 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
2012-04-12 14:32:09,335 Thread-1148807488 ERROR ssl: nzos_Handshake failed, ret=28862
2012-04-12 14:32:09,336 Thread-1148807488 ERROR http: 6: Unable to initialize ssl connection with server, aborting connection attempt
2012-04-12 14:32:09,338 Thread-1148807488 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https:/rac1.localdomain:1158/em/upload/: retStatus=-1
2012-04-12 14:32:39,777 Thread-1148807488 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
[code]...
View 2 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
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
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
Mar 21, 2013
How to start EM on windows 7?
View 3 Replies
View Related
Feb 27, 2013
In my code i am selecting a column which does not exist for a table so i m trying to handle that error in exception handler but i am getting error
I want to handle ORA-00904 invalid identifier error
DECLARE
l_count INTEGER:=0;
invalid_identifier_exception EXCEPTION;
PRAGMA EXCEPTION_INIT (invalid_identifier_exception, -06550);
invalid_identifier_exception1 EXCEPTION;
[code]......
select sdsd from emp;
*
ERROR at line 14:
ORA-06550: line 14, column 8:
PL/SQL: ORA-00904: "SDSD": invalid identifier
ORA-06550: line 14, column 1:
PL/SQL: SQL Statement ignored
View 3 Replies
View Related
May 8, 2013
i have some form and reports, whenever i call report from forms i got rep-300 OCI invalid_handle_error.
View 8 Replies
View Related
Jul 23, 2010
ORA-31180: DOM Type mismatch in invalid PL/SQL DOM handle
I am getting this error while debugging one of the package in PL/SQL developer or in TOAD. Is there any setting which we need to perform at the database level to debug the packages which have the code related to XML DOM. I am asking as the same code works exactly fine at one of the test database and it gives the above error on the other database.
View 10 Replies
View Related
Feb 18, 2011
My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:
Not a zip file(End header not found)
View 1 Replies
View Related
Feb 8, 2010
we have 5 database servers in different locations,
1.main database 10g(production) ip-192.1.1.1
2.standby for production 10g ip- 192.1.1.2
both are linux
3.another database 10g windows
4. another database 9i windows
both are in same location
5.new database 10g in linux ip-192.1.1.3
some other location
i m having a system windows xp installed
i m monitoring, all 10g by oracle enterpric manager
linux os monitor by Putty software
and i m monitoring below 10g database by sqlplus. now how could i monitor all the database by oracle enterprise manager grid control installed in my system that windows OS installed.
View 4 Replies
View Related
May 11, 2011
i have change my database name successful but after that when i open my enterprise manager i can open it but i cannot do anything in enterprise manager . i cannot show any tabs there.. i have attached my this enterprise manager login page here
View 12 Replies
View Related
Mar 25, 2013
The following college class supplied script not working,
/* SQLINTRODBINIT.SQL */
/* Introduction to SQL */
/* Script file for ORACLE DBMS */
/* This script file creates the following tables: */
[code]....
View 8 Replies
View Related
Apr 15, 2009
I am having trouble getting the following update statement to work.
update Team
set Names.Team_Name = "Not Yet Assigned"
WHERE
Team.ROE_PROCESS = 'G' AND
[code]...
The error message I am receiving is:
ORA-00904: "Department"."UI_WKLY_EARNS": invalid identifier
View 4 Replies
View Related
May 6, 2011
I'm trying to install OMS on AIX and one of the prerequisites is JDK 1.6.0 SR6 but I couldn't find it in the IBM site, can some one tell me where can I download JDK 1.6.0 SR6?
View -1 Replies
View Related
Sep 2, 2013
I am trying to start enterprise manager without success. i used to work after installation of db 10g but do day when i run the command below it fails. also i donot see any thing useful in the logs that am being directed to directory /oracle/Ora10R2/Orahome/localhost.localdomain_dse/sysman/log
[oracle@cdsdb ~]$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Starting Oracle Enterprise Manager 10g Database Control .....
[code]....
View 1 Replies
View Related
Jul 2, 2010
I have two databases on the same oracle 11g install. The first (ORCL) database uses the default port for EM (1158). However, I don't know what the second one uses. I go to the portlist.ini file, but it only has the entry for the default (ORCL) database.
View 3 Replies
View Related
Oct 21, 2011
How can I use OEM remotely?
my DB server is on 172.17.1.4 IBM-AIX
and my computer is 172.17.1.53
Because I am tired of using sqlplus :@
View 2 Replies
View Related
Apr 25, 2010
When i run EM ,in my explorer show these
SID = ORCL
instance is open agent is up but ...listener is down .my listener is active and run.... however i can connect to DataBase and execute DDL or DML transactions.How i could resolve it ?
View 6 Replies
View Related
Mar 29, 2013
RPMS needed by OCFS2 for oracle enterprice linux 6.2,Since we unable to mount through OCFS2 console.
View 1 Replies
View Related
Aug 15, 2013
I have install oracle 11g database enterprise edition But i cannot find the Oracle Enterprise Manager after the installation. i want the gui based Oracle Enterprise Manager i have access the the web base Oracle Enterprise Manager but not the gui based.how to use and download the GUI Based Oracle Enterprise Manager ....
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
when I run the form and do some action intheform (call procedure , etc..) how can to see what is the process in running in OEM? Do it have any way to monitor it?
View 1 Replies
View Related
May 23, 2010
I am trying to install OEM but the GUI asks for weblogic server home.i checked many documents in net but none has weblogic installation procedure. Is it the sequence of installation ?
View 2 Replies
View Related
Mar 27, 2012
am trying to create a backup job in my UAT/testing instance, but with little success. I'm trying to create a backup job to disk (backup is to be stored in a drive local to the DB server) and it seems simple enough, but I keep getting the following error:
The job submission has failed for the following reason
ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error ORA-06512: at "SYSMAN.DECRYPT", line 5 ORA-06512: at "SYSMAN.MGMT_CREDENTIAL", line 408 ORA-06512: at SYSMAN.MGMT_CREDENTIAL", line 1007 ORA-06512: at "SYSMAN.MGMT_CREDENTIAL", line 1400 ORA-06512: at SYSMAN.MGMT_JOBS", line 295 ORA-06512: at "SYSMAN.MGMT_JOBS", line 78 ORA-06512: at line 1
In "Recovery Settings", I have a "Flash Recovery Area Location" defined (path local to the DB -i.e. the server that the DB resides on), a "Flash Recovery Area Size" of 4 defined, and a Flashback Retention Time of 24 hours defined. Everything else is riding default values.
In "Backup Settings", there's nothing defined. Everything here is riding default values. As I understand it, not specifying a Disk Backup Location is fine so long as the Flash Recovery Area is defined. All the local services are turned on (scheduling, etc.).
If it's relevant, I mirrored the recovery/backup settings in UAT to the same as PROD, but changed what I needed to in order to accommodate the UAT environment (e.g. paths, etc.)
View 1 Replies
View Related
Aug 23, 2013
I want to manage my database remotely, through Internet. Is it possible to do that with OEM? Where can I find information related to this? Is there another monitoring software that allows me to perform this?
View 10 Replies
View Related
Feb 18, 2009
enctl is started but its status shows that EM Daemon is not running.What does it mean?And how can i reolve this error.
oracle@srv603484:~> emctl start dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
[code]...
View 6 Replies
View Related
Oct 16, 2007
I have been starting to use OEM 10g and am configuring backups through the maintenance portion. Is there a way to get backup success / failure notification sent to an email address?
View 8 Replies
View Related