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
1answer
195 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
1k views

sudo yum install oracle (-instantclient,-instantclient-basic,etc) not working

Specifically I would like to know what the package name is for the yum package for Oracle Instant Client. I've tried some that Google seemed to like, such as oracle, oracle-instantclient-basic, ...
0
votes
1answer
128 views

Install Oracle 11g on Ubuntu using rpm package?

Does anyone have tried to install orcale 11g using offical rpm packages? I found it is very complicated to install the oracle successfully on Ubuntu server. And there are many different guides ...
2
votes
4answers
392 views

Should I expect a great increase in Oracle performance in terms of handling multiple requests switching from single to dual core?

We have an Oracle database of roughly 100 GB that runs on top of a Windows Server 2k3R2 VM in ESX in a 1 socket, 1 core configuration. Whenever it has to handle a major query it seems to get "pegged" ...
1
vote
2answers
3k views

How to install Oracle extensions for PHP on Linux SUSE?

does anyone have some experience in installing the ORACLE PHP extensions (oci_connect()) on Linux SUSE ? Thank you Antonio
1
vote
1answer
605 views

How do you read an Oracle .dmp file on a Mac?

I have a ~1GB .dmp file I'd like to get the data out of and I'm on a Mac. Is there any way to do this without either buying Oracle or finding a windows machine? Can you import .dmp files into ...
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
108 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
438 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
53 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
192 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
525 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
676 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
677 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
480 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
404 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
583 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
234 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
59 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
516 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
9k views

SQL*Loader installation

Is it possible to install SQL*Loader without installing the whole Oracle package?
0
votes
1answer
253 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
178 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
763 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
212 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
381 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
420 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
85 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
188 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
97 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
298 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
819 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
4k 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
14k 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
108 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
326 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
653 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 ...