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

2
votes
1answer
1k 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 ...
2
votes
2answers
2k 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
620 views

ORA-12899 when creating varchar virtual column based on numeric column

I have a table with numeric column: create table test (a number(2,0)); Next I want to create a virtual column based on column a: alter table test add (b varchar2(3) as ('A:'||to_char(a))); This ...
2
votes
1answer
8k views

Completely uninstall Oracle server on Linux

I have searched lot in Google for how to uninstall Oracle on Linux, but I can't figure it out. I think that I need to reinstall the server because I get a lot of errors when I try to startup the ...
2
votes
2answers
950 views

Create Oracle ASM Disks Without Installing Oracle

I have been asked to setup workstations (VMs) for an instructor's Oracle 11g R2 Workshop. I am finding the documentation that was downloaded from the Oracle Academy site extremely underwhelming. I am ...
2
votes
1answer
2k views

Specify Server for DBMS_Scheduler Job in Policy Managed RAC

A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test is being run from. I know that with an Admin managed database this could be done by creating a service that ...
2
votes
1answer
516 views

Blocking incoming database links

Let's say there is an Oracle database A and another Oracle database B. Our database is A. Is there a way to block database links from B to A?
2
votes
2answers
2k views

Oracle 11g R2 - same query sometimes fast, sometimes slow

I have a simple update query on a table with about 100 rows in it: UPDATE RESULTS_DATA SET IMAGE_BLOB=:myBlob WHERE MEASUREMENT_INDEX=:mIndex AND BATCH_ID=:batchId AND SYSTEM_ID=:sysId ...
2
votes
2answers
21k views

How to store single result in variable and reuse it in a query (Oracle)?

I have a query like SELECT id FROM xyz WHERE ...; which has a more or less complex WHERE clause and returns exactly one row with one column (ID). I need this ID for several later queries in a ...
2
votes
1answer
369 views

Error creating linked database to oracle

CREATE DATABASE LINK myLINK CONNECT TO username IDENTIFIED BY password USING 'PROD'; OPT= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.6.1.5)(PORT = 1521)) ) ...
2
votes
1answer
1k views

SQL on Mac OS X

I'm looking for something like "Oracle database express" to be used on a mac. I hope this question won't offend anyone though. I'm absolute beginner on sql. Your suggestions are most welcome.
2
votes
2answers
204 views

Overhead of DBMS_Profiler

If I use DBMS_Profiler to profile a long running (5 hour) PL/SQL script, how much longer should I expect the script to run with profiling? I realize this will be dependent on what the script is ...
2
votes
1answer
3k views

RMAN & Archivelog Deletion Policy confusion

Never been able to fully grasp the notion of delete input/delete input all when backup up Archivelog with rman. Tied to the same issue is the configure Archivelog deletion policy to backed up X times ...
2
votes
1answer
773 views

Oracle Active Session Pool Questions

what is oracle active session pool? is it activated by default? what is the default maximum active session that there is per user?
2
votes
1answer
355 views

Oracle Stopping - Can't Login All Of A Sudden -

I'm having a problem with Oracle, it happens randomly around once in three weeks or once a month. The instance that i'm using suddenly hangs, and no logins can be established to it.It won't accept ...
2
votes
2answers
2k views

Materialized views use older dbms_job instead of scheduler?

Very new to this topic - using 11g. When I create a materialized view, a matching job (not a scheduler job) is created. But it's my understanding that dbms_job is being replaced by dbms_scheduler. ...
2
votes
2answers
1k views

Piplelined Result Set over Database Link Alternatives

Since a pipelined result set cannot be returned over a database link (see MOS note 560743.1), what workarounds/alternatives are there. I can think of a few, but I'd rather not lead the question. I ...
2
votes
1answer
519 views

Recover Oracle database after drive loss Interview Question

How would you answer this as an interview question? The database crashed and you lost a drive containing one of your control files and another drive containing an entire redo log group. You ...
2
votes
1answer
23 views

Re-import packages in Oracle

I'm aware of options to re-import data to tables using table_exists_action and can give options like skip,append or replace for the data. But is there an option to re-import packages (re-create) into ...
2
votes
1answer
251 views

How to generate an SQL file with DBMS_DATAPUMP

I am trying to generate an SQL file with the DBMS_DATAPUMP api. This tasks is specifically adressed in Oracle support Note 1519981.1 (How To Generate A SQL File Using The DBMS_DATAPUMP API). When I ...
2
votes
1answer
84 views

Oracle 11g connect overhead

