Feed aggregator

Mview creation from view

Tom Kyte - Thu, 2018-03-01 07:06
The MV creation using a view is forcing to use minimum 1 table even if that table is a dummy. Creating MV directly on view is failing with ORA error ORA-12015. Further if I were to use DUAL instead of dummy table it gives a different ORA error ORA...
Categories: DBA Blogs

calculate how many minutes employee worked for a day in hourly breakup

Tom Kyte - Thu, 2018-03-01 07:06
I am having data like Empcode attdate intime outtime 12345 03-JAN-2018 00:00:00 03-JAN-2018 10:56:00 03-JAN-2018 16:44:00 12345 03-JAN-2018 00:00:00 03-JAN-2018 20:00:00 03-JAN-2018 23:...
Categories: DBA Blogs

Getting started with Performance Diagnosis

Tom Kyte - Thu, 2018-03-01 07:06
Mostly we don't get database performance problem, so never felt a need to learn much about performance. Oracle take good care of itself. But one day db server got restarted, then i got performance problem calls from users. At this point i got bli...
Categories: DBA Blogs

Database hang and we cannot switch logfile or shutting down the DB

Tom Kyte - Thu, 2018-03-01 07:06
Hi Experts, During the issue time database hang and we cannot switch logfile or shutting down using IMMEDIATE. All the Redo logfiles are showing status ACTIVE and still its showing ACTIVE after 1 Week. \ Why the Redo logfile is still ACTIVE...
Categories: DBA Blogs

Error on auto execute of job

Tom Kyte - Thu, 2018-03-01 07:06
i am getting this error everyday at 10 AM everyday kindly help me on this ,thanks in advance Errors in file /u01/TBCCDDB/diag/rdbms/tbccd/TBCCD/trace/TBCCD_j003_19550.trc: ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_3196" ORA...
Categories: DBA Blogs

Statistics on Materlized View taking plus 10 hours

Tom Kyte - Thu, 2018-03-01 07:06
I'm trying to update the stats on a materlized view I created: <code> BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname => 'CSPRD', tabname => 'mv_llattrdata_shrinked', cascade ...
Categories: DBA Blogs

Usage of equijoin and natural join

Tom Kyte - Thu, 2018-03-01 07:06
Hi Tom, I know how can I use equijoin and natural join but, I'd like to know when we use equijoin and when we use natural join? In which scenario or query we should use equijoin and in which scenario or query we should use natural join?
Categories: DBA Blogs

Switch from nologging to force logging

Tom Kyte - Thu, 2018-03-01 07:06
I have inherited a 12c database with data guard and was shocked to see that the database was set to no logging on the primary and standby. I checked the scn number and they were roughly matching on both primary and standby. This has been this way f...
Categories: DBA Blogs

Error accessing D2: Error while fetching repositories

Yann Neuhaus - Thu, 2018-03-01 06:55


After patching our D2 we ran into an error we never had before. After all, it’s only a patch. But as you know, patching D2 means recreating the war file and deploying it again. As well as setting up again all the customs you made…

Well this time we had a popup when accessing the D2 interface, which said “Error while fetching repositories”. That means D2 wans’t even able to load the list of available repo. And here’s what we had in the logs:

[ERROR] [http-bio-8080-exec-3] - c.e.d.d.w.s.config.D2X3ConfigService    : Error obtaining the default offline skin java.lang.NoClassDefFoundError: Could not initialize class com.documentum.fc.client.DfClient

I didn’t bring the whole stack trace but it was as “precise” as this line…

I found the solution in the official documentation, but not for my tomcat version… we were using tomcat 7 whereas it is for tomcat 8.

The solution:

Running Tomcat 8.0.5 with D7.1SP1 and DFS7.1.1 requires modifications to catalina.properties:
File location: <CATALINA_HOME>/conf/catalina.properties

Running Tomcat 8.0.5 with D7.1 CS and DFS7.1 requires copying cryptojce.jar, cryptojcommon.jar and jcmFIPS.jar files to the /D2/WEN-INF/lib and /D2-Config/WEB-INF/lib folders. Also, modify the catalina.properties files as mentioned above.


Cet article Error accessing D2: Error while fetching repositories est apparu en premier sur Blog dbi services.

Error starting D2 4.5 on Tomcat 8 No class found: JSAFE_SecureRandom

Yann Neuhaus - Thu, 2018-03-01 06:29


