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
22 views

I have a problem starting my database, I am using redhat 5.5 and 11gR2

My issue is when I start my database, following error are shown. ORA-03113: end-of-file on communication channel Process ID: 3661 Session ID: 1 Serial number: 5 and there is problem with ...
0
votes
0answers
19 views

Removing editioning from an Oracle user

I maintain an Oracle Enterprise 11.2.0.3 database where one user has editioning enabled. I understand that this was an irreversible choice according to the documentation. If I wish to revert that ...
0
votes
0answers
21 views

sqlplus on linux not connecting when provided with IP port

I am running Oracle Database 11g R2 on Oracle Linux 5. I am able to connect to my SID from sqlplus if I use the command sqlplus system/password@orcl but when I provide the IP address and port: ...
0
votes
1answer
68 views

ORA-01078: failure in processing system parameters LRM-00109 error too

SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 1 16:40:07 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in ...
0
votes
0answers
16 views

How to Load Special characters in Database 11.2 & Client Character Set is US7ASCII through SQL * Loader [duplicate]

My client using Oracle database version 11.2.0.1.0 and NLS parameters are NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY ...
0
votes
1answer
41 views

Oracle Full Client / Database Client package locations

I need to install multiple versions of the Oracle client on an app server for an automation project. The platform I'm looking for in specific is Linux, 64 bit. Oracle's network of websites are a maze ...
0
votes
0answers
30 views

How I optimize data dump in oracle 11g

I've an Oracle 11g Database, now the data is very huge, I've an approximately 858 Object in 1 schema and i have 20 Schema, and it's about approx 20 TB in size. I've tried using Navicat Premium v11 to ...
0
votes
1answer
51 views

User can see Oracle tables via ODBC that her account does not have access to [closed]

We have a user whose Oracle account, according to ALL_TAB_PRIVS, has access to tables A, B, and C. However, when the user creates an ODBC and connects to Oracle via Microsoft Access (using her Oracle ...
0
votes
0answers
25 views

Railway Reservation System [Miniature] Schema

I am working on designing a schema to support the development of a miniature railway reservation system, using oracle 11g XE. This is for a project purpose, I am need to be sure about the correctness ...
0
votes
0answers
14 views

Import non-partitioned table into an existing range partitioned table - ORACLE

I have export non-partitioned table1 on disk with some records, then I create same new table2 in my schema (different name) but with range partitioning, I'm talking about Oracle database. So my ...
0
votes
0answers
27 views

Enterprise Manager cannot connect to 11g Release2 database instance for Window

I also have the same problem with Tuhin. I have window vista version. How to solve this problem? If you don't mind Please answer me. Why this problem occur? I was not use Oracle server may be nearly ...
0
votes
1answer
18 views

How can I list Oracle editions granted?

In using Oracle Edition Based redefinition, I am receiving the error: ORA-38802: edition does not exist when issuing the call: DBMS_SESSION.SET_EDITION_DEFERRED("my_edition") I know the edition ...
1
vote
0answers
39 views

Fast restore of dropped partitions

I want to test the restore of errorneously dropped partitions of a subpartitioned tables. This restore would consist of three steps: restore the database (or at least the necessary tablepsaces) to ...
0
votes
2answers
34 views

Tablespace Creation and Reassignment

It has been determined that user "SCOTT" should use a new temporary tablespace called TEMP2 size equivalent to TEMP tablespace (refer to Notes below for determining the size of TEMP). Create ...
0
votes
1answer
64 views

huge table copy avoid duplicates

I've a table with more than 10 billion records. Many NEW records (in quantum of 40-50 million records)are added regularly in a file as input part of batch process at night. The active table is majorly ...
0
votes
2answers
50 views

sp_sequence_get_range equivalent in Oracle

Do we have sp_sequence_get_range equivalent in Oracle. I need to advance my sequence by some numbers always how can I achieve this.
2
votes
1answer
144 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 ...
1
vote
0answers
83 views

TNS-01190: The user is not authorized to execute the requested listener command

Oracle 11g Release 2 Oracle Linux Enterprise 5.10 [oracle@dub-ImrORA3 scripts]$ id oracle uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba),504(oper) ...
0
votes
0answers
81 views

