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
2answers
5k 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. # ...
2
votes
2answers
5k views

Extremely High V_$SYSTEM_EVENT Wait Times on Oracle DB

I'm working on troubleshooting an oracle DB that's having some general performance problems. I ran the following query: SELECT event AS "Event|Name", total_waits "Total|Waits", ...
1
vote
0answers
422 views

Oracle Virtual Server OEL vm fails to start - kernel panic on cpu identify

I am in the process of following a guide to setup various oracle vm templates, so far I have installed OVS 2. 2 and got the OVM Manager working, imported the template for OEL5U5 and created a vm from ...
1
vote
1answer
806 views

How do I ensure that the SQL*Net keepalive is turned on?

I have a public facing application server that accesses an Oracle database that resides behind a firewall. Some of the processes that are executed through the application server can run for over an ...
3
votes
2answers
323 views

Is disconnecting a network cable different from VMware “Connected” option?

I have an application that connects to a database and retrieves information from it. The way it is written is: for every request received, create a new connection to the DB server and retrieve data. ...
0
votes
1answer
270 views

2 RAC node clusters with different RAID layouts?

I am comparing RAID 10 and RAID 5 configurations for Oracle database in order to determine the best choice in terms of performance for mixed workloads. Is it possible to have 2 RAC node clusters and ...
1
vote
2answers
103 views

OID (directory service) Installation and configuration on Windows 2003 R2

I need your help in installing and configuring Oracle Internet Directory service on Windows 2003 R2 server machine, I was wondering if anyone can provide any useful tutorial links on the same. I did ...
0
votes
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
111 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
60 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
104 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
287 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
358 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 ...
-1
votes
2answers
187 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 ...
0
votes
1answer
714 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
49 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 ...
3
votes
1answer
542 views

Error ORA-01034: Oracle not available

I have an old Novell server which runs DocsOpen. I know very little about this system, basically we had a disk fault which halted the system. The server was rebooted and came up, I had to manually ...
1
vote
3answers
16k views

Cannot log into Oracle Enterprise Manager 11g: ORA-28001

I can no longer log into Oracle Enterprise Manager 11g. I get this error message: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) I could log into the server using SQL*Plus. I ...
2
votes
4answers
246 views

Oracle performance problem

We are using an Oracle 11G machine that is very powerful; has redundant storage etc. It's a beast from what I have been told. We just got this DB for a tool that when I first came on as a coop had ...
0
votes
1answer
94 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 ...
0
votes
2answers
673 views

Oracle Database Recovery Problem

I am very new to Oracle, and trying to restore a oracle 8i database on win 2000 server. I have one week old database backup (backup taken with exp command), and i want to restore it now. Now I am ...
2
votes
2answers
2k views

Executing Oracle SQLPlus in a Powershell Invoke-Command statement against a remote machine

We have a basic powershell script that attempts to execute SQLPlus.exe on a remote machine. The remote does not have Oracle Instant client installed, but we have bundled all the necesary dlls in a ...
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
824 views

How to mount an Oracle database to new instance?

I have an instance of Oracle 10g R2 installed on Windows Server 2003. This instance was running a database which does not have any backup. Now the OS went down, could not be repaired, and all I got is ...
1
vote
1answer
306 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 ...
2
votes
3answers
671 views

Getting an alert when my oracle database goes up or down

How can I get an e-mail alert when my oracle database comes up or down? I have a database that I need to know when it goes down (it would be nice to know if it has come back up), preferably from a ...
0
votes
1answer
74 views

Jmeter gets Apache lost db connection

I have a web app that makes to many ajax requests (update data with a grid). When I use JMeter to make a stress test with 20 threads and 10 loops, my web application canno't connect to the database ...
3
votes
2answers
537 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 ...
2
votes
5answers
17k views

Why Oracle database generates lots of archived log per day when there is a small changes to the database?

I'm currently using Oracle database 11g on RHEL5. My database generates a lot of archived logs per day even there is a small amount of changes to the database (about 500 transactions a day). I also ...
0
votes
1answer
507 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 ...
1
vote
0answers
3k views

IIS can't load Oracle.Web assembly (for ASP.NET membership provider)

I am trying to configure an IIS web site to use an Oracle database for ASP.NET membership, but I can't get it to work. IIS doesn't seem to be able to load the assembly containing the Oracle ...
2
votes
2answers
87 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
3
votes
2answers
2k 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 ...
1
vote
1answer
927 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 ...
1
vote
2answers
1k views

Oracle import fails due to NLS_DATE_LANGUAGE setting

I have an Oracle 10 database server and a dump created on another Oracle 10 server. When using the imp command to import the dump to the database: imp 'sys/*** as sysdba' file=c:\[...]\strukt.dmp ...
0
votes
2answers
106 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
1answer
3k views

configuring oracle-ds.xml file in jboss

how can I connect jboss with database and how can I configure oracle-ds.xml
3
votes
1answer
149 views

Oracle RMAN Full Database Recovery

I want to restore a full database backup of a database in noarchivelog, but not the last backup. How can I select the full backup to restore?
1
vote
1answer
245 views

Oracle 8i - Error signaled in parallel query server

I am attempting to run a query against an Oracl 8i database instance running on Aix. It is a simple select * against a single table. The query runs for approximately 8 hours and then throws the ...
0
votes
2answers
179 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 ...
3
votes
2answers
110 views

Migration from oracle to DB2

I want to migrate my oracle schema to db2. Any tool available for migration? Please help
0
votes
4answers
4k views

Can't run GUI while installing Oracle in Linux from a jar file

I'm trying to install an oracle product in Linux using a jar. When I run the command "java -jar installer.jar" using the root user, the installer's GUI shows up without problems. But if I try to run ...
0
votes
1answer
222 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
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 ...
2
votes
4answers
512 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
856 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
123 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 ...