Feed aggregator

Scoop – First glance of the new Oracle Live SQL?

Marco Gralike - Thu, 2016-11-03 10:12
When I was at OOW this year I saw the new (?) Oracle Live SQL…

Invalid number error

Tom Kyte - Thu, 2016-11-03 10:06
I want to check whether there exist a negative duration or not in table \query:-select Emplid,effdt from batchhr.tr_time_mar_intrfce_tmp where SIGN(NVL( ttef_day,0) )= 2; error is showing invalid number where the data type of ttef_day is varch...
Categories: DBA Blogs

FAST refresh materialize view

Tom Kyte - Thu, 2016-11-03 10:06
Hi, First of all apologies for not putting test case in LiveSQL. I tried but got error ORA-06550: line 1, column 9: PLS-00201: identifier 'SYS.DBMS_SNAPSHOT_UTL' must be declared ORA-06550: line 1, column 9: PL/SQL: Statement ignored whil...
Categories: DBA Blogs

The "C" in 12c

Tom Kyte - Thu, 2016-11-03 10:06
Hi Connor, Could you please provide some link/docs, which explains the "C" in 12c Thanks and Regards, Sandeep
Categories: DBA Blogs

Regarding Dmp File export without partition

Tom Kyte - Thu, 2016-11-03 10:06
Hi, We have a table OA_ODIF_LEG which contains 1292 partitions(Range partition), We are exporting this table daily for business purpose. To reduce Time, We need to export that table without partition. Please guide me on this
Categories: DBA Blogs

Users and Roles

Tom Kyte - Thu, 2016-11-03 10:06
Tom, Could you please tell why in the table ALL_TAB_PRIVS_MADE there are no rows which contains that "I have object privileges for my schema objects"? I have no admin rights and I know that this table mustn't show this information. But why? (My t...
Categories: DBA Blogs

best way to perform huge update

Tom Kyte - Thu, 2016-11-03 10:06
Hi Tom, I need to perform the following operation: - add field to existing table (7b rows and 1Tb size); - update that field by joining with another table that contains the necessary data. I see a number of options, and would like your advi...
Categories: DBA Blogs

When should I use ordered hint

Tom Kyte - Thu, 2016-11-03 10:06
Hi Tom, I have one query that is running for a really long time. I was playing with the ordered hint and I noticed that SQL performs much better..I am not sure why though. Can you please explain a scenario where ordered or leading hint will actuall...
Categories: DBA Blogs

How to archive FGA data (fga_log$)

Tom Kyte - Thu, 2016-11-03 10:06
Hi We have need to audit who has seen personal data in database. Fine Grained Auditing seemed to be good candidate for the job. It is however generating a lot of data, which should be kept for two years. About 10 gb of uncompressed data is ...
Categories: DBA Blogs


Tom Kyte - Thu, 2016-11-03 10:06
How dynamical set ARGUMENT value for a program that is called in the chain step ?
Categories: DBA Blogs

Meta data

Tom Kyte - Thu, 2016-11-03 10:06
Hi, I aasked below question to my friend Why oracle created views for all system tables? and he said to protect the base tables (i.e hiding name by creating view), iam not satisfied with that question because by plsql developer we can know t...
Categories: DBA Blogs

Instance Name changes during RAC One Node Failover/Switchover

Michael Dinh - Thu, 2016-11-03 07:07

Just a quick note to self.


     When the node goes down due to abnormal termination (  kill -9 or due to unknown reasons) Grid Infrastructure performs the following:

  •  First cluster tries to restart the instance in same node.
  •  If it is unsuccessful then it will start the instance in other node.
  •  If the instance name is orcl_1, when it failover to node 2 it will be still orcl_1.


    When Manually switchover is performed for relocating orcl_1 from Node1 to Node 2 (Instance Relocation) Grid Infrastructure performs the following:

  • It will first create pfile( init.ora) automatically in node 2.
  • In node 2 it will use the new pfile and start instance with a new name, i.e. orcl_2, this is due to both instances are required to be up and running for active sessions on the original node to complete or time out.
  • Post switchover, it uses new instance name i.e. orcl_2   


