Oracle Database





Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Share tech news, updates, or what's on your mind.

Sign up to Post

Crystal Reports 2016 not connecting to an Oracle DB on the same machine that another similar Tool Tableau Desktop (10.5) the Dashboard Design tool can connect. Errors include "Not implemented" when using the ODBC Oracle in instantclient_11_2 which clearly works for other connecting tools. I have also tried to connect through OLE DB (ADO) as well as having created my own connection through ODBC.

The machine which has CR2016 on it is Windows 7 Pro 64 bit. The ODBC datasource does connect to odbcad32.exe and that is where the Tableau license connects to the data. Not sure if that is the culprit. I am currently searching for odbcad64.exe (thinking that might be the problem...but not sure)  but not found yet. I am not sure it is needed?

Also I can make my own connection to the datasource with my credentials which I use the local ODBC admin tool. I did notice that when I connect with Tableau the tool launches this screen:
The window I get when connection to Oracle Server is made. I have all credentials for it.
But when I launch Crystal Reports I get the common database expert. When I go to the places I think I should be connecting to I do not get the same interface as mentioned above with ODBC OLEDB and others.

This is what most of the errors are when connecting through to any of the Oracle connections.Not sure what would cause this connection to be so difficult to attain since one product on the same machine can but not the other.??? Any help on this is greatly appreciated.
The new generation of project management tools
The new generation of project management tools

With’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Problem with an Oracle upgrade from 11G to 12c.  Failed miserably with the new Grid Infrastructure Management Repository (GIMR) part.  Cannot ping VIPs.  We decided to bypass the GIMR and install manually after a successful Grid Install.  Grid install completed and says successful.  However, now the scan/VIPS are not happy getting the following error that need to be fixed before able to proceed with the install:

crsctl stat res -t reports OFFLINE OFFLINE

Node 1 has the database and ASM online. Node 2 appears to have ASM online but not the database.

Need to get VIPS scan work.  Any ideas, suggestions?
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Hi All,

Is it okay to have two oracle clients (both 11g and 12) in the same windows server? What are the potential issues I could face?The reason I am doing this is to fix attached SQL server linked server connection issue.

In a modern Oracle 12.x RAC database and all things being equal, would it be advisable to explicitly create an ACFS file system for storing shared files or would ASM be more appropriate (like Wallet files etc.)?

  • You do not want to store the files locally on each node if possible.
  • You do not already have an ACFS file system but do have ASM (because you have a RAC).

I am basically looking for the current best practice in storing shared files as seen in the industry.  What has the best ROI etc.


I have Docuemnts table in Oracle 11g  with  Document_No    RevNo  and a few other fileds like fld1, fld2
    RevNo is always numeric
sample data
  Doc1  1
  Doc1  2
  Doc1  3
  Doc2  1
  Doc2   2
  Doc3   1

I need a query to get Latest  revision rows only . In the sample    it should return
   Doc1  3
   Doc2  2
   Doc3  1
Can I use a JDbC Type 4 driver to allow the  'Application' to fail over to the standby DB if the connection has been lost to the Primary

Can I use the this JDBC Type 4 driver with a Oracle Data Guard with a Primary / Standby (not a RAC) for versions 11.2 and higher ?

In oracle, I want to see people who have the same Course Description this year as they did last year

So students where  Last years Course = This Years Couse

Data is stored as follows:

Student ID: 111000
Course Code: 100
Course Year: 2018
Student ID: 111000
Course Code: 100
Course Year: 2017

Any help much appreciated.

I have proc which i want to change to merge please see attachment i have marked
---------------------this change to merge
Business key for merge will be SIN.

INSERT INTO employee

