The second and terminal release of Oracle Corporations Oracle 11g database product. 11.2 was released for Linux on September 1st, 2009. New features added include RAC One Node, Improved data compression ratios (up to 20x), Edition Based Redefinition, Recursive Subquery Factoring, Instance Caging, ...
5
votes
2answers
561 views
How to install Oracle 10g Express and 11g Enterprise on same machine
I have to continue maintaining an Oracle 8i database that receives information (about 20 Inserts and Updates a day) from a 9i database. I am upgrading the 9i database to 11g which does not support ...
6
votes
4answers
315 views
Can this business logic be enforced by a conditional database constraint?
I am trying to duplicate the business logic embodied an intranet C# web application in the database so that other databases can access it and work under the same rules. This "rule" seems difficult to ...
6
votes
3answers
264 views
How can I ensure that only one copy of a procedure is running in Oracle?
We have the need to ensure that only one copy of a particular procedure is running in Oracle. If it is already running and a user tries to open another, then it should error.
Whats the best method ...
2
votes
1answer
518 views
Why Is oracle ignoring my index?
This query is not too complex:
select
trunc(created_date, 'MONTH') as created_date,
al.op_name,
al.region,
al.alarm_type,
COUNT(1) as total_new,
SUM(
(SELECT
...
4
votes
1answer
198 views
How to I interleave logs from two different Oracle tables?
I have two log tables, which are populated from two different PL/SQL packages. It's often useful to keep the data separate, but sometimes I'd like to "interleave" the two tables so I can see what's ...
0
votes
0answers
104 views
How to load XML data into an oracle db table ?
Is there a way to load the XML format data into an Oracle 11g DB table directly ?
I mean, Can we write a Stored Procedure to accomplish the same in a more efficient way with the best performance ?
...
3
votes
2answers
313 views
Help to understand explain plan in Oracle
I am running a query in some big tables, and although it runs fine even tough is a lot of data, I'd like to understand what part of it weighs on the execution. Unfortunately I am not too good with ...
2
votes
2answers
3k views
Comparing date and timestamp variables in a where clause in a procedure
I have a variable in an Oracle stored procedure of DATE type (from user interface), and another of TIMESTAMP type (database is more precise than what the user would enter in the code that is executing ...
1
vote
1answer
95 views
Does Oracle server installation include client components?
I installed Oracle personal edition on a Windows Server 2008 virtual machine for testing purposes. My intention is to test Linked server functionality with SQL Server. Does Oracle Server installation ...
3
votes
1answer
90 views
Using Inteval Datatype to store result of calculation
I want to create a table which has hiredate and Interval of hiredate and sysdate. How to create a column that automaticlaly stores the calculation.
5
votes
1answer
135 views
how do I configure a new Oracle 11g instance to match the configuration of the old Oracle 10g server
How can I compare two Oracle database servers which are on two different machines?
We need to ensure that the new server is setup correctly.
For example, one machine is running Oracle 10g on ...
3
votes
1answer
51 views
INDEX on a table where I'm only filtering on a row_number()
I've got the following table (scaled down to a MWE):
Fiddle here.
CREATE TABLE weekly
( yearnum int,
weeknum int,
location varchar2(5),
weekly_count int,
weekly_sum int);
INSERT INTO weekly ...
3
votes
1answer
563 views
How far should bind variables go in Oracle?
I am currently examining all database users's SQL code in our department for not using bind variables. We do experience an ORA-04031 error within a constant period of time.
Now, I have a quite firm ...
2
votes
1answer
540 views
Drop user did not reduce size of tablespace file
I have a development environment in which I frequently copy a certain schema.
When I'm done with the copy, I will use OracleEM to drop that user/schema.
My problem is that this does not seem to ...
1
vote
1answer
3k views
Oracle DBCA utility: “Listener is not up or database service is not registered with it”
I'm a software engineer with some experience on SQL Server but a newbie on Oracle.
I'm attempting to run dbca on a remote linux machine to reconfigure a database that was initially configured to idle ...
4
votes
1answer
211 views
Dodgy causes of ORA-12549?
I am dealing with a rather massive ETL processing which keeps throwing me the ORA-12549 error.
Have been looking for problems in the database so far and nothing. The DBA says the database is "fine" - ...
1
vote
1answer
740 views
How do I find out the “redo log file max size” in Oracle 11R2
I'm working with Oracle 11R2 and I want to see the max size of my redo log files (I didn't install Oracle so I'm not aware of the configuration).
I have searched the Internet but all I have found ...
2
votes
3answers
142 views
Oracle hint failure
When I run the PL/SQL block after the CREATE statement, I receive the duplicate key error I would expect if I did not add the hint. Any ideas to why the hint does not work?
CREATE TABLE Sandbox.Clue
...
0
votes
1answer
52 views
Verify if I can use a given directory
Admin creates an Oracle directory:
CREATE OR REPLACE DIRECTORY EXAMPLE AS '\\server\share\test';
GRANT READ, WRITE ON DIRECTORY EXAMPLE TO JOHN;
Admin can test whether the directory exists:
SELECT ...
3
votes
1answer
1k views
Is there a timeout for a query over database link?
Edit/Preface:
This question has been migrated from SO as I am particularly interested on the question on timeouts on DB link queries. The provided workaround from SO is somewhat OK, but I'm really ...
3
votes
1answer
283 views
Query taking long on table with low record count
I have an Oracle flat table that grew to just below 800MB. The table was truncated and new records are being inserted. Currently there are <40 records in the table but a select * takes >30secs.
...
0
votes
2answers
973 views
Oracle database link to MySQL database on RedHat Linux
I have an Oracle 11g database on a RedHat server and also have MySQL database on another RedHat server. I want to create a link to the MySQL server from the Oracle which allows me to execute queries ...
0
votes
0answers
92 views
Oracle VPD Implementation?
Our team is implementing VPD into the already existing Schema. The application is currently used by one customer and in order to generalize the application we need to implement VPD in our schema. The ...
0
votes
1answer
2k views
Oracle Forms Runtime error
When I am running a form in Forms 11g
http://rahulsingh-pc:8888/forms/frmservlet
I'm getting an error:
Failure of server APACHE bridge:
No backend server available for connection: timed out after ...
1
vote
0answers
65 views
Port no in Oracle Forms 11G
Which port number to be used in forms 11G Preference-->Runtime--> Application ServerURL Section? I have:
1521-Given at the time of database creation
7003 and 7004-Given at the time of WLS Domain ...
0
votes
0answers
130 views
steps for creating a domain in web logic server 10.3.5
Can anybody give me procedure as to how to create a domain?I want this to run oracle forms 11G in the browser.I have some doubts regarding the configuration of domain like
1. what sdk should i use?I ...
0
votes
0answers
131 views
change database name controlfiles after restore?
I have restored database with the name DB to another database called DB01
it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it ...
1
vote
1answer
353 views
Oracle backup with RMAN Options?
I'm trying to learn RMAN but getting confused everytime I read Oracle docs!
Can someone help me what are the differences and when to use the following?
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT
...
5
votes
2answers
3k views
Learning to Optimize SQL Queries and Understand Execution Plans - Resources?
I find myself writing more and more SQL queries at work (mostly Oracle 11g, but some SQL Server 2005-2008) and have started creating some pretty complex views for the rest of the analyst team.
They ...
3
votes
1answer
226 views
Log rotation of diag logs?
In on of our Oracle 11.2.0 installations the directory database\diag\rdbms\$DB\$DB\alert is filled with hundreds of xml files (log.xml, log1.xml ...). Can Oracle be configured to do log rotation ...
2
votes
1answer
394 views
Flashback feature in Oracle 11g?
I am using Oracle 11gR1. As a part of a project, I have to execute multiple update statements by disabling a few constraints (triggers and check constraints) which could result in a corrupted ...
2
votes
0answers
188 views
Ports necessary for Oracle 11g Replication across a firewall?
We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
4
votes
1answer
118 views
How to use simple output parameters?
I'm new to Oracle, so I apologize for such a simple question, but I've already wasted several hours on it.
I have the following stored procedure:
create or replace procedure MyTestProc (outparam OUT ...
0
votes
0answers
274 views
The Oracle's Log Buffer, Redo Log Buffer Cache and Redo Log files [closed]
I need to know the difference between :
(i) Log Buffer (ii) Redo Log Buffer Cache and (iii) Redo Log files.
0
votes
0answers
347 views
ora-07202 when creating standby database
I am pretty new to Oracle database, and I am trying to set up a high availability between two PCs.
The first PC runs Windows server 2008 R2, and the second is on Fedora.
As far as I have read, with ...
3
votes
1answer
362 views
Objects in v$bh but not dba_objects
The Oracle documentation has a section in the 11.2 Performance Tuning Guide with the title Determining Which Segments Have Many Buffers in the Pool. The section lists the following query:
SELECT ...
0
votes
0answers
48 views
Enumerate open oracle connections
How can I troubleshoot which processes are keeping connections open?
Background: A QA installation of several software components is generating an ORA-12516 error now and then, and I'm not sure which ...
0
votes
0answers
171 views
How to Import a file to Oracle APEX & what are invalid files to import? [closed]
APEX is running. I tried to import a workspace that I exported in a 4.0 version of APEX
After choosing the file I get this message:
the export file has been imported but is not a valid workspace ...
1
vote
1answer
642 views
Error calling stored procedure from trigger in Oracle Database 11g
I'm trying to create a trigger that calls some Java code whenever a table is inserted/updated. I'm aware of possible performance issues, I don't need advice that I should not do this; I just need to ...
1
vote
1answer
3k views
How do I grant execute permission to an Oracle database user?
I'm trying to call a Java function from Oracle database that does the following:
Process p = Runtime.getRuntime().exec("...");
When I try to run it, I get the following error:
ORA-29532: Java call ...
2
votes
0answers
123 views
How to Connect R to Oracle?
I need to connect R to oracle and I have been unsuccessful so far. I downloaded two packages: RODBC & RODM.
This is the statement that I've been using: DB <- ...
1
vote
2answers
1k views
Setting NLS params in logon trigger don't work in oracle 11g
We have a trigger setup so that when a specific user logs in, their NLS session parameters are modified. This used to work on Oracle 10g. We've just migrated to Oracle 11g RAC, and the session ...
4
votes
1answer
210 views
Comments in EXPDB parameter file
Is there a way to put comments in a data pump export parameter file?
2
votes
2answers
6k views
How do you get the explain plan?
Can some one please explain a bit about explain plan, and how does one get the explain plan for a query. Also, if there is any sql script which can be used as utility for this, that would be great.
1
vote
1answer
134 views
Can I recover an overwritten incident trace file?
I was looking at incident trace file in oracle database but some how that file got overwritten. As of now I have ecrep_ora_26467_i49966.trm but trhe corresponding .trc file is lost. is it possible to ...
2
votes
1answer
616 views
Can RMAN duplicate be used to “replace” an existing database?
I have an unused database B, not valuable. I'd like to make a copy of database A, but do not want to go through all the manual steps RMAN requires to set up the auxiliary database. Can I use RMAN ...
1
vote
1answer
391 views
Rule of thumb: AUTOALLOCATE or UNIFORM size for tablespaces
Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size?
Even more, what should apply for ...
0
votes
2answers
1k views
oracle 10g xe to 11g xe upgrade
The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
3
votes
1answer
161 views
Oracle 11, incremental backup goes wrong
Got a pretty big instance on a one-week backup cycle with an incremental (differential) strategy .. or rather, that's what it was supposed to be. Somehow the daily differentials seem to come out as ...
0
votes
1answer
478 views
Override default SERVICE_NAME in init.ora
I'd like to define several service names for my instance in such a way that users should not know the actual instance name. This is what I have done in my init.ora:
db_domain='company.com'
...
