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, ...

learn more… | top users | synonyms

0
votes
0answers
18 views

How to replicate an Oracle 11g DB on AWS

Our client gave us an RMAN back for Oracle Enterprise 11.2.0.3 and we wanted to replicate it on AWS We are unable to do so because the default AWS server runs 11.2.0.1 and we do not have a licensee ...
2
votes
2answers
464 views

Why can't I drop this Oracle datafile - even though it seems empty?

This system is Oracle 11.2.0.3.0, using ASM. We had an issue where there seemed to be a corruption issue of some kind - every time a row tried to get inserted into the table, we'd get the following: ...
0
votes
0answers
110 views

Archive Logs not applied on Primary Database

I have a oracle database and some archive logs in the primary database have not been applied. When I run SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG order by SEQUENCE# I get the following ...
0
votes
0answers
78 views

INDEX SKIP SCAN performance on Index where first columns only contain 1 value

We're running an Oracle 11.2.0.3 database and have a table with above 10 columns in it. There is a non-unique index over all these columns. For simplicity in this example, lets assume the columns are ...
1
vote
1answer
208 views

Object changed during datapump

If some object is being changed when data pump is run how will that object go into datapump file?
0
votes
0answers
59 views

Oracle after insert trigger vs update performance in plsql block

I want to know whether an after insert trigger is better than an insertion statement followed by update statement in plsql block.
0
votes
1answer
2k views

ora 20001 error in oracle dbms scheduler

i have written a test job like begin DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_job' ,job_type =>'plsql_block' ,job_action => 'null' ,enabled => true ); end; / after a while when ...
2
votes
1answer
521 views

ORA-00922 encountered in Oracle 11gR2 installer

I've just run the installer for Oracle 11gR2 on a Windows Server 2008 (64-bit) OS. I encountered the "ORA-00922: missing or invalid option" error at the last stage of installation when it was doing ...
0
votes
1answer
171 views

FAST REFRESH ON COMMIT on Materialized view

I am trying to implement a materialized view which would Fast refresh on commit. I have created materialized view logs on base table as well but i am faced with the following error. ORA-12052: cannot ...
2
votes
0answers
265 views

Why OEM RMAN backup jobs fail after changing the preferred credentials?

