Oracle 11g is the July 11th, 2007 release of Oracle’s primary database product. New features added in 11.0.1 include Virtual Columns, Automatic Memory Management and Interval Partitioning.

learn more… | top users | synonyms

1
vote
1answer
4k views

Oracle server connection reset by peer socket write error

Full disclosure, I'm not a database admin, but if anyone is able to help me, it would be you guys. Our Oracle 11g database server stopped working, I'm not aware of anything that could have caused it, ...
1
vote
1answer
2k views

Oracle 11G Can't create database from template

I am attempting to create a new database from an existing template in Oracle 11G. I have done this before using dbca and haven't had a problem, but now I am hitting the following error: TNS-04404: no ...
3
votes
3answers
3k views

cursor: pin S wait on X in 11g

This has been one of top5 wait events in our database, even though there were not many waits but we see it as a potential threat, we want to find the root cause and solution. Any advice will be ...
4
votes
1answer
14k views

temporary table inside procedure oracle

I'm in a situation right now. I'm migrating several procedures from Mysql 5.0 to Oracle 11g. Mysql procedures allow me to: 1. Create temporary tables 2. Insert data into temporary tables / Query these ...
3
votes
1answer
236 views

Use a Context namespace in a multi-tenant database?

I'm developing an Apex application that uses database Contexts in conjunction with Row Level Security. I'd like to install a second copy of the schema and workspace on the same instance; this works ...
2
votes
1answer
58 views

Transaction stays in capture queue

I set up simple bidirectional db replication using Oracle Streams. I used enterprise manager for this. Streams are active and their status is ok. The problem is that the replication is very slow. What ...
4
votes
2answers
2k views

Where can I find autoextend events?

In Oracle, where can I see the history of DBFs autoextending? Or get the timestamp that a DBF last autoextended, and by how much?
0
votes
4answers
6k views

What's a good client tool to access Oracle RDBMS? [closed]

I'm looking for a good client tool to replace "Oracle SQL Developer" (the tool I currently use) which supports: Oracle DB 10g, 10gR2, 11g Running SQL code Debugging SQL code (with walk-through... ...
1
vote
0answers
284 views

PeopleSoft or Oracle App Designer Tool Alternative

We are using PeopleSoft app designer tool to manage and create projects, database objects - tables, columns, views etc in Oracle database. This tool has limitation that we cannot create tables/columns ...
6
votes
3answers
3k views

ALTER SYSTEM DISCONNECT SESSION doesn't work

Oracle 11g. The devs leave sessions connected overnight, sometimes certain cron jobs fail because of that. I am trying to kill all user sessions, but I can't. I login as: sqlplus system/[password] ...
3
votes
2answers
2k views

How to return a CTE as REFCURSOR from an Oracle stored procedure?

I tried to modify an Oracle stored procedure to use a CTE instead of a simple Select Statement. My procedure looked like this: Create or replace Myproc ( MyRefCursor IN OUT SYS_REFCURSOR) as begin ...
1
vote
1answer
4k views

Delete Archive log file

I am using oracle database 11g. Some day's back we have deleted our Archivelog Manually, and now it's getting full and due to that we are not able to connect to our database. So how should i delete ...
0
votes
1answer
7k views

db_recovery_file_dest_size issue

RMAN gives me this error how should i resolve this issue: ORA-19815: WARNING: db_recovery_file_dest_size of 7516192768 bytes is 100.00 used, and has 0 remaining bytes available. Thanks in ...
2
votes
1answer
233 views

Generating an arithmetic sequence

I would like to generate a named table in a WITH clause which will contain this arithmetic progression: ╔══════════╗ ║ mynumber ║ ╠══════════╣ ║ 0 ║ ║ 30 ║ ║ 60 ║ ║ 90 ║ ║ ...
0
votes
1answer
7k views

check listener status other than 1521

I have two listner: one is running on port 1521 another on 1531. lsnrctl stat show's status of services running on port 1521 only. How should i check whether the services running on port 1531 is ...
3
votes
2answers
3k views

Oracle 11g setup closes without errors on pre-requisite check

I'm installing Oracle 11g and the setup wizard just closes automatically after the pre-requisite check. I have administrative access UAC is disabled IPv6 is diabled There is more than enough free ...
2
votes
1answer
5k views

After truncating a single partition its Primary key's index becomes unusable and all inserts/updates into that partition fail

