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
215 views

Migration from Oracle 10gR2 to Oracle XE

One of my application currently uses Oracle 10gR2 as the backend, with PL/SQL Stored Procedures, Triggers, Sequences, etc. I want to migrate to Oracle XE. Can this edition serve as the primary ...
1
vote
2answers
200 views

Can Oracle VM be downloaded for free?

I would like to try out Oracle VM just for fun. Can it be downloaded for free from Oracle? And if so, does anyone have a link?
0
votes
2answers
851 views

Oracle RAC interconnect in a Dell M1000e Blade Enclosure

We are looking at a Dell M1000e enclosure and appropriate Blades with 4 NICs each. We are planning on running Linux/Oracle 11g RAC on two blades, storage will be handled on an iSCSI SAN for which two ...
1
vote
6answers
186 views

What DBMS' have tight integration with a dedicated OS'?

It has always been my strong conviction that a large-scale multi-user DBMS should reside, stand-alone, on a dedicated server or clusters, with no other unecessary apps, processes or services which ...
1
vote
0answers
895 views

listener could not find available handler for requested type of server

I have ora-12520. I run Oracle 11g on Red Hat 4 64 bit. Actually I have RAC but one node is down and I work only with up one (connection string point directly to listener of running node). I run test ...
1
vote
1answer
564 views

Oracle 11g Express Edition

I have been tasked with installing the latest oracle XE edition. The versions I have installed recently are all 11g, but when I look for the XE edition I only see 10g. Is 10g the latest XE edition ...
6
votes
2answers
410 views

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 ...
2
votes
1answer
484 views

Difference between IDENTIFIED EXTERNALLY and IDENTIFIED GLOBALLY in Oracle

What's meaning of IDENTIFIED EXTERNALLY and IDENTIFIED GLOBALLY respectively? I'm now puzzled by their concepts. Thanks in advance. Kind regards!
2
votes
2answers
6k views

Fixed expired accounts in Oracle 11g

I have an Oracle 11g server that's used for PHP development. Recently, I had a problem logging into the Enterprise Manager due to expired passwords. I've already changed settings so passwords no ...
1
vote
1answer
2k views

What's the difference between instance and server process in Oracle database

I'm now getting familiar with Oracle database. Unfortunately, I'm puzzled by the concept instance and server process. My question is what's the difference between instance and server process. What's ...
1
vote
1answer
181 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 + ...
0
votes
1answer
2k views

How to rename an oracle database?

I am running Oracle 11g on windows 2003. What are the steps to rename database? I had followed the steps in http://www.ordba.net/Tutorials/OracleUtilities~DBNEWID.htm but I can't get past the error, ...
0
votes
3answers
4k views

Oracle tuning optimizer index cost adj and optimizer index caching

What is the correct way to set the optimizer index cost adj parameter for Oracle. As a developer I have observed huge performance improvements as this parameter is lowered. Common queries are ...
0
votes
1answer
2k views

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I got an email from a user when he sees the following error output when he's using our web site. java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ...
5
votes
3answers
2k views

How do you determine the OWNER of an Oracle Database

When you install an Oracle database in a Unix server, the Unix user id you use for the installation becomes the OWNER of the database. What is the most reliable and general way of determining in a ...
1
vote
2answers
247 views

how to hide oracle version

Anyone with version fingerprinting tool can know oracle version. So, are there any ways to hide oracle version rather than filtering incoming traffic?
0
votes
2answers
296 views

Need .NET hosting provider that can access Oracle databases

I'm looking for a hosting provider of IIS/ASP.NET sites that also allows access to Oracle databases (at a minimum they'd need to install the Oracle instant client plus Oracle ODBC drivers). Any ...
3
votes
2answers
831 views

Replicate Oracle to MySQL

I am developing a web apps, this web application will be using MySQL. Now I need to replicate my client's Oracle database into MySQL, only a few tables will be involved.. a table can be up to 2-3 ...
0
votes
2answers
1k views

OraOps10.dll loading problem

I have ASP.NET web service built on windows 7 in 32 bit. All dependences of this service compiled in Release mode in x64 bit. Now, I'm installed it on windows 8 64 bit and when I'm access to this ...
1
vote
1answer
2k views

Error: Unable to load OraOps10.dll

I have NT services compiled with 32 bit version of oracle client on windows 7, but when I run this service on windows 2008 I get error: Unable to load OraOps10.dll. I guess that this is because I ...
3
votes
5answers
3k 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?
2
votes
1answer
196 views

Recovering Oracle admin password

Are there any ways to recover oracle admins (sysman, sys,system) account in times of password forgetting, account locking out? Thanks.
0
votes
1answer
438 views

Oracle 11g RDBMS Enterprise Edition download?

I am looking for a URL where i can download the Enterprise Edition of Oracle 11g. I know that i can download the Standard Edition of 11g at Oracle's technet, but as i would like to use some of those ...
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 ...
0
votes
1answer
483 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
1k 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
5k views

Starting SQLPlus in linux

How do you start sqlplus in linux? I know this is a service in windows.
0
votes
1answer
68 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
183 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
159 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
5k 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
111 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
2k views
1
vote
1answer
194 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
599 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
920 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
963 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
103 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?
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 ...
2
votes
3answers
123 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
8k 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
697 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
703 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 ...