Questions tagged [oracle]
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. Most questions about Oracle are better placed at the sister site https://dba.stackexchange.com/
18
questions
7
votes
2
answers
8k
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 ...
13
votes
2
answers
27k
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
5
answers
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?
41
votes
7
answers
25k
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
1
answer
2k
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
1
answer
363
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?
3
votes
4
answers
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
1
answer
403
views
Can I "flush and lock" an Oracle database to do a filesystem backup?
I'm using ZFS to take snapshots of running OpenVZ containers.
For MySQL databases I can use flush tables with read lock to put them in a flushed & locked state. This will put the underlying files ...
3
votes
2
answers
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)?
3
votes
3
answers
6k
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 ...
3
votes
2
answers
9k
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
4
answers
4k
views
How to best optimize an Oracle database for writes?
How can I maximize the write performance without impacting reads?
2
votes
1
answer
7k
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 ...
2
votes
4
answers
35k
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 SQLPlus. I warned ...
2
votes
4
answers
8k
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 ...