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

10
votes
2answers
14k 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 ...
0
votes
2answers
935 views

The same database name different server in same domain possible?

In Oracle world - is it possible to have the same database name in a different server in the same domain? In our test environment the database server is cloned (VMWare) and then our DBA have to ...
2
votes
1answer
3k views

Oracle ORA-19011: Character string buffer too small

I'm trying to do an insert from a XML column to a CLOB column and I end up with this error. ERROR at line 1: ORA-19011: Character string buffer too small Any ideeas of what i can do ?
0
votes
2answers
599 views

Why doesn't my oracle asm disks show up under dbca?

I am running into a problem where I have created some ASM disks under linux, they show up when I run oracleasm listdisks, but they are invisible when I use dbca and try to Configure Automatic Storage ...
1
vote
4answers
7k views

Running Oracle 10g and 11g side-by-side

I recently tried installing Oracle 11g on a server already running 10g. Each would run independently with no problem, but 10g refused to run simultaneously with 11g. Can this be done? I don't need a ...
1
vote
3answers
198 views

perl question needing to get value from file

I am writing a perl script to automate certain processes on our Oracle databases. One portion of the script involves putting the script to sleep until the alert log shows the database open. I intend ...
1
vote
2answers
2k views

How to fix corrupt indexes blocks in SYSAUX tablespace

we had power failure that left corruption in data files. It was recovered from RMAN backup including logs and all is OK, the DB is working.. except that I noticed this: RMAN> BACKUP VALIDATE CHECK ...
1
vote
2answers
204 views

What knowledge should Oracle DBAs and sysadmins share?

http://serverfault.com/questions/20248/what-would-make-working-with-dbas-easier already touched on the question of interaction between DBAs and sysadmins. The answers focused on personal interaction ...
1
vote
2answers
79 views

How do I re-execute a skipped section in Oracle Data Pump?

I did a start_job=skip_current on a large import because I thought it was hanging on some bad data. It turns out it was just a really large index so I'd like to re-run it but I don't want to do the ...
2
votes
6answers
1k views

Copying 100 billion records per day to Oracle - how?

I have received a request to make a 100 billion records database available on Oracle, too. Optimizing using replication is not an option, unfortunately, so I guess the easiest solution is to create a ...
0
votes
1answer
195 views

Oracle hardware requirements and optimization [closed]

I'm an application developer. We have some reporting solution for our client on Oracle database 10g. They would like to speed up execution of some calculation stored procedures. Ok, I know about query ...
0
votes
1answer
2k views

installing Oracle Instant Client 10.2 on Solaris

we are trying to install Oracle Instant Client 10.2.0.2 for Solaris x86-64 in order to connect to an Oracle database on another server. I downloaded and unzipped the required files into an ...
3
votes
1answer
5k views

How to get Redo Rate per second?

I am configuring data guard. So I want to calculate required bandwidth as formula: Bandwidth in MBPS = (redo bytes per sec /0.7)8)/1,000,000 Can someone explain how would I be able to calculate the ...
2
votes
1answer
675 views

Oracle DB import error

I get the error below when importing a database - any ideas why? I do this type of import all the time and I've never seen this error. Prior to doing the import we drop all objects in the schema. ...
2
votes
2answers
431 views

Linking to oracle from SQL Server 2005, this sucks

I need to create a link server from SQL Server to Oracle, but I'm having no luck. I've install the oracle 10g client software and I'm able to use TOAD for oracle and use ODBC to connect to the ...
2
votes
2answers
214 views

How do you use Oracle's tools from scripts?

Most Oracle tools and scripts request that you pass them the password via the command line - where everyone on the same machine can see them. Example: exp <user>/<password> ... Is there ...
2
votes
5answers
2k views

Why does this SQL run so much faster in a Oracle server with the same hardware/data than another Oracle server?

My application has a SQL that takes ~ 30 min to run in the Oracle server in production. It takes about the same in a test Oracle server. For some reason, in another Oracle server, it runs much ...
4
votes
3answers
329 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
4answers
8k 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 * ...
2
votes
1answer
1k views

Documentation on the SQL execution plan page in Oracle Enterprise Manager (Oracle 10g)

In Oracle Enterprise Manager, in "Performance > Top Activity", you can click a SQL that is being executed and then go to the Plan tab to see SQL execution plan. For the execution plan, the Enterprise ...
2
votes
3answers
3k views

How to determine SQL causing Oracle CPU Spikes

I have a J2EE Spring/Hibernate webapp using Oracle 11g for persistence, occasionally in production the Oracle CPU spikes to 100% usage, restarting Tomcat drops the Oracle CPU. I am unable to ...
1
vote
1answer
138 views

Oracle / PHP / Apache

I have built a web app that was performing very fast, until users from a third coutry (the majority) started using the application. Now its very slow. I see from the logs that I keep getting ...
1
vote
1answer
1k views

What permissions do I need to run SQL*Loader?

What permissions does a database user need to be able to run oracle's sql loader? For instance, since sql loader will disable indexes and triggers, does it need ALTER permissions for those items? ...
2
votes
4answers
476 views

Oracle Logical Standby redo generation

Oracle 10.2.0.4 database with a logical standby on Win2K3. Recently a rather large delete operation was carried out on the production instance. I'm experiencing difficulty with the logical standby, in ...
1
vote
5answers
6k views

Open source scripts for Oracle health check?

I want to put together some scripts to run an automated health check of Oracle 9i and 10g databases. Before I start from scratch, I was wondering if anyone know of any available open source scripts ...
2
votes
1answer
255 views

