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

1
vote
2answers
12k views

How to register two net service names in local_listener parameter

I'm configuring data guard. I want to register the local_listener parameter with two tnsnames: tnsname1 and tnsname2. I use `ALTER SYSTEM SET LOCAL_LISTENER='tnsname1','tnsname2'; but it doesn't ...
2
votes
2answers
18k views

Oracle throwing this error: could not open registry key SOFTWARE\Oracle\ocr

I have an oracle installation that runs fine 95% percent of the time. But for some reason every day at a random time early in the morning (between 4:00am and 9:00am) I get the following error: [ ...
0
votes
1answer
59 views

How to create a database in Oracle8 Lite with Developer 2000?

I am new in Oracle. I install Oracle 8 Lite with Developer 2000. Now I want to create a database for me. For that I open Oracle8 Navigator and Create a database which user is system. But in Oracle SQL*...
5
votes
2answers
7k 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 '...
4
votes
3answers
762 views

Is an alternative there for Oracle Total Recall?

Oracle Total Recall is an option for Oracle Enterprise Edition (11g) that provides secure retention and access of historical data. From the white paper: Flashback Data Archive creates an ...
3
votes
5answers
4k views

What is the quickest way to kill all sessions from a specified user in Oracle?

What is the quickest way to kill all sessions from a specified user in Oracle?
0
votes
1answer
120 views

Version control and branching when using Oracle

At work we're using Oracle and C#/ASP.net to handle a customer's website, this site is very large-scale so the database is very large. We use Perforce for our version control, and tack create or ...
2
votes
1answer
12k views

How to create separate tablespaces in Oracle XE?

Creating separate tablespaces is possible in expensive versions of Oracle, but I can't seem to find a way to do so with the free version Oracle XE. The administration interface just has a "View ...
0
votes
2answers
716 views

Oracle Database Recovery Problem

I am very new to Oracle, and trying to restore a oracle 8i database on win 2000 server. I have one week old database backup (backup taken with exp command), and i want to restore it now. Now I am ...
0
votes
2answers
236 views

Oracle Advanced Security Options is Blank

I just installed Oracle DB 10gR2 with Oracle Advanced Security, but cannot see the algorithms. [user@db-1] adapters Installed Oracle Net transport protocols are: IPC BEQ TCP/...
1
vote
2answers
713 views

export from Oracle into SQL Server/mySQL

I have an Oracle database which we will be removing shortly. But I would like to store some of the data somewhere else so if can be accessed if required. Is there a standard/recommended method of ...
15
votes
5answers
924 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 ...
1
vote
1answer
1k views

Migrate Oracle database from Windows to Linux

I've got an Oracle 9.2.0.1 database running on Windows XP. This has several schemas and includes a public database link to a remote Oracle database. I'd like to migrate this database to Oracle 11g ...
0
votes
2answers
599 views

Importing oracle dump file, getting error on stored procedures

I export an oracle "schema" using exp userid=/ file=pt.dmp log=pt.log owner=FOO buffer=10000000 statistics=NONE direct=Y and then import it into a different schema on the same oracle instance on ...
1
vote
3answers
27k views

How do I fix “ORA-01033: ORACLE initialization or shutdown in progress” error?

I have an Oracle 9.2 database. The server has crashed. After rebooting any attempt to connect to the Oracle server returns error ORA-01033 (as in title). I've tried stopping and starting the Oracle ...
0
votes
1answer
90 views

How do I reset password for AD4J?

I installed oracle's AD4J sometime back and seem to have forgot the password. Not able to figure out how to reset the password for it. Please don't hate me for this :(
2
votes
1answer
2k views

Oracle Account Not Responding

I have an Oracle instance which has user1, user2 and user3 accounts. Yesterday I was able to log in to all three accounts. Today, I can get in to user1 and user3, but user2 is completely 'frozen' in ...
-2
votes
2answers
519 views

Oracle getting slow

My DB is getting slow on particular weekdays like Saturday and Sunday. What will be the reason? Database is Oracle 11g R1. Operating system is Windows 2003 64 Bit Service pack 2.
5
votes
3answers
16k views

SQL*Loader installation

Is it possible to install SQL*Loader without installing the whole Oracle package?
3
votes
1answer
528 views

OracleDbConsole and OracleJobScheduler

OracleDbConsole and OracleJobScheduler services in Oracle - What tasks they performing?
1
vote
1answer
153 views

Boot sequence of JBoss and Oracle

G'day, the recommended SysV startup files for JBoss and Oracle appear to have the wrong sequence. For jboss the community recommends putting # chkconfig: 345 80 20 into the /etc/init.d/jboss ...
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 ...
0
votes
2answers
1k 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
661 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
8k 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
199 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
207 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
99 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
197 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 /apps/...
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
863 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
446 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
230 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 faster:...
4
votes
3answers
333 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
9k 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
144 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 ORA-...
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
512 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 ...
3
votes
1answer
283 views

Good Oracle book for MySQL users? [closed]

Just started using Oracle, no previous experience. I do have a good amount of experience with MySQL (and played a little with PostgreSQL). Could you recommend me a good introductory book to Oracle ...
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
265 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
551 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
143 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 ...