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

Configuring Listener on Oracle Server

I am very much new to Oracle environment. I was trying to connect to my Oracle server from another machine on the same network. I found out that I need to configure Oracle Listener on the server that ...
0
votes
0answers
13 views

Using Database Replay between AIX/Power7 and Linux/Intel - Potential Issues? [on hold]

I'm planning to do a DB migration from AIX+P7 to Linux+Intel. We want to do a performance analysis between the platforms. However the database is massive, and before we commit to procuring the ...
0
votes
1answer
39 views

How do I find gaps between ranges of numbers?

Consider the following table: T_ID | T_START | T_END -----+---------+------ 1 | 0.25 | 0.5 2 | 0.8 | 1 3 | 0.4 | 0.6 4 | 0.2 | 0.3 5 | 0.7 | 0.8 T_ID is unique. ...
0
votes
1answer
76 views

Rows to columns

I am new to Oracle. I know MySQL. I wrote below query in MySQL: Tables: CREATE TABLE Ass ( asset_id BIGINT(20) NOT NULL, caption VARCHAR(64) DEFAULT NULL, description VARCHAR(4000) DEFAULT ...
3
votes
3answers
71 views

Why does the CBO eliminate `distinct` and not `group by` in this query?

The CBO chooses to eliminate the distinct in the 'slow' query - presumably it can tell that the operation isn't needed because of the outer group by. My questions are: 1) Why does it choose to do so ...
0
votes
2answers
117 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
2answers
47 views

How to block external connections for an Oracle database?

I have an oracle database (11g-r2) on my (windows) computer for development, and I am trying to forbid any outside connections. Is there a way to do this?
0
votes
2answers
33 views

Install JVM for Oracle 11g XE

I am trying to configure JavaMail in my Oracle 11g XE(11.2.0.2.0) database, which requires loadjava utility. But after some research I came to know that XE version of Oracle doesn't provide Java/JVM ...
0
votes
1answer
27 views

Oracle Equivalent of the following SQL Server syntax

I'm looking for the Oracle equivalent of the following SQL Server syntax: select Cast(0x41424344 as varchar(max)) In SQL Server, it selects 'ABCD'. 0x41424344 is the hex of 'ABCD'
0
votes
3answers
143 views

Replacing the results of a row

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...
0
votes
1answer
19 views

Backup files not found in ASM

I have an Oracle database 11gr2 and I have installed Oracle Grid on Oracle Linux 5.9. I have two disk groups. /etc/init.d/oracleasm listdisks : flash_recovery_area DATA The first disk group is ...
0
votes
1answer
24 views

RMAN restore from tag

oracle 11.2.0.4 on redhat 6 SERV1 is prod server running database MAZ, SERV2 is developemt server with no databases on it. i have noted the dbid and last SCN, and then taken a backup on SERV1 using ...
0
votes
0answers
34 views

Out of memory error from Java stored procedure

I have a Java stored procedure inside Oracle 11g database. The procedure uses lots of memory, so I'm setting the max memory size in same session: create or replace function setMaxMemorySize(num ...
1
vote
2answers
1k views

Using transactions in sqlplus

I'm coming to oracle from postgresql. In postgresql, I can use the command-line tool, psql, to execute a delete or update in a transaction: dbpool.production=> begin; BEGIN ...
3
votes
2answers
681 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 ...
2
votes
1answer
21k views

Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server

I installed 11g on Centos VM on my mac.I have everything up and working on server.I have included following command I ran on cenos. $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production ...
0
votes
0answers
40 views

Is there a way to check which views have data? Oracle 11g

I'm undergoing a cleanup process for a data mart design. However, I want to get rid of any views (in the design) which result in having 1 or less rows of data. Instead of manually going through ...
-3
votes
0answers
18 views

Can't log in to oracle 11g R2 dbconsole [closed]

I have install oracle 11g release2 and configured environment variable and listener correctly. When i create instance using DBCA, show this error at end of create instance. Once click ok, ...
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 ...
-2
votes
0answers
20 views

Can't open oracle 11g admin page [closed]

I was installing Oracle 11g r2 on Windows Server 2008, but received an error when creating instance. ( https://drive.google.com/file/d/0B_sjxK048-u8MzZ5TnE0U3J4NHc/view?usp=sharing ) Ignore error ...
0
votes
2answers
223 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
1answer
130 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 ...
1
vote
0answers
45 views

SELECT stuck giving results from the query result cache, though table has changed

A process that runs every two minutes or so started to misbehave. We noticed it was because the cursor fetched repeatedly 0 rows, even if indeed there were new rows satisfying the conditions in the ...
2
votes
2answers
409 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 ...
1
vote
1answer
1k views

ORA-12516 but max_utilization not reaching limit

Our app began to raise ORA-12516, TNS:listener could not find available handler with matching protocol stack errors, and I'm trying to diagnose why. The workload has not changed, so I think we might ...
0
votes
2answers
53 views

ORA-00600 argument description

I am experiencing several ORA-00600 error events, presumably during exceptionally high I/O. Does anyone know where I can lookup the meaning of the following arguments for ktspfmdb:objdchk_kcbnew_3? ...
0
votes
1answer
49 views

Oracle 11gR2 RAC unable to connect to SCAN address [closed]

I'm having a problem with my RAC environment. I am using RedHat 6, Oracle 11.2.0.4 SE. Have a 2 node RAC setup using ASM. When connecting using SQL Developer, i can connect to my service ...
0
votes
1answer
34 views

Oracle RAC, unable to connect to node vip [closed]

I have a new oracle RAC installation running 11.2.0.4 on redhat 6. I can connect to sqlplus from a client using the node name but it is timing out when i use the node vip eg. first one works, second ...
0
votes
1answer
18 views

Unable to configure oracle 11g net server

I installed Oracle 11g on my Windows Server 2008 workstation. After I try to configure oracle net server with port number 1521. But ONS error say to me as "Use another port number. This port is ...
0
votes
2answers
7k views

Oracleasm deletedisk failed Unable to clear disk

I have dropped the disk from ASM diskgroup: > ALTER DISKGROUP DATA01 DROP DISK DISK1; Oracle did a rebalance operation and then dropped the disk. Now, I want to delete the disk from ASM library ...
2
votes
4answers
2k 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: ...
0
votes
1answer
4k 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
1answer
185 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
1answer
330 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 ...
5
votes
1answer
1k views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
1
vote
1answer
45 views

2 Different Oracle DB Version on same server

Is it possible to install and run 2 different oracle version(11g and 12c)software and db on same server? is it possible then how we can? and if not then why? Thanks Rahul Joshi
0
votes
2answers
10k 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
2k 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 ...
0
votes
1answer
534 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
1answer
918 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
37 views

How to create oracle user for more than one version

I have server under RHEL 6.3 installed on that server Oracle 11gr2 and 12c, I want to create user lets say Ahmad but I want this user to be sysdba on both servers, for single server I edit ...
0
votes
2answers
38 views

Is using ASM a pre-requisite for RAC?

I am about to build our first RAC development environment, and as I'm new to RAC and have not used ASM I wanted to keep things as simple as possible. I was under the impression that ASM is a ...
0
votes
1answer
32 views

LOAD DATA statement not working in Oracle SQL Developer

When I run the statement: LOAD DATA LOCAL INFILE 'C:/path/date.txt' INTO TABLE dimdate FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (date_id, yyyymmdd, fulldate, weekofyear, month, quarter, ...
1
vote
1answer
142 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). ...
2
votes
2answers
898 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
2k 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>> ...
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
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 ...
-1
votes
0answers
15 views

how can you determine the exact time for a daily Scheduled Jobs on Oracle

i have a daily scheduled job, how can you determine the exact time it will run on the scheduled day?
0
votes
2answers
181 views

Set Oracle Home (install Oracle Home) for Toad 12.6

I had Toad 11.5 and I'm trying to install Toad 12.6, to connect to Oracle 11g on a 64-bit Windows 7 machine. No matter what I try, when I start Toad 12.6, I get the error: "No valid Oracle clients ...