Non-intrusive stored-procedure auditing on Orace 10g

I'm working in a environment where there are a large variety of legacy client programs. I'm trying to get an idea of which programs use what stored procedures. Is there a way to audit access to a ...
1
vote
1answer
514 views

Migrating data from Oracle database to Pervasive .DAT files

The requirement is to migrate some tables with data from a Oracle database server to Pervasive database's .DAT file. Then those .DAT files will be used by a Pervasive database server. The ...
1
vote
1answer
138 views

Find wait reason in Oracle

I'm running a Java application with an Oracle 10g. I've discovered kind of a race condition that leads to an inifite long waiting time for an UPDATE statement. To solve this situation I'd like to ...
3
votes
1answer
2k views

ActiveMQ with persistence in a database

Are any of you running ActiveMQ with persistence in a database? Even better, in an Oracle database? We're wanting to replace our current JMQ uses with ActiveMQ. The plan is to have two machines ...
1
vote
4answers
960 views

Oracle account locked

I had a user in my oracle DB with some 'x' password for sometime. Without notifying my team I changed the password to 'y'. But my team members tried to connect to the machine with the old passowrd 'x' ...
0
votes
2answers
2k views

Accidently overwrote system.dbf - What now?

I accidentally overwrote system.dbf in /usr/lib/oracle/xe/oradata/XE/system.dbf Well I did not actually do it accidentally, however I overwrote it because of other failures in the database. And when ...
1
vote
2answers
439 views

Oracle9i export error

When I rut the following: set ORACLE_SID=orcl exp.exe 'SYS/system as sysdba' full=y log=exp.log file=mydump.dmp in the end i see the following: EXP-00056: ORACLE error 942 encountered ORA-00942: ...
1
vote
1answer
656 views

How to rescue oracle instance having oradata and admin?

I have copy of oracle folder, installed on windows. There are have oradata and admin folders. It is Oracle 9.2.0.8.0. I had working WibXP operation system, and installed oracle there. Now WinXP, ...
1
vote
4answers
13k views

SQL Navigator startup error: Unhandled Exception at startup - Cannot find OCI DLL: oci.dll

I am using 64 bits Windows 7. Oracle Development Tool: SQL Navigator 5.5 was installed on my computer. When I try to start the program I get this error: "Unhandled Exception at startup - Cannot ...
3
votes
8answers
395 views

Should a DBA store and retrieve passwords

Should a DBA record passwords for application logins, or should this be a responsibility of developers/analysts? By application login, I mean the login which an application uses for access to the ...
1
vote
1answer
83 views

Oracle xml column to xml file

I want to automatically generate an xml file for every record found in an xml column in a table. Is there a script using a cursor or another method to do that?
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 ...
2
votes
1answer
994 views

Oracle: Can Weblogic 11G run PL/SQL code like App Server 10G?

This is probably a silly question, but I'm not an oracle admin so I'm not sure. Our client currently runs a website written in PL/SQL and HTML on a Oracle 10G system. As everything is moving in the ...
1
vote
1answer
1k views

Rolling Upgrade of Oracle 11g from 32 bit to 64 bit?

I have an Oracle 11.1.0.7 database running on windows 32 bit. I would like to upgrade to 64 bit (same version of oracle) and would like to use a standby database for a rolling upgrade. Is this ...
1
vote
1answer
3k views

ORA-01041 error when duplicating database to new host

I'm using RHEL 5 with Oracle 11g and I'm testing data guard. I am trying to setup data guard by following this link: ...
1
vote
2answers
1k views

how does odbc driver work?

I have an application hosted on jboss. use jdbc driver of oracle to connect to an oracle 10.2g database. Can anyone guide as to what happens when a session is established. Just trying to understand ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
1
vote
2answers
124 views

Correct directory for Oracle installation on Linux

What is the best directory to install Oracle on Linux box? /srv, /opt, /usr/local?
1
vote
1answer
3k views

Oracle temp file TEMP01.DBF taking up too much space

Can I delete this file or recreate it with a size limit? Thanks.
2
votes
1answer
9k views

Oracle XE 10g: missing file spfileXE.ora (Windows Server 2008 64 bit)

I'm having problems installing Oracle XE 10g on a Windows Server 2008 64 bit machine. After the installation the connection to the database administration page http://127.0.0.1:8080/apex fails. If ...
1
vote
1answer
2k views

How to Check Oracle Extent Free Space Available?

I need to add some indexes to a moderately large table and I'd like to know in advance if the tablespace has room to hold the index. (The extents are suppose to automatically increas in size, but the ...
0
votes
1answer
925 views

Weblogic - Adding websites

Is it possible to create a website in a domain pointing to a local directory? Or does everything deployed to Weblogic have to be WAR, EAR, RAR or JAR? I want a simple possibility to just FTP to a ...
2
votes
1answer
4k views

Installing SSL Support in Weblogic 10

I have some troubles installing my SSL Certificate into Weblogic 10, here are my configuration steps: Copied the .cert and .key to the server Executed the following: []# keytool -import -keystore ...
0
votes
3answers
170 views

Which platform has good job openings in Oracle 91 & 10g

I plan to do an Oracle course in Dream infotech. They are providing training in Oracle on Linux / Solaris. Which platform is best and has good job openings?
2
votes
2answers
6k views

Extremely High V_$SYSTEM_EVENT Wait Times on Oracle DB

I'm working on troubleshooting an oracle DB that's having some general performance problems. I ran the following query: SELECT event AS "Event|Name", total_waits "Total|Waits", ...