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/
Questions tagged [oracle]
850 questions
7
votes
2 answers
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 searching, and I am looking for the right…
L1opardo
- 339
- 2
- 5
- 9
7
votes
1 answer
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 disk failed
WARNING: failed to write mirror side 1…
ewwhite
- 194,921
- 91
- 434
- 799
7
votes
5 answers
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 can't find any information that points me directly…
sam
7
votes
3 answers
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 NetBackup, there is the concept of Multiplexing which…
Jonathan Bourke
- 91
- 2
- 7
7
votes
3 answers
How do I find out which tnsnames.ora file is being used by my linux system?
When I do an updatedb and locate tnsnames.ora I get back a long list due to various Oracle DB installations. I need to add some entries to whichever is the "default" tnsnames.ora configured for the system.
How do I find out which of the many…
TiGz
- 171
- 1
- 1
- 4
7
votes
2 answers
Oracle 10g for Windows does not start up on system boot
We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to Windows Server 2008 Hyper-V.
The services start on…
Mike Dimmick
- 251
- 2
- 4
6
votes
1 answer
Howto install Oracle OCI8 instantclient on Ubuntu 18.04
I want to share some information about my OCI8 installation to access Oracle databases.
If you got errors like "PHP Startup: Unable to load dynamic library 'oci8.so'"
or "checking Oracle Instant Client library version compatibility... configure:…
FixFaier
- 301
- 1
- 2
- 8
6
votes
5 answers
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 the database mounted (as in, has someone done…
Matt Simmons
- 20,218
- 10
- 67
- 114
6
votes
2 answers
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 user_tables. Also, all of its partitions and indexes show up…
Jeremy
- 163
- 1
- 4
6
votes
4 answers
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 package likely do not to require relinking, some do,…
wzzrd
- 10,269
- 2
- 32
- 47
6
votes
7 answers
Things every Oracle DBA should know
This could include:
Books worth reading;
Tools worth having;
etc.
cletus
- 9,779
- 9
- 36
- 40
6
votes
4 answers
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 records from the same table, hanged by the time the…
RPK
- 215
- 1
- 5
- 12
6
votes
8 answers
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?
Bryce Wagner
6
votes
2 answers
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 tape).
Anyone can shed a light on this please?
OS is…
Andreas Wong
- 219
- 3
- 10
6
votes
3 answers
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 experience with Oracle so I'll defer to anyone who has…
nvahalik
- 203
- 1
- 2
- 6