Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...

learn more… | top users | synonyms

0
votes
0answers
612 views

“ORA-19599: block number 1 is corrupt in archived log” while doing active duplication of database

I am attempting for Active database Duplication and facing the ORA-19599 error. Script used and error are below:- duplicate database to reynolds from active database nofilenamecheck spfile set ...
0
votes
0answers
746 views

Oracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00

I'm trying to use data pump to move the database to a different server with this command: impdp dbuser/dbpsw@dbserver directory=data_pump_dir network_link=sourceDB schemas=EMP But I got this error: ...
0
votes
0answers
65 views

Equivalent of old style join with new style

Can someone please help me write the following join expression in new style: Select tb1.col1,tb2.col2 from table1 tb1, table2 tb2 where tb1.col1>=tb2.col2 I know that the equivalent of ...
0
votes
0answers
2k views

'oracle.jdbc.driver.OracleSQLException': ORA-01031: insufficient privileges. (SYS.DBMS_XMLSAVE)

I have this function (written here by someone), placed in the package ENVER.ENCODING_VERIFIER: FUNCTION loadxml_table (p_owner IN VARCHAR2, p_tablename IN VARCHAR2, p_format IN VARCHAR2, p_tmpClob IN ...
0
votes
0answers
509 views

What problems can be caused by dropping a rollback segment manually?

Oracle version: 11.2.0.1 I have the following error: "Transaction recovery: lock conflict caught and ignored" I can't upgrade my database now. I had a RAC. Removed one node, but the undo tablesapce ...
0
votes
0answers
179 views

Installing oracle 9i on windows 7

Is it possible to install oracle 9i on windows 7 32 bit? And where can i download the standalone oracle http server?
0
votes
0answers
155 views

ORA-13901 Object UNDOTBS01 was not found. ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 7

Oracle version is : 11.2.0.1 I have created alerting on every error occurring in database, and in this alert log I've found the following errors ORA-13901: Object UNDOTBS01 was not found. ORA-06512: ...
0
votes
0answers
61 views

“Oneway” Replication from Oracle DB to TimesTen

currently I'm really stuck into a problem and I not able to finde a nice way to realize that. I need a suggestion to replicate from oracle db (some tables) to a TimesTen. A connection is only ...
0
votes
0answers
194 views

Datalink error when executing remote query

This afternoon i was working with an old datalink defined to transfer data from one database to other. It's the first time i've worked with this 'trick'. We use an specific user to work with the ...
0
votes
0answers
1k views

sqlldr: command not found

I have a script which has this command 'sqlldr' which gives me the error sqlldr: command not found when I run this script. I googled and found that people say that this command should be there in my ...
0
votes
0answers
298 views

Multiple Oracle TNS error

I have an Oracle 11gr2 32 bit on windows 2008 32 bit OS 8 gig ram. There is an application running on 6 machines simultaneously that accesses the Database on this Server. I get the below errors in my ...
0
votes
0answers
125 views

Oracle: REGEXP functions hang with “DIRECT PATH READ”

Oracle 10.2.0.5 OS: Solaris Problem: Need to filter a table with REGEXP. Occasionally sessions that execute Regexp on multiple rows hang on if SQL contain like: "where id in (1,3...) or id in ...
0
votes
0answers
53 views

Logical or in oracle PL/SQL

I have this code: declare error1 number; error2 number; error3 number; begin error1 := 1; error2 := 0; error3 := error1 | error2; -- should be error3 = 1 end; But I dont know how to ...
0
votes
0answers
3k views

ORA-03137: TTC protocol internal error

I have 11g 2-node RAC. My alert.log contains several ORA-03137 errors: Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_10679.trc (incident=149362): ORA-03137: TTC protocol ...
0
votes
0answers
2k views

ASM drop disk hangs (STATE DROPPING)

I have added disk into the RAC system by the following way: I have disk /dev/sdh1. Marked it as an ASM disk: --On node 1 oracleasm createdisk DISK7 '/dev/sdh1'; --On node 2 oracleasm ...
0
votes
0answers
887 views

Oracle profile: PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

Let's say I have configured PASSWORD_REUSE_TIME=1 and PASSWORD_REUSE_MAX=5 for Orale user profile. My initial understanding was that it should prevent the user from using the same password until he ...
0
votes
0answers
271 views

ClassNotFoundException when trying to deconfig Oracle Enterprise Manager

The Enterprise Manager for my Oracle 11.2 installation doesn't work anymore as described in How can I change the connection descriptor used by Oracle Enterprise Manager? and I tried to re-configure it ...
0
votes
0answers
1k views

Oracle Transaction recovery: lock conflict caught and ignored

In alert log there are a lot of "Transaction recovery: lock conflict caught and ignored" statements. I've found some information, that this error is caused when there is an active dead transaction. ...
0
votes
0answers
305 views

Execution time vary for the same query

I have a query which looks like this: select * from ORDERDOC, ORDERPOSITION where ORDERDOC.id = ORDERPOSITION.orderId --some other conditions; Execution plan looks like this: 0 SELECT ...
0
votes
0answers
88 views

How Oracle DB maintains client identification

I know in 'dedicated server' mode we have one user process for each client and pool of user process in 'shared server' mode. in either case How oracle maintains the client identification ? Please ...
0
votes
0answers
101 views

dbms_utility.get_dependency give me error “ORDER SIBLINGS BY clause not allowed here” , why?

Oracle 9.2.0.8 running at linux . I'm trying identify the dependencies of one object with the dbms_utility.get_dependency command. But unfortunately it always return the error ORA-30929... I ...
0
votes
0answers
631 views

Oracle EXP Error ORA-12704: character set mismatch

I need to duplicate a Oracle 11g Express Edition database from one computer to another computer. I tried exp sys/password FULL=Y FILE=backup.dump (the idea is to do a imp on the other pc) But it ...
0
votes
0answers
60 views

Advice on DB Changes

Requirement: I'm required to prefix a couple of strings to the existing one. I.e. The current way, the Accounts been recorded in AccountID field looks as "621230093VN00" Under the new format ...
0
votes
0answers
5k views

How to fix error ORA-00322: log is not current copy

I have to submit my project a day after tomorrow. My project is ready but I am having above mentioned error while connecting to Oracle database. I tried the following solution: Enter user-name: sys ...
0
votes
0answers
86 views

Viewing tables and data from a tablespace that was attached from another database

I'm using a database Oracle 11g. I have a DBF file of an old tablespace from a different database that I want to connect to the existing database. I've created a tablespace with REUSE caluse, and it ...
0
votes
0answers
251 views

Error ORA-06550

CREATE OR REPLACE PROCEDURE pro_department_report AS v_did department.deptid%TYPE; v_dname department.dname%TYPE; v_sname student.sname%TYPE; v_count NUMBER(2); v_sdid student.deptid%TYPE; CURSOR ...
0
votes
0answers
99 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 ...
0
votes
0answers
75 views

Query with large number of or'ed predicates on the same column?

At one place we need to query a table to determine whether any records exists that are in a subset of the same table. The columns that are queried are varchar columns containing file-paths, and we ...
0
votes
0answers
182 views

How does tablespace sizing works in Oracle

Let's say I have an input of 20 gigabytes of raw data (text file) which in turn I would into an external table and would then swap partition in order to place them on my database. The question now is ...
0
votes
0answers
96 views

How to grant privileges for a user to create views on specific tables on Oracle SQL?

I just added: GRANT CREATE VIEW TO user1; But it gives user1 access to ALL the tables, I would like them to only have access to the tables where the field X is user1
0
votes
0answers
131 views

Oracle - How can I improve this query?

We have performance problems with some queries. We always use the rank() function to get the latest entries with a status. The question is, how to speed up things. CREATE TABLE PAYMENT ( CLIENT ...
0
votes
0answers
345 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
254 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
113 views

Oracle DBMS_MVIEW.REFRESH debugging output?

Is there any way to see what DBMS_MVIEW.REFRESH is actually doing? I want to investigate partition change tracking (PCT) and verify that it is indeed only updating modified partitions.
0
votes
0answers
495 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
0answers
722 views

FOR loop oracle query with calulation

I have a list of distinct areas, and would like to track statistics for those districts in a SQL statement. I currently have a setup that runs some summary information, but it doesn't include the ...
0
votes
0answers
205 views

After RAM upgrade on 32-bit Oracle server, ORA-04031: unable to allocate x bytes of shared memory

We are in the process of upgrading our Oracle database server at work, from SUSE Linux Enterprise Server 10.4 / Oracle 10g / 4GB RAM (Intel 32-bit) to Scientific Linux 6.4 / Oracle 12c / 8GB RAM ...
0
votes
0answers
1k views

Not able to login in Oracle 11g console using sys/system@SID as sysdba

I am not able to login into Oracle 11g console using administrative account, when I tried it gives me error of wrong username and password. Then I tried from SQL plus, it got logged in without any ...
0
votes
0answers
33 views

Reliability of blobs in MySQL

I'm in the process of migrating an application working with Oracle to MySQL. That application stores data in the form of blobs, which can be pretty big. The Oracle production database is 60 Gb large ...
0
votes
0answers
1k views

Oracle merge query vs correlated update

I have a query which updates a table with data from another table. The current query is written as a correlated update with an exists clause to remove unnecessary rows. The problem is since both of ...
0
votes
0answers
312 views

Oracle prevent CPU usage per process/session

I have an Oracle instance to which several applications from different machines connect (http servers). Normally Oracle CPU usage is ~5-10% even on high server loads. But from time to time, one of ...
0
votes
0answers
86 views

How oracle syncs data across nodes in a cluster

If I have a oracle db server clustered across 2 nodes, it means both nodes have a copy of the whole data, the data is not lying half and half on each node. Now when I make an update using my ...
0
votes
0answers
2k views

Start Oracle 12c enterprise manager in Windows 7

I have installed Oracle 12c in Windows 7. The installation was succesful and the RDBMS and the database that I created are working properly. Then I tried to access to the enterprise manager via web ...
0
votes
0answers
149 views

Efficient, up-to-date way to import an Oracle database into MySql

Here's the situation: I need to automatically merge data from an Oracle and a MySql server into a single, new MySql server. The merging will happen daily, and the resulting server will be hosted on a ...
0
votes
0answers
197 views

Delete backup directories using RMAN

Is there any way RMAN can delete empty backup directories?
0
votes
0answers
358 views

Creating and tuning a materialized view in oracle for use by Cognos BI

I am currently in the middle of a Cognos BI implementation and am having difficulty in tuning a view in order for SQL Server to select its contents for fulfilling the incremental load in a timely ...
0
votes
0answers
111 views

Replicating Excel's CHIDIST function in Oracle 11g

I'm attempting to replicate the functionality of an Excel workbook in Oracle. One of the formulae on the worksheet uses CHIDIST, which "Returns the one-tailed probability of the chi-squared ...
0
votes
0answers
2k views

Oracle 11gR2 DBCA installation failing with TNS Lost contact

I am getting below errors while running DBCA with silent install using response file ORA-12547: TNS:lost contact PRCR-1079 : Failed to start resource ora.ocl.db It's a fresh installation and not ...
0
votes
0answers
411 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 ...
0
votes
0answers
325 views

DBA_SCHEDULER_Job is not giving any result

I have created one procedure that is supposed to trigger on 5th date of every month.for that i have used dba scheduler job.but its not triggering. select job_name,status from dba_scheduler_jobs; ...