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
97 views

how many servers and in what configuration for web application by small company? [duplicate]

Possible Duplicate: Can you help me with my capacity planning? My question is from a startup company providing a web application for the first time. It consists of an Oracle database (11G), ...
1
vote
1answer
2k views

oracle - grant all privileges to schema

i've used mysql before and i'm now switching to oracle. I've already created a user in oracle. Now i want to give it "all privileges" for a schema. In mysql i can give all privileges (DML/DDL) for a ...
2
votes
3answers
6k views

How to install Oracle's exp / imp binaries

I was browsing the net to find a solution, but I had no luck. :( How can I install Oracle's imp / exp binaries to my CentOS box without installing an Oracle Server? I'm accessing an existing Oracle ...
0
votes
1answer
264 views

Installation of Oracle 10.2.0.4 in windows server 2003 [closed]

I have a problem in installingthe oracle database 10.2.0.4 in windows server 2003 environment, when I clicked the installer it always says "...\setup.exe isa valid, but is for a machine type other ...
-3
votes
1answer
258 views

install vncserver without yum on Oracle Linux

can anybody describe me how to install vncserver on Oracle Linux without yum? (yum does not work because it is a pre-built appliance - timeouts all the time)
2
votes
1answer
810 views

Sparc v440 unable 2 boot after recommended patch install

After installing the October 2011 recommended patch bundle on a Solaris 10 the host fails to boot. The output is {0} ok boot SC Alert: Host System has Reset screen not found. keyboard not found. ...
0
votes
1answer
1k views

Trying to install pdo_oci via PECL fails asking for PDO extension

I'm using Linux Mint 11 (based on Ubuntu 11.04) and I need to use PHP with Oracle through PDO, a requirement of the framework we will work with. I've installed various PDO extensions using the normal ...
0
votes
3answers
382 views

XP IIS no longer listen to port 80 or 443 after installing Oracle 9i HTTP Server

I have installed Oracle 9i HTTP Server together with the database. After restarting the PC, even though i restarted the IIS and stopped the Oracle HTTP Server. When I go to http://localhost/ The ...
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
1
vote
0answers
990 views

Oracle 11gR2 error while installing on RHEL6_x64

Whenever I attempt to install Oracle it gives me this error in the install wizard on the group configuration screen. I am using group oinstall and user oracle has also been created. INS-30060] Check ...
1
vote
2answers
98 views

Is it possible that I can change Port Number in Oracle 10g for remote connections

I am creating a project in Oracle Is it possible that I can change Port Number in Oracle 10g for remote connections ?
0
votes
1answer
478 views

Setup VirtualBox to see Oracle on a Local guest

I have a Ubuntu machine and I have a Linux instance running in a Virtual-box on this machine. I need to connect to the oracle instance (through the oracle extension in php) . The extension is running. ...
0
votes
1answer
334 views

Does DBMS_ALERT work correctly on an oracle RAC cluster?

Can anyone confirm whether the oracle DBMS_ALERT package works correctly in a RAC envirnoment. That is, if I have a DBMS_ALERT.WAITONE() on all instances, then I do a DBMS_ALERT.SIGNAL(), will all ...
2
votes
2answers
422 views

Is there a way to dump an Oracle db as SQL statements, à la pg_dump?

I'm very new to Oracle. It looks like all the Oracle DBA use binary only dumps. This sometimes cause problems, and seems rather useless to me (performance gain is bound to be negligible), but what do ...
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 ...
1
vote
1answer
572 views

Oracle on Solaris 10 : 15min TCP Timeout

I have Oracle10g running on Solaris 10. The configuration of the OS is standard, and there is a packet filter firewall running on the server. When I run a long query using sqldeveloper, the server ...
0
votes
1answer
367 views

Oracle EM detect a disk full, but the system has plenty of free space

My enterprise manager instance on Oracle 10.2.0.4 throws the following alert on a regular basis: Name=db4 Type=Host Host=db4 Metric=Disk Utilization (%) Disk Device=sd1 Timestamp=Oct 4, 2011 2:15:50 ...
1
vote
0answers
569 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: ...
2
votes
1answer
290 views

What are the best practice for monitoring Oracle's rollback segment?

Occasionally, we run out of rollback segment space causing the query/update to fail. What are the best practices that I can expect from an Oracle DBA to ensure that this is monitored pro-actively and ...
6
votes
4answers
3k views

Why “Begin Transaction” before “Insert Query” locks the entire table?

I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with ...
2
votes
3answers
12k views

How do I make imp use right charachter set?

I am trying to import a dmp file from one database to another. The problem is that some special danish characters are not imported right because some character map conversion is done during import. ...
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
56 views

Oracle SGD 4.61.915 not closing Windows 2003 application sessions

I'm using a Windows 2003 Application Server and I have followed this article: http://download.oracle.com/docs/cd/E19351-01/821-1926/z40000df1311155.html#bbjiefec but still.. when i close a application ...
2
votes
1answer
149 views

Oracle Backup Strategy

I have recently inherited a smallish Oracle database running on a SPARC Solaris 10 Server. I have been asked to implement a sensible backup strategy. The database has about 3000 odd tables and is ...
2
votes
1answer
90 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
1answer
4k views

Oracle Enterprise Manager showing Agent Unreachable, negative disk space?

