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
0answers
935 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
97 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
431 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
310 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
386 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
980 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
497 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
340 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
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: ...
2
votes
1answer
272 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
11k 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
54 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
144 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
87 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
3k 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
49 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
369 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
165 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
724 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
125 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
210 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
97 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
270 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
324 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
240 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
885 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
467 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
885 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
211 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
157 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
91 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
167 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
173 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 ...
0
votes
1answer
331 views

Oracle Restore and recover Database on the same host?

I have DB1 database on Server1 . I have taken backup. After that I have created table TEST. Inserted some values in the TEST table. Truncated table. And want to return my TEST table to its ...
0
votes
2answers
126 views

Oracle Security Update Patch July 2011 - How to know if i am affected?

Oracle Security Update Patch July 2011 I am using JDK 1.4.2_08, 1.4.2_19, 1.4.2_22, and Oracle DB 9.2.0.8. Can any experts tell me how to tell if i am affected, i.e. after installing the patch ...
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, ...
0
votes
3answers
209 views

Which Linux distribution and backup software should I use for Oracle backups

I want to install Linux with an Oracle database on it and configure Oracle to make weekly backups. Please, advice me which distribution I should install. Also, how do I confugure my database to make ...
1
vote
1answer
66 views

oracle setup new database on oracle linux 5

I've installed oracle11g on OracleLinux5, in order to replicate a customers oracle configuration. I only have access via SSH and the web interface, and i need to setup the character set,and a few ...
1
vote
4answers
22k views

Oracle database is very slow - Where to start and how to find the cause?

Our Oracle database(11g) is very slow all of a sudden. I donno where to start the debugging process to find what actually is the problem? I tried generating table stats and looked for locks..but i ...
4
votes
1answer
187 views

Oracle automatic patch download

I need to update/patch the firmware of a lot of Sun/Oracle systems quite frequently. To do that I first need to download the latest firmware snapshot by hand from Oracle's saggy and unsophisticated ...
0
votes
1answer
165 views

“Oracle initialization or shut down in progress” problem

I installed oracle 9i before 20 days, it was working fine till now but now when i try to login from scott user with correct password it is giving oracle initialization or shut down in progress error ...
0
votes
2answers
117 views

Confused: SunOS Licensing [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I'm confused about the state of OpenSolaris/SunOS/OracleExpress.. Can I use SunOS 10 for free? In a productive ...