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
2answers
19 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
13 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
1answer
28 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
22 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
5 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
0answers
17 views

What is a CLRExtProc oracle instance?

An lsnrctl status output: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, ...
1
vote
1answer
33 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
45 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
19 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
69 views

Oracle becomes too slow after system crash

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
0answers
34 views

Oracle Enterprise Manger not working correctly

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: Where to find the log file to see what's the ...
1
vote
0answers
23 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
21 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
20 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
42 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
23 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
16 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
27 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
24 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
30 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
26 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 ...
1
vote
0answers
35 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 ...
0
votes
2answers
44 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
25 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 ...
3
votes
1answer
62 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
31 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
3answers
46 views

How to mirror the privileges of an user to another in Oracle Database? [duplicate]

I need to grant all the privileges of a user (say 'AAA') to another user (say 'BBB'). Is there such an Oracle command (11.2.0.3.0)?
0
votes
1answer
25 views

too many entries for one single session and serila# in V$Session_longops

I have a concern with the entries in v$session_longops. I used a query to identify query running from past 25 minutes for sid=62 which is given below: SELECT s.sid, s.serial#, ...
0
votes
0answers
34 views

From keyword missing in view

I am this view which I am trying to compile. Given below is the view. CREATE OR REPLACE FORCE VIEW "My_View" ("my_ORDER", "REQUESTOR", "DEPARTMENT", "HOD", "SHIP_TO", "SOLD_TO", "PRODUCT", ...
2
votes
1answer
40 views

Does a DDL in Oracle affect other transactions?

I understand that DDL statements in Oracle have an implicit commit before and after the statement, which obviously affects the current transaction. However, does a DDL statement in any way affect ...
0
votes
1answer
44 views

Inserting data into a table with one value as clob and blob

My table has one clob column and one blob column. I need to insert data into it through insert statements. The length of data to be inserted is more than 4000 chars. When I do export of insert ...
0
votes
0answers
31 views

Oracle Merge performance

I've a question about the merge performance in oracle. I work in the business intelligence area of a big company and its quite common to have to move millions of records one side to other. The other ...
0
votes
0answers
31 views

What is meant by the RMAN Duplicate “noncurrent point in time”?

When doing a RMAN DUPLICATE from backup connected to the target, how current does the duplicate make the database when no until time is set? The closest thing I can find in the documentation is the ...
0
votes
1answer
42 views

Oracle 11g max login fail attempts workaround

My problem with database starts with situation where I cant really modify anything in database. My project specialist has limited time to help me. Here is the thing: My user in Oracle database has ...
0
votes
1answer
57 views

How to export oracle 11g database partially

I have a huge oracle test database whose size is more than 100 GB. I want to export only 1% of all the data and import it into my local database to have a local replica of that application. Is it ...
0
votes
0answers
22 views

How can I receive an input string parameter having about 200000 characters?

I have a SP in Oracle 11G R2 that receives an input XML that contains about 200000 characters that are extracted from the xmliside the SP and inserted into about 25 tables. Thus I am not being able to ...
0
votes
1answer
91 views

Create Oracle DB LINK to a database with no DB_DOMAIN

I'm trying to create a database link between this two DBs. My local DB is 11.2.0.3. SQL> select * from global_name; GLOBAL_NAME ...
0
votes
1answer
50 views

Oracle case insensitive passwords seemingly ignoring SEC_CASE_SENSITIVE_LOGON

I'm trying to change the SYS password of an Oracle 11g database to be case-insensitive for legacy application reasons. My research suggests all I need to do is set the SEC_CASE_SENSITIVE_LOGON flag, ...
0
votes
0answers
46 views

ORA-01658 on index tablespace when trying to insert into empty table of new database

We are getting ORA-01658 (Error :ORA-01658: unable to create INITIAL extent for segment in tablespace MYDATA_LDATA_INDEX) in our application logs. This happens when application is trying to insert ...
0
votes
1answer
27 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
1answer
332 views

ORA-15081: failed to submit an I/O operation to a disk

I have a test environment for Oracle single instance on ASM 11.2.0.3. I have restored database from tape and during the recovery, the system crashed by some I/O error. I restarted the server, ...
0
votes
0answers
22 views

unable to allocate 4064 bytes of shared memory [duplicate]

i am facing this error ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","SELECT...","sga heap(1,0)","kglsim heap") i have tried flushing the shared pool. it still didn't ...
0
votes
0answers
30 views

Installing Oracle on Windows Server 2008 R2 Guested by VMware

I am trying to install Oracle Database 11g R2 on Windows Server 2008 R2 Guested by VMware Workstation 10. I tried this more that 5 times but every time I was encountered by Enterprise Configuration ...
0
votes
1answer
65 views

Installing Oracle 11g on Windows SBS 2011 64 bit

In the Oracle web site, I found the following requirements: http://docs.oracle.com/cd/B28359_01/install.111/b32006/reqs.htm#CHDHGGFE Oracle Database for x64 Windows is supported on the following ...
0
votes
1answer
40 views

Why am I getting an error in execute immediate command in oracle 11g?

I was just testing an anonymous code which I wrote for audit trail It's just a sample for test. However I am getting this error: [Error] Execution (1: 1): ORA-00984: column not allowed here ...
0
votes
1answer
100 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 ...
1
vote
2answers
75 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
58 views

What index(es) should I use for three columns join?

I have a table which has the following columns: CREATE TABLE example ( exid INT, extype INT, studentid INT, (more columns) ) The table will have hundreds of thousands rows, and each ...
0
votes
1answer
52 views

converting varchar to number while passing to IN clause

I am really stuck here.. Given below is the miniature of what I am trying to achieve. set serveroutput on; declare rajesh varchar2(20); x number(10); begin select wm_concat(stocks_id) into rajesh ...
0
votes
0answers
156 views

Oracle installation requires old rpm versions, what to do?

I am installing Oracle 11g R2 on OEL6. I run the following command, for to check only prerequisites ./runInstaller -silent -responseFile /0/grid/response/crs_install_mk.rsp -executePrereqs It ...