(31-May-2016). Retrieved November 3, 2016, from https://support.oracle.com/epmos/faces/DocContentDisplay?id=1540629.1

Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions

Complete IT Professional - Thu, 2016-11-03 06:00
In this article, I’ll explain how to use the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH functions with some examples. I’ve grouped all of these functions into a single article because they are quite similar and are related functions. Purpose of the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions The purpose of these functions […]
Categories: Development

Will Windows Monthly Rollups Work with EBS?

Steven Chan - Thu, 2016-11-03 02:05

Microsoft logoMicrosoft announced that they will release security and reliability patches in a single Monthly Rollup update instead of as individual patches.  They also announced the availability of a single Security-only rollup. 

This change was effective from October 2016 onwards and applies to:

  • Windows 7 Service Pack 1 (SP1)
  • Windows 8.1
  • Windows Server 2008 R2
  • windows Server 2012
  • Windows Server 2012 R2

Compatibility with Oracle E-Business Suite

Microsoft Monthly Rollups and Security-only updates are intended to be backwards-compatible with all applications. Existing Windows functionality does not change.

It is expected that these updates will be fully-compatible with Oracle E-Business Suite 12.1 and 12.2.  We expect that we will do periodic testing of selected updates, but will do not expect to release regular certification announcements for them. 

EBS customers do not have to wait for explicit certification announcements before applying Microsoft Monthly Updates or Security-only updates to their Windows desktops or servers.

Related Articles

Categories: APPS Blogs

Oracle 12c CRS-4995: The command ‘Modify resource’ is invalid in crsctl.

Michael Dinh - Wed, 2016-11-02 21:23

So there I was playing with 12c Oracle restart and ran into
CRS-4995: The command ‘Modify resource’ is invalid in crsctl. Use srvctl for this command.

For 12c, this expected as crsctl shouldn’t be used to modify ora.* resource.

Couldn’t figure out how to modify resource using svrctl.

However, I did learn about -unsupported for crsctl.

hawk:(SYS@hawk):PRIMARY> show parameter db%name

NAME                                 TYPE                           VALUE
------------------------------------ ------------------------------ ------------------------------
db_file_name_convert                 string
db_name                              string                         hawk
db_unique_name                       string                         sgn_hawk
pdb_file_name_convert                string


$ srvctl add database -db sgn_hawk -o $ORACLE_HOME -p $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora -startoption open -stopoption immediate -dbname hawk



