Skip to Main Content
Forums

Oracle Database Discussions

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.

Oracle 12c databases on OL7/xfs

Alex BardosNov 23 2015 — edited Nov 24 2015

Hello,

I am looking for input on how to interpret Doc ID 236826.1 in regards to support of Oracle database files (data, redo, control, ...) on xfs file systems when running OL7.1 (3.8.13-118.el7uek.x86_64). (posted an SR as well)

It states (1):

The current support includes ext2, ext3, ext4 (Oracle Linux 5.6 and later), btrfs and NFS-based storage systems (e.g. NetApp).

 

It also states (2):

 

When a problem is encontered, if a non-supported filesystem is being used for Oracle data, control and redo log files, Oracle will try to reproduce the problem on a supported and certified filesystem. If the problem does not reproduce on a certified filesystem, the specific filesystem / O/S vendor should be engaged for resolution.

 

In this case - using OL 7.1 (3.8.13-118.el7uek.x86_64) Oracle is the OS vendor as the FS vendor. So does the statement 2 above imply that Oracle does support Oracle data, control and redo log files on xfs file systems when running OL7.1?

XFS is also listed in the "Recommended File Systems" section. It states there that:

In summary, the recommended filesystems are:

  • Single node: Any filesystem that is supported by the Linux vendor. Note that any filesystem issues are need to be resolved by the Linux vendor.

The Linux vendor here being Oracle.

 

This is for standalone (no CDB/PDB) file system based (no ASM, raw partitions, etc.) databases.

Anybody using xfs for Oracle 12c databases? Any experience with support problems due to this stack?

(Also - we are using VMware, not the Oracle VM solution).

Thanks.

Comments

675595
Did not understand what you meant by 'file created from the OSB console with a WLST script'?

The customization schema (Customization.xsd) which describes the customization types is available at the following location in your Oracle Service Bus installation:
BEA_HOME\modules\com.bea.common.configfwk_[version].jar, where BEA_HOME represents the directory in which you installed Oracle Service Bus

I guess good starting point for this is to export a customization file for the simple resources from OSB and start customizing.
http://download.oracle.com/docs/cd/E13159_01/osb/docs10gr3/consolehelp/customization.html#wp1113361

Thanks
Manoj
mwh
Hi..

It's fairly straightforward...

Although I do it in Java, it's fairly simple to convert into wlst..

Here's the steps to create an Env Value Customization for a specific project..

Get the Ref object for the project..

Create an EnvValueQuery.. (e.g. EnvValueQuery projQuery = new EnvValueQuery(null, null, Collections.singleton(ref), false, null, false) )

Use the ALSBConfigurationMBean to get a collection of Qualified env values.. (e.g. Collection<QualifiedEnvValue> projectEnvVals = alsbJmx.lookupEsbReadOnlyConfigMBean().findEnvValues(projQuery);)

put the env values into an array list..
e.g. for (QualifiedEnvValue qEnvValue : projectEnvVals){
alCustomRefs.add(qEnvValue);
}

Create an EnvValueCustomization.. (e.g. EnvValueCustomization projectEnvValsCustomization = new EnvValueCustomization("Customizations File for - " + ref.getFullName(), alCustomRefs );)

Create an array list and put the customizations into it.. (e.g. ArrayList<Customization> alCustomizations = new ArrayList<Customization>(); alCustomizations.add(projectEnvValsCustomization);)

Create a File Output Stream and use the Customization class to write the customizations to the file.. e,g. Customization.toXML(alCustomizations, fileOutputStream)

..Mark.
655092
Thank you both for your responses. I've coded the wlst script with specific EnvValueQuery's as suggested by Mark before, but what I am really hoping for is a way to create a customization file with WLST that looks the same as the file that is created when you click the "Create Customization File" in the OSB console. When you create the file in the console, it has all the values, and you can do a search and replace in the file. When you create the file the way Mark suggests, it creates a file that only has those specific things you want to search and replace.

