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

error in identifying a control file

SQL> startup mount ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2233344 bytes Variable Size 616565760 bytes Database Buffers 444596224 bytes ...
-1
votes
0answers
16 views

upgrading oracle 10 -> 11 ubuntu ORACLE not available

I'm trying to upgrade oracle 10 to oracle 11 on ubuntu (yes I know it's not supported), because this is occurring on a system that had a version of oracle in some cases it thinks it's been configured ...
0
votes
0answers
12 views

Why duration is so high, 2.0 hours compared to the database time which is only 4.8 seconds?

When checking in SQL Monitoring of OEM I found that something bad occurs for one of queries used in ETL process. Query is: SELECT * FROM ( (SELECT t1.id AS id , t1.TIME_COLUMN AS ...
3
votes
3answers
164 views

Nested table as condition prevents using index

The following query joining a subquery does a TABLE ACCESS FULL when the master-table uses nested table as condition. When the condition is a simple =, the same query does an INDEX RANGE SCAN as ...
0
votes
1answer
18 views

Does restoring an Oracle backup of the whole database restore schema objects?

I used RMAN with, RMAN>backup database archivelogs all; After that I truncated a table. I then tried to restore with, RMAN>restore database; RMAN>recover database; RMAN>alter database ...
0
votes
0answers
24 views

Oracle service names with a minus sign (?)

Are there any reasons not to use minus signs/dashes/hyphens in Oracle service names? DBMS_SERVICE, tnsping and sqlplus seem to be fine, but the documentation says no. We are switching from Oracle ...
1
vote
3answers
55 views

Remove ORA-01100:DATABASE ALREADY MOUNTED

I am using Oracle 11g and there is a database create during installation name "xyz" and user "xyz".Now i created a user 'abc' and gave following permission to abc. "CREATE SESSION, ALTER SESSION, ...
0
votes
0answers
15 views

Oracle - Reduction in count of active session

I am getting a peculiar behavior - Whenever TPS (Transaction per second) of my application reduces significantly, there is proportionate reduction in 'Active Average Session' for commit operation. PFA ...
0
votes
1answer
22 views

How to design and implement a datawarehouse using oracle data integrator 12c?

I want to design and implement a datawarehouse using oracle products. The most recently documented product to do that is Oracle Warehouse Builder 11g R2. But when installing, oracle database 12c, OWB ...
0
votes
1answer
25 views

Oracle 11g not allowing to connect to. Error ORA-01122: database file 1 failed verification check

I am running Oracle 11g on Windows 7 Enterprise SP2 16 GB RAM, 1 TB HD. I can connect to Oracle using SQL Plus (see below), C:>sqlplus sys/xxxxxxxxx@XE as sysdba SQL*Plus: Release 11.2.0.1.0 ...
0
votes
1answer
40 views

Cannot remotely connect to oracle express

I have installed Oracle Express in a oracle-6.5-x64 virtual machine (let's called it host). The installation went fine, I am able to connect and run commands using SQLPlus from the host. Now I'm ...
0
votes
0answers
28 views

Performance getting rows with max column

I have an historic table called 'historic', with three columns: object_id, day, value. For historical reason, day(date) is an integer number (number of day since 01/01/1904) Example: object_id | day ...
0
votes
1answer
67 views

ORA-00227: corrupt block detected in control file

I am getting the following error while starting the sqlplus (I am using Oracle XE 11.2.0) ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 0 Serial number: 0 So, I ...
0
votes
2answers
37 views

BASH: DBCA: command not found

When I use dbca command as Oracle 11g user I have the following error message: BASH: DBCA: command not found and when I checked the bash profile I found the following: # .bash_profile # Get ...
1
vote
1answer
35 views

Oracle Patching & Database Upgrade - Which Order

I have an Oracle instance running 11.2.0.2.0: SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Release ...
-1
votes
0answers
34 views

optimizing query and identifying the problem

i have a query which takes 2 mins to exceute in qa environmnet and the same query takes 10 mins in test environment. in qa environmnet Code: Elapsed: 00:00:02.86 Execution Plan ...
0
votes
1answer
15 views

Oracle Hierarchical query: with two node attributes NodeId and NodeType

I have the following use case where I want to make use of hierarchical queries to get the desired result. In my use case I have two types of node say 'A' and 'B'. So the unique identifier of node is ...
0
votes
2answers
79 views

Not able to connect to non-default oracle database after reboot

I have installed Oracle 11g r2 on Centos. On initial setup it installed database named INFA for me.I setup listener.ora and tnsnames.ora for INFA and on reboots all I had to do was run lsnrctl start ...
0
votes
0answers
41 views

ORA-02070: database does not support antijoin in this context

I don't think this is even a question, but in case someone has seen something like this before or has any thoughts besides 'file a bug with Oracle' (which I'm doing), I'd love to hear it. create ...
-1
votes
1answer
56 views

Oracle Partition Table Space Issue

I have a table with list partitions on it. When i insert data i see that all the partitions have default initial size of 8 MB and I also noticed that when i truncate full table and check size it still ...
1
vote
1answer
89 views

Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server

I installed 11g on Centos VM on my mac.I have everything up and working on server.I have included following command I ran on cenos. $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production ...
0
votes
1answer
46 views

Connecting to SQL Server using Oracle SQL Developer

I am using oracle sql developer to manage my oracle database. I recently added third party database jdbc drivers to be able to connect to my new MySQL and SQL Server installations. I need help with ...
0
votes
0answers
28 views

A issue on DB link between Postgres and Oracle?

I am trying to create a DB link between Oracle and PostgreSQL using OCI. CREATE DATABASE LINK oraedb CONNECT TO hr IDENTIFIED BY 'hr' USING oci '//127.0.0.1/xe'; CREATE DATABASE LINK When I ...
0
votes
0answers
176 views

IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer

I have installed Oracle 11g ON a RedHat6 linux instance, by following all the steps mentioned in "http://technologylair.net/2013/08/oracle-11g-installation-linux/#comment-50" I am trying to connect to ...
0
votes
0answers
39 views

data pump error

I have 2 database in the same host. JDETST (for test) JDEPRD (for production) JDETST is a old copy of JDEPRD (now with different data but non parameter) If i do an export of JDEPRD: export ...
0
votes
1answer
20 views

How to return a result set from oracle procedure ?

How can i return a result set from a stored procedure in oracle ? suppose i want to return a table from a simple select statement such as this : Select * from tblTest I tried this but this seems ...
0
votes
1answer
43 views

General question on dbms_stats

General question on dbms_stats and auto sample size? what is the impact of having IOTs with overflows and you switch to auto_sample_size and enable approximate NDV . How does it impact?
3
votes
1answer
128 views

Why is add timestamp column with default not null so slow in Oracle 11g?

In Oracle I need to add a new column with type timestamp with time zone to a large table (80 million rows). I cannot have more than 30 - 60 seconds of downtime when I run it in production. This ...
0
votes
2answers
161 views

What is the difference between Schema and Database in Oracle?

In oracle, Datafile are system files where actual data is stored.The collection to datafile make Tablespace and atlast database is collection of tablespaces Correct me if I am wrong on the concepts ...
1
vote
2answers
84 views

Inner Join Performance

This is my first question on this forum, so be patient... My question is about the most efficient way to build a query on the following table: create table OpenTrades( AccountNumber number, ...
0
votes
0answers
13 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
99 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
47 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
43 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
59 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
18 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
295 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
92 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
60 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
72 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
86 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
34 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 ...
0
votes
0answers
39 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
32 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
235 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
49 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
47 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
37 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
161 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
86 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 ...