Currently one of our new applications is connecting to an Oracle 11g instance over 30,000 daily (at every user request) via their application server, using the same account. (it will be significantly ...
2
votes
1answer
159 views

transactions and Oracle dblink

I have 2 dbs, let's call them writedb and readdb. Readdb has a dblink to writedb and a view to a table over that dblink. I do an update on writedb to that table which view points to and then read ...
2
votes
1answer
4k views

Connected to an idle instance; trouble creating DB

I tried to connect to my database and got Connected to an idle instance: C:\>sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Mon Sep 22 19:07:34 2014 Copyright (c) 1982, 2010, ...
2
votes
2answers
421 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 ...
2
votes
1answer
689 views

Oracle 11g installation stuck at installation

I'm trying to install oracle 11g on fedora by following this tutorial but it stuck after I click Next in step 8. The screen does not go away even after several hours. There's no log file in ...
2
votes
1answer
156 views

Backing up Oracle home directory while instances are running

Can I take a backup of Oracle home directory (with cp -r) before upgrade while the instances using the home are running or is it required to shutdown instances first? Trace files/alert logs are in ...
2
votes
1answer
1k views

Is there a way to explicitely have a not-null column in a view

If I create a view in Oracle, the column definition's not null characteristic is inherited from the base table: create table tq84_t ( col_1 number, col_2 varchar2(15) not null ); create view ...
2
votes
1answer
4k views

SP2-0750: You may need to set ORACLE_HOME

I am getting following error message when i write sqlplus on command prompt SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Here are the path details
2
votes
1answer
315 views

BLOBs storage in a dedicated table

I have a database that has several BLOB columns scattered across multiple tables. Since I am a developer and am looking at making application code writing easier, I wanted to turn these columns into ...
2
votes
1answer
3k views

where is oracle session timezone set?

I have a logging table CREATE TABLE EMAIL_LOGGING ( ID NUMBER(9) NOT NULL, SEND_DATE TIMESTAMP(6) DEFAULT LOCALTIMESTAMP NOT NULL, ...
2
votes
1answer
987 views

Oracle: Long delay opening connections

I am getting a very long delay (about 2 minutes) opening initial connections on my 11g2 development server. Sometimes I get ORA-28547: connection to server failed, probable Oracle Net admin error and ...
2
votes
1answer
466 views

Upgrading from 10.2g to 11g by incrementals

I know it's possible to generate a full rman backup in a 10.2g database, move it to another server containing 11g, restore it there and finally do an upgrade. Since I have to do this to a large ...
2
votes
1answer
2k 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 ...
2
votes
1answer
635 views

Reverse engineer Oracle database in visio

Trying to reverse engineer tables added into a database but when i connect, I get strange Chinese symbols with a lot of apex stuff. I dont see anywhere the tables that i added, what am i doing ...
2
votes
2answers
14k views

Oracle11.2g post-installation problem on Oracle Linux kernel

[question copied from stackoverflow] After installation of Oracle 11.2g in silent mode on the Oracle Linux kernel, I have the following error: [u01/app/oracle/product/11/bin] $ sqlplus sqlplus ...
2
votes
1answer
294 views

Rman not replacing logs with same name on networked drive

Historically, rman saved logs by replacing files of the same name so that the most recent set was always there, and logs from backup of older than the most recent set simply went away. Rman is ...
2
votes
1answer
3k views

when to use embedded PL/SQL gateway with Oracle APEX?

Oracle Application Express (APEX) requires one of the following three options for an HTTP server: (1) Oracle HTTP Server (with mod_plsql), (2) Oracle Application Express Listener, or (3) an embedded ...
2
votes
1answer
3k views

Oracle DB hanging after upgrade to 11.2.0.3

The database is hanging randomly (with some leniency I would say almost each hour). Top session is: select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 or select ...
2
votes
1answer
187 views

May I Convert Non RAC db to an RAC DB and add on a Node?

Currently my work env as 1 node none RAC database 11gR2, we are getting another machine (Linux), so I need to add on this node to our currently env and becoming a RAC db. What is the best way/route to ...
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 = ...
2
votes
1answer
3k views

Best methods for ingesting XML into Oracle 11gR2

I have a large Oracle 11g Instance. I now have a requirement to convert large amounts of XML into records in several related tables. The xml will arrive frequently at irregular intervals. The ...
2
votes
1answer
692 views

How to configure so the Oracle wallet password can be authenticated with a web based Oracle application?

Does anyone know how to configure it so that the Oracle wallet password can be authenticated with a web based Oracle application? I’m trying to make secure LDAP connections with an Oracle web based ...
2
votes
0answers
51 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 ...
2
votes
2answers
377 views

Oracle Data Pump Import imports no records

When we do an Oracle Data Pump import of our database, it runs without significant errors. However, on one table Oracle reports that 0 records have been imported. Processing object type ...
2
votes
0answers
499 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
2answers
805 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 ...
2
votes
0answers
59 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
1answer
3k views

Data Migration from Oracle to SQL Server [duplicate]

If you need to do a data migration from an Oracle database to SQL server, what approaches and technical solutions are the best practice? Our database has about 100 million rows and a total of 52 ...
2
votes
1answer
148 views

What's the most appropriate NLS_SORT parameter to cover all/most European languages?

I'm developing an Oracle 11g-based application which is likely to be used by clients in many different countries (mostly European). I want the program to change its NLS_SORT so that it's case ...
2
votes
2answers
863 views

Unable to start Oracle Database Server : Get an error as I try to start it

I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop : but as I click this icon I see this dialog box : What is it ? How do I ...