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

4
votes
0answers
237 views

Should I group by and then join, or join and then group by?

(oracle's optimizer does the same thing for both approaches when just two tables are involved, thus my question involves three tables) Assume three tables t1, t2 and t3 with a pairwise 1:n ...
2
votes
0answers
207 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 ...
2
votes
0answers
39 views

Attaching Existing Oracle Home to fresh Windows Install

I have a client who recently was forced to reformat and reinstall Windows Server 2008 R2. Their ORACLE_HOME (Oracle 11g) and all of the data was located on a D: drive that was not reformatted. Can I ...
2
votes
0answers
1k views

Oracle high Paging Faults

What are the reasons that lead to terrible high Paging faults. The following is the topas information and background about the Environment. OS: AIX 6.1 Softwares: Oracle 11gR2 Paging Space:30720 ...
2
votes
0answers
636 views

Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function?

Oracle SQL Developer (I'm using v3.2) has a feature called "DB Doc", which generates documentation for database objects. I mostly want to use it to generate documentation for my stored procedures, ...
2
votes
0answers
1k views

ORA-01017: invalid username/password; logon denied

I've come across the abnormal situation, and can't understand what happens. I am connecting databases using PL/SQL Developer 8.0.4.1514(I've also tried v7,but same) . Sometimes(When I am trying to ...
2
votes
0answers
378 views

Isssue with Database Links converting OEM Job to DBMS_Scheduler Job

We had an OEM job that would run a PL/SQL block using a particular database users credentials. The credentials are the same for two different databases, so there was no problem for the block to use a ...
1
vote
0answers
16 views

Replacement for Pragma Restrict references

Up to Oracle 11.1 you could mark a package as only reading from the database by adding PRAGMA RESTRICT_REFERENCES( DEFAULT, WNDS); This has now been deprecated. I would like to enforce read only on ...
1
vote
0answers
34 views

Adding custom meta data to a table in oracle

I'd like to know if there's a possibility to add some custom metadata to a oracle database table. The problem at hand is the following: I'm importing a table from another DB. It might happen that I ...
1
vote
0answers
25 views

PLSQL Compilation error for other users/

I created a plsql procedure that queries the database and dumps the result onto a CSV file. I am an application developer and I have dba rights to my oracle database. I'm able to compile and run the ...
1
vote
0answers
38 views

Importing data into Oracle 12

I got a set of files from a client which are, as far as I can tell, copies of a database in Oracle 11. Each folder has the following structure: - init<DB>.ora - orapw<DB> - arch - dbf ...
1
vote
0answers
73 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) ...
1
vote
0answers
99 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
62 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 ...
1
vote
0answers
60 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
0answers
71 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 ...
1
vote
0answers
339 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
0answers
38 views

is there a DB client which supports oracle editions?

We are using a clever feature or oracle 11gr2 called edition-based redefinitions. This means each stored proc and view looks different depending on the edition you set in the session. There are ...
1
vote
0answers
125 views

Advice to set minimum preferable value for MEMORY_TARGET

I have a server having 90GB of RAM. I have set MEMORY_TARGET to 60GB, because OEM showed me the following graph: Which tells that, if you set the parameter to the value of 60GB, the performance ...
1
vote
0answers
63 views

Register XML schema using dbms_xmlschema in Oracle 11g

I have a xsd file located at C:\temp\test.xsd I need to register this schema to create a XMLType table for Object Relational XML Storage. How do I register the schema for relational storage? I do ...
1
vote
0answers
89 views

Oracle specifying join order hint

Oracle 2 node RAC 11G R2 I have a query (this is a simplified version, but still exhibits the same issue as the larger query) that looks like this: SELECT t1.trip_id, t1.origin, ...
1
vote
0answers
3k views

Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]

While I try to take incremental backup level 0 by using the command RMAN> backup incremental level 0 database plus archivelog; , encountered this error. RMAN-00571: ...
1
vote
0answers
87 views

Import from incremental backups to a new host in Oracle 11g

I am using Oracle 11g. I would like to know that whether it is possible to import from incremental level 0 & 1 backups to a new host using RMAN. If yes, how can I do that? For level 1 I am using ...
1
vote
0answers
316 views

rman 'delete archivelog all’ very slow

On our automated test system we use flashback all the time to reset our Oracle 11g database to a state before a testrun. We noticed some of the scripts involved started to become slower and slower. In ...
1
vote
0answers
192 views

Performance Hit when upgrading to Oracle 11gr2

I am experiencing the same symptoms as noted in this question which was closed and does not have a satisfactory answer. Original Question We've recently upgraded from Oracle 10gR2 (10.2.0.4 ) to ...
1
vote
0answers
104 views

need the most efficient way to handle unique constraint errors

I am looking for the most efficient way to solve this situation: We are an Oracle shop. I need to load data from one table to another. My source table, which contains 30 million rows, has a person ...
1
vote
0answers
4k views

impdp failing with ORA-01031: insufficient privileges

I'm trying to import a dmp file provided by our dba to my dev database. I've been able to export the contents to a SQLFILE and the contents look ok. I tried importing the schema and it kept on failing ...
1
vote
0answers
2k views

Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant

this is my first time to install Oracle 11g R2 on Linux. I made all instructions in Oracle documentation. But in the installation process, the Net Configuration Manager is failed. I continued the ...
1
vote
0answers
513 views

Oracle 11g release 2 32 bit client Installation

I have installed a 32 bit Oracle 11g Release 2 (11.2.0.3) client on my Solaris 64 bit machine. But I am getting: Generic Status: Library Open failed, Library Name: libclntsh.so, Platform Status: ...
1
vote
0answers
543 views

What is the nature of “LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2”?

I'm not sure when this started, but for the time being the primary database instances in a physical standby configuration logs this message on every redo log switch. ...
1
vote
0answers
5k views

Oracle XE TNS Listener fails to start

I freshly installed Oracle XE 11.2.0.2.0 and found out that the TNS Listener service fails to start. At first I tried to start the Windows service by hand. After the failure this is the entry in the ...
1
vote
0answers
184 views

How to find an text in entire Oracle database?

I have a Oracle database (11g2). But i don't know how to find a text in all of table on a database. Because there are so many tables, can't find down by one column, one table... it takes me a lot of ...
1
vote
0answers
4k views

Could Oracle ORA-08103 'object no longer exists' error be caused by size of undo_retention parameter?

Had a once-a-day long running data warehousing procedure that I had written that was failing about 50% of the time. Logs were showing ORA-08103 'object no longer exists'. ORA-12012: error on auto ...
1
vote
0answers
1k views

ORA-01460 during Data Pump Import

While migrating data from Oracle 11.2.0.1 RAC to Oracle 11.2.0.3 RAC using Data Pump, the import failed with ORA-01460: ORA-39097: Data Pump job encountered unexpected error -12801 ORA-39065: ...
1
vote
0answers
471 views

Restoring Oracle prod backup to test server with new database name

I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database ...
1
vote
0answers
129 views

Use of hash functions in group by?

I'd use a listagg() to generate a list of components a certain customer has and compare it to another list generated the same way somewhere else to detect inconsistencies. The problem is that ...
1
vote
0answers
139 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
12 views

Oracle SQL Loader - BULK UPDATES

Can SQL loader be used to do bulk updates? I have a table that holds customer information. The table has a primary key and it has 5 columns pertaining to the customer. Now we created three more new ...
0
votes
0answers
28 views

Oracle Duplicate Database with no archived logs

I am trying to perform a duplicate operation from one server to another (testing disaster recovery) on oracle 11g. I am very much still learning about Oracle. The system is not in production, it is ...
0
votes
0answers
26 views

Results of SAMPLE clause using a DBlink between 2 Oracle databases not randomised

I'm using the SAMPLE clause to retrieve random rows from a table. It works fine except when the table is from another database. I'm using a database link between 2 Oracle 11g databases (11.2). This ...
0
votes
0answers
30 views

ORA-26097: unsupported conversion for column SYS_NC0000500006$ (from type 58 to type 23)

I have an Oracle Enterprise Edition as a source and taken the dump using the oracle data pump(expdp) and the dump is imported using (impdp) to an Express Edition of Oracle. The import was working ...
0
votes
0answers
29 views

Oracle: How to split records across days

I have data with two timestamp columns startdate and enddate. The data is produced continuously everyday and some records are such that the startdate is one day and the enddate is the nextday as it ...
0
votes
0answers
70 views

ORA-01034: ORACLE not available in oracle 11g

I installed oracle 11g on ubuntu 14.04 and i started lister and the message is as below. LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 10-OCT-2014 14:20:02 Copyright (c) 1991, 2011, Oracle. ...
0
votes
0answers
30 views

Did another application use an Oracle block?

One of our production Oracle databases got hit with a corrupt block. Looking at the hex dump, the first part of the block seems to contain Microsoft Windows Event Log and Windows Registry information. ...
0
votes
0answers
21 views

Oracle Support Identifiers?

Right now i am not working in any company.How to get oracle Support Identifiers?
0
votes
0answers
162 views

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor at the time of switchover using data guard broker

I have a oracle data guard setup with nodes - one as primary and other as physical standby. I also, have configured the data guard broker on it. The problem is when I tried to switch over , I just ...
0
votes
0answers
39 views

how to make oracle db instance and em dbconsole running manually/?

I installed oracle11gr2 (x64) on vmware oracle linux (x64). When I finished installing, I'm sure that I executed the init scripts as root: /app/oraInventory/orainstRoot.sh ...
0
votes
0answers
39 views

Selectively load data using Oracle 11g r2 External Table Preprocessor

I am using the Preprocessor feature in Oracle 11g r2 to load several data files in a table. However, the raw files seem to have certain rows that shouldn't be imported with the rest. For example: ...
0
votes
0answers
42 views

How to import data into Oracle 11g r2 daily

I need to batch load several log data files (comma delimited but they don't have a .csv extension in the file name) once each day into an Oracle database. I'm sure this is a very common use case, but ...
0
votes
0answers
40 views

How to find materialized view log dependencies over database links

Is there a way to identify materialized views that have used a given MV log, even if the MV is using the log over database link? (Oracle EE 11.2) The problem is that I would like to drop a certain MV ...