Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can I install an oracle patch on XE 11g?

2659273Jul 15 2014 — edited Jul 15 2014

Customer Problem Description
---------------------------------------------------
 
Problem Summary
---------------------------------------------------
Not able to install the patch '69552 - Oracle TNS Listener Remote Poisoning' on CentOS Linux server
 
Problem Description
---------------------------------------------------
1. We have ORACLE XE installed on CentOS Linux server. Our oracle home is /u01/app/oracle/product/11.2.0/xe/
.
2. I downloaded OPatch version 11.1.0.10.2 for Linux 64 bit and the patch number 12880299 for '69552 - Oracle TNS Listener Remote Poisoning' from oracle support web page.
 
3. I tried to apply the patch '69552 - Oracle TNS Listener Remote Poisoning' using the following command:
 
/opatch apply -JDK $JAVA_HOME /home/oracle/12880299/
 
4. I get the following error:
 
Applying interim patch '12880299' to OH '/u01/app/oracle/product/11.2.0/xe'
Verifying environment and performing prerequisite checks...
Log file location: /u01/app/oracle/product/11.2.0/xe/cfgtoollogs/opatch/opatch2014-06-30_11-49-36AM_1.log
 
Recommended actions: Please make sure no other OPatch or OUI processes is running. Try to run $ORACLE_HOME/oui/bin/runInstsaller.
 
OPatch failed with error code 20
 
$ cd $ORACLE_HOME/OPatch/
$ ./opatch version
OPatch Version: 11.1.0.10.2
 
5. I also see the following in the log file generated by opatch:
 
OPatch found incompatible or invalid applicable product type with respect to the Oracle Home.
[Jun 30, 2014 11:49:39 AM] OUI-67035:System is intact, OPatch will not restore the system
 
Note: I am not sure if I downloaded the correct versions of the opatch and the patch for '69552 - Oracle TNS Listener Remote Poisoning' or not.
 
Please help.

Comments

Mike Kutz

This is what External Tables were designed to do.

I believe that you can use SQL*Developer to create the necessary parameters.

Now, if the CSV was a CLOB (or BLOB) in a table (eg APEX "File Browse..." Item), then you'll want to up-vote this:

Other than that, you will need to explain what you want with more details.

MK

Gbenga Ajakaye

This is what External Tables were designed to do.

I believe that you can use SQL*Developer to create the necessary parameters.

Now, if the CSV was a CLOB (or BLOB) in a table (eg APEX "File Browse..." Item), then you'll want to up-vote this:

Other than that, you will need to explain what you want with more details.

MK

Thanks Mike. I want to be able to read the data in a .CSV without loading the data. I can see how your idea could come in handy, but it's different from what I'm looking for.

BPeaslandDBA

I'm going to vote Up. The reason is because this has already been implemented...many many versions ago. Here is the Oracle documentation on the subject:

External Tables

Either that, or I missed the point entirely.

Now querying a .xlsx file directly from an external table...now there's an idea!

Cheers,
Brian

BPeaslandDBA

Thanks Mike. I want to be able to read the data in a .CSV without loading the data. I can see how your idea could come in handy, but it's different from what I'm looking for.

External Tables do not load the data. They do use the SQL*Loader engine to read from the .csv file, but data is not loaded to the database.

Gbenga Ajakaye

External Tables do not load the data. They do use the SQL*Loader engine to read from the .csv file, but data is not loaded to the database.

I know that @"BPeaslandDBA".

Mike Kutz

I'm going to vote Up. The reason is because this has already been implemented...many many versions ago. Here is the Oracle documentation on the subject:

External Tables

Either that, or I missed the point entirely.

Now querying a .xlsx file directly from an external table...now there's an idea!

Cheers,
Brian

BPeaslandDBA wrote:
Now querying a .xlsx file directly from an external table...now there's an idea!
Cheers,
Brian

Hmmm... can you pass a BFILE to the XMLType() that is part of an XMLTable() ???

MK

Gbenga Ajakaye

I'm going to vote Up. The reason is because this has already been implemented...many many versions ago. Here is the Oracle documentation on the subject:

External Tables

Either that, or I missed the point entirely.

Now querying a .xlsx file directly from an external table...now there's an idea!

Cheers,
Brian

I'll like to see that @"BPeaslandDBA". Though .xlsx can be rather problematic to query. It's not as straightforward.

FatMartinR

.xlsx is a proprietary format.     Not only could it change in the next release of Excel, but it can contain objects other than just text.

How would it copy with embedded objects, for example?

William Robertson

I know that @"BPeaslandDBA". 

BCG14 wrote:
I know that BPeaslandDBA.

Then why suggest something that you know already exists?

Gbenga Ajakaye 
BCG14 wrote:
I know that BPeaslandDBA.

Then why suggest something that you know already exists?

My reply was that I know that external table is meant to ready data.

BPeaslandDBA

I know that @"BPeaslandDBA".

If you know that, then why did you say "I want to be able to read the data in a .CSV without loading the data." That's precisely what an External Table does. I must be missing something, because you're asking for functionality that already exists so either you did not know that, or  you're asking for something that is not clear to the rest of us in which case you should elaborate more.

Gbenga Ajakaye

If you know that, then why did you say "I want to be able to read the data in a .CSV without loading the data." That's precisely what an External Table does. I must be missing something, because you're asking for functionality that already exists so either you did not know that, or  you're asking for something that is not clear to the rest of us in which case you should elaborate more.

I do know what a external table is are what it's used for. I see what you both are saying. I'll remove the idea.

1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 12 2014
Added on Jul 15 2014
1 comment
2,704 views