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

2
votes
1answer
163 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
681 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
286 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
422 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
11k 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
4k 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
217 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
201 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
858 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
187 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
934 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
414 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
495 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
190 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
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
258 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
307 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
848 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
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?
2
votes
1answer
197 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
443 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
5k 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
536 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
3k views
1
vote
1answer
198 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
608 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
979 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, ...