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

Script to automatically Identify tablespaces above threshold and bring it back to below threshold value

I am facing all the tablespaces crossing threshold problem in all most all the databases we have in our environment. Because of this much manual effort is been needed. I am able to identify the ...
0
votes
0answers
7 views

Stack trace of oracle sql execution

Is there a way to get the stack trace of the SQL query that is given in awr, I mean a way to check the flow of the query from which package or procedure that it has been triggered? tkprof and awr both ...
0
votes
1answer
626 views

Oracle Duplicate Database with no archived logs

I am trying to perform a duplicate operation from one server to another (testing disaster recovery) on oracle 11g. I am very much still learning about Oracle. The system is not in production, it is ...
0
votes
1answer
475 views

Views for XML with attributes using XMlTable

I created an XMLType table CREATE TABLE PERSON OF XMLType XMLTYPE store AS OBJECT RELATIONAL XMLSCHEMA "PERSON.XSD" ELEMENT "root"; The XML is - <root> <Person empid="1" empname="Joe" ...
0
votes
0answers
26 views

In USER_INDEXES but not in USER_IND_COLUMNS

I can't believe I don't know this but what type of index (Oracle) would have an entry in the USER_INDEXES view and not in the USER_IND_COLUMNS view? I see two system entries in USER_INDEXES. Here is ...
0
votes
1answer
242 views

Oracle 11g r2: Cannot create partition on timestamp field

I have data with a timestamp field of the form '2014-01-01 00:00:00.99' in one of the columns. I want to create a new partition for the table every month. For this I did something like this. CREATE ...
1
vote
2answers
37 views

Compressing partition - what about index?

To save space on disk I want to compress some partitions of my tables: alter table TEST_TAB move partition TEST_TAB_2014 compress for all operations; I have also indexes on this partition. Should I ...
3
votes
1answer
3k views

Why ORA-00932: Inconsistent Types error?

