Feed aggregator

Oracles Free TNS Firewall - VALIDNODE_CHECKING

Pete Finnigan - Tue, 2020-03-31 22:26
I said in a post a couple of days ago that my overall plan to secure an Oracle database; actually my plan is to secure the data in an Oracle database not blindly just secure Oracle. We must focus on....[Read More]

Posted by Pete On 31/03/20 At 12:26 PM

Categories: Security Blogs

How To: Reduce Cloud Bill in Half for Any Cloud Provider

Pakistan's First Oracle Blog - Tue, 2020-03-31 17:09
“But you said, we would be only paying what we use then how come my Cloud bill is way more than my on-prem cost?”
Managements are now asking above question from Cloud Operations team all across the globe as recession looms, revenues drop, businesses almost to a standstill, budgets shrunk and economic outlook becoming grimmer by the day.

Above statement about Pay-as-you-go is still true about the cloud but it doesn’t happen just by migrating to cloud. It has to be configured, monitored, managed and audited. If you start a virtual machine in the cloud, use it for 9 to 5, leave it running until next morning, then you will be charged for 24 hours instead of just from 9 to 5 where you were supposedly “using” it. Running in cloud means using, and you pay for it. Same is also true for managed database services in the cloud.
Following are top 3 things you can do right now to significantly reduce your cloud bill.
  1. Control Resource Creation:
Resource Creation privileges must be given to a handful team in your organization, and this team should be doing it through pipeline after proper approvals. So revoke resource creation rights from everyone else, and let one team be doing it through pipeline with a single click.
2. Tag Resources
Tag your resources, and no resource in cloud should live without following tags:
StartTime, StopTime, LifeSpan
These tags are self-explanatory. StartTime will tell, when this resource will start, when it will stop, and how long this will remain in cloud. You can either write your own serverless functions to enforce these timings, or use any third party or cloud-native solution to implement it. (Drop me a line, if you want further guidance on this). This point is a game-changer for your bill especially for VMs and managed databases.
3. Remove the Clutter
No matter how little it costs; if its not needed or you cannot find the owner, just delete it. Orphan persistent disk volumes, ownerless compute images, dangling object stores, and all stray services must be stopped and deleted.
If followed, these 3 points can reduce your cloud bill to half or even more in any cloud provider setup. Cloud’s honeymoon period is over, and with all this belt tightening around, its time to save.
Categories: DBA Blogs

Oracle Offers Free HR Tool to Help Customers Keep Employees Safe

Oracle Press Releases - Tue, 2020-03-31 08:00
Oracle Offers Free HR Tool to Help Customers Keep Employees Safe

By Gretchen Alarcon, Oracle—Mar 31, 2020

As we continue to face increasing concerns about COVID-19, many organizations and HR professionals are facing new and unprecedented challenges.

In an effort to help, we are providing free access to our Workforce Health and Safety solution to current Oracle Human Capital Management Cloud customers. This module will help our customers manage key workplace health and safety issues and answer critical response questions, including:

  • Who in my organization has been exposed to the virus?
  • Have the communal areas of the buildings been appropriately cleaned?
  • Do we have adequate supplies for cleaning and for protecting staff?
  • How do I reach staff to let them know an incident has occurred?
  • Do I need to notify local public health authorities? What data should I share?
  • How can I be sure we have followed up on an incident, and implemented corrective action?

Employees can access this information wherever and however they need—from mobile to desktop devices—and we think of this module as an “incident response button”. It provides HR professionals and managers with a number of ways to help take the necessary actions to help keep employees safe.

For instance, as a manager, I typically know what to do when someone calls in sick. But under the current circumstances, once I’ve helped that individual, I also have to think about what I need to do to protect his/her coworkers and the company as a whole.

Our Workforce Health and Safety module helps automate reporting of workplace incidents both now and in the future, as we adapt to heightened health and safety concerns. For example, consider the task of reporting when a conference room hasn’t been cleaned overnight. Under ordinary circumstances, such an incident might not be a top priority, but under the current circumstances, it’s critically important for it to be reported and for action to be taken immediately.

Once an employee or HR manager reports an incident, the system immediately routes the incident to whoever is assigned to remediate it and act. It also sends an email confirmation to the employee who reported the incident, noting the report has been received and is being acted upon.

In addition to providing an easy, effective, and confidential process for handling health and safety matters, our Workforce Health and Safety module also gives reassurance that reports are being appropriately acted upon.

At Oracle, we are committed to helping our customers get up to speed with Workforce Health and Safety as quickly as possible. We will be providing a white paper with step-by-step instructions for configuring basic incident reporting and will also hold virtual “office hours” through the end of April to assist with configuration.

During this time of unprecedented uncertainty, we want to do everything possible to help and we want you to know that you can continue to count on us to support your changing business needs.  

Other Resources

Customers can download and modify sample reports from Customer Connect:  https://cloudcustomerconnect.oracle.com/posts/ab7d3058b0

