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

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 ...
48
votes
10answers
129k views

Run Oracle SQL script and exit from sqlplus.exe via command prompt

I would like to run an Oracle script through SQL Plus via a Windows command prompt. The script does not contain an "exit" command, but I would still like SQL Plus to exit, returning control to the ...
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 ...
25
votes
7answers
4k views

Reasons to disable / enable SELinux

In the line of this question on StackOverflow and the completely different crowd we have here, I wonder: what are your reasons to disable SELinux (assuming most people still do)? Would you like to ...
20
votes
2answers
41k views

How do I turn off Oracle password expiration?

I'm using Oracle for development on my local machine. The password for a bootstrap account that I always use to rebuild my database has expired. How do I turn off password expiration for this user ...
16
votes
10answers
565 views

Should core system servers be able to connect to the internet for maintenance/support?

A couple of our servers have Oracle maintenance licenses. Our hardware vendor asked there was internet connection in the server room. Our policy is that all machines in that room is isolated from the ...
15
votes
5answers
901 views

Is my new Oracle DBA talking sense

When we setup FC LUNs for our MSSQL boxes we rarely have to present them with more than about 8 distinct LUNs of various kinds (Quorum, MSDTC, TempDB, Data, Logs, Backup and a few others). We have a ...
13
votes
6answers
20k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article ...
13
votes
3answers
1k views

Does my Oracle DBA need root access?

My Oracle DBA Colleague is requesting root access on our production servers. He is arguing that he need it to perform some operations like rebooting the server and some other tasks. I do not not ...
11
votes
2answers
847 views

Oracle 11gR2 - How to recover from normal redundancy when 1 of 2 failure groups goes down

Background info: Oracle 11gR2 2 failure groups - normal reduncancy Each failure group associated with a single disk Failure Group Alpha is one Disk 1 and Failure Group Bravo is on Disk 2 We ...
11
votes
2answers
2k views

Best practices for settings for Oracle database creation

When installing an Oracle Database, what non-default settings would you normally apply (or consider applying) ? I'm not after hardware dependent setting (eg memory allocation) or file locations, but ...
9
votes
2answers
920 views

How do you get the latest update for Java 6?

An application my company is considering buying requires Java 6. I am concerned that this is quite out of date and am recommending against the application as a result. But it seems that Oracle do ...
9
votes
2answers
13k views

Disable CPU cores in bios?

Is it possible to disable CPU (Intel) cores in BIOS, and if yes what HP/DELL (others?) 1U/2U servers would allow this? It is becoming difficult to find new server hardware with dual core CPUs, most ...
9
votes
5answers
4k views

Putting Oracle redo logs on DRAM SSD for a heavy write database?

I have a Sun M4000 connected to an EMC CX4-120 array with a write-heavy database. Writes peak at around 1200 IO/s and 12MB/s. According to EMC, I am saturating the write cache on the EMC array. I ...
8
votes
11answers
2k views

Linux or Windows 2003 (64 bit) for hosting an Oracle database?

Copied from StackOverflow Are there any overwhelming reasons to pick one over the other? I'm in the middle. Our database administrator says that Oracle on Linux is better, but cannot present proof. ...
8
votes
2answers
701 views

Is Toad from Quest a dying tool?

I've used and loved Toad for years, but I switched jobs and loaded Toad 10 and it's a disaster. Besides what I consider numerous look-and-feel degradations, I'm getting access violations out the ...
7
votes
5answers
54k views

How can I start Oracle Enterprise manager after restarting the Red Hat Server?

I installed Oracle 11g on Red Hat Enterprise server 5.0. First time everything worked well. After creating dbora script file in /etc/init.d/ and setting all the oracle environmental variables I just ...
7
votes
1answer
51k views

Differences between classes12.jar, ojdbc14.jar, ojdbc5.jar and ojdbc6.jar

We are planning to upgrade our application servers to a new version of JRun which is carrying with it an upgrade from Java 1.4 to Java 1.6. As part of that, we have been testing various pieces of our ...
7
votes
1answer
479 views

LSI RAID controller errors on DB import - How to troubleshoot?

We're running an import of a database dump on an Oracle system - (RHEL 5.9, 2.6.18-348.6.1.el5). The import does not complete, eventually erroring-out with: ORA-15080: synchronous I/O operation to a ...
7
votes
3answers
3k views

NetBackup Multiplexing for Oracle RMAN Backups

My question is... what multiplexing factor in NetBackup is recommended / do you use for Oracle RMAN backups over 1Gb/s management network to LTO3? JB Background: With enterprise backup tools like ...
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 ...
6
votes
4answers
82k views

How to restore/import an Oracle database from dmp file?

I've recently recieved the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now i need to restore the original database. Can anyone give me a step to step ...
6
votes
2answers
222 views

Oracle: 1 Large Server vs. 2 Smaller Servers?

We are in the planning stages of setting up our production Oracle 10gR2 environment. Our budget gives us the ability to buy 2 processor licenses of Oracle DB Standard Edition. We have minimal ...
6
votes
2answers
400 views