Sorry for the meaningless title, but I couldn't think up a better one. I'm using Oracle 11g r2. The following query raise ORA-00932 error: SELECT BBB.FIELD1 FROM TABLE0 AAA JOIN (SELECT * FROM ...
0
votes
1answer
11 views

How can I solve java lang unsatisfiedlink error when runing jdeveloper?

I cannot run Jdeveloper. My java is in /usr/java How can I fix this? I run rpm --query --whatprovides 'libX....' but it says no package provides this
0
votes
1answer
116 views

Results of SAMPLE clause using a DBlink between 2 Oracle databases not randomised

I'm using the SAMPLE clause to retrieve random rows from a table. It works fine except when the table is from another database. I'm using a database link between 2 Oracle 11g databases (11.2). This ...
2
votes
2answers
819 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 ...
0
votes
1answer
1k views

startup mount issues with Oracle

I am a newbie with Oracle so bear with me. I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the ...
0
votes
0answers
17 views

Accounting Program Error [on hold]

I have Oracle Application R12 running on 11g. The error occurs in Accounting Program when we are running Create Accounting session in Payable Module. When we click on Diagnostics it gives this ...
0
votes
1answer
18 views

How to fix “TNS:listener does not currently know of SID given in connect descriptor” with DBVisualizer on Linux?

I am trying to connect with Oracle database from a server having Oracle client installed (RHEL Linux Environment). I installed DB Visualizer on client machine. But getting listner error on hitting ...
0
votes
1answer
50 views

What's the fastest way to migrate an Oracle database from Unix to Linux?

We have an Oracle database installed on AIX 7.1, and now we want to migrate our database instance to RedHat 6.2. The RedHat server has Oracle 11.2 installed already. What's the fastest way to ...
2
votes
2answers
399 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 ...
1
vote
1answer
125 views

How to retire a physical standby in Oracle 11.2

I have a production Oracle 11gR2 RAC database with a single node physical standby. Now it has become the time to retire the old standby and pass that role to a RAC on fresher hardware. We don't use ...
0
votes
1answer
1k views

listener can not start

My listener in Oracle 11g R2 can not start . When I want to give the status of that, the error in below is shown: Connecting to <ADDRESS=<PROTOCOL=tcp><HODT=><PORT=1521>> ...
1
vote
0answers
40 views

How to identify concurrency issues in Oracle 11g?

For a short period in time we had a concurrency issue that lead to subsequent faults in our application (Java, Spring, Hibernate). Since we are using dictionary managed tablespaces, I first thought ...
0
votes
0answers
32 views

Monitoring active query step using only pure sql

I would like to monitor actively running query on Oracle. What I mean is to gather info about: Actually running step. (What is currently db engine doing in this query) Actual query plan used in ...
0
votes
1answer
545 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 ...
1
vote
1answer
1k views

Oracle error 12154 while importing DMP file

My Setup I'm running Windows 7 64-bit, using Oracle DB 11g R2 for Windows 64-bit. I have Oracle SQL Developer Release 3.0 (4.0.2.15.21) as the GUI for my database. Question I followed the ...
0
votes
1answer
150 views

ORA-12541: TNS: No listener after adding new IPs to machine

We are receiving the ORA-12541 error since we added 2 new IP addresses to the machine. This may or may not be related to the problem at hand, but this is the latest severe change that was made, before ...
0
votes
1answer
29 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 ...
18
votes
11answers
46k views

Eliminate duplicates in ListAgg (Oracle)

Prior to Oracle 11.2 I was using a custom aggregate function to concatenate a column into a row. 11.2 Added the LISTAGG function, so I am trying to use that instead. My problem is that I need to ...
3
votes
2answers
641 views

FileWatcher Troubleshooting Options

I have setup a Credential/Procedure/Program/File Watcher/Job to monitor a folder for new files, but it is not working. I am trying to figure out what I can check to troubleshoot why this isn't ...
0
votes
0answers
18 views

impdp syntax for schema that is not available on other database

My intention is to import the data of schema 'SCOTT'. I have exported it from db1 using expdp scott/tiger schemas=scott dumpfile=scottexp.dmp ...... Now When I try to import the same in database db2 ...
1
vote
1answer
108 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
893 views

Cannot remotely connect to oracle express

I have installed Oracle Express in a oracle-6.5-x64 virtual machine (let's called it host). The installation went fine, I am able to connect and run commands using SQLPlus from the host. Now I'm ...
1
vote
3answers
2k views

Oracle query is slower the second time

I have a general question about something I'm seeing in performance tuning in Oracle. I have a query that I'm testing. It's too big and complex for me to provide a simple example, sorry! (I tried ...
-1
votes
4answers
27k views

How to determine if an Oracle table is locked or not?

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2. Some of these batch reports will try to access a database table which may still be locked. How ...
2
votes
4answers
1k views

Why can't I drop this Oracle datafile - even though it seems empty?

This system is Oracle 11.2.0.3.0, using ASM. We had an issue where there seemed to be a corruption issue of some kind - every time a row tried to get inserted into the table, we'd get the following: ...
1
vote
1answer
129 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. ...
0
votes
0answers
34 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
180 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
2answers
39 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
0answers
37 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 ...
1
vote
2answers
4k 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
112 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
1k views

Oracle Enterprise Manager - Where do I find the error logs?

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: In english: "Internal Error has occurred. Check ...
2
votes
2answers
331 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 ...
0
votes
1answer
57 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
2answers
8k 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
1answer
3k 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 ...
1
vote
2answers
1k views

Rule of thumb: AUTOALLOCATE or UNIFORM size for tablespaces

Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size? Even more, what should apply for ...
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
2answers
194 views

Database is slow once in a while

I am executing a web service for 100 times. The average response time of this service is 1.5 seconds. But when I look at the response time of each execution individually, there are a few executions ...
1
vote
2answers
2k views

Extract Archived Log Files from RMAN Backupset

I have an RMAN backup that is taken on 19th january with: BACKUP DATABASE PLUS ARCHIVELOG command. Now I need to restore Archived logs from that backupset to some other OS directory. Is there any way ...
0
votes
1answer
63 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
2answers
81 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?