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

5
votes
2answers
698 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
824 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
100 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
5k 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
193 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
113 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
5k 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
5k 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
620 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
9k 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
678 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
969 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
1k 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
5k 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
492 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
451 views

OracleDbConsole and OracleJobScheduler

OracleDbConsole and OracleJobScheduler services in Oracle - What tasks they performing?
1
vote
1answer
142 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
714 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
65 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
195 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
190 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
507 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
397 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
197 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
322 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 ...
4
votes
3answers
24k views

Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name

Can someone explain to me what's the difference of SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name in Oracle ? Thanks Michael
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 ...
2
votes
2answers
1k views

Oracle startup and shutdown with Powershell

I'm trying to automate the startup and shutdown of some Oracle instances with powershell. The best I've come up with so far is below param( [String]$Instance = $(Throw 'Instance required' ), ...
6
votes
7answers
2k views

Things every Oracle DBA should know

This could include: Books worth reading; Tools worth having; etc.
1
vote
1answer
127 views

Oracle / PHP / Apache

I have built a web app that was performing very fast, until users from a third coutry (the majority) started using the application. Now its very slow. I see from the logs that I keep getting ...
3
votes
1answer
1k views

ActiveMQ with persistence in a database

Are any of you running ActiveMQ with persistence in a database? Even better, in an Oracle database? We're wanting to replace our current JMQ uses with ActiveMQ. The plan is to have two machines ...
1
vote
1answer
398 views

How to rescue oracle instance having oradata and admin?

I have copy of oracle folder, installed on windows. There are have oradata and admin folders. It is Oracle 9.2.0.8.0. I had working WibXP operation system, and installed oracle there. Now WinXP, ...
3
votes
1answer
211 views

Good Oracle book for MySQL users?

Just started using Oracle, no previous experience. I do have a good amount of experience with MySQL (and played a little with PostgreSQL). Could you recommend me a good introductory book to Oracle ...
2
votes
1answer
196 views

Non-intrusive stored-procedure auditing on Orace 10g

I'm working in a environment where there are a large variety of legacy client programs. I'm trying to get an idea of which programs use what stored procedures. Is there a way to audit access to a ...
1
vote
2answers
3k views

Find Current open Cursors in Oracle

What is the query to find the no. of current open cursors in an Oracle Instance? Also, what is the accuracy/update frequency of this data? I am using Oracle 10gR2
0
votes
3answers
170 views

Which platform has good job openings in Oracle 91 & 10g

I plan to do an Oracle course in Dream infotech. They are providing training in Oracle on Linux / Solaris. Which platform is best and has good job openings?
3
votes
8answers
372 views

Should a DBA store and retrieve passwords

Should a DBA record passwords for application logins, or should this be a responsibility of developers/analysts? By application login, I mean the login which an application uses for access to the ...
1
vote
3answers
4k views

Oracle 11g server rename issue

So we set up an Oracle server out of production (11g on Server 2008 x64) and our plan was to just rename the server's hostname to move it into production. Well, the database itself is functioning but ...
4
votes
5answers
3k views

Are there any disadvantages of using UTF8 in an oracle database?

We are installing ordering a configured oracle database and they are asking us what character encoding we would like to have. The application (in Java) is in English only but users are from different ...
1
vote
1answer
1k views

Rolling Upgrade of Oracle 11g from 32 bit to 64 bit?

I have an Oracle 11.1.0.7 database running on windows 32 bit. I would like to upgrade to 64 bit (same version of oracle) and would like to use a standby database for a rolling upgrade. Is this ...
2
votes
1answer
844 views

Oracle: Can Weblogic 11G run PL/SQL code like App Server 10G?

This is probably a silly question, but I'm not an oracle admin so I'm not sure. Our client currently runs a website written in PL/SQL and HTML on a Oracle 10G system. As everything is moving in the ...