I have a partitioned table: SAMPLE_PARTITIONED_TBL with 60 partitions (no sub-paritions) based on the PERIOD_ID numeric field (Data set: 201001...201212.. and so on). This table has several local ...
2
votes
2answers
239 views

Support ticket system - when/how to move old tickets?

I don't have access to the partitioning feature, but consider a support ticket system with tens of thousands of tickets being opened everyday and taking about a week to a couple of months in getting ...
0
votes
2answers
729 views

Oracle dump import

After a system failure I bought a new server and now I'm trying to recreate the Oracle database I had. I have a dump file which was made with the command exp and full=y. Can I restore the full ...
4
votes
2answers
2k views

Hibernate Query Running Slow

I am currently facing a problem with a slow running Hibernate query that is being kicked off from a Java program. It is making a call to Oracle 11g at the back end. This query is taking anything from ...
2
votes
1answer
3k views

Oracle error “too many values”, must be solved with nested SELECTs

I have hit upon a "too many values" error in Oracle, when working with some intricate nested SELECTs. A simplified description of my problem, on a toy problem describing the hierarchy in a company. ...
3
votes
2answers
9k views

sqlnet.ora or tnsnames.ora changes require reboot?

Anytime you change Oracle's sqlnet.ora or tnsnames.ora files, does the system require a reboot? In my instance, I only have the Oracle client installed on the machine I'm referring to, but out of ...
10
votes
1answer
2k views

Commit vs Fast Commit vs Commit Cleanout in Oracle Database

I was wondering whether someone could verify my understanding regarding the differences between those 3 terms as pertaining to Oracle Databases. Many sources confuse these terms and do not explain ...
1
vote
1answer
56 views

Supporting Multiple Oracle Clients

I have an application where the data repository is moving to Oracle 11g. This means we need the new Oracle 11g client on the application server to support the retrieval of their data. Is it ...
2
votes
1answer
1k views

How do I export data from Oracle 11.1 to 10.1?

I have a 11.1 oracle server and I need to export a dump file for a client who has a 10.1 server. While reading the documentation, I figured out I needed the 10.1 Export Utility. I searched the ...
1
vote
3answers
130 views

Query missing one date; only happened today

This should be pretty reproducible I hope. I'm on Oracle 11g. This query, which I use as part of another query, is acting strangely: SELECT TRUNC(SYSDATE - ROWNUM) DATEITEM ...
4
votes
1answer
476 views

How to I interleave logs from two different Oracle tables?

I have two log tables, which are populated from two different PL/SQL packages. It's often useful to keep the data separate, but sometimes I'd like to "interleave" the two tables so I can see what's ...
2
votes
1answer
457 views

How do I connect to Oracle Server without installing Oracle Client on client machines?

I am using Microsoft VB.Net to create a Windows application, and would like some suggestions on how to connect to an Oracle database.
1
vote
1answer
2k views

ORA-12541: TNS:no listener using EXPDP

I need to export an Oracle 11g database to an Oracle 10g instance. I have the command, which I believe is correct: expdp user/pass@192.168.10.8 full=Y VERSION=10.2 directory=m_dump ...
1
vote
0answers
152 views

Port no in Oracle Forms 11G

Which port number to be used in forms 11G Preference-->Runtime--> Application ServerURL Section? I have: 1521-Given at the time of database creation 7003 and 7004-Given at the time of WLS Domain ...
2
votes
2answers
5k views

Troubleshooting Oracle ORA-08103 - object no longer exists

I am getting this error from Oracle intermittently. A trigger is truncating a partition from a partitioned table while a long-running query is running against it. Since I'm truncating a different ...
2
votes
1answer
319 views

ETA: translate Oracle SQL queries to MySQL

task: replace Oracle 11g with MySQL current setup: Oracle 11g SE One about 80 tables stored procedures, PL/SQL are in place but out of scope for this question client applications do not use a ...
1
vote
1answer
435 views

Help with getters & setters in PL/SQL

I am not a db guy, and I have a very beginner's knowledge bout PL/SQL. That being clear now the question: I have 2 tables one file level & another batch level. In a day, only 1 file_id is ...
1
vote
1answer
490 views

Oracle out-of-place upgrade on same host: impdp issues

I am testing an out-of-place Oracle upgrade from 11.2.0.2 to 11.2.0.3 on the same host. From what I've read, expdp and impdp is the way to go. My problem is that since I am importing to another ...
-4
votes
1answer
4k views

