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!

Locking down 18c XE

NickeNJul 3 2020 — edited Sep 5 2020

I have some sensitive data I wish to install in an Oracle 18c XE database on Windows in a way that only a specific oracle user with a specific password of my choosing can acces the data. I've googled around and not found any information at all really. TDE looks really nice, passwords can be changed etc. But in the end, the user that installed the database can use 'sqlplus / as sysdba' to turn it all around, or even orapwd.exe I guess.

Is Oracle databases in general not appropriate for installation/usage in such a hostile environment or am I missing someting?

Comments

807598
hi :-)

- when this error occur? during compilation of your java or when tomcat is already running?
- have you tried to put your commons-logging.jar to your apps web folder?
YourApp\WEB-INF\lib
- then try to reconfigure again your classpath :-)

regards,
798906
Should work ok. Are you sure you have the commons-logging.jar in the $CATALINA_HOME/common/lib directory? Make sure that you haven't accidentally put it under $CATALINA_HOME/common/lib/commons-logging-1.0.4/. You should really place this jar under $CATALINA_BASE/shared/lib if you want tto share it across all your web applications since there is no need to make it visible to tomcats internal classes (although the common/lib directory should work ok)
798906
then try to reconfigure again your classpath
Tomcat ignores classpath
807598
I have followed both of you people suggestion but still doesn'
t work!!
I had put my commons-logging-1.0.4.jar under Tomcat\shared\lib and remove that jar file from Tomcat\common\lib .
i put the same under myApp\WEB-INF\lib directory as well.
it throws the compile time error always!!
807598
this is my part of java code:
import org.apache.commons.logging.Log; 
import org.apache.commons.logging.LogFactory; 
import org.apache.log4j.PropertyConfigurator;

	public Operation() 
	{
		log = LogFactory.getLog(Operation.class); 

		//Setting the properties for logging
		String userDir = System.getProperty("user.dir");
		String configPropertiesFile = userDir+"/Operation.properties";
		//System.out.println("configPropertiesFile   "+configPropertiesFile);
		PropertyConfigurator.configure(configPropertiesFile);
	}
807598
hi :-)

it throws the compile time error always!!
there something wrong with your classpath when you compile your program.
can you show us how you compile your java program or your classpath.

regards,
807598
Oops! I fotgot to set the classpath contains commons-logging-1.0.4.jar
on Enviornment variables CLASS_PATH value.
Thnks a lot
venki
798906
Oops! I fotgot to set the classpath contains
commons-logging-1.0.4.jar
on Enviornment variables CLASS_PATH value.
Yes because where you put the jar files under tomcat is completely irrelevant with regard to compiling your code ...
1 - 8

Post Details

Added on Jul 3 2020
6 comments
906 views