I'd prefer to have the full file like it is created when you use the console as we already have a process in place to deal with this file format that works very well for us. If I have to use the method Mark mentioned, we have to recode a chunk of our automated process, which is what I am trying to avoid. That's not to say Mark's suggestion is incorrect... I'm just hoping there's another option that fits better into the process we already have in place.
mwh
Hi..

There's a simple way to do what you want.. but not too sure within WLST.. but there's an MBean that the console uses "com.bea:Name=Config.XBus Kernel,Type=com.bea.wli.config.mbeans.ConfigMBean", if you can get hold of that then the following does exactly the same as the console...
	    ConfigMBean alsbConfigMB = alsbJmx.getCoreConfigReadOnlyMBean();

	    Set<Ref> domainRefs = alsbCoreRO.getRefs(Ref.getDomainRef());	//..instance of ALSBConfigurationMBean    
	    
	    byte[] contentsProj = alsbConfigMB.createCustomizationFile(domainRefs, EnvValueTypes.ENV_VALUE_TYPES);
	    FileOutputStream fosConfig = new FileOutputStream("testCustomization.xml");
	    fosConfig.write(contentsProj);
	    fosConfig.close();
..Mark..
thank you very much
525476
Mark -

I'm trying to accomplish this and I'm not able to derive the code needed to accomplish this line from your example. Can you please help with this? I havent been able to find anything else online that talks about this. Thanks!

ConfigMBean alsbConfigMB = alsbJmx.getCoreConfigReadOnlyMBean();

Edited by: JeffWest on Feb 9, 2010 5:53 PM
679367
I am NOT able to access the ConfigMBean either. Can someone help to mimic the same functionality of exporting the customization file done in OSB admin console using WLST?
user10290371
Hello mwh

I have also tried to repeat your steps using JMX. This is exactly what I need to do. I managed to find the mbean and the method you mentioned (createCustomizationFile(...)).

2 Questions:
- You have provided us with some very useful software hints. UNfortunately this is not enough to write a fully functional programm as this uses Oracle proprietary transport objects and MBeans.
It would be very very helpful, if you could send us the full source code of an example client so that we can see all the necessary imports and the way how you did get all those objects.
You would do me a very big favour if you could tell me how to export ALL projects in one step into the customizing.xml file.

- I also do need the reverse function -> important an customization.xml into an ESB which is called execute in the sbconsole. I cannot find a corresponding MBean-Operation for "execute". Do you have any hints for us how to do this ?


Thanks a lot in advance
Martin
Ul
How I get a instance of alsbConfigMB?
Ul
I resolved my problem. The solution is follow (Java language):

Set<Ref> domainRefs = alsbConfMB.getRefs(businessServiceQuery);

EnvValueQuery evquery = new EnvValueQuery(null, // search across all
// resource types
envValueTypesToSearch, domainRefs, // search only in found refs.
false, // Search all resources
null, // the string we want to replace
false // not a complete match of URI.
);

Collection<QualifiedEnvValue> founds = alsbConfMB.findEnvValues(evquery);

List<QualifiedEnvValue> qualifiedEnvValueList = new ArrayList<QualifiedEnvValue>();
for (QualifiedEnvValue qev : founds) {
if (qev.getEnvValueType().equals(EnvValueTypes.SERVICE_URI)) {
qualifiedEnvValueList.add(qev);
}
}


EnvValueCustomization projectEnvValsCustomization = new EnvValueCustomization("Customizations File for businss services ", qualifiedEnvValueList);
List<Customization> customizationList = new ArrayList<Customization>();
customizationList.add(projectEnvValsCustomization);
OutputStream fileOutputStream = new FileOutputStream("testCustomization.xml");
Customization.toXML(customizationList, fileOutputStream);
fileOutputStream.close();
859601
Hi Ulisses,

Could I ask you something?
How did you do to connect your script java to weblogic server?

Helps me a lot if you tell me the java's class invocation

thank you
1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 22 2015
Added on Nov 23 2015
#general-database-discussions
5 comments
4,399 views