Oracle Database 11g Release 2. Please also tag oracle for search purposes.

learn more… | top users | synonyms

1
vote
0answers
81 views

Oracle, Cursor_Sharing = Force and Queries with literal comparisons forcing FTS

I have the following scenario: Oracle 11.2.0.3 A 3rd party application, that requires cursor_sharing = TRUE A table (T2310) with a indexed field (C1000000161) that has no duplicated values Result ...
1
vote
3answers
86 views

What procedure can be used to change system statistics in a production environment

System statistics aren't required but highly recommended by Oracle. From my own experience, it produced a huge improvement on the total user IO waits of our production environment when first ...
3
votes
2answers
667 views

Database not able to startup showing control file is inconsistent with another

Our windows server 2008 R2 is shutdown due to power failure. When I am trying to startup Oracle 11g database its shows an error. SQL> startup ORA-01081: cannot start already-running ORACLE - shut ...
0
votes
0answers
59 views

Does RECO always resolve in-doubt transactions ? (Oracle)

I am working on an application which uses a Oracle 11gR2 database in order to fetch and store data. The application is written in C/C++ and some Pro*C, which takes care of everything related to the ...
0
votes
1answer
167 views

Top Activity in OEM reports that dbms_scheduler jobs run as the job_creator user?

The top activity graph in Oracle Enterprise Manager was reporting that certain activity was being performed by certain users at odd hours of the night. Upon researching, this activity was because the ...
0
votes
0answers
40 views

Oracle Enterprise Manager 11g - restricting tablespace access

This may be a complete newbie question but I need help nonetheless. I have an administrator assigned to a default tablespace with his quota set to zero on all other tablespaces yet find that when ...
3
votes
1answer
62 views

Running / Accumulative Sum with Reset - Oracle

I am trying to accumulate a sum, but the sum accumulated cannot be positive. So far i got the following: Select t.caccserno,t.Reportingmonthyear,t.Amount,t.cycleage from temp_UnpaidInterest t ...
0
votes
1answer
221 views

Migrate/Export DB from Oracle 11g Enterprise to Oracle 11g Express

So I'm a DBA newbie and I've got an Oracle Enterprise server running in production with the following information under All Reports -> Data Dictionary Reports -> Version Banner, under "...
0
votes
1answer
68 views

How do I iterate over 1000 records in a particular order

I am writing a procedure to migrate two tables into different tables. This procedure will have two cursors. One to fetch the parent records and then second cursor to fetch the details for each parent ...
0
votes
1answer
237 views

Problem using sample schemas by Oracle in Oracle APEX

I am new to Oracle and Oracle APEX. I have been practicing to make Oracle APEX database application using "hr" schema of the database. Before doing so, I unlocked the schema, along with schemas "scott"...
0
votes
0answers
89 views

Possible cause of ORA-00600 on dbms_xplan.display?

I'm trying to see the execution plan information for queries. I can see some statistics after I set autotrace on. Also, I can check from plan_table. However, most tutorials or blogposts suggest ...
0
votes
3answers
484 views

lsnrctl is not working on Ubuntu 14.04

I have managed to install Oracle 11g on Ubuntu 14.04 through lots of pain. I managed to install it in the end but listener does not seem to be working and even responding any command. My /home/...
0
votes
0answers
40 views

One Listener for two Oracle Versions

I've got an dev machine with Oracle 10 and 11 running (on separate users) So I want to use only one Listener (the new from 11). I deleted the Listener of Oracle10 and created one on Oracle11. After ...
0
votes
1answer
44 views

Is it possible to generate workload for hammerora (hammerdb for oracle) from AWR tables?

I'm trying to generate workload from our production databases but rather than running a trace file in production, I would prefer using the AWR tables since we have a license for it. Is it possible? ...
0
votes
1answer
163 views

Oracle migration unable to create indexes

I want to move the contents of a database instance to another using the expdp and impdp utilities. The source instance is version 12.1.0.1.0 and the destination is 11.2.0.1.0 so I modified the expdp ...
1
vote
2answers
106 views

Testing on Logical Standby Database

Primary DB: 11.2.0.3 Enterprise Standby DB: 12.1.0.2 Enterprise I've found several articles on making changes on a Physical Standby DB, but I've been having difficulty locating how to enable user ...
1
vote
2answers
62 views

Fetching recent/historical queries run on a database from an application

