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

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 ...
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 ...
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? ...
6
votes
4answers
82k views

How to restore/import an Oracle database from dmp file?

I've recently recieved the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now i need to restore the original database. Can anyone give me a step to step ...
1
vote
2answers
2k views

How to find out the current SGA memory distribution?

How can I get the current SGA memory distribution on Oracle 10G? Something like this: AME SIZE_MB RES -------------------------------- ---------- --- Maximum SGA Size ...
1
vote
3answers
241 views

Easy way to wipe a set of Oracle schemas

How can you wipe a set of Oracle schemas? By wipe I mean remove all data, tables, views, procedures, synonyms, etc, etc.
0
votes
2answers
700 views

Oracle 10g queries very slow and CPU usage very high after applying patch

So I recently updated an Oracle Database 10g from 10.2.0.3.0 to 10.2.0.4.0, as advised by Oracle Support, due to stability issues (a known issue under some systems where the instance would freeze ...
0
votes
2answers
267 views

how to see queries to oracle database

the database in question is Oracle 10g Enterprise software the tools available are Toad, SQL Developer, and other built in oracle tools I have an application server within the network, alongside the ...
4
votes
3answers
34k views

Oracle: how to find out storage space used by a table?

How to find out (if possible via Enterprise Manager), the total in Mb that a certain table is using?
-1
votes
1answer
102 views

How to connect to an Oracle 10g database on the host computer from Ubuntu installed in VMware? [closed]

I have Oracle 10g installed in my host system which is running on Windows 7. I have also installed Ubuntu in the same system using VMware. Now I have written some program in Ubuntu which needs to ...
0
votes
1answer
122 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 ...
1
vote
1answer
2k views

Connecting Oracle XE DB / Oracle Database 10g Express

I started with Oracle DB. On Windows Server 2003 I installed Oracle Database 10g Express Edition and then I also installed PL SQL Developer. I tried log on via PL SQL Developer to XE database. I use ...
0
votes
0answers
601 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 ...
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 ...
0
votes
1answer
2k views

Weblogic intensive CPU usage

I am using Weblogic 10.3.4 + Oracle DB both on Solaris machines (VM) Unfortunately last week our app hosted on Weblogic became very very slow not being able to serve new users coming (everything ...
1
vote
2answers
367 views

How to change Port Number Of Http Server in either Oracle10g or tomcat?

I am looking to run Apache tomcat and oracle10g... both are on port 8080 how to change port of any of them?
2
votes
2answers
231 views

Oracle (xe) 10 vs 11 . Have I lost the SQL tuning pages ? Am I going out of my mind?

Ok .. so perhaps the title needs calming down a bit. Basically I am after the XE 11g equivalent of the pages that you can see here, in which you can then navigate to stuff like "top 50 queries" and ...
1
vote
1answer
700 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, ...
3
votes
2answers
2k views

How to diagnose frequent “500 Internal Server Error” on Oracle Apex

I have an Oracle 10g XE database running on OEL 5 on an Amazon EC2 instance. On it I run a public website (actually, 2 web sites) written in Oracle Application Express 4.0.1. Most of the year, the ...
1
vote
1answer
889 views

How to export database from Oracle 10g

I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files ...
0
votes
2answers
106 views

How I can upload an oracle ddl file of 15M

I have a file of 15 mb and i need run the sql of that file in oracle, but when I try load the file, I have a error: The file exceeds the maxim limit When I can change that limit or how I can run ...
0
votes
1answer
211 views

Where to create directory for importing over network link?

While using data pump import over network link in Oracle: impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT directory=TEST_DIR remap_schema=SCOTT:TEST Where are we creating ...
0
votes
1answer
221 views

Oracle error when logging into database

When I try to log into my db with a specific user I get this message. Below is from the alert log. I can login as system just fine. Anyone know how to figure out what is causing this? Thanks in ...
0
votes
2answers
2k views

Accidently overwrote system.dbf - What now?

I accidentally overwrote system.dbf in /usr/lib/oracle/xe/oradata/XE/system.dbf Well I did not actually do it accidentally, however I overwrote it because of other failures in the database. And when ...
1
vote
0answers
352 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
2answers
1k views

Oracle Data Pump - export from Enterprise Edition to Standard Edition

I am migrating from an Enterprise Edition of Oracle 10g to a Standard Edition of Oracle 10g and I was wondering if anyone has experience doing this. I've searched around and I can't really find a ...
2
votes
3answers
310 views

Change local admin password. Impacts on Oracle and Citrix?

I need to change the local admin password on some Citrix and Oracle servers. These servers are in production. Then we will start using a secure password procedure, and change them every X month. ...
1
vote
3answers
843 views

no suitable image found when installing Oracle on Mac OSX

I'm installing Oracle Database 10g Release 2 (10.2.0.4) for MAC OS X on Intel x86-64 I have Mac OS X 10.6.7, running at Intel Mac. When I start installing, I am faced to the following error: ...
2
votes
4answers
453 views

Oracle Logical Standby redo generation

Oracle 10.2.0.4 database with a logical standby on Win2K3. Recently a rather large delete operation was carried out on the production instance. I'm experiencing difficulty with the logical standby, in ...
2
votes
2answers
11k views

oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist

I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried. $ lsnrctl start LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 ...
2
votes
2answers
13k views

Oracle throwing this error: could not open registry key SOFTWARE\Oracle\ocr

I have an oracle installation that runs fine 95% percent of the time. But for some reason every day at a random time early in the morning (between 4:00am and 9:00am) I get the following error: [ ...
5
votes
1answer
256 views

How to prevent remote login for SYS

Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
0
votes
1answer
109 views

ODSI + weblogic = JDBC problem

I'm currently developing a web service using ODSI through Oracle Workshop for WebLogic (ex AquaLogic). I created a datasource on weblogic using the driver "Oracle thin driver 10g", the test succeed on ...
0
votes
2answers
853 views

Microsoft Cluster or Oracle Fail Safe error

Trying to get Oracle Database 10g to work on Microsoft cluster (using Oracle Fail Safe, not RAC). Everything installed, but when trying to verify group or add database to group I get following error: ...
2
votes
1answer
328 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
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. ...
2
votes
1answer
91 views

How can I tell how my oracle databases configurations' differ?

I have two databases with the same data, running on the same physical server. They are performing differently (one is twice as fast as the other). I've compared the Initialization Parameters and ...
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 ...
13
votes
6answers
20k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article ...
4
votes
1answer
147 views

Are there any performance differences between Oracle Entreprise and Oracle Standard editions?

Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition. Given the same ...
0
votes
1answer
171 views

Group policy define new services with install them in main server

I have Active Directory with Windows Server 2003 64-bit. One of my users asked me if it is possible if he can start and stop Oracle and MYSQL services from start --> control panel --> services. From ...
3
votes
1answer
695 views

Is there a way to easily run the same query in Toad against multiple Oracle database servers?

I have several servers hosting data for the same application, and I want to see the results of the same query from different servers.
1
vote
1answer
236 views

how to find foreign keys constraints?

I have a table called abs with primary key absId, this is used as a foreign key in couple of tables which I don't know. Is there a way that I can find out how find the names of those tables in which ...
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 ...
-1
votes
1answer
562 views

problem in run oracle server please help

I used Oracle 11g, from few days ago I face below error: SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: ...
0
votes
1answer
303 views

Configure oracle in debian testing

I have installed oracle10 in debian, in the web ui i can use the database, but this doesn't work with sqlplus, where i can configure this? updated: when i run sqlplus in command line, ask me for ...
0
votes
1answer
254 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 ...
1
vote
2answers
142 views

How to connect an Oracle server between two countries and maintain high speeds for read & write

Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, ...
1
vote
1answer
408 views

Oracle Internet Directory implementation questions?

I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using various Oracle DB versions 9i up to v11, usually I send email for all of the users to manually copy and update the ...
0
votes
1answer
135 views

Installing Oracle 10g on Panasas PAS12 (NAS)

We are using Panasas PAS12 (running in pNFS protocol) internally in our team, and are currently thinking of migrating our Oracle 10g in it. We have two sides among ourselves. On one hand, Oracle 10g ...