Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle10g** are assumed to be specific to this version or features introduced in this version.

learn more… | top users | synonyms

1
vote
2answers
2k views

Commvault Oracle RMAN Restore to new host

We use Commvault Simpana 8 and I have a situation where I have backups of an Oracle database on tape that were taken from Host A. Host A suffered a disk failure (lost its raid configuration) and the ...
3
votes
1answer
4k views

Oracle 10g for Windows does not start up on system boot

We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
2
votes
1answer
327 views

DBMS_ALERT slow to trigger on RAC

I asked a question earlier about whether DBMS_ALERT works on the RAC. The answer was yes, and I have set up a VMWare test environment and confirmed it. However, there seems to be a long delay ...
1
vote
1answer
699 views

GWT - Oracle JDBC Connection problems

I am having great difficulty making a connection to an Oracle Database OJDBC. I´m using Google Web Toolkit and i added a SQL Database to my project. The Database name is Agenda. I've searched a lot, ...
1
vote
1answer
37 views

What are the contents of the Headers in Control,Redo log and data file in a typical Oracle DB?

Where can i find the contents contents of the Headers in Control,Redo log and data file in a typical Oracle DB.
1
vote
1answer
1k views

What permissions do I need to run SQL*Loader?

What permissions does a database user need to be able to run oracle's sql loader? For instance, since sql loader will disable indexes and triggers, does it need ALTER permissions for those items? ...
0
votes
1answer
121 views

oci.dll is not linked

I have an application developed in Delphi 5 accessing Oracle 10g and I´m getting the error OCI.DLL IS NOT LINKED when I try to save data in database. My ODAC version is 6.50 and I'm running the ...
0
votes
1answer
404 views

Oracle 10g Failover Database - How to fail back?

I want to know how the failover database concept works after recovery. We have defined our application to connect to a backup database in case the production database fails. If this happens, then all ...
0
votes
1answer
127 views

oracle sql developer and sql server

What should I input the connection name there? I have a database called Stack Overflow... I tried the hostname as localhost and it didn't work
0
votes
1answer
153 views

Cannot install Oracle Application server

After succesfull installation of database 10g server, I cannot run install file for application server - it closed unexpectly. How can be problem investigated? Log file contains: Checking installer ...
0
votes
1answer
414 views

How to set _optimizer_search_limit and _optimizer_max_permutations in Oracle10g

I am working on a product that must support both MSSQL and Oracle (10g and 11g). I have some very complex queries that seem to run without issue on MSSQL 2005/2008, but very, very slow with Oracle. ...
0
votes
1answer
253 views

Is it possible to run a mixed Red Hat O/S version Oracle RAC Cluster

I have a client who is currently running a 4 node Oracle RAC Database cluster. They want to add new hardware for 2 new nodes. The current nodes are running Red Hat 4.4 Oracle RAC and Database software ...
0
votes
1answer
185 views

Connecting SQL 2005 to Oracle 10g

Environment: - Oracle 10g database over a windows 32bit 2003 server - SQL 2005 database over a windows 32 bit 2003 server. I am trying to connect the above databases through heterogeneous services. ...
0
votes
1answer
540 views

Oracle on windows cluster with online/offline IPs

I have a windows cluster (on windows 2008 server) with nodes in different subnets. So cluster has two IPs, one for each node (I'm talking not about node IP, but about cluster IP). One is online, the ...
2
votes
0answers
50 views

Equivalent of SQL Server trace for Oracle 10g?

I've got a bad code duplication problem where we cannot tell which versions of packages/procedures are being used. i.e. I have different packages with procedures of the same name and I need to be ...
1
vote
0answers
39 views

Export data from Oracle Lite 10gR1 odb file

I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database ...
1
vote
0answers
351 views

migrate 10g xe to 11g xe

The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
1
vote
0answers
42 views

How to open a standby database (Oracle)

First, let me state that I am not a DBA nor am I a systems guy; I'm a software developer. At work, we recently built a new virtualized db server by cloning our disaster recovery (DR) database server. ...
1
vote
0answers
106 views

Oracle 10g Release 1 on Windows Server 2003 R2

Is Oracle 10g R1 supported on Windows Server 2003 R2? And if it isn't is it known to run without issue?
0
votes
0answers
600 views

ORACLE Forms app throws error: “Failed to open file: ifrun60_dump_” on terminal server

Scenario We have an ORACLE Forms client application deployed on multiple Windows clients and one Microsoft Terminal Services server. The application has scarce documentation and largely inefficient ...