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
1answer
3k views

PL/SQL Plus script just gives me numbers

I have an PL/SQL Script that I'm trying to run from the command shell with SQLPLUS. However, whenever I go to run it, All I get back is a number and a cursor waiting for some input. When I hit enter, ...
0
votes
5answers
2k views

What is the Best HW / OS Combination for Oracle 11g?

My company is in the midst of upgrading our database hardware / software to support Oracle 11g. We're considering the following hardware / OS combinations for the database server: Sun v890 (current ...
0
votes
1answer
781 views

Oracle client installation on Windows 7

I installed Oracle 11g database on Windows XP(32-bit) and now I need help for installing Oracle client on Windows 7 (64-bit) If possible, can you explain me how to do this... step by step... starting ...
1
vote
4answers
573 views

why this statement in oracle perform much slower then ms sql

I tried to run a simple test to see how the speed fair between oracle and Ms Sql as follow: populate two tables with 2 million records, cross join them, filter by a range, and do a sum. Both table ...
3
votes
2answers
1k views

How to handle one-way synchronization of two Oracle databases with no network connection?

Here's the situation: I have two Oracle 10g databases (with the same tables, etc.) that cannot be connected by network. At some regular intervals (say, once a day) I need to be able to update the ...
1
vote
1answer
724 views

High “user rollbacks” in v$sysstat - what does it mean?

There are some people on my team running performance tests against an Oracle database. During the execution of their scripts, they are seeing a large increase in the value of "user rollbacks" in the ...
5
votes
5answers
4k views

Setting up array of SSDs for Oracle Database, recommendations?

I am configuring a server for a small, but read I/O intensive database. It serves as a master index for public access to a larger Oracle RAC database. When looking at the requirements for I/O, it was ...
0
votes
1answer
118 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 ...
0
votes
1answer
1k views

Examples of Exp tool to export data from Oracle db table to text file

I need to export data from an Oracle database and then import the data to another oracle database. To import data, I can use SQLLDR tool to load a flat text file. To do that, I have to generate this ...
0
votes
1answer
166 views

installing oracle on linux red hat 5

while installing oracle on linux red hat 5 its giving java.lang error how can i get rid of it?
2
votes
2answers
4k views

Install oracle 11gR2 on Centos 5 : No init file found

I'm trying to install oracle 11gR2 on Centos 5 and when I do a /etc/init.d/oracle start I get in the log : No init file found for Database instance "ORCL". Error database instance "ORCL" not ...
2
votes
2answers
92 views

Oacle Data Gaurd related question

I have two Oracle 11g Database servers, one at primary site and second at failover site, and i intend to use Oracle Data Gaurd for failover in between. I have few questions 1) Do i need standby ...
0
votes
3answers
2k views

How to restore an oracle database

I am very new to Oracle and customer gave us their oracle database files. ARC00016_0724940467.001 initVISUAL.ora VISUAL.2010-07-22-1637.log VISUAL-trace.sql SYSAUX01.DBF SYSTEM01.DBF UNDOTBS01.DBF ...
2
votes
2answers
89 views

Preventing Oracle data files from being used on other servers

Is there a way to encrypt or password protect Oracle database files so that they can not be used in case they were copied to other servers? Thanks
-1
votes
4answers
118 views

time required to Build server configuration [closed]

I need an advice on time required to build the following items. 1) oracle 10g installtion 2) Apache web server 3) Solaris OS 4) Setting of backup service for server 5) Big IP Load balancer A quick ...
0
votes
1answer
71 views

How to get number of calls to Oracle DB

I want to monitor number of calls made by my application Oracle DB. Which counter (from V$table) should I use ?
0
votes
2answers
86 views

Which tool / technology: System management for databases and dependent services

I'm looking for advice on how to enable our team to take down and re-start our company systems for maintenance purposes. The scenario includes several Oracle db machines several MS SQL Server ...
1
vote
2answers
3k views

Best practices for SQL Server to Oracle data synchronization

I have some tables in a SQL Server database that I want to make available to an Oracle database. Keeping in mind that data integrity is the top priority, what are some best practices for keeping the ...
1
vote
1answer
141 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 ...
2
votes
1answer
215 views

How do you profile an Oracle database?

What I would like to do is capture all the selects executing against a production Oracle database with all the parameters used for a period of time. I would then rerun all the captured statements ...
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 :(
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 ...
1
vote
3answers
718 views

Installing an Oracle DB

I am trying to install an Oracle DataBase. My idea is to call the DataBase Configuration Assistant from my Inno Setup installer and I need to know if the result code of this creation process is ...
3
votes
1answer
3k views

how to change the maximum number of connection to Oracle database?

How do I change the maximum number of connection to Oracle database at start? I use : ALter system set sessions=500 scope=spfile; However, after restart the database, use show parameter sessions ...
1
vote
1answer
300 views

CPU Performance on Virtualised Windows 2000 for Oracle 8.0.5

Can somebody suggest any steps I can take to improve the CPU performance of an Oracle 8.0.5 database on a Virtualised Windows 2000? Update New installed OS, Windows 2000 Server Advanced SP4 Oracle ...
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 ...
2
votes
4answers
5k views

Oracle 10 g - Unable to free up space in tablespace

The tablespace in Oracle 10g is almost 100% used. Size (MB) = 571,768.0 Used (MB) = 571,534.0 I just deleted (and committed) thousands of records in a table that belongs to a schema associated with ...
0
votes
2answers
258 views

How do I get Oracle 11g to install on Vista when it gives an error about the listener port?

I'm trying to do an install of Oracle 11g.R2 taking the defaults, but the installers keeps generating and error message when trying to setup the listener. If I have the installer just install the ...
0
votes
1answer
443 views

How to handle oracle installations with same SID on same subnet?

I have two Oracle RAC clusters on the same subnet. For this discussion, let's assume one is a QA cluster and one is a DEV cluster. They are both running on RedHat Enterprise Linux 5, 64-bit. They are ...
2
votes
1answer
13k views

SQL, pl/sql, sqlplus: how to return a variable to DOS batch file?

I have a DOS batch file which invokes sqlplus, which executes some basic SQL contained in another .sql file, and I want the last part of it to return a value back to the dos batch file. However, ...
1
vote
2answers
5k views

How to do a consistency check of oracle database?

I am looking for a command like fschek or something similar for oracle to make sure that the indexing is proper . I am doing a HP UX server installation and there was some error while installing some ...
0
votes
2answers
221 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
202 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
905 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
210 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
1k 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
567 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
429 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
534 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
3k 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
224 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
3k 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
3k 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
282 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
350 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
932 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
2k 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 ...