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
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
459 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
242 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
492 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
136 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
1k 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
928 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
426 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
562 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
12k 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
384 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
60 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
944 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
122 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
8k 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
908 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
5k 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", ...
1
vote
1answer
172 views

PHP/Oracle Connectivity randomly “drops out”

Here's the current situation - I have two web servers (for now named A and B) and two database servers (named C and D). The web servers are quite old, and are running an early version of Apache 2 + ...
1
vote
3answers
349 views

Oracle DB Deadlocks

We have a situation where a db is "slowing down". DB operations that normally take a second or two are taking ten times as long. There appear to be a large number of locks in the DB when this is ...
0
votes
2answers
2k views

What linux filesystems does Oracle 10g support?

I am wondering if there is a supported (or recommended) list of filesystems that Oracle 10g supports. Specifically I wish to know if storing Oracle data on an XFS partition is a bad idea. I ask ...
2
votes
1answer
1k views

Oracle 10g on Snow Leopard?

I have found a couple of pages on how to get this configured on Leopard (link and link), and then apparently an upgrade to Snow Leopard does not seem to complicate matters much. However, I'm already ...
2
votes
2answers
925 views

How do I setup Red Hat Enterprise Cluster and oracle 9 to support failover?

I am trying to figure out how to use RHEL cluster to have automatic failover of an oracle 9 database from one physical machine to another. Ideally this solution would be fully hardware redundant in ...
4
votes
6answers
907 views

Oracle DB on VMWare?

Management have OK'd a migration of our main Oracle DBs to a virtual machine platform. Operations say they'll dedicate heavy-duty hardware and only run the DB VMs on it. I've heard that running DBs ...
0
votes
1answer
3k views

ORA-27101: shared memory realm does not exist

A couple mornings now my Oracle database has hit this error and not come up for an hour or so. Then it works fine for the rest of the day without needing any interaction. But this messes up my apps ...
0
votes
2answers
174 views

Oracle / windows hardware recommendation [closed]

I'm specifying a Windows server to run Oracle for (time based) performance tests of our application. Although the total data volume & number of users will be low, we would like the performance to ...
2
votes
2answers
2k views

Skip inserts for one table with oracle imp

I'm doing an oracle imp and in the dump there is a big table that I would like to only create but not to insert row into. Is this possible ? Exp was done on 10.2.0.4. I'm doing imp on XE ...
1
vote
3answers
4k views

Oracle 11g server rename issue

So we set up an Oracle server out of production (11g on Server 2008 x64) and our plan was to just rename the server's hostname to move it into production. Well, the database itself is functioning but ...
3
votes
5answers
1k views

Should Oracle *online* redo logs be backed up?

Obviously archived redo logs are backed up as frequently as required, but does it make any sense to backup online redo logs? Is the online redo log an open and active file such that copying it in this ...
4
votes
4answers
18k views

ORA-12705: Cannot access NLS data files or invalid environment specified

I am getting this error while trying to create a connection pool, on my Oracle database, Oracle 10gR2. java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot ...
1
vote
2answers
506 views

Database run in archive log mode

I'm using Oracle 11g on RHEL 5. I've created one database with no archivelog. After doing offline migration from SQLSERVER to ORACLE, I've changed this database to run in archive log mode. My ...
1
vote
4answers
115 views

Is there service management software in existence that meets these needs?

I work in an IT dept. at a higher ed. institution. Because the department is small and the infrastructure simple, managing all the services we offer out to the school (like LDAP, AD, various DBMS', ...
1
vote
3answers
5k views

Oracle export failed: EXP-00006: internal inconsistency error

My call to Oracle's exp is failing with: EXP-00006: internal inconsistency error EXP-00000: Export terminated unsuccessfully The command I execute is C:\oracle\product\11.1.0\db_1\BIN\exp ...
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
7answers
6k views

Oracle Vs SQL Server to handle around 6-7 Terabytes of data

I am looking for some valid points to choose between Oracle Vs SQL Server to handle around 5-6 Terabytes of data. This data will get accumulated over a period of 8 Months. Any data older then 8 months ...
1
vote
2answers
11k views

Disconnecting an Oracle Session from a Logon Trigger

I'm trying to construct an Oracle 11g logon trigger that restricts access for a specific user to a known list of applications. For example, user SCOTT can only connect with MYAPP.EXE. I believe I ...
1
vote
1answer
921 views

Create Oracle user to do backup job

For the security reason, I want to create the user and then assign the backup job to that user. This means that this user is not allowed to do anything else beside backing up the database. However, ...
2
votes
1answer
181 views

Oracle Database Security

I'm currently using RHEL 5 and Oracle 11g. I use DBCA to create Oracle database with all default options available. The problem is that when I create a new user on that database, this user can ...
0
votes
1answer
511 views

Oracle logical standby fails with ORA-01919

I have an Oracle logical standby database being managed via data guard. Just this morning the redo apply process began failing with an ORA-01919 error, indicating one of our application roles did not ...
17
votes
10answers
576 views

Should core system servers be able to connect to the internet for maintenance/support?

A couple of our servers have Oracle maintenance licenses. Our hardware vendor asked there was internet connection in the server room. Our policy is that all machines in that room is isolated from the ...