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

1
vote
1answer
2k views

Oracle- Can't access objects from other users schema

I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I ...
0
votes
1answer
112 views

Oracle Import Dump [closed]

After system failure I have bought a new server and now Im trying to recreate the oracle database I had. I have a dump file which was made with the command exp and full=y. So can I restore the full ...
0
votes
1answer
61 views

Oracle replication A->B and B<-A?

If you have two unrelated Oracle databases on separate servers, can you replicate A to B and B to A so both servers have a copy of both db's? Idea is for DR "on the cheap" without buying more Oracle ...
0
votes
2answers
106 views

How Oracle is doing high availability? [closed]

We are searching for some replacement of our mysql cluster - Oracle or pgsql. I read the whole document about HA in Oracle 11 database system, but I really was not able to understand it quite enough. ...
0
votes
1answer
321 views

Are Oracle Database CPU license limits enforced by software, and how do I check them? [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? I've inherited a windows VM running Oracle Database 10g. Currently the VM has only one CPU assigned to it, but I can ...
0
votes
2answers
394 views

Performance-optimizing Oracle 10g on a server that is also a Tomcat JSP app server?

I have inherited a simple RedHat 5 - 64bit platform. It has SCSI disks on RAID1, with 16GB of RAM. Double Core CPU. Oracle 10g, Release 2. This would be a decent platform for running the DB ...
2
votes
1answer
180 views

HPSA (HP Server Automation) [closed]

Using HP SA (HP Server Automation) version 9 for automation and its Oracle database consumes inordinately large amounts of CPU resources. Anyone have a similar experience?
1
vote
2answers
2k views

Configure Perl DBI and DBD in Linux

I am new to Perl and I work in a Linux OEL 5x server. I am trying to configure the Perl DB modules for Oracle connectivity (DBD and DBI modules). Can anyone help me out in the installation procedure? ...
0
votes
1answer
51 views

Does Oracle database need to be restarted to use Rman?

We have an Oracle database which uses Rman. The server hosting Rman repositories crashed. We've put the Rman server back online, but do we need to bounce the Oracle database to get it to start using ...
0
votes
1answer
107 views

How does Oracle Streams prevent the execution of code during the distribution process?

I thought about Oracle Streams and stumpled into a question. Oracle Streams is used on the database I am programming for, but I am not the DBA. Therefore I am not familiar with the configuration of ...
1
vote
2answers
6k views

Can't install kernel-uek-headers for currently running kernel

I have just created a VM in VMWare and installed a minimal install of Oracle Enterprise Linux 6.3. # cat /etc/oracle-release Oracle Linux Server release 6.3 It is running with the UEK kernel. # ...
3
votes
2answers
630 views

Why would adding a datafile cause a deadlock in Oracle?

I have noticed something in Oracle which never happened before to me. Though I frequently do this kind of thing for many years now. In this case it's an Oracle11 instance (Oracle Database 11g ...
1
vote
1answer
319 views

Install Oracle Java JRE 7 on Ubuntu with just the command line

I can't use openjdk because it doesn't have native .jpg support. I can't use sudo apt-get install sun-java6-jre sun-java6-plugin any more because apparently those have been pulled. JRE version 7 ...
0
votes
1answer
599 views

Exception thrown when trying to access a web service (Weblogic) - java.lang.LinkageError

I've installed Adobe LiveCycle for Weblogic 10.3.4, and when I try to access one of the web services it deployed, I'm getting the following exception: Exception - java.lang.LinkageError: loader ...
2
votes
3answers
2k views

SELinux is preventing Perl CGI script from accessing Oracle libraries

I'm trying to configure SELinux on a Red Hat Enterprise Linux 6.2 web server that runs Apache 2.2.15 and Perl 5.10.1, and connects to remote Oracle databases. The Oracle 11.2g client is installed. The ...
2
votes
2answers
100 views

Linux OEL 6x - Compatibility with ACL

Will the ACL [ Access control lists like getfacl, setfacl ] utility work fine with OEL 6x? It works great with Solaris 5.9 but not sure OEL 6x will support ACL utilities
1
vote
1answer
980 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 ...
3
votes
2answers
113 views

Migration from oracle to DB2

I want to migrate my oracle schema to db2. Any tool available for migration? Please help
2
votes
1answer
519 views

Cant open up oracle web console after install db 11gr2 and show weird symbols?

i just finished installing oracle database 11gR2. after successful install, i will usually want to open up web console at http://localhost:1158/em.. however if i open up the page i get a weird symbol ...
0
votes
1answer
2k 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, ...
1
vote
2answers
2k views

latest version of oracle developer including forms and reports

What is the latest version of Oracle Developer which includes Oracle Forms and Reports? I am taking a Database Administration class in college. The professor is installing Oracle Developer 6i but ...
0
votes
1answer
130 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 ...
1
vote
1answer
1k 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
1answer
820 views

Oracle redo log performance degradation when inserting

I have a oracle 11g database. I'm testing in for inserts. The database running in noarchive mode. I have 3 redo log configured, each 2gb. I'm trying to insert data into test table. At begin it goes ...
0
votes
1answer
135 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 ...
2
votes
4answers
606 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" ...
2
votes
1answer
8k views

Oracle: FRM-41211 Error Message when starting a Report from Oracle Forms (64 Bit Windows Server)

After installing Oracle Forms and Reports 6.0 (Patch 18) on a Windows 2008 64 Bit server we get the following error when we try to start a report from Forms. "FRM-41211 integration error: ssl failure ...
0
votes
1answer
55 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
1answer
304 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 ...
1
vote
0answers
526 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
773 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
276 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 ...
-1
votes
2answers
204 views

display sql syntax in Oracle's sqlplus? [closed]

What is in Oracle's sqlplus equivalent of Linux's man or --help ? When I'm in sqlplus and type help index, I get some commands displayed, but there is no way to get specific sql syntax. For example ...
2
votes
2answers
4k 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 ...
0
votes
2answers
212 views

Improving latency between developer machine and oracle db

It seems our developers are concerned with the latency they are getting between their dev machines at site a and the database which is at site b. Ofcourse the obvious thing is to have as little as ...
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 ...
2
votes
3answers
5k views

How to have oracle database accessible remotely

I can connect to my oracle database using localhost:1521. However, connecting to the IP address does not work. I'm trying to do this because I am trying to connect to my database using another ...
1
vote
2answers
229 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 ...
1
vote
2answers
5k 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 ...
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
247 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 ...
2
votes
1answer
990 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
1answer
393 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 ...
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
549 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
2k 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
576 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
104 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 ...
3
votes
1answer
3k views

logfile deleted on Oracle database how to re-create it?

For my database assignment we were looking into 'database corruption' and I was asked to delete the second redo log file which I have done with the command: rm log02a.rdo this was in the ...
2
votes
0answers
267 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 ...