In an Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Running on Oracle Linux 6.5, we configured full RMAN backup schedule using OEM (Oracle Enterprise Manager 11g ...
1
vote
1answer
417 views

Oracle 11gR2 + RedHat 6.5 cannot start sqlplus

I cannot start sqlplus I've read everything I found, tried everything and still I am getting "command not found" I have a user oracle, I did export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 ...
0
votes
1answer
45 views

SYSDBA privileges of viewing users table

Is there anyway which would restrict sysdba from watching the users tables. It sounds ridiculous but we sort of need this functionality. We only want sysdba to act as administrator only, no peeping ...
1
vote
0answers
92 views

Running materialized view refresh in parallel

I have a large materialized view that is refreshed periodically (complete refresh) and I would like to do it in parallel. I can already run the query part in parallel but the problem is (much slower) ...
0
votes
0answers
77 views

Strange behavior with context index on matarialized view

We are experiencing a very strange behavior with a materialized view on oracle. Here is the statement that we've used to create the materialized view: CREATE MATERIALIZED VIEW MY_MATERIALIZED_VIEW ...
0
votes
0answers
703 views

Uninstalling Oracle Database Products: Which & How to?

Long time reader, first time poster. For our client's project we are using Oracle 11g. It's a simple C# web application so we are using Oracle's most basic components. Now my project team has been ...
0
votes
0answers
264 views

Impdp over DB_LINK failing with ORA-31631

I am getting below error message while trying to execute impdp between our SIT and UAT environments: ORA-31631: privileges are required ORA-39149: cannot link privileged user to non-privileged user ...
1
vote
0answers
117 views

Oracle Scheduled Job Stays in State RUNNING

I have an Oracle 11.2g on which I use Scheduled Jobs to get some regular work done. There are around 15 jobs running 24/7. The time interval at which those jobs run varies between 1 second for some ...
1
vote
0answers
68 views

plsql procedure gets invalidated

procedure involving dblinks gets invalidated regularly .we need to recompile every time.How to find what is causing the problem in my case procedure p1()--resides in db1 is begin .... select col1 ...
0
votes
0answers
893 views

Oracle 11g Instance that won't start

I'm in need of some help with an Oracle 11g instance that won't start. First of all, this is development instance so if it won't start it's not the end of the world, but it does have some useful data ...
5
votes
1answer
115 views

Why does the CBO not chose a lower cost skip scan without stats?

In the script below, the CBO chooses an INDEX FAST FULL SCAN over an INDEX SKIP SCAN (this is illustrated by the queries with the UNION ALL but you can demonstrate it is true with just explain plan ...
0
votes
1answer
72 views

MS Access migration from Oracle to SQL server?

Let me start off by saying I'm relatively new to databases etc. I have been asked to undergo a project is which I will attempt to migrate about 100 or so existing MS access 2003 databases from using ...
1
vote
1answer
797 views

First query running in PL/SQL Developer results the error

When I run first query in PL/SQL Developer I got the error: Dynamic Performance Tables not accessible, Automatic Statistics disabled for this session You can disable statistics in the preference ...
0
votes
2answers
191 views

How can I limit a hierarchical query to the point where there are multiple children?

This question is related to my previous question about hierarchical queries. I have a hierarchical query in Oracle 11gR2 that returns something like this: - Level 1 - Level 2 - Level 3 - ...
2
votes
2answers
715 views

How can I select rows from a hierarchical query with the lowest level?

I have a hierarchical query in Oracle 11gR2 that returns something like this: Parent (Level 1) Child (Level 2) Grandchild (Level 3) Child (Level 2) Grandchild (Level 3) Grandchild (Level 3) ...
2
votes
2answers
206 views

SQL query for next occurrence of specific date

I am working on a function for our database that contains contract data. Each contract expires on a certain date, and then each contract has an expiration type that determines what happens after that ...
0
votes
0answers
116 views

Problem with a trigger (Oracle 11gR2)

I converted the trigger into a "Compound" trigger; this is my first attempt using a compound trigger. Here is my new code: --select * from user_errors; CREATE OR REPLACE TRIGGER ai_fin_transaction ...
0
votes
0answers
75 views

Where can I download jvm files for oracle on ubuntu

I want to install Java packages for oracle, and I found following files in the internet. @?/javavm/install/initjvm.sql; @?/xdk/admin/initxml.sql; @?/xdk/admin/xmlja.sql; @?/rdbms/admin/catjava.sql; ...
2
votes
1answer
2k views

Oracle Automatic Memory Management - SGA_MAX_SIZE

When using Automatic Memory Management, what value should SGA_MAX_SIZE be? Should it be 0? These are my current settings, and I'm unsure whether to leave SGA_MAX_SIZE or set it to 0. ...
0
votes
0answers
32 views

How to make a role from schema A “grantable” in schema B

There are two schemas in the same database: A and B. Schema A has a role A_ROLE. I want to be able to give grants to A_ROLE from schema B ( so that the users with A_ROLE were able to query tables from ...
0
votes
0answers
328 views

ORA-12516 but max_utilization not reaching limit

Our app began to raise ORA-12516, TNS:listener could not find available handler with matching protocol stack errors, and I'm trying to diagnose why. The workload has not changed, so I think we might ...
0
votes
2answers
2k views

Installing scott schema for oracle 11g express

I want to install scott schema, a sample database in oracle. But in express edition, I can't find out it. Please help me install it on Oracle 11g express. I'm a newbie, pls help me
0
votes
1answer
39 views

Why is the OCR&Vote disk group servicing SCAN name

I have installed 11g R2 Grid Infrastructure followed by database software only installation. I have not created any database yet. When I open asmca->diskgroup, I can see the diskgroup which I have ...
0
votes
2answers
4k views

TNS-12535: TNS:operation timeout

I have Windows Server 2008 R2 with Oracle Client 11.1.0.7.0 client installed. TNSPing to 100% available databases (accessible from other machines, i.e. I can do TNS ping to these databases from other ...
0
votes
0answers
45 views

Oracle edition-based redefinition

I have difficulty purging prior editions that clutter up my system: we deploy new code every 2 weeks, hence a new edition every time: ORA$BASE --> v37 --> v38, for example. I actualized all ...
1
vote
0answers
67 views

Oracle forms and report 6i compatibility issue

Please advise,is there any compatibility issues with windows server 2008 64 bit and oracle forms and reports 6i? I am being asked to buy a new server with 32bit processors by my support provider. Are ...
1
vote
1answer
73 views

Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?

A database application I'm working with uses Oracle scheduled jobs to perform certain tasks. The DBA insists that hard-coding the schema name in the procedures that organise these jobs improves ...
0
votes
1answer
86 views

Striping IO with datafiles on different physical mounts

I have a server with three directly attached disk controllers. Each of these can provide internal redundancy and IO-striping accross disks, but I'm wondering what is the best way to configure the ...
0
votes
0answers
22 views

are temporal relationships a good candidate for Oracle cubes?

We have a requirement in our database to represent various "temporal" relationships in our data. A simple example would be an event table where I want to know how many days prior to the event date ...
1
vote
2answers
408 views

Oracle becomes too slow after system crash [closed]

I am using Oracle 11.2 as a database for my application. For this purpose I should import my data (around 100m records) to this database. For this purpose I used SQL Developer. Unfortunately at the ...
0
votes
1answer
505 views

Oracle Enterprise Manager - Where do I find the error logs?

I'm not familiar with oracle management. The problem is when I try to connect to the enterprise manager through the Web browser I get this error: In english: "Internal Error has occurred. Check ...
1
vote
0answers
78 views

Multiple handler entries in lsnrctl services output

This what I get for an lsnrctl services. LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-APR-2014 10:01:43 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to ...
0
votes
0answers
35 views

how do we specify an oracle edition in a database link?

We are connecting using a DB link from one oracle database (a) to another (b), and b has oracle editions enabled. How do we specify an edition to be used when viewing the tables / views in database ...
1
vote
0answers
540 views

Truncating Table Partitions Containing Data and Global Indexes

I have to truncate a partition (392,000 records) of a table with 20.000.000 records. At the moment, I'm making a truncate table and rebuilding indexes. But the table has 37 indexes and it takes 20 ...
1
vote
2answers
74 views

Oracle result cache behaviour

Oracle by default caching the query results and function results(Buffer cache). I have noticed this with AutoTrace utility, where the physical reads are huge on first execution, but from next ...
0
votes
0answers
34 views

SCAN verification error during 11gr2 installation

Hi All, I am getting the following warning when installing RAC DB (11.2.0.4). Does any one has idea what could be the reason? I have tried to search from Metalink but no help. Can I proceed with ...
0
votes
1answer
109 views

How to change the output encoding of Oracle command line tools to UTF8?

I am using a german oracle 11.2.0g install, which has some command line tools communicating with some non-ascii characters (ü, ö, etc.). These are written out in iso8859-1 encoding, but I need them as ...
0
votes
2answers
48 views

Not able to select the disk during Oracle 11g Installation

Hi All, During the 11g installation on Win 2012, I am not able to select the available disks which are already stamped using ASM. Any idea what could be the reason? I have tried to select using ...
0
votes
0answers
28 views

Database dependency problem

Hi I have a small question. I need some suggestions on how to solve this problem. I have database A,B,C,D. D access data from A,B,C in all environments (DEV,UAT,PROD). SO whenever database A,B,C get ...
0
votes
2answers
60 views

Hide zero hours and minutes with NLS_DATE_FORMAT

I'm currently using date format: alter session set nls_date_format = 'DD.MM.YYYY HH24:MI'; The (cosmetic) problem is that this always displays time even if it's zero, for example: "27.03.2014 ...
0
votes
0answers
53 views

Oracle DB automatic backups

I want to apologize because i believe that this question is already consumed, but please give it a chance. I've started practicing on a Oracle DB 11g XE. I'm following the tutorial from Oracle Docs ...