I'm getting some database errors from an application related to unique constraints however none of the records have any duplicate values so I want to check what query was run that produced the error. ...
0
votes
1answer
94 views

ORA-12154 when PLSQL Developer 11 is trying to connect to database

Hi i have troubles when i'm trying to connect my PLSQL Developer to Oracle 11g R2 Express Edition. I created a new folder in c:\Oraclex86, in that folder I installed the oracle 11g R2 Client for x86 ...
0
votes
2answers
615 views

Oracle database patch update doubts

Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1) says the following 4 patches are recommended to be applied to 11.2.0.4 database. Note:21744343.8 Combo of 11.2.0.4.5 OJVM PSU and 11.2....
0
votes
1answer
611 views

How to call an oracle stored procedure in sql developer tool

I have written an Oracle procedure like below: create or replace procedure Sp_emp(cv_results out sys_refcursor) is begin open cv_results for select * from employee; end; / ...
1
vote
1answer
29 views

Find out where length semantics gets changed

I've code to create tables that doesn't specify length semantics: CREATE TABLE CHAR_TEST ( CHAR_TEST_ID NUMBER(*,0) NOT NULL, FOO VARCHAR2(6) NOT NULL, BAR VARCHAR2(6) NOT NULL, ...
2
votes
1answer
266 views

Unable to turn off automatic memory management (AMM)

i am running oracle 11.2.0.4 SE RAC on Red Hat linux 6, the database is using ASM for datafile management i have been experimenting with turning on AMM and set the following parameters alter system ...
0
votes
0answers
45 views

Login as SYSTEM in web console

I've installed Oracle XE 11g on Windows Server. I've set a password for SYS/SYSTEM when prompted, I've opened port 8080 to receive incoming connections and http://example.com:8080/apex loads fine. In ...
0
votes
1answer
602 views

Updating BLOB Columns

I have table blobtable which has a BLOB column blobcol. A user updated the table using a command similar to this: UPDATE BLOBTABLE SET BLOBCOL=BFILENAME('directory/subdirectory', 'filename.txt') ...
1
vote
1answer
202 views

Difference between ASYNC & SYNC real time apply

What is the difference between a data guard (Oracle 11g) operating in max performance ASYNC mode and enabling real time apply and a data guard operating in maximum availability SYNC and enabling real ...
0
votes
1answer
205 views

Backup an Oracle database to NAS

I have an Oracle database (11.2.0.4) on Oracle Linux 6.7. I want to backup this database with rman to a folder on a NAS (network attach storage). How can I do this?
-1
votes
1answer
164 views

ORA-00904: : invalid identifier [closed]

Anyone help me with this error. I'm trying to create a table named "accounts" with 2 columns. CREATE TABLE accounts ( accountno number(10) NULL, accountname varchar2(50) NOT NULL, ); > ORA-00904: ...
1
vote
2answers
208 views

Permissions needed for dbms_metadata.get_ddl in a function

Oracle Enterprise 11.2.0.3 I'm receiving: ORA-31603: object "string of type "string" not found in schema "string" when executing a function that calls dbms_metadata.get_ddl. I know that ...
0
votes
1answer
60 views

Oracle 11g: SQLDeveloper

How would I use the pre-installed SQLDeveloper that comes packaged within Oracle 11g if I am invoking it with a user that has no oracle or admin rights on linux? Would it be enough just to change ...
0
votes
1answer
115 views

Could we delete old database and grid version?

We upgraded rac system and I want to ask, could I delete old grid and database version? [oracle@orcl1 app]$ cd 11.2.0.3/ 12.1.0.2/ Middleware/ oraInventory/ 11.2.0.4/ grid/ ...
1
vote
2answers
62 views

Add standby database on different OS version?

Primary database is installed on RHEL 6.1. Standby database software is installed on RHEL 7.0. I am trying to add new standby database by using Grid Control. Database versions are same 11.0.2.0.3. I ...
4
votes
2answers
2k views

Archive Logs filling up Flash Recovery Area (FRA) space

I got hired to fill a position of DBA that I wasn't quite ready to fill, and while the training is getting me there, I am running close to a potential issue. My oracle 11g database's Flash Recovery ...
0
votes
1answer
85 views

Fill a GTT with external data each session

I have to import an external csv file into a table in database each day. The file is encoded in 'UCS2-LE BOM'. I have found a solution using external tables and bulk insertion, but the problem is to ...
0
votes
0answers
206 views

Cannot log in sys as sysdba to Oracle 11g SQL*Plus with full ezconnect string

I am having problems with SQL*Plus on my RAC One ODA. I cannot use a full connect string to log in to any database (there are three on two separate ODAs) with sys as sysdba. I can duplicate this ...
0
votes
1answer
274 views

what is oracle shiphome?

I am trying to install oracle grid, One of the Oracle installation steps says, set the variable ORA_SHIPS to the path location where you are going to extract the 11.2.0.4 shiphomes Please ...
0
votes
1answer
30 views

how i can extract a table data to a binary file

I´m new in oracle, i try to get data from a table of oracle and I only find how to extract to a csv, i want to know if someone knows how to extract in a binary file, im already try with sql developer ...
0
votes
1answer
81 views

How to find current setting of “FORCE PARALLEL QUERY” in Oracle

I can change (override) the current level of parallelism in an Oracle session using e.g.: alter session force parallel query parallel 6; Is there any system view of function that will return me the ...
0
votes
0answers
34 views

Minimum Oracle table size making IOT advisable?

I have inherited an IOT that doesn't seem to merit it because: only 25k rows fairly pure join table, non-index fields rarely queried total index width only ~125 bytes total row width only ~160 bytes ...
1
vote
2answers
152 views

Automate - recover database using backup controfile

I am trying to automate a periodic clone of a database from one environment into another changing the database name. I have done this many times manually by doing a begin/end backup on the source ...
0
votes
0answers
457 views

Extremely slow datapump imports from 10.2.0.1.0 -> 11.2.0.1.0

All imports/exports talked about here are using datapump, the 10.1.5 system is running on Windows Server 2003 and the 11.2 system is running on Linux. I have an 11gig datapump dumpfile from a 10.1.5 ...
0
votes
1answer
742 views

how to call a stored procedure in Oracle Scheduler job

i want to call a stored procedure in Oracle Scheduler job, my procedure and job like below ----stored procedure create or replace PROCEDURE emp_test IS begin delete from emp; insert into emp(...
0
votes
1answer
371 views

impdp schema name not found

I have Oracle Database 11.2.0.4 . I want to import a dump file to it with impdp . The Dump file is for a "Popualtion" schema . the schemas name is case sensitive. How can i import this file to ...
0
votes
1answer
304 views

Updating row of one table using rows of another table based on specific conditions

I want to update OFFICE_ID,OFFICE_TYPE of FA_SUBLEDGER_MST table, by using OFFICE_ID,OFFICE_TYPE from EMPLOYEE_MST table based on following conditions: EMPLOYEE_MST.SL_CODE = FA_SUBLEDGER_MST.SL_CODE ...
0
votes
0answers
18 views

Managing The Change of Records In Tables

I have Oracle 11.2.0.4 . I have some tables like person that have information about persons , person-death that have information about death of persons and etc . Some of tables in my database have 4,...
0
votes
0answers
80 views

Is it good to gather stats in Oracle?

I have a very new database, and I have a request to gather stats for some schemas.. is it okay to gather stats without any transactions processed in the database? What are the impacts it could have if ...
1
vote
2answers
453 views

How to erase in sqlplus with backspace?

Using SQL*PLUS, I cannot use the backspace button to erase content during a line command. When I hit backspace, instead of erasing it writes ^H Is there a way to configure backspace so it works as ...
0
votes
1answer
93 views

Want to remove global_name from DB links (Oracle 11g)

I am trying to call remote function via DB LINKS. However, My global name contains the string ON and I believe it causes an error. The Error I have is ... SQL> var tmp varchar2(2); SQL> ...
0
votes
1answer
97 views

Need to clean up my Oracle database

Requirement is that I need to clean up my database in which my application has extensively tested on, and now I will have to clean up the data and have a database which will be ready to go live. By ...
1
vote
1answer
261 views

SQLPlus “no listener” only with a remote connection from Windows

The Oracle database is running on a linux server. The lsnrctl service is running. Locally, I can connect to database from sqlplus and sql developer. Remotely, from windows, I can't connect. sqlplus on ...
1
vote
1answer
524 views

Export Data Pump skipped packages bodies

I've got a BASH script for exporting from our Oracle 10G database. #!/bin/bash #This script should be run with the Oracle account. It exports the necessary files from the database for creating a ...