---------------------this change to merge
         INSERT INTO employee(DATE_CREATION,
Can an application use a JDBC driver that can contain the IP to both a primary and Standby instnace, so that the client can switch to standby if the primary IP is no longer reachable.

Or is there some other way an application can perform this

We are using an Oracle DB (Data Guard, primary and standby), but I am asking this from a client application failover to the correct DB instance, as opposed to a db failover
Hire Technology Freelancers with Gigs
LVL 12
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Hello there,
I came up with a SQL to find the timestamps of current scn and applied scn on primary and standby 11gR2 DBs respectively. This is for checking standby LAG. I now need to find the "difference" between these two timestamps in minutes/hours.. Is there a way this can be accomplished? Will appreciate your help in getting this difference.
I tried some options but they didn't work (using to_date)..

select scn_to_timestamp(to_char(current_scn)) ,scn_to_timestamp(to_char(APPLIED_SCN)) "applied scn" from v$database,v$archive_dest where dest_id=2;

applied scn
14-MAR-18 AM
14-MAR-18 AM

select to_date(scn_to_timestamp(to_char(current_scn)),'dd-mon-yy AM')  as first_date, to_date(scn_to_timestamp(to_char(APPLIED_SCN)),'dd-mon-yy AM') as second_date from v$database,v$archive_dest where dest_id=2;
select to_date(scn_to_timestamp(to_char(current_scn)),'dd-mon-yy AM')  as first_date, to_date(scn_to_timestamp(to_char(APPLIED_SCN)),'dd-mon-yy AM') as second_date from v$database,v$archive_dest where dest_id=2
ERROR at line 1:
ORA-01821: date format not recognized

select   round((second_date - first_date) * (24),2) as …
Hi there,

We have a server and runs some tests for us using Oracle.  I unfortunately installed the 12c 32bit Oracle client, but we really want the 12c 64bit client.  I followed some online instructions to remove the 12c 32bit client, which seemed to work.  I then installed the 64bit client and it seemed to be working, but when I run these tests, the tests all fail and they bring up the error below:

System.InvalidOperationException : Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.   ---- System.BadImageFormatException : An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

I decided to follow an article that mentions I could install both clients and then have a symbolic link between both clients so that it wouldn't matter what bit test I run, it would either use the 32bit or 64bit libraries, depending on the test.  So I reinstalled the 32bit client under a different home directory.  Of course this didn't work and I'm stuck.  I really don't want to have to uninstall anything so is there a way to fix this issue?  I also don't want to have to reinstall Windows just to fix this when the server is working fine otherwise.

Thanks in advance!
- Christian
Hello expert,

Using Oracle SQL Developer to import large data set from Excel Office 365.
The way it has been done before is to right click on the Tables icon in Connections
navigator, then Import Data. This goes to dialogue box titled 'Open' where a browse
thru the file structure leads to the Excel spreadsheet. Then the import dialogue
goes away and comes back in a few seconds (directly proportional to the number
of records in the Excel file). Then it goes thru a five step process.

The problem is the Excel file is 76K rows  with 13 columns.
The process described above is followed but when it goes to the import dialogue
after choosing the file at the Open screen it never comes back.

But smaller files have been imported many times. So it is surmised that the size
of the file is the issue. So the file is cut in half to 38k. Same result.
File halved again to 19k. No luck. Files halved again to 9k. The
table was created but the SQL Developer says the data failed to load
and the INSERT statement was rolled back. Finally got a file of 4.7k rows to load.

This means after the initial load of 4.7k, fifteen additional files would be
appended. Not an optimum operation.

Is there some way of doing this without 16 loads? Will the number of rows
loadable in a single pass increase by using CSV or other file type?

Is there another process that can be used to import data?


Allen Pitts, Dallas Texas
I had this question after viewing Host Credentials for Oracle Enterprise Manager 11g not working?.
Why does Backup through OEM not work in spite of correct credentials? It shows error message that required privilege is not held by the client.
I have already checked local policy settings as shown in some of the links, and also checked ORA_DBA group, etc.

The thing is that backup had been working fine for a long time and it suddenly started failing this month. Our network admin says nothing else has changed.

/* Formatted on 2018/03/13 11:40 (Formatter Plus v4.8.8) */
SELECT gh_sys_id, year_month, gh_txn_code, gh_no, gh_supp_code, supp_name,
       subtotal, ited_anly_code_1, t_amt
  FROM ((SELECT gh_sys_id, year_month, gh_txn_code, gh_no, gh_supp_code,
                supp_name, (total - NVL (disc, 0)) subtotal
           FROM ((SELECT   gh_sys_id, TO_CHAR (gh_dt, 'YYYYMM') year_month,
                           gh_txn_code, gh_no, gh_supp_code, supp_name,
                           SUM (gi_fc_act_val) * gh_exge_rate total
                      FROM ot_gr_head JOIN om_supplier
                           ON gh_supp_code = supp_code
                           JOIN ot_gr_item ON gi_gh_sys_id = gh_sys_id
                     WHERE gh_txn_code = 'GC4'
                       AND gh_dt BETWEEN '1-JAN-18' AND '31-JAN-18'
                  GROUP BY (gh_txn_code,
                           )) a
                LEFT JOIN
                (SELECT   SUM (NVL (ited_net_lc_amt, 0)) disc, ited_h_sys_id

Open in new window

Using an Oracle Data Guard with a Primary and Standby database instance, is there a way to use a JDBC driver to send to the correct DB instance (or more specifically, to allow the application to fail over to the Standby  database instance if the primary is down)

I examined the documentation and the JDBC drivers appear to be for a RAC cluster as opposed to the Data Guard Primary and Standby

Can some one please help clarify ?

we are facing issue in one of our web application it works fine locally .Response Time on internal network  is 4ms but when we try to access it from out side  web application open but took long time to load the files. The application accessed by all the customers to view and download load their licenses.

OS :WIndows sever 2012
Database: Oracle
Memory 32GB

All the resources are Normal  except Network latency

Network Latency reaches to 280ms when access from outside .The server is in DMZ .
i want to disable all user from access my oracle database includig user with admin privilage like system  ;
I have a Docuemnt No in following sequence

    Typically a  DocuemntNumber wil be    Type1-01-001-123
     But there is bad data also so some of them may be just 01-003-234  ( No type) or 01/004/123 ( with /)  ..e.t.c
     I need the oracle query for following
          Check if the pattern of docuemnt number is correct  ( That is 3 hiphens) .
             If the pattern is correct , return the Docuemnt type  (First part of the DocuemntNo)
             Else return ''
Never miss a deadline with
Never miss a deadline with

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Below is the code I have run to schedule the job in oracle using scheduler in oracle.  I want to run the procedure every 12 hours. But the job does not run automatically , I need to run it manually. Any help is really appreciated.

  -- Job defined entirely by the CREATE JOB procedure.
  DBMS_SCHEDULER.create_job (
    job_name        => 'Load_OMR_data',
    job_type        => 'PLSQL_BLOCK',
    job_action      => 'BEGIN P_LOAD_INVENTORY_DATA( ''' || 'today' || ''') END;',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'freq=HOURLY;Interval=12',
    end_date        => NULL,
    enabled         => TRUE,
    comments        => 'Job to load inventory data for host database instance');
I have written a SQL query where I am getting all the required fields but the update timestamp in not in order

Though I have given as group by and order by in the script. Could someone tell what I need to change in the script below

 SELECT b.cust_id,
    SUM(DECODE(a.status_cd,'pending',1,0))  AS Pending,
    SUM(DECODE(a.status_cd,'Error',1,0))    AS Error,
    SUM(DECODE(a.status_cd,'success',1,0))  AS success,
    SUM(DECODE(a.status_cd,'existing',1,0)) AS Existing,
    SUM(DECODE(a.status_cd,'canceled',1,0)) AS Cancelled,
    SUM(DECODE(a.status_cd,'',1,0))         AS Null_Values
    FROM table a,
    table b
    WHERE A.UPDT_TS BETWEEN TO_DATE('28-JUN-2017 00:00:00','DD-MON-YYYY HH24:MI:SS') AND sysdate
    AND b.cust_id=a.cust_id
    GROUP BY b.cust_id,
    ORDER BY b.cust_id,
    a.updt_ts DESC;
Recently our Storage Array LUN was extended by our Sys Admin group, to allow my DBA team to increase the size of “OCR_VOTE” disk group.  Apparently, this is a new requirement for Oracle Database 12c.  Unfortunately, the Sys Admin group did not format this new extended LUN.

The DBA team has determined we need 50Gig, and this has been confirmed running the Solaris, “format -e” command, and also the “prtvtoc” command.  So, am I totally wrong thinking, my DBA team could just run “format”, select the correct disk, partition, then label, then save?

# format<cr>
Searching for disks ... done

       0. c0t0d0 <SUN146G cyl 14087 alt 2 hd 24 sec 848>
       1. c0t1d0 <SUN146G cyl 14087 alt 2 hd 24 sec 848>
       2. c3t60A98000572D577465346D3936706348d0 <NETAPP-LUN-7330-200.00GB>
I have oracle database with Tbl1with fileds fld1, fld2
           Tb9 with fields   Name, Tbl9UID

 I need to look  
      If  Tbl1.Fld1 in ( 1,2,3) then
            if  fld1 ||  fld2 = Tb9.Name  then return  Tbl9UID
      else  if fld1 = Tb9.Name  then return Tbl9UID
      else  return ''

I can do it with case when   statement . But what I am not clear  is   how I can do it when I have to use a left outer join
 it needs to come as one of the multiple  left join for the reasons of another question I asked here
HI Experts,

Running an export utility from Oracle database 11g which is running on AWS Linux.

this process usually takes 45 minutes as per product. but it is taking almost 2 hrs.

Could you please help me identify the bottleneck, worst sql and give me some directions please?

Thanks in advance
In  Oracle Sql Developer , I am seeing only Table design when I double click on the table. How I can see the data instead of design

Oracle Database





Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Vendor Experts

monday.comMonday Learn more about Monday