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
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
28 views

DataSet.Fill slower after upgrading to oracle 11g

We have migrated from an oracle 10g to an oracle 11g Database. The instance of Database 11g is totally new an installed on a VirtualMachine in a different HW. The new DB is on Windows Server 2013 ...
2
votes
2answers
3k 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 ...
2
votes
1answer
375 views

Opening an oracle database crashes the service

I am experiencing a weird issue with Oracle where the service started fine after a crash. The database mount went fine as well. However, when I issue alter database open; command, the database does ...
0
votes
0answers
41 views

Oracle 10g RAC ASM instance creation

I am having a problem with using SQL*Plus to manage my ASM instance. I am working on a two node Oracle 10g Standard Edition RAC cluster setup running on Windows Server 2003 Enterprise. One of my nodes ...
0
votes
0answers
25 views

TNS Listner error for SID

My Error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor ...
3
votes
3answers
5k views

How can I find my Oracle 10g server version?

I don't have physical access to my Oracle server but I can run some sql command from Toad. Is there a way I can find wich version the server is running, like 10.2.3.1. I know it's 10g but I'd like to ...
1
vote
2answers
4k views

Find Current open Cursors in Oracle

What is the query to find the no. of current open cursors in an Oracle Instance? Also, what is the accuracy/update frequency of this data? I am using Oracle 10gR2
3
votes
1answer
862 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.
2
votes
1answer
2k views

Oracle Account Not Responding

I have an Oracle instance which has user1, user2 and user3 accounts. Yesterday I was able to log in to all three accounts. Today, I can get in to user1 and user3, but user2 is completely 'frozen' in ...
6
votes
4answers
91k 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
3k 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
259 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
780 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
425 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 ...
5
votes
3answers
44k 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
184 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
135 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
3k 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
977 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
45 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
3k 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
420 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
257 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
743 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
981 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
239 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
282 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
402 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
366 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
895 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
474 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 ...
3
votes
2answers
13k 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
14k 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
326 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
118 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
908 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
350 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
43 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
92 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
53 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
21k 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
197 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
190 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 ...
1
vote
1answer
308 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 ...