This is the error message iam getting when trying to open EM... Im new to DBA and also to this DB....
[sandeep@Linux4 ~]$ emctl start dbconsole
TZ set to US/Eastern
Unable to locate file /home/sandeep/oracle/product/10.2.0/db_1/Linux4.localdomain.com_orcl/sysman/config/emd.properties : No such file or directory
I'm trying to configure the patching setup in OEM(11g) and when I tried testing the connection to URL...., it errord out saying "Gateway timed out. Either you need to setup proxy or there is no process listening on the remote port".
View 1 Replies View Relatedi want to configure my present Data Guard Setup with Enterprise Manager...and on the Enterprise Manager grid control page i am not seeing any Data Guard option.....i am using oracle 10gR2 and Windows XP.
How to use enterprise manager for configuring Data Guard.
While running "Prompt>Emctl resetTZ agent"
it gives error message: jvm.dll missing....
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 RelatedI cannot start our Enterprise Manager services for our newly created db. I'm encountering this error:
"$ emctl start dbconsole
Unable to locate file /appl1/home/oracle/10.2/xxx-dbs_abcd/sysman/config/emd.properties : No such file or directory"
I've been executing this command for a no. of times at the ORACLE_HOME directory:
$ ./emca -config dbcontrol db -repos create
.. but still I cannot start EMCTL dbconsole.
I have installed database 10gr2 on Red Hat linux 5.4 but cannot use enterprise manager. When i launch the page it shows ALL SERVICE are down ( Database , LISTENER) but all these services have been started manually. I dropped the old repository and created a new one but getting the following errors in the logfile:
Jun 17, 2013 5:20:56 PM oracle.sysman.emcp.ParamsManager getParamCONFIG:
No value was set for the parameter MODIFY_SID.Jun 17, 2013 5:20:56 PM oracle.sysman.emcp.DatabaseChecks getDbServiceNameCONFIG: No service name available. Will try to set db_unique_name.db_domainJun 17, 2013 5:20:56 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineCONFIG: SQLEngine connecting with SID: ghadb, oracleHome: /ORACLE/product/10.2.0/db_1, and user: SYSJun 17, 2013 5:20:56 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineCONFIG: SQLEngine created successfully and connectedJun 17, 2013 5:20:56 PM
[code]...
i use oracle11g. i got some error messages.
ora - 03113: end-of-file on communication channel
Process ID : 13782
Session ID: 87 Serial number : 5
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.
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
I have this message when I try to create a new standby database.In the others targets I don't have it..Some database file locations are empty. Please specify locations for all database files.
If I try to customize ... I have the same error.
How to start EM on windows 7?
View 3 Replies View RelatedMy 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)
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.
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 RelatedIs there any setups required for creating a utl file using sql developer. If yes, what are the setups to be done.
View 1 Replies View Relatedwhen i try to install Oracle 10g (10.1.0.2) 64- bits on windows server 2003 enterprise edition 64 bits service pack1 and i try for windows server 2003 standard edition 64 bits on a pc,i am getting the below error.
the image file E: is valid, but it is for a machine type other than current machine
i need to install it as soon as possible .
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 RelatedI am trying to install Oracle 11g R2 on my Windows 7 Ultimate 64 bit. When I execute setup.exe as Administrator the command window flashes and exits. I could not even see what the message is. Also tried command prompt.
View 12 Replies View RelatedHow to get the file name from directory without Java. Is there any way to do it in Pl/Sql.
View 13 Replies View RelatedI 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]....
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 RelatedI 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.
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 :@
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 ?
have a log file in unix server under(/usr/home/oraj/log/abc.log) I am trying to access from oracle stored procedure as fallows
src_clob BFILE := BFILENAME('/usr/home/oraj/log', 'abc.log');
Exception:
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 716
ORA-06512: at "usr.LOAD_CLOB_FROM_XML_FILE", line 39
ORA-06512: at line 1
I dont want to create directory as such ('/usr/home/oraj/log') as it is already exists and all log files sits there.
CREATE OR REPLACE PROCEDURE Load_CLOB_From_XML_File
IS
dest_clob CLOB;
src_clob BFILE := BFILENAME('/usr/home/oraj/log/', 'abc.log');
dst_offset number := 1 ;
src_offset number := 1 ;
[code]...
This generates a CSV file in an directory. When it runs for the 1st time it take SYSDATE -7 data. After the 1st run it appends the data since the last run. Now my problem is the appending happens at the bottom of the file and every time the header appears. I want the header only the first time and the new data should keep appending at the top so that i get the latest data always at the top.
View 18 Replies View RelatedI 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 Relatedwhen 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?
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