Questions tagged [oracle10g]

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.

Filter by
Sorted by
Tagged with
3 votes
1 answer
3k 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.
Cade Roux's user avatar
  • 375
1 vote
0 answers
134 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?
ITGuy24's user avatar
  • 1,576
0 votes
2 answers
650 views

Issues Installing Oracle Xe 10g on CentOs 4.6

Help! Trying to re-install Oracle XE 10g on my CentOS 4.6 Machine from RPM and cannot complete the installation, prompting the following error: error: unpacking of archive failed: cpio: lstat failed ...
DaveCol's user avatar
  • 26
1 vote
2 answers
1k 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. ...
user52856's user avatar
1 vote
3 answers
384 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.
Marcus Leon's user avatar
1 vote
1 answer
54 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.
user avatar
1 vote
1 answer
780 views

Fetching data from MS SQL Server 2008 to Oracle via ODBC: Getting ORA-28545: error diagnosed by Net8 error

Background: I am fetching data from a database on SQL Server 2008 (SQLA ) over to Oracle (ORCLA) . The data is pulled using a database link, via HS ODBC connection. Both the SQL and Oracle databases ...
Sathyajith Bhat's user avatar
4 votes
3 answers
7k 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 ...
Philippe's user avatar
  • 191
1 vote
2 answers
29k 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 ...
Sergey Stadnik's user avatar
0 votes
1 answer
1k 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 ...
user avatar
2 votes
1 answer
249 views

How do you profile an Oracle database?

What I would like to do is capture all the selects executing against a production Oracle database with all the parameters used for a period of time. I would then rerun all the captured statements ...
Darryl Braaten's user avatar
0 votes
2 answers
129 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 ...
diegueus9's user avatar
  • 117
0 votes
3 answers
3k views

How to restore an oracle database

I am very new to Oracle and customer gave us their oracle database files. ARC00016_0724940467.001 initVISUAL.ora VISUAL.2010-07-22-1637.log VISUAL-trace.sql SYSAUX01.DBF SYSTEM01.DBF UNDOTBS01.DBF ...
user avatar
0 votes
1 answer
319 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 ...
diegueus9's user avatar
  • 117
0 votes
2 answers
264 views

Migration from Oracle 10gR2 to Oracle XE

One of my application currently uses Oracle 10gR2 as the backend, with PL/SQL Stored Procedures, Triggers, Sequences, etc. I want to migrate to Oracle XE. Can this edition serve as the primary ...
M.N's user avatar
  • 337
8 votes
2 answers
7k 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 ...
Mike Dimmick's user avatar
0 votes
1 answer
234 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. ...
user avatar
2 votes
3 answers
206 views

Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment?

Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment? From an IT professional position, why would I not allow Oracle XE and MSSQL2005 to run on the same ...
Michael Rosario's user avatar
2 votes
2 answers
7k 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 ...
Glenn Stauffer's user avatar
14 votes
4 answers
203k 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?
b.roth's user avatar
  • 259
2 votes
1 answer
605 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 ...
1 vote
2 answers
13k views

Starting SQLPlus in linux

How do you start sqlplus in linux? I know this is a service in windows.
sandos's user avatar
  • 160
