Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java.

learn more… | top users | synonyms

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 ...
0
votes
1answer
99 views

Oracle OID SSO does not logout of partner applications on VM PCs

We have Oracle's OID providing Single Sign-On functionality to Oracle's EnterpriseOne software suite. Everything was working fine and dandy until we provided some developers access to VM PCs (instead ...
1
vote
0answers
414 views

Oracle parameter array binding from c# executed parallel and serial on different servers

I have two Oracle 9i 64 bit servers, dev and prod. Calling a procedure from a c# app with parameter array binding, prod executes the procedure simultaneously for each value in the parameter array, ...
0
votes
1answer
50 views

Longevity of Tape versus Disk

I read something in a Oracle Archiving book, about longevity of Tape Versus Disk, i quote: "Longevity. No matter how you store your data, eventually it has to be moved either due to obsolescence ...
2
votes
4answers
2k views

Setting environment variables in mod_wsgi for Django

I'm running Django on an RHEL instance under Apache/mod_wsgi, and I'm having issues setting some environment variables for the Python process. All of the components (Apache, Python, mod_wsgi, ...
1
vote
2answers
3k views

Connect to Oracle Database that is hosted in a Virtual Machine from the host machine

Good day, I've just setup a Virtual Machine (using VirtualBox) of Oracle Linux with Oracle Database in it. After setting it up, I can verify that I can connect to it using sqlplus (sqlplus of the ...
2
votes
1answer
172 views

What exactly is “pinning” in relation to indexes? [closed]

When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions. It is part of a test question, where ...
4
votes
7answers
1k views

Oracle SQL editor tools

OK, I've used TOAD in the past and it's pretty cool, but I don't feel like spending that kind of coin. What other Oracle 10g SQL editors are there? Note: I don't need tuning tools, simply SQL query ...
1
vote
0answers
492 views

Intermittent java.sql.SQLException: ORA-03120: two-taskconversion routine: integer overflow exception

I get the following error intermittently when my spring app starts up. I am using oracle with dbcp pooling as my datasource bean in spring. Caused by: org.apache.commons.dbcp.SQLNestedException: ...
1
vote
4answers
141 views

Oracle 10G installation on Linux

i have faced some problems when i install oracle 10g on Linux OS anyone can send me the exact tutorial or link of oracle installation on Linux. Thanks ...
1
vote
3answers
587 views

How do I find the query parameters for a prepared statement in an oracle .trc file?

I have an oracle query generating a 3137 error, and the trace file contains the query. For example: select x from y where z = :1 I think it would help to isolate the problem if I could determine ...
0
votes
1answer
618 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 ...
1
vote
7answers
473 views

Scripting Oracle tasks in Linux

I am more familiar with Windows so Linux is a rather strange place for me at present, so please exuse me if this is a dumb question. Basically, i would like to know if anyone has any suggestions ...
0
votes
1answer
45 views

Blocking locks and performance

My main question is if high amounts of blocking locks degrade Oracle server performance. I understand that it can hurt users performance, but does it cause high load on Oracle itself?
1
vote
0answers
371 views

PHP5 OCI8 FreeBSD

I'm running a FreeBSD server with Apache and PHP 5.3. I'm trying to get the Oracle DB extension (OCI8) running with PHP but I can't find a port or anything for it. Half of the Internet says it's no ...
1
vote
0answers
525 views

cx_Oracle - InterfaceError: Unable to acquire Oracle environment handle

I have installed Django on Ubuntu 12.04 behind NGINX with uWSGI. I use Postgresql as the main database for the application however I need to retrieve some data from an Oracle database. I have ...
0
votes
1answer
219 views

I compiled samba 3.6.4 on Solaris 9, and can't get smbd to run

I compiled the latest release of samba on a Solaris 5.9 system to address CVE-2012-1182, and I'm getting this result when I run smbd. fs17151# ./smbd -i smbd version 3.6.4 started. Copyright Andrew ...
2
votes
1answer
58 views

Oracle SOA repository migration

Does anybody know whether it is possible to migrate Oracle SOA repository from a simple Oracle database to Oracle RAC? Thanks
0
votes
0answers
486 views

VirtualBox setup of Bodhi Linux

I have a .vdi file that has a setup of Bodhi Linux which I am trying to run with virtualbox. Everything goes fine and the system starts but stops at the grub screen, not loading the linux on the ...
4
votes
3answers
8k views

SQL*Loader installation

Is it possible to install SQL*Loader without installing the whole Oracle package?
0
votes
1answer
220 views

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history? For instance, I want to move from BPEL instances deployed to defined partition on Oracle SOA to ...
1
vote
4answers
1k views

Oracle 11g network configuration

I installed Oracle 11g Enterprise Edition on my Windows 7 Pro. My problem is that I cannot log into database from other host (local network). When I connect to database using Oracle SQLdeveloper ...
2
votes
2answers
3k views

unable to install sun jdk on ubuntu

I have Ubuntu 12.04 x64 and I'm trying to install sun jdk for opennms. sudo apt-get install sun-java6-jdk when i run above given command i get following msg: root@fido:~# sudo apt-get install ...
1
vote
2answers
168 views

create a 'definition' file from Oracle

I have inherited an oracle database, and have no Oracle experience. I have been tasked with building a 'clone' of the database on a new server. I am searching around, but not finding the things I am ...
2
votes
1answer
683 views

Can I enable Kerberos authentication for Oracle 11g Database Standard edition?

I have an Oracle 11g Database Standard instance running on Windows Server 2008 R2 and I need to enable Kerberos authentication. I followed the documentation for activating Kerberos 5, but cannot get ...
0
votes
2answers
2k views

Setting up Oracle Database in Oracle Linux

Good day, I am trying to install Oracle Database in Oracle Linux. However, it is looking for some dependencies. Anybody knows where I can get them? Package: gcc-3.4.6 FAILED Package: ...
2
votes
1answer
207 views

Need to downgrade from an intel xeon 5675 [closed]

I'll skip my sob story and just say Oracle has weird licensing, and because of this I'm trying to see if I can avoid buying three new ESX host servers by downgrading from 12 cores (6 licensed ...
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 ...
0
votes
1answer
1k views

INS-40719 error when Install Oracle RAC?

I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6 all went OK so far but I get INS-40719 Error message regarding SCAN Name I do not have DNS server and I'm not going to try to use it on ...
5
votes
2answers
348 views

My table half-exists. Can't drop it

I have a table that is taking up quite a bit of space even though it has no rows. I also dropped it a while ago. When I try to drop it now, it says the table doesn't exist. It shows up in ...
1
vote
1answer
1k views

Reporting Services: Cannot connect to Oracle using Integrated Security

Context I have an Oracle 11g database instance and a SQL Server 2012 instance installed on 2 different servers in the same domain. The Oracle database is configured to accept connection with ...
1
vote
1answer
385 views

How does Oracle Database Standard Edition (One) benefit from running on a dual CPU server?

I am evaluating the impact of additional CPUs on Oracle database performance. I am looking to license Oracle Standard Edition One (SEO, being most cost effective) or Oracle Standard Edition (SE). As ...
2
votes
1answer
83 views

Migrating Oracle DB to another operating system from Red Hat Enterprise by using a disk image

I have a Red Hat Enterprise server disk image that Oracle DB is installed on it. My question is : Is it even possible to use this disk image in order to setup same DB on another Oracle supported ...
1
vote
1answer
2k views

How to connect to an Oracle Server hosted in VMPlayer, from a SqlDeveloper client on my local client machine

Disclaimer : I'm novice in Oracle configuration and I want understand why it does not work. Here is my configuration : My local machine : Windows 7 Ultimate (x64) My VM hosted on my local machine ...
32
votes
7answers
2k views

Database server: Small quick RAM or large slow RAM?

We are currently designing our new database servers, and have come up with a trade off I'm not entirely sure of how to answer. These are our options: 48GB 1333MHz, or 96GB 1066MHz. My thinking is ...
1
vote
0answers
172 views

Oracle concurrent programming execution methods

I created a package and a stored procedure under it to test a concurrent program. When I run it as an Oracle report executable method it works fine. But when I change it to PL/SQL stored procedure ...
-5
votes
1answer
95 views

What is the stability level of Oracle 11g? Is it suitable for production? [closed]

We are using both Express edition and Commercial edition to power up a Distributed application. Is Oracle 11g a good candidate for this application since we need data synchronization? Or is Oracle 10G ...
2
votes
3answers
275 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
794 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: ...
1
vote
2answers
3k views

Oracle 10g default username and password

I'm trying to import a database dump file into Oracle 10g. I'm very very new to Oracle. I've installed Oracle Server ok, but when I go to SQLPlus, I'm prompted for a username and password. I've ...
3
votes
1answer
12k views

How to execute datapump commands as sysdba from remote machine

I would like to know the syntax to call datapump commands (expdp/impdp) logged as 'sys as sysdba' from a remote machine. I know that when logged on the machine which runs the database, I can use : ...
0
votes
2answers
107 views

Configuring swapfile error

I installed oracle linux 6 on my desktop but I forgot to configure the swapfile, I want to install oracle 11gr2 on it and it requires 2gig or ram, if I type the following commands on the terminal I ...
1
vote
2answers
272 views

Oracle only starts with autostart, doesn't when trying manually

I have installed oracle on my ubuntu system a few months ago and its been working pretty well. I have it setup to start on system boot and I run the following commands to stop/start the service sudo ...
1
vote
1answer
637 views

Oracle sysman password reset and enterprise manager

We are running oracle 10g.yesterday we had to reset sysman(and all other sys acounts)user with alter user command. Password change command worked by oracle enterprise manager does not see the database ...
2
votes
4answers
425 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 ...
0
votes
1answer
1k views

Data Guard Status: ORA-16764 after switch to log transport services

I originally set up our physical standby database with redo transport services. Now, I'm switching to log transport services to reduce the time in which the standby lags production. I set up a new ...
0
votes
1answer
99 views

DB2 to Oracle Migration

I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime ...
1
vote
1answer
566 views

Oracle physical standby database received redo has not been applied

I followed the steps in oracle documentation on creation of a physical standby database. The link to the configuration steps, ...
0
votes
2answers
2k views

ORA- 01157 / Cant connect to database

this is a follow up from this question. Let me start by saying that i am NOT a DBA, so i'm really really lost with this. A few weeks ago, we lost contact with one of our SID'S. All the other ...
3
votes
2answers
6k views

Using unixODBC to connect to Oracle server

I am trying to configure our web server (RHEL 5.4 x86) to connect to an Oracle database using unixODBC. I have installed unixODBC-2.2.11-7.1.1, which yum tells me is the latest version. I have also ...