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

My SQLs are taking too long to execute for first time everyday in Oracle 11g [duplicate]

whenever I make a new request in my application it takes to long to respond for the first time and all the subsequent requests are faster. If I do it again after some hours or tomorrow again it takes ...
0
votes
0answers
39 views

How to backup the database before partitioning (RANGE) 100 GB database?

I want to carry out the partitioning activity. I am using oracle 11g R2. In case of error occurs while partitioning I might loose the data. On safer side I want to take backup of the database and if ...
0
votes
1answer
1k views

Oracle 11gR2 IMP Won't Import Table in Dump File From 10g

I've got a screwy problem using imp on an Oracle 11gR2 instance to try and import export files created with exp on an Oracle 10g instance (different hardware, if that matters). I've read through the ...
0
votes
0answers
71 views

Oracle APEX Button creating ORA-00920

I have a table for user registration with a column for account_status which I filled with the content from SYS.dba_users. I also have a APEX application for this table and some other stuff and want to ...
1
vote
1answer
298 views

Oracle 11g database structural change doesn't autobackup controlfile/spfile

I have configured controlfile autobackup: CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/backup/%F'; Then added a test tablesapce into ...
1
vote
1answer
1k views

Is it possible to query value of SQLNET.EXPIRE_TIME parameter?

Can somebody advice whether it is possible to query for current value of SQLNET.EXPIRE_TIME parameter in Oracle 11 DB? Should select * from v$parameter return value of SQLNET.EXPIRE_TIME (if it ...
0
votes
2answers
5k views

How to migrate Oracle database to MySQL server?

Currently our application is running using Oracle 11g database. We are developing newer version of the application which runs on MySQL cluster. We need to migrate the data from Oracle database to ...
4
votes
1answer
1k views

Materialized view: compilation_error

When executing the following code on the SCOTT schema I receive a compilation_error. What am I doing wrong here? I doesn't even tell me what the error is. SQL> create materialized view dept_emp_mv ...
0
votes
1answer
85 views

Index being ignored by Oracle

I have a table for sensor data, simplified it looks like this: DEVICE_ID NUMBER SENSOR_ID NUMBER DATA_TIME NUMBER DATA_VALUE1 NUMBER The table constains billions of rows and is partitioned by week ...
0
votes
2answers
600 views

Listener Log Oracle 11g R2

I'm using Oracle 11gR2 in RHEL5. Now a days my application, during run time, is showing exception as below. Listener refused the connection with the following error: ORA-12519, TNS:no appropriate ...
1
vote
1answer
366 views

Oracle RMAN substituting variables

I'm playing around with the USING clause in RMAN, but cannot seem to get it to work. Here is my RMAN command: rman target username/password @${RMAN_DIR}/backup.rman using "db1" When I run that ...
0
votes
0answers
134 views

Install 10g XE on 64bit linux

As I know there is only 32bit version of 10g XE, am I right? And the installation file is called "oracle-xe-univ-10.2.0.1-1.0.i386.rpm". I want to install it on Centos 6.4 64bit. But during the ...
0
votes
1answer
3k views

Oracle 11g increasing shared pool size and java pool size

i need to install/configure oracle jvm on 11g. to be able to install same i need to increase the size of shared_pool_size and java_pool_size. i have automatic memory management enabled. my ...
0
votes
0answers
98 views

My transaction's max time is going beyond a minute

I have a transaction called "updatePolicyStatus" whose response time is usually under a 3 seconds for many instances during a peak load. This transaction processes bunch of business rules and fires ...
0
votes
1answer
496 views

Oracle 11g install problem on Ubuntu

I ran the runInstaller script in the root dir of the extracted zip files. After some pages of the graphical installer it sent me to run /tmp/CVU_11.2.0.1.0_macbook/runfixup.sh as root. It gave me ...
0
votes
0answers
285 views

Oracle Installation issue on Oracle Linux 6.4

I am trying to install Oracle 11g(11.2.0.1.0) on Oracle Linux 6.4(Remote Server). I get the following error(s) when Database Configuration Assistant is running ORA-01092: ORACLE instance terminated ...
0
votes
0answers
111 views

Save a dynamic cursor for reuse?

I have a search page where users can select from multiple variables. When the page is submitted to a package in the database a cursor is constructed and opened. a snippet to show what I mean ...
0
votes
1answer
77 views

how to download oracle database to a remote server

I am trying to install Oracle 11g on my client's server. In order to download it to the server, I have followed this : Logged in to www.oracle.com with my client's username/pass from my desktop. ...
1
vote
1answer
317 views

ORACLE file I/O withouth explicit flushing on 10g and 11g

what happens, if I open a file (foo := utl_file.fopen(... ), write multiple times to a file ( utl_file.put_line (foo,bar) ) and close it ( utl_file.fclose(foo) ) without any flushing? Is there a ...
0
votes
1answer
573 views

Audit Trail in Oracle 11gR2

I'm using Oracle 11g R2 on RHEL5. How can I find what is being audited? I want to know what actions (like create, insert, delete, update etc.) are being audited or logged for a user, say scott.
0
votes
1answer
383 views

Oracle Character set identification

In the given export(Normal Export) log file i see following: Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set Is this multi-byte or single byte database char-set. Can you ...
0
votes
0answers
205 views

How to get session parameters changed by the user in Oracle?

Oracle 11.2.0.3 . I need to identify all "alter session" changed for a specific session. There is some v$session_* where I able to get this information? My objective is part of investigation what ...
0
votes
0answers
122 views

My queries are slow under load

I am performing a load test for my application. All my SQL queries which are fired from my application, individually look better and perform fast. The same SQL are becoming bottleneck when they are ...
0
votes
1answer
236 views

Can I use RMAN to backup and restore data in a certain point in time?

I have an Oracle database over which I have full control. What I am doing is performing load testing on our application, which uses Oracle as a database. To do this, I initially set the database up ...
1
vote
2answers
252 views

What is the meaning of “sga_max_size= # internally adjusted”

I used following command to get backup of my spfile. CREATE PFILE='c:/test_init.ora' FROM MEMORY; it has following lines related to memory. memory_max_target=12G memory_target=8G ...
0
votes
0answers
58 views

Managing user priviliges on schema objects

In our database, most of the users have a role X, and role X grants select any table. I want to maintain this privilage for most of the tables, but I do not want some users access some tables in the ...
0
votes
1answer
49 views

object oriented database

I am new to object oriented databases. What is the error in this database schema? It gives error after insertion query and not before that insert into student_table values ( student_detail ...
4
votes
0answers
235 views

Should I group by and then join, or join and then group by?

(oracle's optimizer does the same thing for both approaches when just two tables are involved, thus my question involves three tables) Assume three tables t1, t2 and t3 with a pairwise 1:n ...
0
votes
0answers
303 views

migrate APEX to a new database with newer APEX version?

what is the best approach to migrate an APEX app to a newer version of APEX (4.2.3) on a fresh installed database on a new server? is there any straightforward step by step? I never done that before! ...
0
votes
1answer
1k views

oracle enterperise manager start error

i have oracle database 11GR2 on windows 7 when i want to start enterprise manager , the error in below is shown : Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All ...
1
vote
1answer
642 views

Audit select queries against specified tables by specified users

I have a requirement to audit all SELECT queries (by access) against specified tables by specified users. As far as I can tell, this can't be done with normal auditing; it only supports auditing all ...
0
votes
0answers
30 views

Simultaneous table read in single query in Oracle

Is it possible to set Oracle to read tables simultaneously and don't wait until the first table scan is finished? Example: I'm joining a remote table to a local table. Oracle is reading the remote ...
0
votes
0answers
82 views

ORACLE_HOME is not available

I install Oracle 11GR2 on Cenots 5.9 . i edited bash_profile to correct values for ORACLE_HOME and ORACLE_BASE and etc . But when i want to run SqlPlus , " command not found " is shown . but when i ...
0
votes
1answer
583 views

Install Oracle 11gR2 driver for Node.js 0.10.20

I want to connect Oracle 11gR2 and Node.js 0.10.20. I use this package but I don't understand this part of installation process. Can you explain it to me? # Replace /opt/instantclient_11_2/ with ...
0
votes
2answers
536 views

Trigger needs dbms_alert declared

A trigger has given me the following: ORA-04098: trigger 'adminuser.DB_ERROR_CHANGE_TRIG' is invalid and failed re-validation and this is when working on altering schemas/triggers/etc from an ...
3
votes
1answer
149 views

Oracle Datapump: modify fully qualified objects when cloning a schema

I am confronted with a problem for which I have not found an elegant solution: I need to clone a schema within the same database, so I use datapump's remap_schema import parameter. The problem is ...
-3
votes
1answer
120 views

I am trying to import a file but it gives me exception : ORA-20001: Invalid Operation. while calling a stored procedure, how can i solve this [closed]

I am trying to import a file , but while calling the procedure i get an exception ORA-20001: Invalid Operation. Stored Procedure: begin -- Call the procedure imp_pkg.isinmstimp(cpath => ...
0
votes
0answers
35 views

Is DBCA in Oracle for a single database or the entire system?

I ask this because I was going to create a simple phone list database for learning. But when I used dbca, I was asked did I want to install the sample databases, HR, etc. It also had the default ...
0
votes
1answer
113 views

imp paused mid import

OK, I'm new to Oracle administration but I'm trying to import a previous dump (no pun intended) which was split into two files. The import is happening from an Oracle 9i to 11gR2 on Windows I used ...
2
votes
2answers
212 views

Does RMAN in Oracle only copy the archive logs? What happens to the active redo log in case of failure?

If RMAN copy copies the archived redo logs when they are full, what happens to the current redo log in the event of a failure (hardware failure, etc.)? Isn't there always an active redo log that is ...
1
vote
3answers
5k views

Environment Varible PATH exceeding recommended length solution?

I am attempting to install Oracle Database 11g on a Windows 7 64x laptop. I get all the way to step 5 of 8 and I get a fail on Environment variable path "exceeds recommended length"... I have ...
0
votes
1answer
150 views

Trigger and temp table or materialized view

I'm looking for the better/best solution to compare data in a table before update and after. This can be done with trigger and temp/global temp table or with read only m-view as far as I know. Would ...
1
vote
2answers
124 views

Audit table insert restriction

So I'm trying to create my own audit table for some user management analysis and stumbled across a little problem. I use this trigger CREATE OR REPLACE TRIGGER usr_t_audit_user_alnd AFTER LOGON ...
1
vote
1answer
67 views

recover oracle db from datafile

We have oracle db which unfortunately we did'n make backup and all control files and other files except all data-files are damaged. Is there any solution to recover db from all of these intact ...
2
votes
1answer
108 views

Backing up Oracle home directory while instances are running

Can I take a backup of Oracle home directory (with cp -r) before upgrade while the instances using the home are running or is it required to shutdown instances first? Trace files/alert logs are in ...
0
votes
2answers
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 ...
0
votes
1answer
1k views

Installing Oracle 11gR2 on Oracle Linux 6 - error possibly related to database (unique) name

Installing 11gR2 on Oracle Linux 6.4. System is a desktop used by one developer. It's on DHCP. Hostname is similar to ip-t3400-1547.mydomain.local Please note I have no issues installing this ...
1
vote
1answer
147 views

Enforce a constraint problem

This business model is for a case management database. This is closely modeled on the idea of a file folder representing the phase and a sequential checklist representing the stages. A case consists ...
0
votes
1answer
454 views

SQL output formatting

I want this: "ACCOUNT_ID","MAJOR_VERSION","MINOR_VERSION","COUNTRY","ACCEPTANCE_TIMESTAMP","AGREEMENT_ID" "abcdefgh-1234-5678-ijkl-mnopqrstuvwx","20110901","1","CN","1329574013737","tos" But I get ...
0
votes
1answer
58 views

Is it possible to dynamically retrieve the number of columns in a view in Oracle?

As the title says, is it possible to retrieve the number of columns in a view dynamically? I'm learning Oracle 11gR2 and I'm checking out the V$ views. One of the things I want to do is output them ...