Backing up oracle to TAPE

our Oracle database has grown very large as of late ~= 400 - 500 GB and saving to filesystem is not scalable anymore to us. We are looking at using RMAN to backup to tape (directly, not to fs then ...
5
votes
8answers
5k views

Can Oracle and SQL Server exist on the same server?

We want to install SQL Server on a legacy machine which is running Oracle. Is there any reason why they cannot coexist on the same machine?
5
votes
7answers
1k views

The wisdom of exposing a database server on the internet?

The leadership of the small company I work for has gotten very excited about SaaS and is pushing our product into a SaaS deployment - I have a concern about this because part of the functionality of ...
5
votes
8answers
6k views

Installing Oracle 11g for 64bit on Ubuntu 10.04 server 64bit?

I want to install Oracle 11g for 64bit on a Ubuntu 10.04 64bit server.Does anybody knows how to install the Oracle 11g on Ubuntu from the scratch(pre-installation to post-installation)?
5
votes
2answers
421 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 ...
5
votes
1answer
256 views

How to prevent remote login for SYS

Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
5
votes
3answers
1k views

Physical Vs. Logical standby database

I want to open the discussion about the Data Guard Configuration. A Data Guard configuration consists of one production database and up to nine standby databases. A standby database can be either a ...
5
votes
3answers
2k views

How do you determine the OWNER of an Oracle Database

When you install an Oracle database in a Unix server, the Unix user id you use for the installation becomes the OWNER of the database. What is the most reliable and general way of determining in a ...
5
votes
5answers
4k views

Setting up array of SSDs for Oracle Database, recommendations?

I am configuring a server for a small, but read I/O intensive database. It serves as a master index for public access to a larger Oracle RAC database. When looking at the requirements for I/O, it was ...
5
votes
2answers
6k views

How to delete .dbf file in oracle?

I am trying to recreate a tablespace in Oracle and get the following error message: "created file already exists" I am running the following script: create smallfile tablespace dev_01 datafile ...
5
votes
2answers
6k views

When to relink Oracle?

Various sources on the internet suggest relinking of Oracle binaries is necessary after each OS upgrade and / or patch. I can understand relinking would be necessary when upgrading glibc. Some ...
5
votes
3answers
5k views

ORA-01019 error only as an administrator

I'm having a strange problem. I've installed the Oracle 10g client on a terminal server running Windows Server 2008R2. When I try to connect to Oracle, using, say, Toad, I receive the error ...
5
votes
2answers
820 views

Can't access database server over VPN

I am attempting to connect to an Oracle server via a VPN. I have tried to do so, unsuccessfully, from OSX and, alternately, from a Windows XP VM machine (VMWare Fusion) running on OSX. I can, ...
4
votes
3answers
33k views

Oracle: how to find out storage space used by a table?

How to find out (if possible via Enterprise Manager), the total in Mb that a certain table is using?
4
votes
3answers
326 views

MultiCPU servers - which one can you suggest? [closed]

We want to install a couple of big servers for our customer to run Oracle on one and Java applications on another. Tired with clusters, replications, want to run everything on one big server. We ...
4
votes
6answers
899 views

Oracle DB on VMWare?

Management have OK'd a migration of our main Oracle DBs to a virtual machine platform. Operations say they'll dedicate heavy-duty hardware and only run the DB VMs on it. I've heard that running DBs ...
4
votes
5answers
4k views

Are there any disadvantages of using UTF8 in an oracle database?

We are installing ordering a configured oracle database and they are asking us what character encoding we would like to have. The application (in Java) is in English only but users are from different ...
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 ...
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 ...
4
votes
2answers
18k views

How to install Oracle OLE drivers for use in SQL Server 2008 R2 x64

As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our ...
4
votes
4answers
17k views

ORA-12705: Cannot access NLS data files or invalid environment specified

I am getting this error while trying to create a connection pool, on my Oracle database, Oracle 10gR2. java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot ...
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 ...
4
votes
4answers
28k views

How can I tell if an Oracle database is mounted and activated?

IANADBA, but I'm writing a script that will take action as long as the oracle standby database hasn't been activated. What I'm looking for is two queries (or sets of queries, if necessary). 1 - Is ...
4
votes
2answers
115 views

Is there any viable alternative to using Oracle Auditing

I am currently tasked with developing a action plan for monitoring DB activity, encompassing general actions (failed logons etc) with some finer grained monitoring(e.g. who selected from table x, what ...
4
votes
4answers
7k views

Moving a table to a different schema in Oracle

How do I move a table from one schema to another? It's a fairly large table, so the following query would take ages to complete and need huge disk space: CREATE TABLE newschema.mytable AS SELECT * ...
4
votes
4answers
30k views

Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name

Can someone explain to me what's the difference of SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name in Oracle ? Thanks Michael
4
votes
2answers
17k views

What is the typical maximum number of database connections for Oracle running on Windows server?

We are maintaining a database server that serve a large number of clients. Each client typically running serveral client-applications. The total number of connections to the database server (Oracle ...