I am an OEM Gird Control 11g server with Oracle 11.2.0 running on OEL 5.3
I also have 2 node RAC cluster running Oracle 11.2.0 on OEL 5.3. I have installed OEM Agent on nodes of this cluster. I can see them on OEM Grid Console. When I check the configuration of the Database Instance GTRD1 (one of my target instance)I can see that the "Listener Machine Name" is the management IP address of target database server. Similarly Database Instance GTRD2 has the management IP address of target database server. When I click test conenctions it works. This is without entering any reference to this server/IP address in /etc/hosts file.
But when I select targets->all targets->Database Instance GTRD1 and then try to access performance tab, it does not connect. I get this error "The Network Adapter could not establish the connection"
Looking at the "emoms.trc" I find the follwing
2012-04-30 14:02:12,071 [EMUI_14_02_12_/console/database/instance/sitemap] ERROR perf.sitemapPerfChart logp.251 - java.sql.SQLException: The Network Adapter could not establish the connection
The Connect Descriptor was (description=(address=(host=GTRD-scan.GTRD)(protocol=tcp)(port=1521))(connect_data=(service_name=GTRD1)(instance_name=GTRD1)(UR=A)))java.sql.SQLException: The Network Adapter could not establish the connection
The Connect Descriptor was (description=(address=(host=GTRD-scan.GTRD)(protocol=tcp)(port=1521))(connect_data=(service_name=GTRD1)(instance_name=GTRD1)(UR=A)))
But when I enter the scan address in the /etc/hosts as "112.5.14.154 GTRD-scan.GTRD" Then everythign work works. NOTE: 112.5.14.154 is GTRD1 server and 112.5.14.155 is GTRD2 server
Now my questions are: 1. Do I must enter scan address/ref "GTRD-scan.GTRD" in /etc/hosts? 2. Is there are way to change it to use hostname or the IP address? 3. If I am to use scan address, then how I refer to the other IP address in hosts file?
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.
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...
trying to get oracle-xe-universal_10.2.0.1-1.0_i386.deb rolling on Debian/6.0.1a which coincidentally is on another server, not on my desktop, so I obviously can't reach the web frontend at 127.0.0.1:8080. And I couldn't trick it with a simple TCP proxy on the server:
nc -l -p 80 127.0.0.1 8080 and then on the client: telnet 192.168.0.252 80 bailed out with an error invalid connection to [192.168.0.252] from (UNKNOWN) [192.168.0.1] 35798
So, is there a way to change the listening IP address, or to allow IPs other than the local host to connect? I've tried some googling around,.
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:
My problem is that when i sign in on Enterprise Manager page ( URL.... ), i don't see that green up arrow that status is UP (and also those charts), but status: Agent unreachable: URL....
I tried to do what is specified in the Metalink(also here: URL.....), but the problem persists. And that metalink note (317242.1) applies to EM Grid Control (maybe that solution works for EM dbconsole also). So i don't have a Grid Control.I tried to stop dbconsole, then start it and then start upload agent ( emctl upload agent), but i got:
C:Documents and SettingsSorin>emctl upload agent Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. --------------------------------------------------------------- EMD upload error: Upload was successful but collections currently disabled - disk full
The agent status is:
C:Documents and SettingsSorin>emctl status agent Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent Version : 10.2.0.4.2 OMS Version : 10.2.0.4.2 Protocol Version : 10.2.0.4.2 [code].....
The EM documentation does not work in this situation (and i specify this because sybrand_b has a problem with users who don't read the documentation.. ) However, i read here: URL....
"The agent collections will stop when the space on the disk is used beyond the default. Solution is to release the space on the disk."how to release space on the disk? What exactly means this? I have enough space on my D partition, where the Oracle product is. What should i do now? I want to see the EM page like this: URL....
The last week or so, the job has not ran. I finally got some time today to take a look and when I try to manually export the schemas, i get the following message after the first screen (where you choose Schemas and your credentials are entered)
Validation Error - Examine and correct the following errors, then retry the operation: Error - IO error occured.
A few weeks ago i changed the password for sysman and dbsnmp because the backups were not running and after i did that, they ran for a few nights. The only other thing is our system admin for the server changed some user access for the C:Oracle folder, but I still have full control.
I am in the ORA_DBA group and i have "Logon as batch job" selected for my account.
I read at one place to go to Preferences - Preferred Credentials and test the host username and password. When i do this i get the message : "Connection to server as user XXXXXXX failed" so I am thinking it has something to do with my user account, but not sure what i need to change.
I am configuring the Backup Settings through EM. It says 'An error has occurred while configuring the backup settings.'. When i click on 'View Error Details' it shows:
'open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at - line 831'
I cant figure out the problem.. I have also created the Disk Backup Location.
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
I have a problem when I install oracle 11g: I did an installation on a win2008 r2 server and everything works fine, I did another installation on another server in the same network as a test, but at the end of the installation I get an alert that says:
start database error control ..... Executing set oracle_unqname and then emctl start dbcontrol. of course nothing happens.
dbcontrol_nome the service instance will not start. checking the file in your home directory I always acts everything is in place. I reinstalled windows to eliminate all the checks made, repeated installation and here appeared the same problem.
question: can exist 2 oracle installations on the same network with the same name db? I currently have two installations of the same name with oracle db 10
I am getting an error regarding Starting Database Control. I have multiple databases on the same server but every time I am trying to create a new database I am getting the same error again and again.
I try to install the Grid Control 10.2.0.5 on Solaris 10 in an existing (empty) Database Oracle 10.2.0.4. All steps work without problems except
-- OMS Configuration (in Configutaion Assistants)
emca_repos_create15_25_32.log :
Quote: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647) [code].......
ORA_NLS10 is set to $ORACLE_HOME/nls/data of DB
Also tried to set to $ORACLE_HOME/nls/data of oms10g but get Problems to start opmn and later on it report also ORACLE_HOME and NLS Parameter set incorrectly. I checked MetaLink / Internet without success.
I'm trying to create a database using DBCA, but before it completes i recieve the following error:
enterprise manager configuration failed due to the following error - Error starting database control refer to the log file at
E:oracleproduct10.2.0db_2cfgtoollogsdbcaorcl30emconfig.log - for mote details you can retry configuring this database with enterprise manager later by manually running E:oracleproduct10.2.0db_2inemca script
I'm using oracle 10g version 10.2.0.5, and my operating system is windows 7
I am attempting to make a job on an active database and I keep getting the error "An error occurred checking if the script file directory exists. Correct the error and try again. Error message: Agent Unreachable"
I can't find any information about the error on the logs and I don't knwo what to do about the error. I really need the script the job makes but how to get it.
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.
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
I have installed Oracle 10g on Windows XP. I created a database called orcl1 using DBCA and set the sys and system user passwords as "oracle". My windows xp operating system password is set as username:Bobby and password :welcome4all. Yet at the startup/shutdown page in Enterprise Manager, when I enter HOST CREDENTIALS as username:Bobby,password :welcome4all
and credentials for target database as username:sys,password :oracle, I get RemoteOperationException:ERROR: WRONG PASSWORD FOR USER .I don't understand why? Am I doing something wrong?
i am getting error when iam starting enterprise manager GUI dbcosole,its not displaying the graphs of HOST CPU and active session graphs instaed its giving me error such as java.lang error and null point error below the graphs.
i stop and start the dbconsole from services and from command prompt and rebooted the server,but still showing the same error..did open in other kernals such as mozilla and google still the same issue..
Tried restarting OracaleDBConsole service after a Windows security patch was installed and now I'm getting error 1053:The service did not respond to the start or control request in a timely fashion" error message when you stop or pause a managed Windows service.
Apparently it was a MS known issue and it has been fixed in .NET v1.1 which is what was installed(& I didn't have any problems) before server team installed the latest security update which was .NET v2.0
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.
EM displays: Enterprise Manager is not able to connect to the database instance
And yest the Database Instance status show open and the instance is up; Listener status is Up; Agent Connection to Instance status is Succeeded (but no details)
emctl status dbconsole shows ""Oracle Enterprise Manager 11g is running"
emctl status agent shows "Agent is Running and Ready"
I can connect with SQL Developer and see everything in the database.