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

-3
votes
0answers
14 views

select for loop result in oracle [on hold]

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
1answer
25 views

Oracle StartUp Issue

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
19 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
27 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
24 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 ...
-1
votes
0answers
22 views

Oracle 11g .DMP file import [closed]

I have been trying to import my abc.DMP file in Oracle 11g I have created a user. When i am trying to import then this happens. I am new to oracle I have gone through some tutorial but they weren't ...
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
52 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
31 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
35 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
64 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
44 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) ...
0
votes
2answers
49 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
41 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
68 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
73 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
55 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
69 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
45 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
106 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
34 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
84 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
46 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
19 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
98 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
31 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
281 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
89 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
456 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
77 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
19 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
106 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
69 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
49 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
70 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
38 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
40 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
179 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
44 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
42 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
26 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 ...
0
votes
1answer
48 views

Increase in temporary tablespace while import

When i am importing some tables in my database, the temporary tablespace is getting full. This never happened earlier for other tables. Please help me know why this is happening and any solution for ...
0
votes
1answer
142 views

Oracle Database Client 11g R2 Installation Types, which components?

I need to know which component is under each installation type! Instant Client Administrator Runtime Custom (No need as it shows all the components) ALSO? does it includes ODP.NET? is it the ...
0
votes
0answers
222 views

intermittent TNS-12533: TNS:illegal ADDRESS parameters

I am running a windows XP (SP3) VM in virtualbox, on which I host Oracle XE. It has been running fine like this for a couple of years, but recently I am seeing some strange problems. My client ...
0
votes
2answers
251 views

Slow import for users .DMP files in Oracle 11G

After upgrading my DBMS Oracle 10g to 11g, when it will import user files, they are slower than the old version. A .DMP file in Oracle 10g with the size of 20GB takes almost 1 hour to import, but ...
1
vote
3answers
81 views

Oracle static lookup table

What is the best approach (or what options am I not aware of) to creating a static table or view where the data rarely, if ever, changes? An example use-case is a list of US states, where my ...