oracle11g

Oracle ASP.net Provider-model objects performance

Oracle 11g version of ODP.Net introduces the provider model objects (session state provider, identity provider etc) which lets the application to store these information in an oracle DB without writing custom provider implementation. Has anyone has done any performance benchmarking on these objects? how do they compare in performance to...

Is it ok to use oracle 11g client with a 10g server?

I am creating a .NET program that uses odp.net, specifically the 11g version. Our oracle server is running 10g. I am too late in the development process to make a change. Am I heading for trouble? Have you had any experience running 11g client against a 10g server? ...

How can i get Enterprise Manager for Oracle 11g R1 to install?

I am running a windows xp sp3 machine with 22gb free space, 1.5ghz Intel Pentium M and 768MB of RAM. Every time i try to install oracle 11g, the installation goes okay except for running the emca script. Enterprise manager failed due to the following error- error starting database control caused by OracleDBConsoleorcl not being...

Default passwords of Oracle 11g?

I installed Oracle 11g. I didn't change the passwords for SYSTEM and SYS. However now I find that the default passwords do not work. Please help. ...

Oracle: Does a 10g oracle client work with an 11g server?

This is the reciprocal to this question. Currently, I am trying to use the instant client for Mac, version 10.2. There's no 11g version for Mac, as of now, based on this page(you have to click into each link to find out the actual version for each platform...lame). I tried connecting to our Oracle 11g server, and it just hangs there for...

Unable to set up ODBC after installing ODAC (Xcopy)

We are trying to use ODAC Xcopy to minimize the footprint of installing Oracle 11g Client. Currently, we use the Oracle 11g Admin install (~700mb). I've tried using the ODAC Xcopy, and that works. However, the only issue I now have is that I cannot set up an ODBC on the target system by just installing the ODAC Xcopy. After installing ...

How do you run Spring 2.5.6 sample apps in Jdeveloper 11g?

I am trying to run imageDB and jpetstore in JDeveloper 11g. It compiles fine, but it won't run, and the weblogic server throws errors. Does anyone know how to successfully run Spring 2.5.x sample applications in Jdeveloper 11g? I get the following error when I try jpetstore sample. Jul 27, 2009 5:03:20 PM org.springframework.web.contex...

oracle 11g hibernate problem

Hello friends, I am changing my database from PostgreSQL to Oracle 11g. I am using hibernate 3.0 with Java and Struts. Everything is working fine with PostgreSQL. I have changed following in hibernate.cfg.xml file. <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="hibern...

Configuring Oracle 11g client to work with 9i, in order to use ODP.NET for VS 2008 and C# or ASP.net, issues

Hi there, i just have some issues regarding the usage of the latest oracle ODP.NET client , and using it to connect with ASP.NET 2008 and C# to an old Oracle 9i database. As stated in the ODP.NET instalation instructuins it should work, but i'm a litte bit rusty when it comes to configure oracle. The old 9i client has issues for .NET, it...

Oracle's NCHR() function is behaving differently across platforms. How to fix?

I am encountering an issue with some Oracle code which uses the NCHR function. The same code is running on Windows/Ora10g and Linux/Ora11g, yet it behaves differently. The NLS characterset is identical on both instances. I am trying to determine if this is an issue with Oracle versions or because of the OS. Has anyone encountered thi...

Oracle 11g connection prob.

Our application is based on Oracle 11g database its drivers already installed but application throws an error on runtime. "AppliMSP.ADOcommands.GetConnected Error while connecting, Provider cannot be found, It may not be properly installed." I am using OraOLEDB.oracle provider. This provider work properly on other module (Administrati...

How can I use Oracle Preprocessor for External Tables to consume this type of format?

Suppose I have a custom file format, which can be analogous to N tables. Let's pick 3. I could transform the file, writing a custom load wrapper to fill 3 database tables. But suppose for space and resource constraints, I can't store all of this in the tablespace. Can I use Oracle Preprocessor for External Tables to transform the custo...

oracle xml parsing gives invalid character error

Hi, I am using Oracle 11G sql developer's Export Utility to convert the tabular data into XML. To do so, I have used utf-8 encoding. The special characters (0x13) which i see in DB as square boxes, have come into xml as it is. To get rid of this special character, do we need to select some other encoding in Sql Developer? The problem I...

can oci driver for 11g (odbc5.jar) work with 10g client ?

Hi, I need to connect to Oracle9,10 and 11 in my java application.The client will always be present where the app will be run and I want the app to just work with username,password and instance (specified in tnsnames.ora).Hence I would like oci drivers with a connection string of type : jdbc:oracle:oci:@testora .Im using the driver: ora...

Help building a SQL query from multiple tables

Given the following tables, how might I build a SQL query that includes a list of all the items from the "items" table, and a column for each color from the "colors" table that, for each item listed, indicates what colors the item has a relationship with. If that is unclear at all, please let me know what additional information will hel...

SQLDeveloper using over 100MB of PGA

Perhaps this is normal, but in my Oracle 11g database I am seeing programmers using Oracle's SQL Developer regularly consume more than 100MB of combined UGA and PGA memory. I'd like to know if this is normal and what can be done about it. Our database is on the 32 bit version of Windows 2008, so memory limitations are becoming an incre...

Oracle Database Deleting Files Using Java

Sometime this weekend one of our databases (11.1.0.7) began having problems accessing certain folders on a portion of the network through Java. I have reproduced the problem using a small portion of java that does nothing but create a file object and attempt to delete the file. From the database this works for deleting local files and de...

ssl_error_rx_record_too_long

I've googled this error but came up with no solution, this happened when I installed oracle database 11g, I tried to reach https://localhost:1158/em and this error pops up in firefox Secure Connection Failed An error occurred during a connection to localhost:1158. SSL received a record that exceeded the maximum permissible length. (...

Automating problem query identification in Oracle 11g

In our test bed, a number of test suites will be run in a row (unattended), producing reports for later consumption. I want to include in those reports queries which are candidates for further investigation, along with the data that justifies their inclusion in that list. We should be able to associate any query identified this way wit...

Troubleshooting ORA-00942

In the middle of an automated test run last night, one of my twenty worker threads blew out; the application was attempting an INSERT. Springframework reports ORA-00942: table or view does not exist. Connecting to the database (11.1.0.6.0) through the enterprise manager, I pull up a SQL worksheet and query the table, discovering (a) th...