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
480 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
176 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
243 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
292 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
812 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?
0
votes
1answer
843 views

javax.naming.InvalidNameException using Oracle BPM and weblogic when accessing directory

We are getting this exception when we start our cluster (2 managed servers, 1 admin), we have deployed only the ears corresponding to the OBPM 10.3.1 SP1 in a weblogic 10.3. When the server cluster ...
2
votes
1answer
194 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
436 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
460 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
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
156 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
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
191 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
589 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
879 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
949 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
197 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
688 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
700 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 ...
1
vote
4answers
7k 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
504 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
494 views

OracleDbConsole and OracleJobScheduler

OracleDbConsole and OracleJobScheduler services in Oracle - What tasks they performing?
1
vote
1answer
148 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
858 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 ...