Why only ~half of RAM is used by Oracle on Linux server?

Why Oracle 11.2 would be using only around half of available RAM on RHEL5 box? I have 64GB but 32GB is free which really annoys me. Any memory not used is wasted memory in my books - especially on ...
0
votes
0answers
17 views

Disabling audit objects on Oracle 11

How can I disable audit objects on Oracle 11? I have tried NOAUDIT ALL; NOAUDIT NETWORK; NOAUDIT SESSION; NOAUDIT ALL ON DEFAULT; NOAUDIT SELECT INSERT UPDATE DELETE EXECUTE PROCEDURE; NOAUDIT ...
0
votes
0answers
17 views

How to run step 2 instead or after step 1 (when step 1 does not meet condition)?

I have 2 steps and 2 rules (3 when counting in END rule, which was pointless to add): DBMS_SCHEDULER.DEFINE_CHAIN_RULE ( chain_name => 'xaxa_c', condition => ...
0
votes
1answer
65 views

I am upgrading from 11.1.0.7.0 to 11.2.0.3 with R12.1.3 while pre upgrade/catupgrd.sql erroring out ORA-00600

While upgrading from 11.1.0.7.0 to 11.2.0.3 with R12.1.3, during running the pre upgrade script catupgrd.sql, it is erroring out ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi ...
0
votes
0answers
41 views

IMPDP twice with same Oracle EXPDP dumpfile with different results?

At my work, we receive data in the form of an Oracle dumpfile generated by an EXPDP command using Oracle DB 11.2.0.4.0. We import it using IMPDP into an Oracle DB (same version) set up with roles, ...
1
vote
2answers
38 views

Oracle RAC Failover functionality clarification

we are running two node active/active Oracle11g R2 RAC cluster i need to replace public network cables on each node. I am planning to do as given below: Setup: OS: oracle Solaris 11.1 Sparc ...
0
votes
0answers
28 views

Transfer data from SQL Server to obiee

I need to transfer data on a daily basis from a SQL Server 2008 R2 database to Oracle Business intelligence. What's the best practice? Db link? External table? Odbc?
1
vote
1answer
53 views

du of directories in a diskgroup in Oracle ASM

In Linux, you could run the below on a directory to find the size of each sub-directory: du -sh * When you're in asmcmdin the +FRA disk group for example, how can I retrieve the size of each ...
0
votes
0answers
20 views

Recurse path from leaf to root? [duplicate]

I have a table structure (in an Oracle 11g database [11.2.0.3.0]) that maps out a folder hierarchy for employee records that looks like this (note: I have to start at the leaf node and recurse up to ...
2
votes
1answer
76 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 ...
0
votes
0answers
71 views

DBMS_SCHEDULER JOB interval not working

I've created DBMS_SCHEDULER job, which type is CHAIN. Chain has 2 steps and 2 rules. Each step has PL/SQL "program" (which inserts SYSDATE to table). First rule's condition is TRUE. Second rule has ...
0
votes
2answers
47 views

DESCRIPTION_LIST in tnsnames.ora

How does this work? If I specify an address list, I know I can specify a load balance or failover option to switch the connection to the other address. But in case of various descriptors (DESCRIPTION ...
0
votes
2answers
28 views

Duplicate databases error

I have two Oracle 11gR2 databases on separate servers. I want to duplicate these databases. For this, I do these steps : In auxiliary db : create password file with password that is same if ...
0
votes
1answer
50 views

Error while migrating SQL Server database to Oracle

I am getting this error message while loading database capture script output in Oracle SQL Developer. The source is SQL Server 2000 and destination is Oracle 11g. java.sql.BatchUpdateException: ...
1
vote
0answers
34 views

What changes to Oracle installation are needed to work with Microsoft MSDTC

We have windows 2008 and 2003 servers that use COM PLUS-MSDTC and distributed transactions with 11g(11.2.0.3) running on SunOS and SPARC hardware. The oracle server was installed years ago by a DBA ...
0
votes
2answers
72 views

Is there any other way that we can take auto backup in oracle 11g apart from RMAN?

I have tried with RMAN. But is there any other possible way that we can backup database and tables. backup using queries or stored procedures is possible?
0
votes
0answers
51 views

Help with Joins - Cartesian Product

I have 5 regions that each contain 1 store and 1 warehouse. I have a table that contains the regions and corresponding stores and warehouses. I also have a table that lists the inventories of both ...
1
vote
0answers
44 views

ORA-01861 - Input seems ok and FX/FM modifiers not used

Using SQL Developer 4, I am getting an ORA-01861 exception when I do the following (and BTW, I ticked 'Ignore NLS Definitions'): alter session set nls_date_format = 'DD-MON-YY'; alter session set ...
0
votes
1answer
57 views

SQLDeveloper.exe itself is getting access denied

Installed Oracle 11g and the 11g client. Everytime I start SQLDeveloper it prompts for the java.exe and again which files to associate. It must be trying to save this in registry (or maybe disk). ...
0
votes
1answer
293 views

ORA-12154 TNS:could not resolve service name from PL/SQL, but SQL Developer Connects Fine

I'm totally new to the world of Oracle. I've got PL/SQL Developer installed on my machine, and able to access client databases on other servers. I installed Oracle 11g express on my machine to try ...
0
votes
1answer
58 views

Rows to columns

I am new to Oracle. I know MySQL. I wrote below query in MySQL: Tables: CREATE TABLE agl_asset ( asset_id BIGINT(20) NOT NULL, caption VARCHAR(64) DEFAULT NULL, description VARCHAR(4000) ...
1
vote
2answers
82 views

Getting ORA-01031:insufficient privileges during first time login to oracle 11.2.0.1.0 database on my windows 8 PC

I installed oracle database 11.2.0.1 on my windows 8.1 PC. I downloaded the zip files from oracle website viz. win64_11gR2_database_1of2 and win64_11gR2_database_2of2. I followed the installation ...
0
votes
1answer
55 views

In Oracle, how to get a list with the names of schemas that a user has read permission?

In Oracle, i need list which schemas a particular database user (or the current database user) has read permission. Based on this information, also need to get all the tables and views are in each ...
4
votes
2answers
148 views

TNS-12541 Error

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
1
vote
1answer
92 views

Optimize large table design

First, I am a complete novice when it comes to databases, but have been given the task to speed up queries on a large set of data. (Hundreds of millions of records) The current implementation is a ...
0
votes
1answer
106 views

How to set ADR Base directory correctly on OracleDB on Linux?

Installed Oracle Database on Linux based OS. Listener is ok. But Oracle is not. (I changed all angular brackets to vertical, because parser not shows angular brackets) ORA-48108: invalid value ...
1
vote
1answer
148 views

How to set the sequence to the last used id for all tables in Oracle?

I'm working on an open source elearning system called Moodle which usually uses MySql or Postgresql, but can also use MSSQL and Oracle. A client wishes to use Oracle, which I have limited experience ...
0
votes
1answer
59 views

ORA-08102 while creating a view

I am learning PL/SQL programming. I'm trying to create a view with the following statement: create or replace view viewName as select ID from employees; The view creation throws the following ...
2
votes
1answer
127 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 ...
0
votes
1answer
60 views

Migrating everything to do with a schema from one Oracle DB server to another

We have an old DB server, running Oracle 11g on Solaris. We also have a new DB server, also running Oracle 11g, but on RHEL. We want to move a schema to the new db - but we need everything it refers ...
0
votes
2answers
178 views

Enterprise Manager cannot connect to 11g database instance

In Oracle 11g when we are opening OEM in browser it is showing the following message : "Enterprise Manager is not able to connect the database instance." Listener status is showing Up and Agent ...
0
votes
1answer
75 views

Solaris 10 - Why shell limits needs to be increased to run oracle database?

Shell limits affect shell and scripts running shell like bash. Oracle's requirements (https://docs.oracle.com/cd/E11882_01/install.112/e48357/pre_install.htm#SSDBI1182 - section 2.10) is to modify ...