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

learn more… | top users | synonyms

0
votes
1answer
81 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
64 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
968 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
72 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
150 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
192 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
25 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
124 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
303 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
231 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
357 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
413 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
65 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
275 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
25k 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
365 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
63 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
208 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
67 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
138 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
134 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
59 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
73 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
48 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
52 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
23 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 ...
1
vote
1answer
897 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
0answers
101 views

Oracle NLS_CHARACTERSET mismatch while import

I have source Dump with NLS_CHARACTERSET WE8MSWIN1252 NLS_NCHAR_CHARACTERSET AL16UTF16 Requires the target database system is with NLS_CHARACTERSET AL32UTF8 NLS_NCHAR_CHARACTERSET ...
0
votes
2answers
328 views

Drop datafile without dropping a tablespace in Oracle 11g

I was trying to take backup of database in Oracle 11g by using RMAN $ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 11 10:14:37 2015 Copyright (c) 1982, ...
0
votes
2answers
127 views

PowerShell script to access Oracle system views [closed]

I am using PowerShell script to access oracle 11g's system views as SELECT COUNT (*) AS COUNT FROM v$session but I keep getting "ORA-00942: table or view does not exist" I have created a user with ...
0
votes
1answer
130 views

Query on Standby redo logs - Oracle

I have a oracle 11g (11.3) database running with two standby databases (at different locations) in Maximum performance mode. The platform is Linux. Log transport parameters are: log_archive_dest_5 ...
1
vote
1answer
968 views

Oracle cannot connect to SQL developer as sys account

I am trying to connect to SQL developer as sys account. It is always giving the error invalid username/password. When I try to connect it through SQLPLUS, it gets connect with any wrong password ...
1
vote
0answers
409 views

PLSQL Compilation error for other users/ [closed]

I created a PL/SQL procedure that queries the database and dumps the result into a CSV file. I am an application developer and I have dba rights to my oracle database. I'm able to compile and run the ...
0
votes
1answer
618 views

Cannot Start Oracle Database after Shutdown

I have install oracle 11.2.0.4 with oracle asm on oracle linux 6.4 and it work correctly . After shutdown abort , i can not start database at all . can any one help me ? SQL*Plus: Release 11.2.0.4.0 ...
1
vote
2answers
608 views

Copy values to another column - ORA-01481: invalid number format model

I want to copy values of col1 NUMBER(13,4) column to another newly added col1_temp VARCHAR2(50). To perform this action I build the following update query: update table1 set col1_temp = to_char(col1, ...
1
vote
2answers
21k views

Inserting data into a table with one value as clob and blob

My table has one clob column and one blob column. I need to insert data into it through insert statements. The length of data to be inserted is more than 4000 chars. When I do export of insert ...
0
votes
1answer
88 views

How do I copy a materialized view to a table?

I have a materialized view. I want to create a copy of it so I can modify some of the data to test a few theories about an issue and its possible solutions. How do I make a copy of this MV as a ...
0
votes
1answer
505 views

How to copy tablespace from one database to another database in Oracle 11g

How to copy tablespace and datafiles from one database to another database in Oracle 11g in same server ?