When installing D2 and launching the tomcat server you can have an error on a missing lib: JSAFE_SecureRandom.

Here’s the trace you can have:

2018-01-17 17:32:19 [DEBUG] [localhost-startStop-1] - c.e.c.d.contents.D2FileCleaningTracker : Init D2FileCleaningTracker with /pkgs/dms-tomcat/D2_TOMCAT_HOME/temp/D2FileCleaningTracker_D2.ser
2018-01-17 17:32:20 [ERROR] [localhost-startStop-1] - c.emc.d2fs.dctm.servlets.D2HttpServlet : LoadOnStartup - java.lang.NoClassDefFoundError: com/rsa/jsafe/JSAFE_SecureRandom
2018-01-17 17:32:20 [ERROR] [localhost-startStop-1] - c.emc.d2fs.dctm.servlets.D2HttpServlet : {}
java.lang.NoClassDefFoundError: com/rsa/jsafe/JSAFE_SecureRandom
at com.documentum.fc.client.security.impl.InitializeKeystoreForDfc.execute(InitializeKeystoreForDfc.java:46) [dfc.jar:na]
at com.documentum.fc.client.security.internal.KeystoreMgr.initForDfcWithDefaultPolicy(KeystoreMgr.java:71) [dfc.jar:na]
at com.documentum.fc.client.security.impl.IdentityManager.initFromKeystore(IdentityManager.java:139) [dfc.jar:na]
at com.documentum.fc.client.security.impl.IdentityManager.<init>(IdentityManager.java:41) [dfc.jar:na]
at com.documentum.fc.impl.RuntimeContext.<init>(RuntimeContext.java:52) [dfc.jar:na]
at com.documentum.fc.impl.RuntimeContext.<clinit>(RuntimeContext.java:185) [dfc.jar:na]
at com.documentum.fc.client.DfClient.<clinit>(DfClient.java:772) [dfc.jar:na]
at com.emc.d2fs.dctm.servlets.init.SessionIterator.<init>(SessionIterator.java:77) [D2FS4DCTM-WEB-4.5.0.jar:na]
at com.emc.d2fs.dctm.servlets.init.LoadOnStartup.getSessions(LoadOnStartup.java:441) [D2FS4DCTM-WEB-4.5.0.jar:na]
at com.emc.d2fs.dctm.servlets.init.LoadOnStartup.processRequest(LoadOnStartup.java:164) [D2FS4DCTM-WEB-4.5.0.jar:na]
at com.emc.d2fs.dctm.servlets.D2HttpServlet.execute(D2HttpServlet.java:243) [D2FS4DCTM-API-4.5.0.jar:na]
at com.emc.d2fs.dctm.servlets.D2HttpServlet.doGetAndPost(D2HttpServlet.java:506) [D2FS4DCTM-API-4.5.0.jar:na]
at com.emc.d2fs.dctm.servlets.D2HttpServlet.doGet(D2HttpServlet.java:116) [D2FS4DCTM-API-4.5.0.jar:na]
at com.emc.d2fs.dctm.servlets.init.LoadOnStartup.init(LoadOnStartup.java:116) [D2FS4DCTM-WEB-4.5.0.jar:na]
at javax.servlet.GenericServlet.init(GenericServlet.java:158) [servlet-api.jar:3.0.FR]
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284) [catalina.jar:7.0.53]
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197) [catalina.jar:7.0.53]
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087) [catalina.jar:7.0.53]
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210) [catalina.jar:7.0.53]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493) [catalina.jar:7.0.53]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.53]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.53]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.53]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632) [catalina.jar:7.0.53]
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073) [catalina.jar:7.0.53]
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) [catalina.jar:7.0.53]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_152]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_152]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_152]
Caused by: java.lang.ClassNotFoundException: com.rsa.jsafe.JSAFE_SecureRandom
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720) [catalina.jar:7.0.53]
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571) [catalina.jar:7.0.53]
... 31 common frames omitted

What’s the cause of this?

When you generate the D2 war file it requires some libraries like the dfs sdk. If you look into the logs you can see what has been added to the war file or at least what is missing. Well, for the sdk 7.x there are 2 libs missing, for generating the D2 war file for the version 4.5:

[copy] Warning: Could not find file /D24.5P29/emc-dfs-sdk-7.3/lib/java/dfc/certjFIPS.jar to copy.
[copy] Warning: Could not find file /D24.5P29/emc-dfs-sdk-7.3/lib/java/dfc/jsafeFIPS.jar to copy.

