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

4
votes
2answers
5k views

Install Oracle Linux 6.4 on HP ProLiant DL380e Gen8 server

installation does not detect the raid 1 logical drive created from ACU. the installation shows the two 2T disks, and after the installation is complete, I can not boot up to the system. I have been ...
11
votes
2answers
17k 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 ...
3
votes
5answers
1k views

Hidden features of Oracle Database

As my daily job circles around an Oracle DB I wonder are there any hidden features that could come in handy in day to day work with the DB, both as a developer and as a DBA?
29
votes
7answers
7k 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 ...
7
votes
1answer
849 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 ...
2
votes
1answer
239 views

Microsoft SQL alternative for Oracle's Imp and Exp command

I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases. Any suggestions?
2
votes
2answers
2k views

prevent ORA-28001?

Using Oracle 11g, is there a way to prevent my user's passwords from needing to be updated (ORA-28001)?
2
votes
4answers
3k views

How to best optimize an Oracle database for writes?

How can I maximize the write performance without impacting reads?
2
votes
3answers
3k 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 ...
1
vote
3answers
5k views

Easy Oracle Log-Shipping

I am looking for a decent way of keeping a secondary Oracle database up to date without exporting and importing the database each time. There are 3 users on the instance that I would essentially like ...
3
votes
4answers
1k views

VMWare VCenter Server 4.1 & Oracle

We have VCenter Server 4.1 set up to use Oracle database (11r2 with the latest patches). Everything works fine except the vcenter server starts very slowly, at the startup time one of the oracle ...
3
votes
2answers
6k views

Oracle Linux 6 kernel panic boot - anything I can do?

I'm running Oracle Linux 6 on a HP Proliant server. It's been running fine for the last week, but seemed slow earlier so the Oracle service was stopped. Rather than restart the service, I was asked to ...
2
votes
3answers
20k 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
4k views

How to make RHEL have persistent local hdd name?

I have 2 identical Dell R720 servers running identical Oracle Enterprise Linux(RHEL)6.4. Both servers (supposedly) configured in exactly the same way. However, one of the servers is behaving ...
2
votes
1answer
8k 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
4k views

oracle database move current server to another machine problem

these day i really stress because of oracle server, im quite new to oracle. i have one old windows 2003 server which installed oracle 10.2.0 version. and i want to full backup of this oracle then ...
1
vote
3answers
3k views

How do you clone an oracle instance?

How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname. I'm working with Oracle 10.2.