While connecting my oracle with My JDBC driver . i got an SQLException:
public class Orajdbc {
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection
[code]......
i am successfully connected by type 1 odbc driver but while i want to connect it with "ojdbc6.jar" file then i got this exception i already added that jar file to my Environment variable ClASSPATH ..
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.
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
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.
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:
When viewing SQL statements in Top Activity in OEM, I am only able to see the Explain Plan for the most recent statement. Is there a setting to increase the number execution plans kept?
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...
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.
I suddenly started getting this error message "Error
java.lang.Exception: IOException in sending Request :: Connection refused: connect ". on the dbconsole of my database. Any clue where to proceed or how to find whats causing this error.
I have installed Oracle 11g R2 on the RHEL 5 platform. Once the installtion is complete we need to run two scripts: 1: orainstRoot.sh 2: root.sh
As the root user.When we run the root.sh script is ask us to overwrite three variables yes/no? we did yes.After Running these scripts we opened the database, tried to run listner as well, everything is running fine but when we are trying to run the Emterprise Manager using command:
emctl start dbconsole
we are prompted with a path to check the logs /u01/app/oracle/product/11.2.0/db_1/localhost_orcl11g/sysman/log
I do not know which file I have to check.What could be the reason we are not able to run the EM.I need it urgently as we ahve to generate the AWR reports for the client.
i have installed oracle 10g. but not able to start the Enterprise Manager, i am getting the error when ever i enter the url in the browser (//home:5560/ isql plus) .
is Oracle Corporation provides Enterprise console for 11g, like oracle provides Enter prise console for 10g through which we can view/create/manage all the objects like tables,views,functions and procedures etc.
is there a way to export/download graphs that are shown on Oracle Enterprise Manager? I tried to find some buttons that make it possibile, but I'm unable to find them...
I have just downloaded Oracle 11g from the Oracle website.How do I start enterprise manager?
but once I get away from UNIX I don't have a clue what I am doing. What are the windows bits. I go to the oracle bin directory from a dos window and enter emctl commands, and I get "emctl" is not recognised as an ibternal or external command.
When looking at some of the metrics available in OEM, I am puzzled by the interpretation:
1) Using the Host tab, and load metrics, I can get a metric for the Total I/O for the host .. I assume this is IOPS.
2) Using the Database tab, and the instance_throughput physreads_pc metric I can get a metric for the Physical Reads from the database instance per second.
3) We generally have several Oracle instances on the same server, and in all cases, the sum of the physical reads for each database is SIGNIFICANTLY higher that the total i/o for the host.
Am I interpreting the information incorrectly ? Does one of the metrics consider db_block_size ?
When i try to login into em it always give - [URL]... dba role is granted to the user and i have verified the passoword . I even tried with system user and it gave me same error.
Validation Error
Examine and correct the following errors, then retry the operation:Host Credentials - Connection to host as user system failed: ERROR: Wrong password for user
I am using Oracle 11g Rel1 on Window 2003 Server R2 Enterprise Edition x64 with SP2. I am trying to configure DB console using command throuth emca. But I am getting the below mentioned error. Even I tried after manually deleted the repository then tried to create using emca command.
========================================================== Mar 28, 2011 3:11:16 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Mar 28, 2011 3:16:16 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error starting Database Control Refer to the log file at D:appAdministratorcfgtoollogsemcamonetaemca_2011_03_28_15_09_53.log for more details. Could not complete the configuration. Refer to the log file at D:appAdministratorcfgtoollogsemcamonetaemca_2011_03_28_15_09_ 53.log for more details.
C:Documents and SettingsAdministrator> ===========================================================
using Firefox 8.0 and found that I was "unable to connect". I found that although my OracleDBConsoleorcl service was set to automatic, it was not started. So, I attempted to start it from the Windows services menu, but received a message that Windows could not start it and it said to see the System Event Log. So, I checked the Windows System Event Log and found:
"The OracleDBConsoleorcl service terminated with service-specific error The system cannot find the file specified."but it does not tell me the name of the file or directory path. So, where do I go from here? I did not want to hijack the other thread, so I started a new one, especially since the original poster was able to start this service. Is there a different way to try to start the service that might provide more information?
I have been using this installation for a long time and seem to remember this working once upon a time, but I could be wrong. I don't usually use Enterprise Manager, so this is not something critical, just a curiosity, and something that I might like to explore. I have provided version and system info below.
-- Oracle version info: SCOTT@orcl_11gR2> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for 64-bit Windows: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production
5 rows selected.
-- partial systeminfo (some lines like product key removed): C:>systeminfo OS Name: Microsoft Windows 7 Professional OS Version: 6.1.7601 Service Pack 1 Build 7601
comparison of oracle and toad products.I know we have oracle enterprise manager for doing application and enterprise management.I am listing the tools from toad
Can list the tools from oracle which have or perform the same functionality.
Toad Toad Development Suite for Oracle Toad DBA Suite for Oracle Toad for SQL Server Professional Edition Toad for SQL Server Xpert Edition Toad Data Point Pro Edition Toad Data Point Pro Edition- with analytics
behaviour of oracle enterprise manager. i want to edit a table of a database. after i clicked on the table the oem crashes without any messages - simply disappearing.
i installed oracle9i release2 V9.2.0.1.0 windows client and want to access an oracle8i V8.1.7 server on linux.
