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

0
votes
2answers
4k views

Does Apache ever give incorrect “out of threads” errors?

Lately our Apache web server has been giving us this error multiple times per day: [Tue Apr 06 01:07:10 2010] [error] Server ran out of threads to serve requests. Consider raising the ThreadsPerChild ...
1
vote
1answer
795 views

Oracle 10.2.0.1 --> 10.2.0.4 patchset errors on Advanced Queuing tables. Serious or not?

We're running Oracle on RHEL 5.4 64-bit. We recently did an upgrade from 10.2.0.1 to 10.2.0.4. Many errors were generated during the upgrade (sample listed below from trace.log) but during ...
0
votes
1answer
398 views

Can I prevent Oracle users from creating public synonyms but allow private ones?

I've had a few issues where users have mistakenly created public synonyms which have led to people thinking some objects are in one schema when they're actually in another schema. Everyone knows they ...
0
votes
2answers
969 views

creating tables on remote database

I created a database link using database link. create public database link REMOTEDB connect to REMOTEUSER identified by REMOTEPWD using 'REMOTEDB'; then i create a table in remote db like, create ...
1
vote
2answers
4k views

Starting SQLPlus in linux

How do you start sqlplus in linux? I know this is a service in windows.
0
votes
1answer
67 views

Linux and Windows Server Setup

I have an win 2008 R2 machine (a home machine of mine) that I am messing around with and learning the server technologies. I also wanted to try out oracle, and was wondering if its possible to setup ...
0
votes
1answer
182 views

Memory Usage for Databases on Linux

So with free output what we care about with application memory usage is generally the amount of free memory in the -/+ buffers/cache line. What about with database applications such as Oracle, is it ...
0
votes
1answer
154 views

installPrep.sh / validate.pl for Oracle 11g database on Red Hat EL 5

For Oracle 9i + 10g (database), there used to be a really helpful script that you could run to validate your environment was correct before you did the install. Does such a thing exist for 11g does ...
1
vote
3answers
4k views

Easy Oracle Log-Shipping

I am looking for a decent way of keeping a secondary Oracle database up to date without exporting and importing the database each time. There are 3 users on the instance that I would essentially like ...
1
vote
3answers
87 views

Oracle database linux flavor

Can someone recommend me a linux flavor to install an oracle database on? I have no preferences for any flavor. Is there flavor which is easier than others? Or has less issues?
2
votes
1answer
2k views

MS SQL - Problem running SQL Server Agent Job via service account credentials

There are 5 steps in this job. First job is an SSIS Package store, second to fifth are file system jobs. We configured all jobs to use Windows Authentication. Under Run As, we specified a user account ...
2
votes
1answer
109 views

pl/sql Oracle syntax

I have a query in pl/sql that i need to migrate to ms sql. select count(*) from table1 t1 where (conditions1) and (conditions2) and variable = t1.column1(+) Could anyone tell me what the (+) after ...
1
vote
4answers
1k views
1
vote
1answer
180 views

Oracle Ordcom and Wallet Coexistence Problem

We use Oracle's ORDCOM infrastructure on our 11.1.0.7 database to interact with a COM object. The COM object doesn't do anything with the database. This process has been working fine for several ...
0
votes
2answers
567 views

SQL Server 2005 - Oracle Linked servers stop working

[URGENT - PRODUCTION ISSUE] All of a sudden, on a SQL Server 2005 instance, all the Linked Servers to Oracle stopped working. All other instances can connect to the linked servers without a problem ...
5
votes
2answers
805 views

Can't access database server over VPN

I am attempting to connect to an Oracle server via a VPN. I have tried to do so, unsuccessfully, from OSX and, alternately, from a Windows XP VM machine (VMWare Fusion) running on OSX. I can, ...
1
vote
1answer
901 views

Oracle AQ - why I don't see processed messages in global view?

Does anyone have an idea on why I see PROCESSED messages here: select 'MFS_MISSION' as queue_name, CONSUMER_NAME, MSG_STATE, count(*) from aq$MFS_MISSION_QTAB group by consumer_name, MSG_STATE ...
1
vote
2answers
101 views

Single Oracle Session For Data Export

What is the standard way of only allowing a single login during an Oracle 9i database export to prevent others from modifying the database during or after the export?
0
votes
4answers
6k views

How to connect to oracle server in java?

I am trying to connect to my friends Oracle server. But while connection I am getting error please help..... JDBC code Class.forName(oracle.jdbc.driver.OracleDriver).newInstance(); ...
1
vote
3answers
195 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 ...
2
votes
3answers
118 views

Oracle: data recovery after defining a property in Hibernate

By mistake I have defined a property in Hibernate <prop key="hibernate.hbm2ddl.auto">create</prop> and I lost all the data I have in Oracle 10. Is there any way to rollback that ...
1
vote
2answers
7k 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 ...
5
votes
2answers
6k 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
666 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 ...
2
votes
1answer
10k 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 ...
2
votes
1answer
2k views

“Export” SQL Tuning Profile to another instance?

I left work Friday with a long running SQL Tuning Advisor session running from Grid Control in Oracle, on one of our development instances. Some of these sessions take over 4 hours to run, so I prefer ...
1
vote
2answers
696 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 ...
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 ...
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 ...
2
votes
4answers
1k 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 ...
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 ...
1
vote
4answers
6k 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
2answers
1k views

Oracle DBV File Parameter

For our 10g Oracle database I had a script that would periodically create batch files to run DBVerify on all our datafiles. This way if I needed to check for corruption I would just have to run the ...
-2
votes
2answers
500 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.
3
votes
1answer
485 views

OracleDbConsole and OracleJobScheduler

OracleDbConsole and OracleJobScheduler services in Oracle - What tasks they performing?
1
vote
1answer
147 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 ...
0
votes
2answers
792 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
2k 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 ?
1
vote
2answers
70 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 ...
1
vote
2answers
200 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 ...
0
votes
1answer
2k views

Upgrade oralce jdbc driver in Weblogic 10

I found in Weblogic's documentation, "If you plan to use a different version any of the drivers installed with WebLogic Server, you can replace the driver file in WL_HOME\server\lib with an updated ...
0
votes
1answer
194 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
1k 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 ...
2
votes
1answer
567 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
411 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
205 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 ...
4
votes
3answers
326 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 ...
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

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
2k 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 ...