To resolve the issue, copy these 2 libraries from the 6.7SP2 dfs sdk and paste them into the lib folder of D2.


Cet article Error starting D2 4.5 on Tomcat 8 No class found: JSAFE_SecureRandom est apparu en premier sur Blog dbi services.

Oracle VM x86: Installation walkthrough / step by step for a node/server

Dietrich Schroff - Wed, 2018-02-28 13:11
Last week i tried to setup Oracle VM. For all who are interested, here a short walkthrough.
First the VirtualBox Setup: The VM which should contain the Oracle VM server:

Let's boot:

Next reboot:

 And here we go:

Foreign key constraint DDL & locks

Tom Kyte - Wed, 2018-02-28 12:46
For the period when DDL runs to add FK constraint (on un-indexedcolumn), both child and parent tables are unavailable to be read by 2nd session. Is this behaviour expected / documented? Is there anyway to avoid issue (which manifests in applicati...
Categories: DBA Blogs

How to know the number of records to be retrieved and cost of the query without really executing in the database

Tom Kyte - Wed, 2018-02-28 12:46
Dear Team, I would like to know ,would it be possible to know number of records fetched as well as cost incurred before directly executing the query in the database via SQLPLUS. I have worked with explain plan utility which returns the number o...
Categories: DBA Blogs

USING REGEXP_REPLACE to remove duplicates

Tom Kyte - Wed, 2018-02-28 12:46
Sorted input: <code>select regexp_replace( 'three0, three, two, two, two2, two3, three, three, three, one1, one1', '([^,]+)(,\1)+(,|$)', '\1\3') from dual; three0, three, two, two2, two3, three, one1</code> unSorted input: <code>select regexp...
Categories: DBA Blogs

Writting all DDL statements to file

Tom Kyte - Wed, 2018-02-28 12:46
Hello Tom I need assistance. Wee have not been monitoring database changes at work for our software. This has really become hectic and we have to find a way to track database changes. Every developer has his own database instance, in this case, th...
Categories: DBA Blogs

ORA-04030 when using sqlldr direct path load

Tom Kyte - Wed, 2018-02-28 12:46
I am using sqlldr to load two hundred million data, but after a few minutes I get a "out of process memory when trying to allocate 64544 bytes (sort subheap,sort key)" error , and trace file shows that `sort subheap` used up to 22G memory. Foll...
Categories: DBA Blogs

In JSON query get node key

Tom Kyte - Wed, 2018-02-28 12:46
<code>CREATE TABLE j_computerlist (computer_data CLOB CONSTRAINT ensure_json CHECK (computer_data IS JSON)); CREATE TABLE Mytable ( Computers varchar2(200), Idnumber NUMBER(10), Environment varchar2(200), LastReportTime date, firstcheckin ...
Categories: DBA Blogs

In-memory cursor duration temp tables.

Tom Kyte - Wed, 2018-02-28 12:46
Hi I just ran into interesting article about in-memory cursor duration temp tables: https://oracle-big-data.blogspot.fi/2017/03/this-post-covers-one-of-new-sql.html There was mentioned that this feature is available for 12.2 for 'serial querie...
Categories: DBA Blogs

Oracle Linux 7 UEK5 - preview updated from 4.14.11 to 4.14.20

Wim Coekaerts - Wed, 2018-02-28 09:30

Just as FYI -

latest update of uek5 preview is on https://yum.oracle.com

Oracle Linux 7 Server - Developer preview Unbreakable Enterprise Kernel Release 5

kernel-uek-4.14.20-1.el7uek - The Linux kernel (Update)

This update has a bunch of fixes from us (typically see that with changelog entries containing "orabug" and it pulls in gregkh's stable 4.14.20 tree on top of 4.14.11.

# rpm -q --changelog kernel-uek-4.14.20-1.el7uek | more

Remember - go check http://yum.oracle.com/whatsnew.html on a regular basis, good source to see what's been updated or added.

VirtualBox 5.2.8

Tim Hall - Wed, 2018-02-28 07:50

VirtualBox 5.2.8 has been released.

The downloads and changelog are in the usual places.

I’ve done the installation on my Windows 10 PC at work and it seems fine.

Update: I’ve also done the installation on macOS and Oracle Linux 7 hosts at home and it worked fine.



VirtualBox 5.2.8 was first posted on February 28, 2018 at 2:50 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.


Subscribe to Oracle FAQ aggregator