CDC: Interim Guidance for Businesses and Employers https://www.cdc.gov/coronavirus/2019-ncov/specific-groups/guidance-business-response.html

OSHA: 10 Ways to Get Your Safety Program Started https://www.osha.gov/shpguidelines/ten-easy-things.html

OSHA: Recommended Practices for Safety and Health Programs https://www.osha.gov/shpguidelines/worker-participation.html

Workforce Health & Safety Cloud Service Documentation https://docs.oracle.com/en/cloud/saas/human-resources/20a/fawhs/index.html

Gretchen Alarcon is group vice president for Oracle’s human capital management strategy.

Free Oracle Learning and Certifications for OCI and Autonomous database - Limited period

Syed Jaffar - Tue, 2020-03-31 05:57
Hello All,

Oracle announced a limited period free access to Oracle Learning and Certifications on OCI and Autonomous Database technologies. 
Its absolutely free of cost for everyone. Indeed it is a very good chance everyone to learn something new to update Oracle knowledge and get certified. Use the below Oracle link for enrolling to courses and certification:


All the very best and happy learning.

Distributed and in-doubt transactions

Tom Kyte - Tue, 2020-03-31 04:06
Hello Ask Tom, Team. I am struggling with distributed transactions. Oracle RAC 18c (18.6) and .NET app. I want to know a few things: The RECO background process of an Oracle Database instance automatically resolves failures involving distri...
Categories: DBA Blogs

Uploading files in a Rest webservice using PlSql UTL_HTTP

Tom Kyte - Tue, 2020-03-31 04:06
Hi, I'm calling REST web services using PLSQL UTL_HTTP package, in JSON, with no problems. However, now i need to invoke a WS but attaching a file. I can do it with Postman in ?form-data? mode. In PLSQL, I've tried the same thing in the...
Categories: DBA Blogs

OGG-02030 Failed to set logmining server parameters back to default val

