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, ...
0
votes
0answers
8 views
Oracle 11g install on Debian Wheezy does not start
I successfully installed Oracle 11g R2 on my laptop for evaluation, by mixing various sources of documentation. I saw the Oracle daemons after installation.
But I have a few problems :
After a ...
1
vote
1answer
31 views
Data Migration from Oracle to SQL Server [duplicate]
If you need to do a data migration from an Oracle database to SQL server, what approaches and technical solutions are the best practice?
Our database has about 100 million rows and a total of 52 ...
5
votes
0answers
39 views
Sudden increase in log_file_sync waits
I'm on Oracle 11gR2 with a 2 node RAC system. It's shared fiber storage to an EMC Clariion.
Last friday things went bad..fast. All of the sudden processes that normally ran fine for years became ...
1
vote
0answers
46 views
Performance Hit when upgrading to Oracle 11gr2
I am experiencing the same symptoms as noted in this question which was closed and does not have a satisfactory answer.
Original Question
We've recently upgraded from Oracle 10gR2 (10.2.0.4 ) to ...
0
votes
1answer
77 views
Granting privileges to dbms_crypto
I'm trying to grant proper privileges for using DBMS_CRYPTO.
Whenever I call it from package it gives me error:
PLS-00201: identifier 'DBMS_CRYPTO' must be declared
User already has privileges:
...
0
votes
1answer
17 views
Enable Oracle Database options in an existing database
I want to enable Oracle Real Application Testing option in my existing database, but I couldn't find the way to do that using Oracle Universal Installer (OUI) or Database Configuration Assistant ...
0
votes
0answers
49 views
How to clone a database from one environment to a database on another environment?
OS: RHEL
DB: Oracle 11g version 11.1.0.7.0
I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
1
vote
2answers
767 views
“ORA-01950: no privileges on tablespace 'SYSTEM' ” : What error is it?
Earlier I created a user :
SQL>create user suhail identified by password
SQL>User created.
SQL>Grant create session,create table to suhail;
SQL>Grant Succeeded.
but when I login as ...
1
vote
1answer
208 views
Alternative tools to export Oracle database to SQL Server?
I've got an Oracle database that I need to export (schema and data) to SQL Server.
I am trying the Microsoft SQL Server Migration Assistant for Oracle, but it is horribly slow, grossly inefficient ...
1
vote
1answer
46 views
Oracle 11g - what's the most appropriate NLS_SORT parameter to cover all/most European languages?
I'm developing an Oracle-based application which is likely to be used by clients in many different countries (mostly European). I want the program to change its NLS_SORT so that it's case insensitive ...
1
vote
1answer
64 views
grant execute on utl_file to user in Oracle 11g XE
sqlplus connect <sys>/<pwd>
grant execute on utl_file to <user>
connect <user>/<pwd>
DESC utl_file
then i get:
ORA-24372: invalid object for describe
How can I access ...
1
vote
2answers
46 views
How to remove all hidden parameters from Oracle Database
How do I remove all hidden parameters from Oracle Database before upgrading? I'm using the SQL query below. So what do you recommended?
SELECT name,description from SYS.V$PARAMETER WHERE name LIKE ...
15
votes
7answers
4k views
How do you version your Oracle database changes?
I am interested to know what methods other people are using to keep track of changes made to the database including table definition changes, new objects, packages changes, etc. Do you use flat files ...
2
votes
2answers
95 views
Duplicating a Database with RMAN
I would like to duplicate to the same server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database. My database is using SPFILE as shown below.
SQL> SELECT ...
0
votes
1answer
31 views
User with dba privs can't login to APEX, but can from SQL*Plus
I'm using Oracle 11gR2 XE. A user with dba privileges can't log in to the APEX interface, but can from the command line with sqlplus.
I just created user:
CREATE ROLE administrators;
GRANT dba TO ...
0
votes
2answers
461 views
Run Unix command using PL/SQL
Is it possible to run a Unix command using a query in Oracle?
I want to run simple commands (like df -h) using a query.
Is this at all possible or am I wasting my time? I don't want to use a ...
3
votes
2answers
262 views
Shrinking the SYSTEM tablespace in Oracle
Our SYSTEM tablespace grew out of control because of the SYS.AUD$ table.
We have truncated SYS.AUD$ but the datafile is still very big (~30G).
Resize doesn't work because the file contains used data ...
0
votes
0answers
27 views
Duplication Oracle Database to remote host
I have two scenarios.
1 ) Let's say , I have the same file system and same SID on both nodes. I've created any directories necessary for start the duplicate database.
First I used command below.
...
1
vote
1answer
83 views
NLS_TIMESTAMP_FORMAT changing automatically and randomlly
I am using Oracle 11gR2. My nls_timestamp_format is changing randomly from dd-mon-rr to yyyy/mm/dd.
Does anyone have any clue why this is happening?
1
vote
1answer
69 views
Unable to start Oracle Database Server : Get an error as I try to start it
I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop :
but as I click this icon I see this dialog box :
What is it ? How do I ...
0
votes
3answers
72 views
Exporting schema data (tables, permisions) into another schema on same database
I want to take data from one schema schema1 and put it into schema2 this should be quite easy to do but i have searched through the oracle documentation and can't find a way to do it.
0
votes
1answer
40 views
How to purge logs by using Flashback feature in Oracle Database
I’ve configured flash recovery area for Oracle Database. My question is: how can I delete Flashback Database log?or is there any retention policy for that?
2- After I’ve enabled archive log mode and ...
4
votes
2answers
312 views
Return a fully dynamic table from an Oracle function
I'd like to write a function with two IN parameters where the first one is a varchar and the second a list of varchars. Based on these I want to return a table with varying column amounts and names of ...
0
votes
1answer
48 views
Efficient way to perform approximated search?
I have to perform a join between table_a and table_b, using three fields as key being one of them the date of the event, say, both tables have id1, id2 and evnt_time for eache record.
As it happens ...
0
votes
1answer
37 views
How to clean up duplicate objects in SYS/SYSTEM
I have a sql query like below to check duplicate objects in SYS/SYSTEM.
select OBJECT_NAME, OBJECT_TYPE from
DBA_OBJECTS where OBJECT_NAME||OBJECT_TYPE
in (select OBJECT_NAME||OBJECT_TYPE from
...
2
votes
1answer
136 views
Database Link from Oracle 10g on Windows over to MySQL database
Didn't see any answers on this subject so hoping for a miracle! :-)
I've got an Oracle 10g database running on Windows Server 2003 and I'd like to create a database link to an external MySQL database ...
-1
votes
0answers
54 views
Installing Oracle 11g on ubuntu 12.10 [closed]
I am installing Oracle 11g so I can work through practice excerises. I am following the installation walkthrough at link.
In the terminal when I run chown -R oracle:oinstall database
I get Operation ...
0
votes
0answers
42 views
one vs two column index difference when doing JOIN query?
Let`s suppose that alfa,beta and gamma contains milions of rows so we need to create indexes obviously to get optimal performace for this query :
SELECT * FROM alfa
JOIN beta on beta.id = ...
0
votes
1answer
25 views
Dynamic where condition in a stored procedure
I am using Oracle 11g. I am trying to get the table data with this procedure:
CREATE OR REPLACE PROCEDURE test(p_table IN varchar2)
IS
v_sqltxt varchar2(4000);
BEGIN
v_sqltxt:='select count(*) from ...
-9
votes
0answers
44 views
Creating view and traverse [closed]
Creating and traverse by using n Primary Key and n foreign keys and relations? on oracle 11g
1
vote
0answers
38 views
need the most efficient way to handle unique constraint errors
I am looking for the most efficient way to solve this situation:
We are an Oracle shop. I need to load data from one table to another. My source table, which contains 30 million rows, has a person ...
0
votes
1answer
185 views
How to connect to a Database made by Oracle SQL Database?
So I am fairly new at this, so if you could keep that in mind in your answers, it would be much appreciated. I installed Oracle SQL Database on my Windows PC. It came in two zip files. I installed it ...
0
votes
2answers
62 views
How to set Proxy Settings when installing Oracle 11g on Windows 7 Ultimate Edition?
I have downloaded the file - "win32_11gR2_database_1of2.zip" from oracle site.
While installing Oracle 11g, I find this window in the first place:
What to do?
What values should I put on the ...
1
vote
1answer
52 views
Delete shared memory segments left over by an Oracle instance
We're using Oracle Enterprise 11rR2 running on Solaris.
How can I delete/remove allocated shared memory segments using ipcrm?
I'm getting this error:
ORA-01041: internal error. hostdef extension ...
3
votes
2answers
5k views
Using Oracle client to connect to remote database
Although I can do a telnet to remote oracle port I am unable to connect.
I have a following tnsname.ora connecting to oracle database using sql plus:
remoteOracle =
(DESCRIPTION =
(ADDRESS_LIST ...
5
votes
1answer
112 views
What must be in place to validate a XMLTYPE against a schema?
I have a procedure that generates an XMLTYPE and I want to validate it against a schema. The problem is that there seems to be a permissions issue running createSchemaBasedXML because when I run the ...
0
votes
2answers
55 views
Oracle database uses wrong parameter file
When I try to startup my Oracle database I get the following error:
LRM-00109: could not open parameter file '/opt/app/oracle/product/11.2.0/db_1/dbs/initjicdbaex.ora'
The /dbs directory in my ...
1
vote
0answers
158 views
impdp failing with ORA-01031: insufficient privileges
I'm trying to import a dmp file provided by our dba to my dev database. I've been able to export the contents to a SQLFILE and the contents look ok. I tried importing the schema and it kept on failing ...
0
votes
0answers
25 views
What value should oracle.install.db.config.starterdb.memoryLimit be set to in the Oracle response file for a silent installation?
What happens when oracle.install.db.config.starterdb.memoryLimit is not set in the Oracle response file for a silent installation?
I noticed that when recording the response file for a silent Oracle ...
9
votes
2answers
121 views
Why is a “non-single-group group function” allowed in a subselect but not on it's own?
Why does the first query not fail with the same error as the second:
with w as (select 1 product_id, 10 units from dual union all select 2, 5 from dual)
select sum(units) from (select product_id, ...
0
votes
0answers
21 views
file extension of the file types cdump, incident, trace
I need to know the file extension of the file types cdump, incident, trace, alert.
Actually I want to create files of the above types manually using mkfile command.
There are no existing files of ...
0
votes
0answers
108 views
Error AWR Operation failed: CATPROC not valid when creating database with dbca
I have a fresh installation of Oracle 11g enterprise edition on CentOS 6, both 64 bits. I have installed Oracle and so far everything looks fine. I have already added an started a listener. The ...
13
votes
9answers
15k views
Eliminate duplicates in ListAgg (Oracle)
Prior to Oracle 11.2 I was using a custom aggregate function to concatenate a column into a row. 11.2 Added the LISTAGG function, so I am trying to use that instead. My problem is that I need to ...
0
votes
0answers
30 views
Why can't OUI detect system packages when they are already installed?
I am installing Oracle 11g 32bit on Ubuntu Linux and the OUI shows following error message on Prerequisite Checks screen -
This is a prerequisite condition to test whether the package "make-3.80" is ...
0
votes
0answers
64 views
Can't change Oracle sqlnet.ora runtime in the client program?
I am trying to setup Kerberos authentication for my Oracle database and I have a situation where I need to maintain different versions of sqlnet.ora for each kerberos user connection. My application ...
5
votes
2answers
160 views
Defining constraints in `CREATE TABLE` statements
Recently I have been using a Database Abstraction Layer built by a Python web-framework called web2py (click for their DAL syntax). They include the option to include your constraints within the ...
1
vote
0answers
117 views
Registry error while trying to install Oracle 11g on Win 2008 R2
I am new to Oracle and trying to install Oracle database 11g Enterprise Edition on Windows 2008 Server R2 but getting this error all the time...
It gives me error when updating registry key ...
0
votes
1answer
49 views
List partitioning or filtering a non-partitioned table, which incurs lower cost?
Consider a list partitioned table PARTITIONED__SOURCE_TBL on column period, and non-partitioned table SOURCE_TBL also having the same columns. Assume all tables are adequately indexed.
Set 1:
...
1
vote
0answers
188 views
Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant
this is my first time to install Oracle 11g R2 on Linux.
I made all instructions in Oracle documentation.
But in the installation process, the Net Configuration Manager is failed.
I continued the ...
1
vote
1answer
91 views
Specify Server for DBMS_Scheduler Job in Policy Managed RAC
A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test is being run from. I know that with an Admin managed database this could be done by creating a service that ...
