0
votes
0answers
94 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 ...
0
votes
0answers
17 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
1answer
707 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
1answer
575 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 ...
2
votes
3answers
258 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
2answers
7k 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 ...
0
votes
1answer
158 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 ...
2
votes
1answer
85 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
46 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 ...
4
votes
1answer
107 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 ...
1
vote
2answers
926 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 ...
5
votes
1answer
189 views

How to prevent remote login for SYS

Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
1
vote
1answer
355 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 ...
3
votes
2answers
1k 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 ...
2
votes
1answer
2k views

what is causing oracle archive log files to be growing fast

in the last few days our Oracle DB has been generating a large amount of archive log files. How would I find out what DML activity has been causing such a spike in log file generation?
0
votes
1answer
528 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: ...
1
vote
3answers
762 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: ...
0
votes
1answer
991 views

import XML to Oracle 10g

What would be the fastest, easy, and quickest way to import an xml data to a database table in Oracle 10g database? What tool should I use (if possible free)? The XML will look like this: <?xml ...
2
votes
1answer
3k views

how modify username in oracle

I create a username in oracle that has spelling mistake, I want to modify it now but I am not successful. would you please help me how I can modify my username in all_users table? I use oracle 9.
1
vote
1answer
359 views

Oracle 10gR2 RMAN: Channel allocation

Oracle 10gR2, Win2003. I know enough about RMAN to perform basic functions. I'm trying to learn more. We have an RMAN backup process that is used to duplicate a database nightly. The backup is ...
0
votes
2answers
4k views

Oracle 11g: Why doesn't “grant create session” allow user to log in?

I'm working on an Oracle 11g database, and simply need to create a user and log in with it. I successfully create the user, but after running the second line below, I still can't log in. Is there ...
1
vote
1answer
1k views

After applying archive log in oracle, what time is it now?

I have restored the database and applied the archive log. How can I tell the latest transaction timestamp I have recovered to? This is oracle 10g R2 standard (no flashback enable)
0
votes
2answers
778 views

Convert an Oracle 10g RAC database to single instance

In an attempt to reduce the complexity of a solution, I've been asked to convert a two node Oracle 10g RAC production database to single instance. The database is running on RHEL5 with ASM on SAN. I ...
0
votes
3answers
4k views

How to move Oracle database to another PC without restoring backup?

Take this scenario: Suppose the customer has no backup of Oracle 9i or 10g database. The customer wants to move the database from one PC to another. The other PC has a fresh installation of Oracle. ...
2
votes
1answer
520 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.
0
votes
1answer
362 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. ...
1
vote
2answers
215 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.
1
vote
1answer
34 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.
2
votes
2answers
3k 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
1answer
1k 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 ...
2
votes
1answer
144 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 ...
0
votes
2answers
103 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
3answers
1k 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 ...
0
votes
1answer
276 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
2answers
203 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 ...
3
votes
1answer
3k 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 ...
3
votes
3answers
23k 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
vote
2answers
3k views

Starting SQLPlus in linux

How do you start sqlplus in linux? I know this is a service in windows.
0
votes
1answer
520 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 ...
0
votes
2answers
792 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
2answers
11k 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: [ ...
2
votes
1answer
1k 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 ...
1
vote
4answers
5k 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 ...
0
votes
1answer
190 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 ...
2
votes
1answer
507 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. ...
2
votes
1answer
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 ...
1
vote
1answer
938 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? ...
2
votes
4answers
416 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 ...
1
vote
5answers
6k 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 ...
2
votes
1answer
196 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 ...