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

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
28 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
19 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
32 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
19 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
60 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 ...
-3
votes
0answers
21 views

select for loop result in oracle [closed]

How i can achieve below result : Procedure GET_Test(i_MatricNo in varchar2, i_Subj_Code IN t_c_subj_code, o_cursor out ...
0
votes
2answers
36 views

Oracle StartUp Issue [closed]

I am facing the following issue while starting the Oracle instance. SQL> Connected to an idle instance. SQL> SQL> ORACLE instance started. Total System Global Area 1269366784 bytes Fixed ...
0
votes
0answers
40 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
39 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
27 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
48 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
28 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 ...
-1
votes
1answer
55 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
48 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
32 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
38 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
83 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
0answers
46 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
52 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
43 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
76 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
74 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
57 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
79 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
50 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
110 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
35 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
93 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
51 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 ...
0
votes
0answers
23 views

On Solaris 10, does soft limit affect process memory allocated to oracle database?

System: Solaris 10 Database: Oracle 11gR2 We are encountering ORA-4030 - Out of process memory recently. I noticed that stack size was rather low in the soft limit of oracle user: ...
0
votes
3answers
102 views

How to tell from the OS whether Oracle instance is a standby, assuming no DB access?

One can easily check via SELECT database_role FROM v$database; whether your Oracle database is a primary or standby database. Is it possible to make the same determination without database access, ...
1
vote
0answers
32 views

Should an SCN obtained from one RAC node be immediately usable on other RAC nodes?

I'm seeing ORA-08181: specified number is not a valid system change number and don't understand why. The error happens around once a month from a process that runs every few minutes - so very rarely. ...
0
votes
0answers
26 views

Required Information to start oracle warehouse builder

I am using windows 8 64 bit . I want to install Oracle Warehouse Builder on my system. I have installed Oracle 11g and come to know that Warehouse Builder is already a part of it. But when I start ...
1
vote
3answers
336 views

How to handle big data update based on excel spreadsheet

Scenario Select-based data is exported from DB to Excel spreadsheets. Some manual work is done on the excel files (filling missing data). Changed data from excel files is updated back to DB. ...
1
vote
2answers
103 views

Will enabling row movements on list-partitioned table cause performance problems(oracle 11g r2)

Our incident management system has run for years, and the large quantity of closed incident tickets makes the table rather huge and slows down the search queries. Our database version is oracle 11g ...
6
votes
1answer
177 views

Can I use Oracle Standard or Enterprise edition for my own training purposes?

Question is about Oracle licensing terms. I would like to learn more about Oracle Database administration. Unfortunatelly I am using 32 bit verison of LInux, so I can't install Oracle 11 XE (I can't ...
0
votes
1answer
572 views

How to solve “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor” error?

I am trying to create connection with the database for debugging ASP.Net website. Database is 11g Oracle DB... There is no problem when I connect using SQL Developer, however using Visual Studio I get ...
3
votes
1answer
88 views

Oracle Data Pump Import with running advanced replication

In our system we have a running advanced replication between two databases(11g release 2) and want to use pump import to import a backup on one site. However the imported data is not replicated to the ...
0
votes
0answers
21 views

issue granting privileges in a hierarchical user configuration

as SYS: grant execute on sys.dbms_reputil to system with grant option; grant select any dictionary to system; grant dba to system; -> ok. Then, as SYSTEM: GRANT EXECUTE ON sys.dbms_reputil TO ...
0
votes
0answers
113 views

Connecting SSIS to Oracle using Attunity Drivers

I am trying to recreate the steps I took to allow me to connect to 64bit Oracle installation from SSIS using the Microsoft Connectors 3.0 for Oracle and Teradata (Attunity driver). MY issue is I ...
1
vote
1answer
76 views

Check if an index exists by comparing columns

We are currently using ALL_IND_COLUMNS to check if an index exists by its name or the columns it is using. The problem is that we can only check if the index exists with columns in a specific order. ...
3
votes
1answer
52 views

Possible RMAN orphan files in backup directory

I am trying to scrape together some space in my Oracle 11g backup directory in AIX. I have deleted obsolete files using RMAN's "DELETE OBSOLETE" command, but I see many (just under 200) files dated ...
1
vote
2answers
72 views

Can install a test machine with Oracle 11G R2, not express edition, on a VirtualBox?

Im starting like a Oracle DBA, and I want play with the database and your administration task in a test enviroment. I have a macbook pro i5, and had thought install on it oracle under virtual box ...
0
votes
1answer
39 views

XMLDB - Nodes to Rows

I have an application that stores XML as XMLType in a table. This is the first time I'm using XMLDB and XMLType features, and was wondering if I could use the results from an XQuery FLWOR expression ...
0
votes
2answers
45 views

11gR2 didn't ask me to set username or any password

I have installed Oracle 11gR2 (latest version 11.2.0.1.0) on my system. During the installation it didn't ask me to set username or any password. I'm unable to start sql plus because i don't have the ...
0
votes
0answers
183 views

ORA-12578: TNS:wallet open failed

I am calling an oracle wallet through "autosys" job. When i am calling through clicking on my myreport.bat file its working fine and connecting to DataBase but when i am calling that myreport.bat ...
-3
votes
1answer
46 views

Database fragmentation [closed]

How can we find the list of fragmented objects in the database. And how much space we can reclaim by defragmenting those objects.
0
votes
0answers
46 views

Oracle 11G DataGuard: infrequent change of Log Archive Destination Role

currently we have the weired behavior of our DataGuard-Setup, in which the primary database somtetimes changes the role of "log_archive_dest_1" from "valid_for=(ALL_LOGFILES,ALL_ROLES)" to ...
1
vote
0answers
29 views

Where to put standby control file in Physical standby database?

I am creating a physical standby database for which I am creating a standby control file using command = ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oracle/dbs/stbycf.ctl'; but It creates only one ...