Tom Kyte - Tue, 2020-03-31 04:06
I`ve try to start integrated Extract: <code>REGISTER EXTRACT EXTR_R DATABASE ADD EXTRACT EXTR_R, INTEGRATED TRANLOG, begin now ADD EXTTRAIL ./dirdat/lt, EXTRACT EXTR_R START EXTRACT EXTR_R</code> with param file: <code>Extract EXTR_R USERIDA...
Categories: DBA Blogs

What happens when there is no space in 1 diskgroup in ASM?

Tom Kyte - Tue, 2020-03-31 04:06
Hi, We have DB that is using ASM with normal redundancy. The space consumption is really high. There was an occasion when almost 1 TB space was consumed in a month. We have been adding disks when there the remaining space gets really low. Now, we ...
Categories: DBA Blogs

500 internal server error

Tom Kyte - Tue, 2020-03-31 04:06
We have an application in Oracle APEX where we do not have a large database and the number of pages used in the application would be max 250. However, there is a 500 Internal Server error that we are encountering since the last 3-4 days and we have n...
Categories: DBA Blogs

Analytic Functions Drawbacks

Tom Kyte - Tue, 2020-03-31 04:06
Hi Tom, Analytic functions are really cool, and I can see great benefits from using it. Despite its benefits, does Analytics Functions has any drawbacks, like performance issues, or any details one should be aware of when choosing to use analytics...
Categories: DBA Blogs

Oracle Ramps Up Free Online Learning and Certifications for Oracle Cloud Infrastructure and Oracle Autonomous Database

Oracle Press Releases - Mon, 2020-03-30 12:00
Oracle Ramps Up Free Online Learning and Certifications for Oracle Cloud Infrastructure and Oracle Autonomous Database

By Raghu Viswanathan, Vice President of Education Products and Delivery, Oracle University—Mar 30, 2020

Juergen LindnerI’m happy to announce that Oracle is offering free access to online learning content and certifications for a broad array of users for Oracle Cloud Infrastructure and Oracle Autonomous Database. This program kicks off on Monday, March 30, 2020, and will be available until May 15, 2020.

Starting now, any user, including developers, technical professionals, architects, students and professors, will have quick and easy access to more than 50 hours of online training and 6 certification exams.

Oracle University will provide users with free access to an extensive library of materials for Oracle Cloud Infrastructure and Oracle Autonomous Database, as well as content related to topics such as data science, machine learning, and multi-cloud environments such as integration with Microsoft Azure.

We’re making high-quality videos, access to subject matter experts, and recorded demos of hands-on labs available anywhere, anytime so IT pros can accelerate their learning and gain highly sought-after skills. Machine translation (sub-titles only) will also be available for Chinese, Japanese, Korean, Portuguese, and Spanish speaking countries for all the videos.

As our customers adapt to a rapidly evolving digital landscape, Oracle is stepping up its efforts to help build critical technical cloud skills they need to ramp up innovation. We believe that certifications help professionals develop in-demand skills, shorten turnaround times for customer projects, enhance their expertise and advance their careers, while improving their overall job performance. 

Start learning and get certified in three easy steps:

Step 1: Get a free Oracle Single-Sign-On (SSO) account. If you have an SSO, skip to Step 2

  • Click on Hello. Log In. (See far right corner of the page).
  • Select “Create an account” and fill in the required fields.
  • Verify account via email.

Step 2: Access learning paths through the links below:


Step 3: Register and take your free certification exam. If you have a PearsonVue account, log in.

  • If not, choose “Create a web account” on the right side of the page and follow instructions.

This initiative builds on a recent Oracle announcement of free training resources for cloud developers. Learn more about Oracle University and other training available.

Raghu Viswanathan is Vice President of Education Products and Delivery for Oracle University. He joined Oracle as a software engineer in 1990 and led Operations, Marketing and Sales Readiness before taking on his current role overseeing all Content, Delivery, Certification, Renewals, IT, and Development.

January 2020 Patches Not In Recommended Patch Advisor

Bobby Durrett's DBA Blog - Mon, 2020-03-30 10:58

Every quarter I download the latest patch set from Oracle’s support site by using the Recommended Patch Advisor. But the January 2020 patch sets did not show up. The RPA still recommends the October 2019 patch sets. The Recommended Patch Advisor is one of the options under the Patches and Updates tab in Oracle’s support site. I tried searching Oracle’s support site and Googling but did not find any answers. I am sure that the information is out there somewhere but the way I was searching for it did not find it. So, I thought I would post a quick note about it. The short answer is that you should use this Oracle support document to find the latest patch sets and not the Recommended Patch Advisor:

Master Note for Database Proactive Patch Program (Doc ID 756671.1)

To find this out I had to open an SR with Oracle Support. They quickly identified this document which explained the situation:

My Oracle Support: Patch and Health Recommendations No Longer Supported (Doc ID 2644769.1)

Note 2644769.1 seems to say that the Recommended Patch Advisor will continue to refer to the October 2019 patches until Oracle removes the RPA from their support site in May.

The funny thing is that I knew we had an internal document that a coworker and I had both contributed to that describes how to download the latest patch set and apply it to a database to create a tar or zip that we could use to deploy a new database. I decided to modify that document to refer to note 756671.1 and remove references to the RPA. To my surprise my coworker had already included note 756671.1 months ago in our instructions and not the RPA. I think that Oracle support must have recommended the note some time ago, but I was still using the advisor. I guess you learn something new every day.

Anyway, note to self: don’t use the Recommended Patch Advisor to find the quarterly patch updates. Use note 756671.1.


Categories: DBA Blogs

Add A SQL*Net Security Banner And Audit Notice

Pete Finnigan - Mon, 2020-03-30 09:46
I would have to say whilst I see security banners on customers Unix boxes when I am allowed to log in as part of a security audit I canot ever remember seeing a security banner when I log into a....[Read More]

Posted by Pete On 30/03/20 At 02:02 PM

Categories: Security Blogs

Ethiopian calendar support

Tom Kyte - Mon, 2020-03-30 09:46
In oracle databse 12c it says it suppirt ethiopian calander.in my database I have one employee table in that I have one column hiredate which date data type until i want to insert ethiopian calander date type data how it is possible?
Categories: DBA Blogs

ADD_MONTHS Function returning last day of the month

Tom Kyte - Mon, 2020-03-30 09:46
The question I have is regarding the ADD_MONTHS function. The live sql link for the test case is as below:- https://livesql.oracle.com/apex/livesql/s/JT1FDGOHXMRWN3LG94GEYLMPJ If we have a look at this link it has 3 components:- 1. A function ...
Categories: DBA Blogs

UTL_FILE write and User permission in Unix directory

Tom Kyte - Mon, 2020-03-30 09:46
I am using UTL_FILE.FOPEN('Unix_Directory_path','FileName.txt','w') in my Pl/Sql package and the file is getting written successfully but the User and permission are different than the file generated using SPOOL, both are using the same batch file in...
Categories: DBA Blogs

Combine create and insert with if-then or case-when in sql?

Tom Kyte - Mon, 2020-03-30 09:46
Hello people, I would like to ask for your help with a simple issue. I am srry if this is too common, but for me it is not easy at all: I have a table like this - p.sometable: <code> ID AMOUNT YEAR cusomter1 42476281.61 ...
Categories: DBA Blogs

No data found extracting information from xml

Tom Kyte - Mon, 2020-03-30 09:46
Why can't you find data in an XML when I have proof of its existence?
Categories: DBA Blogs

Index Rebuild for just 1 partition

Tom Kyte - Mon, 2020-03-30 09:46
Hi, We have partitions in our table. We want to build index for just one partition. If we do that, then does it affects the application? One time we got an error like index in unusable state. First we create index in unusable state like: <code>C...
Categories: DBA Blogs

Paginated queries

Tom Kyte - Mon, 2020-03-30 09:46
Bello, Ask Tom Team. I need to build a report that connects to a 18c Oracle database. There are big tables and I need to paginate the results. I want to show 50 rows per page in the report. I have read about Fetch, Offset features since Ora...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator