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
1answer
28 views

What are the OMem and 1Mem columns in the plan output?

The plan output, for example SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR( '' ,NULL,'ALLSTATS LAST')); has the columns OMem and 1Mem. What is their meaning? I could not find any reference or ...
0
votes
0answers
6 views

Fusion Middleware Clone

I am trying to automate the installation of fusion middleware. Can I clone an exisiting fusion middleware installation that is fully functional onto another host and then change various configuration ...
0
votes
2answers
165 views

Unable to mount database: error reading control file

I have an installation of an Oracle XE on Windows 7 (Home Premium). The database worked fine until yesterday when the database could not be started. It reports ORA-01033: oracle initialization or ...
0
votes
1answer
83 views

How to solve “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor” error?

I am trying to create connection with the database for debugging ASP.Net website. Database is 11g Oracle DB... There is no problem when I connect using SQL Developer, however using Visual Studio I get ...
1
vote
1answer
505 views

Exporting from Oracle enterprise edition to standard edition reaches schemas limit

So, I'm trying to export an oracle database(10.2) from EE to SE over a networklink. It all works fine except that I'm hitting a limit. The database has 1335 schemas and it seems that I can't transfers ...
0
votes
1answer
162 views

Toad for Oracle 64-bit : 1603 - Fatal error during installation

I'm trying to install Toad for oracle client, my Toad version is 12.1 for 64 bit system, i have succeeded to install oracle client 12c for 64 bit system, but i have stumbled by a problem when ...
0
votes
2answers
1k views

ORA-00227: corrupt block detected in control file

I am getting the following error while starting the sqlplus (I am using Oracle XE 11.2.0) ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 0 Serial number: 0 So, I ...
3
votes
1answer
140 views

Can I use Oracle Standard or Enterprise edition for my own training purposes?

Question is about Oracle licensing terms. I would like to learn more about Oracle Database administration. Unfortunatelly I am using 32 bit verison of LInux, so I can't install Oracle 11 XE (I can't ...
7
votes
1answer
355 views

Designing Simple Schema for Disaggregation of Demand Forecast

I am doing a simple database design task as a training exercise where I have to come up with a basic schema design for the following case: I have a parent-child hierarchy of products (example, Raw ...
0
votes
1answer
190 views

How to install ROracle on Linux

I am trying to install the ROracle library. This fails: install.packages("/storage/Downloads/ROracle_1.1-11.tar.gz", repos = NULL, type = "source") ** package ‘ROracle’ successfully unpacked and MD5 ...
0
votes
3answers
88 views

Replacing the results of a row

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...
1
vote
1answer
34 views

MySQL created_by or updated_last-by [closed]

I've been giving the task of taking SQL DDL from data modeler and to transcribe it into mySQL for an internship. The only thing I cannot figure out is how to take Created_By VARCHAR2(30) DEFAULT ...
0
votes
1answer
71 views

Update table from different table

UPDATE RBI.RBI_OV_F_DETAIL A SET (BRANCH_ID, BRANCH_NUMBER) = ( SELECT PRICE_BRANCH_ID, PRICE_BRANCH FROM RSE.RSE_SO_F_ORDERS B WHERE A.SOURCE_ID = ...
1
vote
2answers
166 views

Recovery from datafiles

Thanks to the recent weather/floods, we lost many of our servers. This included our central database server as well as the server that holds our backups. The database server was running Oracle 12c ...
0
votes
1answer
204 views

Unable to create Central Inventory

I am Traying to install Oracle 11g on my Linux a have alrady config the varible and X-host but can,t able to Create Central Inventory my Central Inventory location is : /u01/app/u0 ** and ...
2
votes
2answers
104 views

How to convert html entities in Oracle?

I'm trying to decode html containing html entities. I've tried dbms_xmlgen.convert and utl_i18n.unescape_reference but the results are less than satisfactory. SET ESCAPE ON; SELECT ...
1
vote
2answers
140 views

Does Active Data Guard include Golden Gate?

I've been told that Active Data Guard incorporates Golden Gate as part of its technology stack. Is Golden Gate usable directly from the Active Data Guard installation?
0
votes
1answer
209 views

FAST REFRESH ON COMMIT on Materialized view

I am trying to implement a materialized view which would Fast refresh on commit. I have created materialized view logs on base table as well but i am faced with the following error. ORA-12052: cannot ...
0
votes
1answer
254 views

Queries hang when accessing Oracle via ODBC and Python

I have Python scripts running on a Windows 2003 server that access an Oracle 11g database in the US via VPN. I am in the UK. We have recently moved offices and upgraded our broadband speed. Some of ...
0
votes
1answer
143 views

ORA : 12519 No appropriate Service Handler

Sorry if my question has already been asked many times but I spent two days trying to solve it. I have a machine in which I had an Oracle database. Everything was working propertly until I added two ...
2
votes
0answers
112 views

Failed to drop column - value too large

I'm trying to remove column from DB and got a strange error: Error starting at line 147 in command: alter table config drop column dte Error report: SQL Error: ORA-12899: value ...
1
vote
1answer
54 views

Check if an index exists by comparing columns

We are currently using ALL_IND_COLUMNS to check if an index exists by its name or the columns it is using. The problem is that we can only check if the index exists with columns in a specific order. ...
0
votes
1answer
39 views

Toad 9.7.2 for Oracle hangs on Windows 7

I am using Toad 9.7.2 on Windows 7 64 bit. It is generally working fine but there is one problem. When I click on certain tables in "Schema Browser" and then click on "Data" tab to see records in ...
4
votes
1answer
402 views

Is Oracle's dbms_utility.get_hash_value algorithm documented do reverse engineered anywhere?

I'm working with an existing database where passwords are hashed like this: DBMS_UTILITY.GET_HASH_VALUE(the_username || the_password, 1000000000, 1073741824) I know that this is bad for various ...
1
vote
1answer
67 views

Type with nested table in oracle

I want to create a type with a nested table. I have a table called assignment_tbl which I want to put a type assignment_status. This assignment_status contains primitive types but also contains a ...
0
votes
1answer
48 views

Why do I get ORA-27102 ON WINDOWS 64 BIT if I increase the memory to 2.5GB

BANNER Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for 64-bit Windows: ...
1
vote
2answers
5k views

exporting oracle tables on command line as sql files

I use exp and expdp to export database tables on command line but it generates binary .dmp files. I want to export/import tables as .sql* files on command line like pl/sql developer app can do. Is ...
1
vote
1answer
30 views

Error while duplicating Oracle database after failover, using 11.2.0.4

I've recently updated oracle from version 11.2.0.1 to 11.2.0.4 and my redundant system is no longer able to recover from failover. I'm using scripts both on primary and standby node to get back to a ...
1
vote
2answers
59 views

Can install a test machine with Oracle 11G R2, not express edition, on a VirtualBox?

Im starting like a Oracle DBA, and I want play with the database and your administration task in a test enviroment. I have a macbook pro i5, and had thought install on it oracle under virtual box ...
0
votes
0answers
580 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: ...
1
vote
1answer
454 views

How to write a procedure /job to kill all session running for more than 5mins in Oracle?

How to write a procedure /job to kill all session running for more than 5mins in Oracle? So, I query v$session and find out that for a particular user, program pair if the session has been active for ...
1
vote
3answers
6k views

I killed a session and it is still running?

I have Oracle 9.2 I view my running session with the query: SELECT S92700.SYSUSR_VW."NAME", SID,SERIAL#, AUDSID FROM v$session, S92700.SYSUSR_VW, S92700.SECUSR WHERE S92700.SYSUSR_VW.SESSIONID = ...
4
votes
4answers
678 views

optimizing a compare query

Suppose I have two tables, A and B, and I know that size(A) = size(B). I want to confirm that the data in both tables is the same in three given columns, suppose they are X, Y, and Z (there are no ...
2
votes
2answers
1k views

12c Grid Agent installation issues - Shell path is incorrect or not defined

I am installing 12c Grid Control agent on my server via Enterprise manager. The targer server is a UNIX server with AIX OS on it. I add target host manually, enter authentication information, host ...
0
votes
0answers
119 views

Optimization of an Oracle query

I have a view which is accessed via DBLink in Oracle. This view is made up of different tables. Now we have to execute queries on this view. Example: Select * from Viewname@dblink where ...
0
votes
1answer
92 views

ORA-12541: TNS: No listener after adding new IPs to machine

We are receiving the ORA-12541 error since we added 2 new IP addresses to the machine. This may or may not be related to the problem at hand, but this is the latest severe change that was made, before ...
-1
votes
0answers
16 views

What means Buffer Pool/Hit Ratio(%) in Oracle Counter?

I found the buffer pool hit ratio percentage at Oracle database metrics / Oracle Counter. I want to know about this buffer pool detail. Kindly answer to me.
0
votes
0answers
14 views

parsing and purpose of oracle audit (.aud) logs

I am looking at the oracle audit logs and am trying to understand and parse. The format appears to be consistent: Date Length: Action: ...etc My questions are: 1) what generates these? Is it ...
1
vote
3answers
1k views

Remove ORA-01100:DATABASE ALREADY MOUNTED

I am using Oracle 11g and there is a database create during installation name "xyz" and user "xyz".Now i created a user 'abc' and gave following permission to abc. "CREATE SESSION, ALTER SESSION, ...
0
votes
1answer
401 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 ...
0
votes
1answer
74 views

How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously

I have two servers, Oracle and SQL-Server. I have same database on both the servers. I want to perform DML (insert,update,delete). How can I perform same DML statements on both the servers ...
0
votes
1answer
35 views

parsing and purpose of oracle audit (.aud) logs

I am looking at the oracle audit logs and am trying to understand and parse. The format appears to be consistent: Date Length: Action: ...etc My questions are: 1) what generates these? Is it every ...
1
vote
1answer
322 views

Internal query on CDEF$ and CON$ very CPU bound

I am checking an application (Infor ERP LN) that loads a lot of data into an oracle 10.2 database. While checking one of the user sessions with SQL_TRACE and its output with tkprof, I found that the ...
2
votes
1answer
473 views

How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?

I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job. I have a remote Oracle 11g R2 database on unix and a local one on Windows. I read that you can install the oracle ...
3
votes
1answer
39 views

Possible RMAN orphan files in backup directory

I am trying to scrape together some space in my Oracle 11g backup directory in AIX. I have deleted obsolete files using RMAN's "DELETE OBSOLETE" command, but I see many (just under 200) files dated ...
0
votes
1answer
28 views

XMLTABLE solution without getting right parenthesis missing error

I am trying to select from an XML type and produce multiple rows. Have searched for my specific scenario/issue with not much success. Environment: Oracle 12c. I have commented out the offending code. ...
1
vote
1answer
34 views

Transferring full database to another machine oracle 10.2 xe

We are having oracle 10.2 xe working on windows xp sp3(32bit). We need cloning/copying full database to windows server2008r2 machine(64bit). Any help.
0
votes
1answer
24 views

ORA-01830 Error for 11.2.0 client but not for 10.2 client

I have this piece of code: BEGIN DBMS_SCHEDULER.DROP_JOB ( job_name => 'LOANSBUILD.LOANSNEWYORKCLOSE'); END; / BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => ...
1
vote
1answer
62 views

can't backup 11.2.0.2 database after catalog upgrade to 11.2.0.4

(main question is 4th) 1. We today have almost all databases running with Oracle 11.2.0.2. Actually we have an RMAN database created (in 11.2.0.2) and a Catalog with user (called RMAN112) 2. We are ...
0
votes
2answers
5k 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 ...