$ cat listener.ora

    (SID_DESC =
      (GLOBAL_DBNAME = sgn_hawk_DGMGRL)
      (SID_NAME = hawk)
    (SID_DESC =
      (GLOBAL_DBNAME = test2)
      (SID_NAME = test2)


$ srvctl add listener -l LISTENER_12C -p TCP:1551 -o $ORACLE_HOME

$ srvctl config database

$ srvctl config listener
Type: Database Listener
Home: /u01/app/oracle/product/
End points: TCP:1551
Listener is enabled.


$ crsctl stat res -t -w "TYPE = ora.listener.type"|grep lsnr

$ crsctl stat res -t -w "TYPE = ora.database.type"|grep db

$ crsctl stat res ora.sgn_hawk.db -p | grep AUTO_START


Why database not startup automatic 11gR2 Grid Infrastructure?

- always: 
Restarts the resource when the server restarts regardless of the state of the resource when the server stopped.

- restore: 
Restores the resource to the same state that it was in when the server stopped. 
Oracle Clusterware attempts to restart the resource if the value of TARGET was ONLINE before the server stopped.

- never: 
Oracle Clusterware never restarts the resource regardless of the state of the resource when the server stopped.


$ crsctl modify resource ora.sgn_hawk.db -attr AUTO_START=always
CRS-4995:  The command 'Modify  resource' is invalid in crsctl. Use srvctl for this command.


crsctl modify ora.* resource fails with CRS-4995 in and above (Doc ID 1918102.1)
Alternative Procedure To Install and Configure ASM On Unix/Linux Configurations (Standalone) (Doc ID 1954213.1)

$ crsctl modify resource ora.sgn_hawk.db -attr AUTO_START=always -unsupported

$ crsctl stat res ora.sgn_hawk.db -p | grep AUTO_START

12c online move datafile in same filesystem.

Yann Neuhaus - Wed, 2016-11-02 16:03

On Linux, when you move a datafile, with “mv” within the filesystem it’s just a rename. There is no copy. In 12c you can move a datafile online where oracle takes care of the move at OS level. But be careful. Even if you are in the same filesystem, moving a datafile online does a copy of the file.

Linux mv

I have a file, /u01/oradata/test1.txt and I move it to /u01/oradata/test2.txt within the same filesystem:

mv /u01/oradata/test1.txt /u01/oradata/test2.txt

Actually, I’m running it with strace, tracing file operations for these files:

strace -e trace=file mv /u01/oradata/test1.txt /u01/oradata/test2.txt

Then I can see clearly that there is no open() call but just a rename():

execve("/usr/bin/mv", ["mv", "/u01/oradata/test1.txt", "/u01/oradata/test2.txt"], [/* 29 vars */]) = 0
stat("/u01/oradata/test2.txt", 0x7ffcfa624270) = -1 ENOENT (No such file or directory)
lstat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
lstat("/u01/oradata/test2.txt", 0x7ffcfa623f20) = -1 ENOENT (No such file or directory)
rename("/u01/oradata/test1.txt", "/u01/oradata/test2.txt") = 0

If I do the same to another filesystem:

strace -e trace=file mv /u01/oradata/test2.txt /u02/oradata/test2.txt

a rename() is attempted:

execve("/usr/bin/mv", ["mv", "/u01/oradata/test2.txt", "/u02/oradata/test2.txt"], [/* 29 vars */]) = 0
stat("/u02/oradata/test2.txt", 0x7fff1e2b3340) = -1 ENOENT (No such file or directory)
lstat("/u01/oradata/test2.txt", {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
lstat("/u02/oradata/test2.txt", 0x7fff1e2b2ff0) = -1 ENOENT (No such file or directory)
rename("/u01/oradata/test2.txt", "/u02/oradata/test2.txt") = -1 EXDEV (Invalid cross-device link)

but because it’s another filesystem, the “mv” command will do like a “cp”, open the source in read and the target in write, creating it if not exist:

unlink("/u02/oradata/test2.txt") = -1 ENOENT (No such file or directory)
lgetxattr("/u01/oradata/test2.txt", "security.selinux", "unconfined_u:object_r:unlabeled_t:s0", 255) = 37
open("/u01/oradata/test2.txt", O_RDONLY|O_NOFOLLOW) = 3
open("/u02/oradata/test2.txt", O_WRONLY|O_CREAT|O_EXCL, 0600) = 4
newfstatat(AT_FDCWD, "/u01/oradata/test2.txt", {st_mode=S_IFREG|0644, st_size=0, ...}, AT_SYMLINK_NOFOLLOW) = 0
unlinkat(AT_FDCWD, "/u01/oradata/test2.txt", 0) = 0

Move datafile

Let’s do the same from the database where I’ve created the same datafile:

SQL> create tablespace DEMO datafile '/u01/oradata/test1.txt' size 5M;
Tablespace created.

I get my shadow process PID:

SQL> set define %
SQL> column spid new_value spid
SQL> select spid from v$process join v$session on paddr=addr where sid=sys_context('userenv','sid');
SQL> host ps -fp %spid
oracle 7257 7256 93 21:35 ? 00:00:03 oracleCDB1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

and run strace on it:
SQL> host strace -o /tmp/tmp.log -e trace=file -p %spid &
I move the file online to the same filesystem:

SQL> alter database move datafile '/u01/oradata/test1.txt' to '/u01/oradata/test2.txt';
Database altered.

and read the trace:
grep /test /tmp/tmp.log

stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
open("/u01/oradata/test1.txt", O_RDONLY) = 11
stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
open("/u01/oradata/test1.txt", O_RDONLY) = 11
stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
statfs("/u01/oradata/test1.txt", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=3063586, f_bfree=1014477, f_bavail=853095, f_files=786432, f_ffree=672545, f_fsid={1366374386, -1275721753}, f_namelen=255, f_frsize=4096}) = 0
open("/u01/oradata/test1.txt", O_RDONLY) = 11
open("/u01/oradata/test1.txt", O_RDWR|O_DSYNC) = 11
stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
statfs("/u01/oradata/test1.txt", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=3063586, f_bfree=1014477, f_bavail=853095, f_files=786432, f_ffree=672545, f_fsid={1366374386, -1275721753}, f_namelen=255, f_frsize=4096}) = 0
open("/u01/oradata/test1.txt", O_RDONLY) = 11
stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
statfs("/u01/oradata/test1.txt", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=3063586, f_bfree=1014477, f_bavail=853095, f_files=786432, f_ffree=672545, f_fsid={1366374386, -1275721753}, f_namelen=255, f_frsize=4096}) = 0
open("/u01/oradata/test1.txt", O_RDONLY) = 11

At this point the source datafile is opened in read. It continues with:

open("/u01/oradata/test2.txt", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/u01/oradata/test2.txt", 0x7ffd0201e5d8) = -1 ENOENT (No such file or directory)
open("/u01/oradata/test2.txt", O_RDWR|O_CREAT|O_EXCL|O_SYNC, 0660) = 11

and now the destination datafile in write, created if not exist (existence had been tested before). Then it starts the copy:

stat("/u01/oradata/test2.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
stat("/u01/oradata/test2.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
open("/u01/oradata/test2.txt", O_RDONLY) = 11
stat("/u01/oradata/test2.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
open("/u01/oradata/test2.txt", O_RDONLY) = 11
statfs("/u01/oradata/test2.txt", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=3063586, f_bfree=1014475, f_bavail=853093, f_files=786432, f_ffree=672544, f_fsid={1366374386, -1275721753}, f_namelen=255, f_frsize=4096}) = 0
open("/u01/oradata/test2.txt", O_RDONLY) = 11
open("/u01/oradata/test2.txt", O_RDWR) = 11
open("/u01/oradata/test2.txt", O_RDWR|O_DSYNC) = 11

at the end, because I didn’t use the ‘KEEP’ option, so the source file is deleted:

stat("/u01/oradata/test1.txt", {st_mode=S_IFREG|0640, st_size=5251072, ...}) = 0
unlink("/u01/oradata/test1.txt") = 0
stat("/u01/app/oracle/diag/rdbms/cdb1/CDB1/log/test", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0

So what?

As any online move operation, you need two times the space during the copy. Here, the source file is still used for read and write until the move finishes, so this cannot be a rename. A rename would have to put the datafile offline even for a short time. If you can afford a small downtime, then you may prefer to use the offline rename (“mv” at OS level, ALTER DATABASE RENAME FILE at database level).


Cet article 12c online move datafile in same filesystem. est apparu en premier sur Blog dbi services.

Momentum16 – Day 2 – C6, Load Testing and REST API

Yann Neuhaus - Wed, 2016-11-02 13:27

So today is the second day of the Momentum 16 in Barcelona and as expected, this day contained many more technical presentations and discussions than the first day. I attended several interesting presentations and hackathon/hands on sessions as well so I haven’t really had time to rest today.


So first thing in the morning, I started with a two hours hackathon session related to how it is possible to augment Documentum reliability and performance. This hackathon was lead by Henrik Rexed from Neotys. This company is actually providing Neoload, which is a load and performance testing tool that realistically simulates user activity and monitors infrastructure behavior so you can eliminate bottlenecks in all your web and mobile applications. This Load Test solution isn’t related to Documentum so you can actually Load Test everything but they do have some experience with Documentum which makes it even better. In this session, Henrik presented us the methodology that should be used to load test and monitor each and every application starting during the project phase with Unit Testing and Unit Load to ends up with complete SLA verifications by Load Testing the whole application. One thing that it is important to note and remember is that Load Testing each and every component one by one is good but that’s not enough. Sometimes, your system will break only when all components are solicited all together and that’s what you should test in the end!


After that, I attended a session presented by Mirko Weller (Volkswagen) and Christian Meier (fme) related to how 60k users are accessing the Documentum Platform at Volkswagen. This wasn’t actually a technical presentation but I wanted to follow it because we, at dbi services, are also managing a similar Documentum Platform at one of our customers with so many users and environments/instances that I thought it would be good to compare a little bit with what others are doing and to exchange feelings and ideas about how to improve our Platform.


Finally at the end of the morning, I attended a session about how to provide the right interface to your users at the right time. Boris Carbonneill (C6) and Hugo Simon-Chautemps (Sanofi) presented us the “C6 Mobile” application, the “C6 Office” interface as well as their “any” solution. The purpose of these three products is to help your users accessing their documents whenever they want with the best possible user’s experience. I actually found these applications/UIs quite good. There is a good balance in the sizing, colors, features displayed, aso…

  • The C6 Mobile application can be used to access documents while traveling directly using your phone and it can be used to quickly review/approve your tasks.
  • The C6 Office is actually an add-in for Microsoft Office, PowerPoint and Excel that lets you create/update documents based on templates defined in D2 and rules/permissions/acls defined in D2-Config without having to launch an internet browser. What you have to do is just to start Office, connect to the repository and work directly inside Microsoft’s application. For the moment it is apparently not working for Outlook. Maybe a future version?
  • The any solution can be used in the Cloud to merge all kind of repositories coming from Documentum, SharePoint, OpenText (and more) and store all that in one place. This solution actually makes me thing to InfoArchive which is providing similar thing and some other/different features… You can synchronize documents from D2 to the Cloud to share them with external people for example or just do that so that you will have a duplicate copy in case it is needed (E.g.: copying IQs/OQs/DR/IT stuff to the Cloud might be a good idea in case there is a Disaster and your DMS isn’t there anymore, then you would still have enough to actually execute and document your Disaster Recovery!)


Beginning of the afternoon, I followed another two hours hackathon on the following subject: Developing Custom Applications with Documentum APIs. I’m not a Documentum developer but I wanted to do this hackathon so I can learn some stuff related to the Documentum REST API and it was a good session. There were three different levels for this hackathon: beginner, intermediate and advanced. I choose the intermediate one and I had to build an application using Angular and the Documentum REST API. That was actually pretty funny and I was able to play with the APIs calls, aso… Really cool.


This concludes the summary of the second day. See you tomorrow for the third and last one!


Cet article Momentum16 – Day 2 – C6, Load Testing and REST API est apparu en premier sur Blog dbi services.

Momentum16 – Day 2 – What’s new in Documentum 7.3 ?

Yann Neuhaus - Wed, 2016-11-02 13:24

As described in my last post related to Momentum 16, I was excited to see the session “What’s new in Documentum 7.3″. Do not worry, I could slept last night. But are my expectations fulfilled?


So yesterday I wrote about PostgreSQL which will decrease the cost of the DB licensing and then your TCO. It seems that based on benchmarks, there is still some place for small improvements to have the same performance as with traditional DBs. Dell EMC is working on it with the PostgreSQL experts. Let’s see with real case and based on the applications usage.


So a lot of news have been described. In this post, I will list some of them which will help me and my team to deliver even better service. Of course this has to be tested and see if those news can really be applied on our customer’s platforms.

  • Docker and Documentum: starting with Documentum 7.3, docker is now supported. Not only the Content Server but also D2, xCP, aso… So I guess this could help us when we have to build a platform. Using docker images as templates for the Content Server, D2 and their web servers for instance.
  • Renaming repository name: this can be helpful in case you build a docker image which can then be used as a template for your Content Server
  • Renaming Docbase ID: same as for the previous point. Building a docker image, using it for a container, changing the docbase name and ID to have the Content Server and repositories installed as you need.
  • Changing the installation owner: can this be used in case you have to move one repository to another Content Server installation where the installation owner is not the same? This has to be studied and tested…
  • Dormant State for non-Admins: With this new feature you can work on your repository but the normal users cannot access it. So for maintenance tasks, I think this can be helpful too.
  • Upgrade process without touching the database: this should decrease the upgrade time.
  • JDK update tool: with this tool, the JDK patches and security update can be applied. This can not be used to upgrade to a new major version (like from Java 7 to Java 8).
  • Xplore 1.6: fast search within folders, non admin reports are some enhancements in the fulltext area.
  • UCF will no more be used, this is replaced by an Applet-free transfer where there is no more dependencies with the JRE plugin or applet.


In addition to that, SAML 2.0 Single Sign-On, Cross Forest Kerberos, more REST Services, CMIS 1.1 are also some new features coming with Document 7.3! So I hope that we can download this new version in few weeks so we can play with, do tests and see how this can fit with our daily work and future visions.


Now two questions:

  •  Are my expectations fulfilled?
    I would say yes at 90%. Regarding the remaining 10%, I talked to the Content Server and D2 product managers and they were able to give me some answers which comfort me for the future.
  • Am I more exited now compared to yesterday, waiting for the session? I guess yes :-)


New tasks and challenges are coming…


Cet article Momentum16 – Day 2 – What’s new in Documentum 7.3 ? est apparu en premier sur Blog dbi services.

Whatever next? The battle to keep up with changes in technology

Rittman Mead Consulting - Wed, 2016-11-02 10:00

I’ve been managing Rittman Mead’s Training services in the UK & Europe for over a year now, working closely with my colleagues in the US to ensure we continue to coherently deliver expert instructor led educational courses to the very highest standards.

One thing I’ve noticed is that while a great deal of value is gained by attending instructor led training, particularly if you’re upgrading or installing a new product to your data platform, you can find that two or three months down the line a new version is released which comes with new features and functions that weren’t previously taught.

Take OBIEE 12c for example, it first hit the shelves back in October 2015 and we are now on the 3rd release. In the last year, we’ve seen additions such as Data Visualization Desktop (see my friend Francesco’s recent blog post) and the ability to incorporate even more data sources to your OBIEE system (see my friend Matt’s new features guide!)

At Rittman Mead, we’ve been working on a service which we believe will complement our customer’s initial investment in instructor led training sessions. While we always wish to retain an open line of communication with everyone we have trained in the past, we realise that offering contemporary content that’s more attuned to end-users everyday roles is beneficial and necessary.

Our on-demand training service will offer top-up courses as well as our current catalog of training. It's designed to fit around users’ busy schedules with self paced learning to help people get the best out of their investment in new technology.

For more information including sneak peeks & early bird offers for our on-demand training services, please register your details here.

#mc_embed_signup{background:#fff; clear:left; font:14px Helvetica,Arial,sans-serif; } /* Add your own MailChimp form style overrides in your site stylesheet or in this style block. We recommend moving this block and the preceding CSS link to the HEAD of your HTML file. */
Categories: BI & Warehousing


Subscribe to Oracle FAQ aggregator