primary key, foreign key relationship between the department and employee tables How do I install? (sql_developer) [closed]

EMPLOYEES TABLE COLUMN NAMES: EMPLOYEE_ID EMPLOYEE_NAME EMPLOYEE_LASTNAME JOB EMPLOYEE_BUSINESS_PHONE EMPLOYEE_GSM SALARY HIRE_DATE E_MAIL DEPARTMAN_NO NOTE:FOR THIS TABLE: EMPLOYEE_ID IS PRIMARY ...
1
vote
2answers
2k views

Oracle - capture row commit order in a table

Is there a way to capture the order in which rows get committed in a table ? Our application has clients that query the table based on a sequence_id column of the table, that is supposed to reflect ...
0
votes
1answer
313 views

How to troubleshoot/debug Oracle permission problems

An application is connecting to Oracle to do stuff. It's not working but I don't get any ORA errors in the application itself. I'm thinking its a permission problem. So my question is what is the best ...
0
votes
1answer
81 views

Can you search using an index while indexes are being updated in oracle11g?

I am using oracle 11g. I noticed some performance problems that causes hanging on some search operations. Can I still search based on an index while that index is being updated in the database?
1
vote
0answers
178 views

Oracle ASM failover strategies

I inherited a production system with the following setup: Disk A, Failgroup AB Disk B, Failgroup AB Disk C, Failgroup CD Disk D, Failgroup CD Diskgroups AB and CD are configured with normal ...
4
votes
2answers
561 views

Migrating to Oracle Flashback for Historization on Oracle 11g

Our application built using Oracle 11g requires that we keep historic data. The historization is legally mandated, and is mainly used for manual queries, when investigating problems, etc. Basically ...
1
vote
1answer
798 views

Oracle Client vs Oracle Instant Client on Linux!

to have the following setup on a Linux box: SQLPlus client library (oci.dll)!!!! ORACLE_HOME is set for users is Oracle Instant Client enough or I need to have the Oracle Client installed on the ...
4
votes
2answers
11k views

ORA-01502: index or partition of such index is in usable state problem

I have a table in my Oracle database, where select pkcol, count(*) from myTable group by pkcol having count(*) > 1; yields PKCOL COUNT(*) ------- ---------- 1 2 2 ...
3
votes
1answer
867 views

SOA + Fusion + Weblogic + Oracle 11g - STUCK threads

This is sort of a last-ditch effort. We have Oracle SOA on Fusion, 11.1.1.5.0 (+ patches on a separate server) running, and nearing the point where we're taking it into production. I've posted on ...
3
votes
2answers
8k views

Oracle 11g SYSDBA login

I installed Oracle 11g on my win xp machine. Now I want to connect to the database. I was told that to connect to the database from command prompt I should use SQLPLUS "/ AS SYSDBA". But I want to ...
2
votes
1answer
738 views

Alter in PL SQL Loop

I just started learning PL/SQL an hour ago... I'm trying to set profile settings dynamically... I select distinct profile names from dba_users and I'm trying to run an alter profile command for each ...
0
votes
1answer
4k views

Oracle SQL for left outer join to rownum = 1 of another query?

Background I have a query joining many tables together, the chief of which is a workorder table. I also have a table called WOStatusHistory, which stores every status for every workorder. A diagram ...
1
vote
1answer
1k views

How do you monitor specific SQL statement of a specific user ?

We have a few standalone users here which cause high server loads for several 11.1.0.7 Oracle's. I spoke with them a few times but it seems that their queries are causing high loads and probably ...
4
votes
1answer
1k views

How to use the METHOD_OPT parameter in DBMS_STATS.gather_table_stats

Hi there I was just wondering what would be the difference between these 2 METHOD_OPT parameter settings: FOR COLUMNS SIZE 5 some_column and FOR COLUMNS some_column SIZE 5 both will create a ...
3
votes
1answer
2k views

Oracle11g password expiry issue

I have a user which has a default profile in oracle db. I want to reproduce the following warning ERROR: ORA-28002: the password will expire within X days In dba_profile I set following values. ...
1
vote
1answer
953 views

In Oracle, what grants do I need as a non-schema user to view rows in all_objects?

I have two instances of an oracle 11g database, both have the same object definitions in the schema: tables with indexes and constraints, a sequence, and a stored procedure. The facts of the case: ...