I'm recently installed Oracle 11g on a Windows Server 2008 box and although the database appears to work just fine when I load up the Enterprise Manager in Firefox it tells me 'Agent Unreachable'. ...
1
vote
1answer
1k views

Large amount of cursors causing slow response and massive CPU usage - cursor: mutex s

We have a problem with our Oracle server. It was upgraded to 11g a couple of months ago and is running a third-party system. The system has been running for years (and has had several other issues), ...
2
votes
0answers
50 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 ...
3
votes
1answer
411 views

Oracle DB on drbd or SAN replication with Oracle Data Guard

I'm looking to deploy an application based on Oracle DB, and I was assuming that it would be possible to easily do active/passive clustering (with RH Cluster or Heartbeat) and synchronous replication ...
0
votes
1answer
167 views

Oracle Unbreakable Enterprise Kernel compatible with CentOS?

I'm installing Oracle 11.2. Anyone know if Oracle Unbreakable Enterprise Kernel ... (1) is required to be installed for CentOS 5.5? (2) may optionally be installed on CentOS 5.5? I'm following the ...
0
votes
4answers
756 views

SQL server Vs MySql vs Oracle for a large government project [closed]

I am in charge of deciding which database to use for a big government project with: 100 Million records (estimated in one big table) Availability and data reliability is paramount. Performance not ...
4
votes
1answer
147 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
1answer
218 views

Oracle has exactly 20 second delay

I have a development oracle server in the office that has worked for several months up until Friday, when each and every call started returning after a 20 second delay to my computer. The delays are ...
54
votes
7answers
5k views

What are the drawbacks of running a database inside a virtual machine? How do I overcome them? [closed]

Running anything inside a virtual machine will have some level of performance hit, but how much does it really impact the performance of a database system? I found this academic reference paper with ...
1
vote
2answers
105 views

Error 503 on SQL/Oracle prodécure execution

I'm facing a problem with the Apache/Tomcat/JDBC/Oracle communication configuration of an application. Here are all the informations I have at my disposal about the problem : A button on the ...
0
votes
1answer
278 views

Oracle 10g cannot start after cloning server with dd

I used dd to clone a x4100 server with Linux Red Hat. The hardware is identical for old and new servers. Then I changed IP address and host name. The newly restored server is up and running but Oracle ...
3
votes
2answers
346 views

Oracle RAC failover backup procedure

We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database which is located in a town 20km from the data center. The script ...
0
votes
1answer
247 views

oracle 10g tablespace table relation?

Im running "Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production" and trying to get familiar with it. I have created a tablespace und set it online. How do I make sure the next create ...
1
vote
4answers
943 views

CPU utilization is low but swapped out processes and blocked processes is high

We're facing intermittent periods of 100% CPU utilization. Server Configuration:HP DL580 G7 (4 Processor with 8 cores each; 128GB memory.) Operating System: Solaris 10_x86 update 9 Application: ...
0
votes
1answer
497 views

Oracle performance after rebuild TEMP

My application was running without any problems for almost one year. But recently someone executed a big select for a report, and the Oracle´s TEMP datafile has grown from 5GB to 30GB. The server then ...
1
vote
2answers
1k views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...
1
vote
0answers
225 views

Oracle ODBC: DB on Windows Server 2003 – Windows 7 Client Connection Problems

I have an Oracle DB on a Win 2k3 Server (64-Bit). I have to access the database from a Win7 (64-Bit) machine. I have downloaded Instant Client and the 64-Bit ODBC driver, and have apparently ...
0
votes
2answers
162 views

Is it possible to restore an Oracle DB on a different Operating System?

Is it possible to restore a backup of an Oracle 10.2.0.2.0 database which runs on UNIX to an Oracle 10g Express Edition (10.2.0.1.0) instance on Windows?
1
vote
1answer
93 views

lock table syntax from mysql to oracle

I've a mysql sql locking some tables with different permission (read or write). I've to adapt it for oracle, but I did't found any clear documentation to do this job right. this is an example: LOCK ...
4
votes
1answer
171 views

Convert Oracle enterprise to redhat

Has someone converted successfully a running Oracle Enterprise Linux server to redhat enterprise and was able to register it on RHN network? Tried to install kernel from redhat, updated the rhnsd ...
1
vote
1answer
2k views

Can I recover an Oracle database to an instance with a different SID?

I've implemented a backup (and recovery) plan for an Oracle 11gR2 database as follows: Installed the same version of 11gR2 on production and disaster recovery (DR) servers Created identical Oracle ...
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 ...
2
votes
2answers
175 views

Is it possible to run a large Oracle Database (7TB) on Amazon EC2+EBS?

I'm wondering if Amazon EC2+EBS can handle large Oracle databases (7TB to start with). Sounds like EBS can have storage volumes of up to 1TB and I could have many storage volumes attached to the same ...
0
votes
2answers
2k views

How to get Sun X4100 Firmware updates from Oracle?

This document directs how to get there, but it is for the old Sun website. http://download.oracle.com/docs/cd/E19569-01/820-1188-12/core_ilom_firmware.html#50413605_67571 Download the flash image ...
4
votes
3answers
1k views

Backups take so long that the firewall closes the connection

A bit of a mashup of systems here, so bear with me. Essentially, I'm having some trouble using the Backup Exec agent for Oracle, while trying to backup a remote Linux server. The BE agent appears to ...