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 ...
0
votes
0answers
79 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 ...
0
votes
0answers
114 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
2answers
58 views

CASE_SENSITIVE on ORACLE DB

I have a ORACLE DB and when i try inserting "INDIA" and "india" as values into column which is carrying unique constraints on it , it is allowing the value to insert . It looks like case sensitive ...
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 ...
0
votes
0answers
60 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.
2
votes
0answers
268 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
424 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
95 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 ...
2
votes
2answers
554 views

Bad bind variable in audit trail trigger in Oracle 11g R2

I have been trying to construct audit trail triggers and procedures in oracle and I am facing a problem with bind variables. Following is the code create or replace trigger trg_audit_trail for insert ...
0
votes
1answer
1k views

Oracle 11gR2 IMP Won't Import Table in Dump File From 10g

I've got a screwy problem using imp on an Oracle 11gR2 instance to try and import export files created with exp on an Oracle 10g instance (different hardware, if that matters). I've read through the ...
0
votes
0answers
708 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
2answers
610 views

Trigger needs dbms_alert declared

A trigger has given me the following: ORA-04098: trigger 'adminuser.DB_ERROR_CHANGE_TRIG' is invalid and failed re-validation and this is when working on altering schemas/triggers/etc from an ...
0
votes
0answers
270 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
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
903 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
73 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 ...
4
votes
1answer
12k views

Getting “ORA-00942: table or view does not exist” while table does exist

I'm fairly new to Oracle database. I have installed Oracle Database 11g R2 on Oracle Linux 6. I have successfully created a new database with dbca and connected to the database using: $ sqlplus "/ as ...
1
vote
1answer
817 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
1answer
671 views

Audit Trail in Oracle 11gR2

I'm using Oracle 11g R2 on RHEL5. How can I find what is being audited? I want to know what actions (like create, insert, delete, update etc.) are being audited or logged for a user, say scott.
0
votes
2answers
344 views

Accessing Shared Folder Using Oracle Database

I have two machines A & B. I shared a folder from machine B and mapped it as a drive on machine A. Now I want to configure my Oracle Database in Archive Log mode and want to set the Archive ...
0
votes
2answers
197 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
728 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) ...
1
vote
1answer
928 views

How To Export-Import Database in Oracle 11g(Application Express Edition)?

I am beginner in Oracle 11g. I have created a database in oracle 11g(Application Express). I want to export this database with all data(whole workspace) and import this to another computer where I ...
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
2answers
285 views

Can I have Oracle primary 11.2.0.1 and standby 11.2.0.3?

Can I have data guard system like: Primary: 11.2.0.1 Standby: 11.2.0.3 In logical standby ? In physical standby versions(releases) must be the same?
0
votes
0answers
344 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
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
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
818 views

Error AWR Operation failed: CATPROC not valid when creating database with dbca

I have a fresh installation of Oracle 11g enterprise edition on CentOS 6, both 64 bits. I have installed Oracle and so far everything looks fine. I have already added an started a listener. The ...
2
votes
1answer
4k views

Oracle Wallet Setup ORA-12578

I am having trouble setting up the Oracle Wallet on a new box connecting to a new database. I have added the following lines to my SQLNET.ORA: SQLNET.WALLET_OVERRIDE = TRUE WALLET_LOCATION = ...
0
votes
1answer
519 views

ORA-30009: Not enough memory for CONNECT BY operation

I have a Linux VM (with CentOS 64 bit) where I installed Oracle Database 11g Express Edition. The database is running, I can use sqlplus and I can create tables and stuff. However, when I run a ...
3
votes
1answer
99 views

connection issue / Oracle Express 11g in windows7 32bit

I have an issue with Oracle Express 11g in windows7 32bit. Everytime when I try to conncet to the database I get this error message. How can I fix it please!
0
votes
1answer
3k views

Oracle 11g increasing shared pool size and java pool size

i need to install/configure oracle jvm on 11g. to be able to install same i need to increase the size of shared_pool_size and java_pool_size. i have automatic memory management enabled. my ...
1
vote
1answer
1k views

Check only prerequisites when running runInstaller in silent mode

I want to check just prerequisites and generate a log without installing Oracle database. When I run the following command: ./runInstaller -silentvalidate -responseFile ...
0
votes
0answers
46 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
68 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 ...
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 ...
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
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
414 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 ...
2
votes
1answer
12k 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 ...
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
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 ...