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

learn more… | top users | synonyms

1
vote
2answers
51 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. ...
1
vote
1answer
28 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
155 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
1answer
229 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') ...
0
votes
0answers
40 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 ...
1
vote
1answer
128 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 ...
-1
votes
1answer
118 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
158 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 ...
1
vote
2answers
60 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 ...
1
vote
2answers
9k views

ORA-39165 Schema was not found in export

I'm getting the following error on a data pump export: ORA-39165: Schema OFDAT was not found. First I verified that I had full export permission: GRANT EXPORT FULL DATABASE TO OFDAT; Then I ...
0
votes
1answer
59 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
3answers
1k 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 ...
0
votes
1answer
92 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/ ...
0
votes
1answer
69 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 ...
2
votes
2answers
20k views

Where all can the /*+ PARALLEL */ hint be used?

It works with SELECT and UPDATE statements. Are there some more statements with which it works? I was able to use it with create, but am not sure if the hint was actually considered. SQL> create ...
0
votes
2answers
1k 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
1answer
73 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
166 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 ...
1
vote
1answer
10k 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 ...
0
votes
1answer
212 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
27 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 ...
1
vote
2answers
127 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
31 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 ...
0
votes
0answers
350 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 ...
3
votes
4answers
17k 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
249 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
1answer
446 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 ...
2
votes
1answer
1k views

du of directories in a diskgroup in Oracle ASM

In Linux, you could run the below on a directory to find the size of each sub-directory: du -sh * When you're in asmcmdin the +FRA disk group for example, how can I retrieve the size of each ...
0
votes
2answers
533 views

bash: sqlplus: command not found

I have installed oracle correctly and also set ORACLE_HOME correctly on server,still sqlplus command is not working in my PC while it is working in others PC. I think I missed out some important step ...
5
votes
2answers
6k views

Oracle RAC failover not working correctly

I have Oracle 11gR2 set up on a RAC environment with two nodes. I have SCAN set up, eg: I have two entries on the DNS set up so I can ping the SCAN name and reach either node. I can also ping both ...
9
votes
2answers
2k views

Oracle Shutdown Method

Shutting down a database before doing an upgrade or a patch can be done several ways. shutdown immediate; or shutdown abort; startup restrict; shutdown immediate; or shutdown abort; startup ...
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 ...
0
votes
0answers
69 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 ...
2
votes
1answer
3k 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
2answers
328 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
33 views

Reading audit records in Oracle

As a DBA, what is the best way to read the audit records on daily basis? Say, i'm the administrator and I would like to view the audit records made by the DBAs. I have enabled audit sys operatiosn to ...
4
votes
2answers
26k views

How to migrate Oracle database to MySQL server? [closed]

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 ...
1
vote
1answer
402 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 ...
0
votes
1answer
72 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> ...
1
vote
1answer
229 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 ...
0
votes
1answer
78 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
0answers
145 views

TNS Listener started but not working

My listener exists and is started, but when I try to connect to the database it tells me no listener exists. I've tried restarting the listener to no effect. listener.ora SID_LIST_LISTENER = ...
1
vote
3answers
20k 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 ...
3
votes
1answer
143 views

Function Based Index with XPATH extractValue

// Oracle Version 11.2.0.4 Standard Edition // OS RedHat I am trying to create a function index on a large table, based on using an XML object. So I have done stuff such as: CREATE INDEX ...
2
votes
1answer
107 views

Is it possible to copy mounted database without RMAN?

I need to make a copy of production database for development. For some reason I can't use RMAN. My question is: can I copy standby database while its in mounted state and recovery is canceled? Of ...
0
votes
1answer
60 views

Will inserting a row keep it in the buffer cache

I understand that selecting a set of rows from the database will make sure they remain in the buffer cache (assuming they fit). Will inserting a set of rows make sure they are available to select ...
1
vote
1answer
82 views

Oracle: How do I add users to the HTTP ACL in Oracle 11?

How do I add a user to the network ACL (access control list)? When running this code declare req utl_http.req; begin req := utl_http.begin_request('http://example.com'); end; I receive ...
1
vote
1answer
49 views

Join two sql's to return articles and its likes

I am new to Oracle and need help with the following: I am having a sql which returns a list of articles- SELECT LEADERSHIP.LDRSHP_ID , LEADERSHIP.LDRSHP_TITL_DESC , ...
0
votes
0answers
60 views

Strange entry in alert log - Oracle

I'm having a primary database which is a single instance database and it has a standby database running in maximum performance mode. Recently I added standby redo logs in my standby database and after ...
0
votes
0answers
25 views

How can I edit the prediction query to pass the parameters from a GUI?

I have created a data mining in Oracle SQL Developer and I got the the following query using the "Apply" node. I have to use this to predict the values for the class variable when the values for the ...