0 votes
1 answer
621 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 ...
user avatar
0 votes
2 answers
1k 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: ...
user avatar
2 votes
2 answers
33k 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: [ ...
joe's user avatar
  • 197
0 votes
2 answers
4k views

Oracle 10g ODBC Drivers and Connectors

Hello Im using two machines : Windows XP and Windows Server 2003 , on both I have installed the oracle client 10g, and when I try to use ODBC for linked server option on SQL Server It just work on my ...
Jonathan Escobedo's user avatar
2 votes
1 answer
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 ...
wweicker's user avatar
  • 505
0 votes
1 answer
338 views

Export Query Results from Oracle to SQL Server

I'm trying to export the results from a query in SQL Developer into SQL Server. I'm sure I've done it once before, though my route may well have been convoluted - I can't remember. I may have used a '...
CJM's user avatar
  • 730
1 vote
4 answers
10k views

Running Oracle 10g and 11g side-by-side

I recently tried installing Oracle 11g on a server already running 10g. Each would run independently with no problem, but 10g refused to run simultaneously with 11g. Can this be done? I don't need a ...
nw.'s user avatar
  • 723
0 votes
1 answer
209 views

Oracle hardware requirements and optimization [closed]

I'm an application developer. We have some reporting solution for our client on Oracle database 10g. They would like to speed up execution of some calculation stored procedures. Ok, I know about query ...
user avatar
2 votes
1 answer
1k views

Oracle DB import error

I get the error below when importing a database - any ideas why? I do this type of import all the time and I've never seen this error. Prior to doing the import we drop all objects in the schema. ...
Marcus Leon's user avatar
2 votes
1 answer
1k views

Documentation on the SQL execution plan page in Oracle Enterprise Manager (Oracle 10g)

In Oracle Enterprise Manager, in "Performance > Top Activity", you can click a SQL that is being executed and then go to the Plan tab to see SQL execution plan. For the execution plan, the Enterprise ...
b.roth's user avatar
  • 259
0 votes
1 answer
2k views

What is SPFILEXE.ORA?

what is the purpose of SPFILEXE.ORA? I often come across it when surfing the web. BTW: It is encrypted as binary in 10g XE? Thanks.
user25414's user avatar
1 vote
1 answer
3k 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? ...
Jason Baker's user avatar
  • 1,219
2 votes
4 answers
619 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 ...
DCookie's user avatar
  • 2,098
1 vote
5 answers
7k views

Open source scripts for Oracle health check?

I want to put together some scripts to run an automated health check of Oracle 9i and 10g databases. Before I start from scratch, I was wondering if anyone know of any available open source scripts ...
Roy's user avatar
  • 4,446
2 votes
1 answer
295 views

Non-intrusive stored-procedure auditing on Orace 10g

I'm working in a environment where there are a large variety of legacy client programs. I'm trying to get an idea of which programs use what stored procedures. Is there a way to audit access to a ...
David J. Liszewski's user avatar
0 votes
2 answers
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 ...
Filip Ekberg's user avatar
0 votes
2 answers
570 views

oracle 10g User id and password

Hi my name is Manish.M.Meshram I download oracle 10g. i used scott tiger as userId and Password, but it is not working. what will be the user id and password for oracle 10g. Thank you
user avatar
1 vote
2 answers
7k views

Oracle Error ORA-12560 TNS:Protocol Adapter error?

I am using Oracle Database 10g. Both Servers are Windows 2003. I have an Orcale Database set up on one server. Here is the TNSNames.ora from the server with the database. # tnsnames.ora Network ...
David Basarab's user avatar
0 votes
2 answers
3k views

What linux filesystems does Oracle 10g support?

I am wondering if there is a supported (or recommended) list of filesystems that Oracle 10g supports. Specifically I wish to know if storing Oracle data on an XFS partition is a bad idea. I ask ...
SCdF's user avatar
  • 261
2 votes
1 answer
1k views

Oracle 10g on Snow Leopard?

I have found a couple of pages on how to get this configured on Leopard (link and link), and then apparently an upgrade to Snow Leopard does not seem to complicate matters much. However, I'm already ...
mmc's user avatar
  • 141
8 votes
4 answers
39k views

ORA-12705: Cannot access NLS data files or invalid environment specified

I am getting this error while trying to create a connection pool, on my Oracle database, Oracle 10gR2. java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot ...
M.N's user avatar
  • 337
0 votes
1 answer
749 views

Oracle logical standby fails with ORA-01919

I have an Oracle logical standby database being managed via data guard. Just this morning the redo apply process began failing with an ORA-01919 error, indicating one of our application roles did not ...
DCookie's user avatar
  • 2,098
2 votes
3 answers
381 views

Oracle fully patched install

How do I create a fully patched version of Oracle 10g for install?
Joshua's user avatar
  • 779
0 votes
1 answer
512 views

iSQLPlus not starting on Port 80

I am trying to change the port for iSQLPlus on my Oracle DB server, by making changes in the file http-web-site.xml. When I change the port to 80, in this file, the iSqlPlus doesn't start. I can ...
M.N's user avatar
  • 337
2 votes
5 answers
5k views

SMON process in infinite loop in Oracle database instance...help!

My team and I have Googled (and Binged!) our guts out trying to find an answer to this issue, so hopefully the Oracle gurus on SF will know the answer. A week ago we had a power outage in the ...
Kevin Babcock's user avatar
1 vote
2 answers
6k views

Oracle ARCxxxxx_xxxxxxxxxx.001 Files on Windows Server

I have a database server that supports a single application. Sadly much of the configuration of this box is strictly controlled by the vendor. So in the event we change things they may discontinue ...
Laura Thomas's user avatar
  • 2,855
2 votes
3 answers
4k views

How do you clone an oracle instance?

How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname. I'm working with Oracle 10.2.
BIBD's user avatar
  • 1,876
2 votes
4 answers
6k views

Oracle 10 g - Unable to free up space in tablespace

The tablespace in Oracle 10g is almost 100% used. Size (MB) = 571,768.0 Used (MB) = 571,534.0 I just deleted (and committed) thousands of records in a table that belongs to a schema associated with ...
b.roth's user avatar
  • 259