Feed aggregator

Webcast: "12.2 Technical Upgrade Overview and Process Flow"

Steven Chan - Wed, 2017-03-29 10:08

EBS 12.2 upgrade webcastOracle
University has a wealth of free webcasts for Oracle E-Business Suite. 
If you're looking for an overview of how to optimize your EBS 12.2 installation, see:

Udayan Parvate, Senior Director Release Engineering, Quality and Release Management, shares a high level overview of the 12.2 technical upgrade and the sequence of technical steps to follow in the 12.2 upgrade process. This material was presented at Oracle OpenWorld 2015.

 

Categories: APPS Blogs

Oracle Unveils Industry-First Cloud Converged Storage to Help Organizations Bridge On-Premises and Oracle Cloud Storage

Oracle Press Releases - Wed, 2017-03-29 10:00
Press Release
Oracle Unveils Industry-First Cloud Converged Storage to Help Organizations Bridge On-Premises and Oracle Cloud Storage Organizations Can Seamlessly Merge Oracle Storage Cloud Functionality and Economics with the Power of High Performance Oracle ZFS Storage Appliances

Redwood Shores, Calif.—Mar 29, 2017

Oracle today unveiled the industry’s first Cloud Converged Storage, representing the first time a public cloud provider at scale has integrated its cloud services with its on-premises, high performance NAS storage systems. Oracle ZFS Cloud software, included in the latest Oracle ZFS Storage Appliance release, enables organizations to easily and seamlessly move data and/or applications to the cloud to optimize value and savings, while eliminating the need for external cloud gateways and avoiding the costs of software licenses and cloud access licenses—AKA “cloud entrance taxes”—charged by legacy on-premises vendors for the right to access the public cloud from their infrastructure platforms. As an example, Oracle’s total cost of ownership versus one industry competitor was 87 percent less.*

Oracle’s approach removes the burden on users to do their own on-premises to public cloud integration, manage environments comprised of different security requirements, support teams, industry standards, and skill sets, as well as the struggle with end-to-end visibility, diagnostics and support. Oracle is, in fact, the only company that can bring the two worlds together as one co-engineered solution. On-premises NAS storage providers cannot offer this level of convergence and economic benefits as they lack a public cloud, and public cloud providers lack on-premises high-performance NAS storage systems.

“With its ZFS Cloud, Oracle simultaneously challenges not only public cloud providers that cannot deliver on-premises, high-performance storage systems, but also traditional hardware vendors that lack truly integrated public clouds,” said Mark Peters, Practice Director & Senior Analyst, Enterprise Strategy Group. “Oracle is delivering business value with a genuine hybrid data ability with a ‘cloud insurance option’ built right into the storage system, significantly streamlining users’ experiences.”

“Cloud is forcing IT practitioners to rethink their organization’s infrastructure to accommodate current technology while future-proofing their business for tomorrow,” said Steve Zivanic, Vice President, Storage, Converged Infrastructure, Oracle. “By converging the Oracle ZFS Storage Appliances with Oracle Storage Cloud, organizations benefit from the highest performing storage systems for their on-premises needs, while seamlessly extending them to Oracle Cloud resources when necessary. Oracle ZFS Cloud is the unifying enabler that helps customers bridge the gap between their current infrastructure and plans for broader public cloud adoption.”

The convergence of the company’s Oracle Storage Cloud with its high-performance Oracle ZFS Storage Appliances—the storage foundation for Oracle Public Cloud and IT with over 1 exabyte installed—empowers users with the performance of flash and the agility, simplicity and elastic scaling of the Oracle Storage Cloud. Oracle customers can use Cloud Converged Storage for elastic application storage, back-up and recovery, development, testing, active archive storage, snapshot replica storage, Dev Ops with a single API for both on-premises and in the Oracle Storage Cloud, and lift-and-shift workload migration. Modern applications can leverage data both in on-premises high performance Oracle ZFS Storage Appliances and in the Oracle Storage Cloud without any application changes.

The latest update also includes a series of Oracle ZFS Storage Appliance innovations that extend Oracle Database dynamic automation capabilities and increase Database Administrator productivity by 10X as well as add all-flash pools to accelerate critical business applications. Enhancements include the following:

  • Oracle Intelligent Storage Protocol 2.0 Delivers Next Generation Automation for Oracle Database and Oracle ZFS Storage Appliance: brings new capabilities that increase Oracle Database performance, decrease manual storage tuning through automation, and simplify database storage optimization. Developed collaboratively between the Oracle Database and Oracle ZFS Storage Appliance engineering teams, it prioritizes IOs based on database hints, effectively increases online transaction processing per minute by up to 19-percent, Oracle Database RMAN backup performance by up to 33 percent, latency-sensitive control file IO performance by up to 13x, and log writer IO performance by up to 3.9x—all without database or storage administrator intervention.
  • All-Flash Storage Pools Improve Application Performance: flash storage pools that boost performance for any application are now available and offer seamless scalability from 16TB to 2.4PB of capacity and over 34GB/second of throughput, regardless of access protocol. These systems accelerate database performance, deliver low latency for critical applications while reducing energy resources and needed datacenter space.
  • Cloud-Scale Data Protection: Oracle ZFS Storage Appliance delivers market-leading data backup, with over 62TB per hour, and data restore, with over 60TB per hour, performance over Infiniband, Ethernet, and Fibre Channel. This latest software release extends Oracle’s leadership in data protection with innovations in data reduction and data mobility. New data reduction technology reduces the backup storage footprint by up to 9x and bandwidth demands by up to 4x with advancements in deduplication and compression. In addition, enhanced data mobility technology increases the amount of data that can be securely distributed to multiple locations by up to 2x with advancements in replication, intelligent data reduction, and remote data distribution security.

Oracle ZFS Storage Appliance is trusted by the world’s leading financial services companies, telcos, semiconductor companies, oil & gas and media & entertainment companies for its extreme performance and massive levels of sustained bandwidth for data-intensive applications in the cloud and on-premises.

Oracle Cloud

Oracle Cloud is the industry’s broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data.  The Oracle Cloud delivers nearly 1,000 SaaS applications and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world and supports 55 billion transactions each day.

For more information, please visit us at http://cloud.oracle.com.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

*A 5-year TCO comparison of one petabyte of on-premises capacity and two petabytes of cloud public storage is 87% less with ZFS Backup Appliance and Oracle Storage Cloud versus Dell EMC Data Domain and its cloud licensing scheme.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Kristin Reeves

  • +1.415.856.5145

Blue Shield of California, Family Health Network, and Health Car

Oracle Press Releases - Wed, 2017-03-29 10:00
Press Release
Blue Shield of California, Family Health Network, and Health Car Complete cloud solutions help healthcare insurers deliver affordable healthcare through improved financial functions

Redwood Shores, Calif.—Mar 29, 2017

Oracle today announced that Blue Shield of California, Family Health Network (FHN), and Health Care Service Corporation (HCSC) have selected Oracle Cloud Applications to help them provide healthcare coverage at an affordable cost by digitizing and modernizing their financial, planning and budgeting systems, and business processes. With Oracle Cloud solutions for finance, these organizations have the tools needed to be able to achieve the speed and flexibility required to support and scale with the healthcare industry’s rapidly changing needs.
 
Oracle Enterprise Resource Planning (ERP) Cloud help organizations simplify and streamline operations with increased visibility and insights into financial and operations. By reducing IT complexity and costs, organizations can also increase productivity, by freeing employees to help provide their insured members with the best and most affordable health insurance plans.
 
Health Insurance Organizations Move to the Cloud
 
Blue Shield of California chose Oracle ERP Cloud to support more than four million health plan members and nearly 65,000 physicians. The move to Oracle ERP Cloud has allowed Blue Shield of California to streamline hundreds of application interfaces and reports, which has stabilized the monthly close. With Oracle ERP Cloud, Blue Shield of California expects improved financial analysis to enable cost savings for policy holders.
 
“When we looked at transforming our technology, we observed our competitors moving to the cloud, and for good reason,” said Michael Sheils, VP, corporate shared services fin.  “After a careful evaluation, we selected Oracle as our partner because of their commitment to innovation in the cloud, their expertise in the health payer space, and the breadth and depth of the ERP Cloud offering.”
 
Improved financial efficiency was the primary driver for Family Heath Network to select Oracle ERP Cloud. A not-for-profit provider sponsored health plan in the Chicago area, FHN is one of the largest managed care plans in the region under the Medicaid Family Health Plan. In evaluating a new financial system, FHN decided a move to the cloud was the best approach in order to best streamline operations and upgrades.
 
“In insurance, clear finance reporting is critical in order to process claims as quickly as possible,” said Nirav Shah, vice president of finance at Family Health Network. “Oracle ERP Cloud is a valuable tool for our company, streamlining our financial operations, while also maximizing business performance and growth.”
 
As changes in the financial reporting structure and lengthening close times began to impact HCSC, they recognized that cloud technology could help them to remain agile and quickly react to future changes. The largest customer-owned health insurer in the United States, HCSC selected Oracle ERP Cloud to help transform its financial systems and support its 22,000 employees serving more than 15 million members across five states, with the functionality, breadth, and depth of the Oracle Cloud.
 
“We evaluated vendors based on several drivers, including strategic fit, capability, maturity, vendor commitment and support, employee feedback, and implementation considerations,” said James Kadela, SVP controller at HCSC. “Oracle ERP Cloud was the natural choice based on the nature of HCSC’s financial systems. In addition to its current capabilities, Oracle is heavily investing in research and development and we feel confident that Oracle ERP Cloud will evolve with us to support our long-term business strategy.”
 
“Oracle is committed to supporting the healthcare industry with our complete, secure, and modern set of enterprise-grade cloud applications that help healthcare payers provide affordable health insurance to their communities,” said Terrance Wampler, vice president of financials applications strategy at Oracle. “Our connected, best of breed ERP Cloud solutions are uniquely placed to cater to dynamic business environments and enable our customers to modernize core financial operations, empower its people, and support growth.”
 
Oracle Cloud delivers the industry’s broadest suite of enterprise-grade cloud services, including software as a service (SaaS), platform as a service (PaaS), infrastructure as a service (IaaS), and data as a service (DaaS).
 
Contact Info
Joann Wardrip
Oracle
+1.650.607.1343
joann.wardrip@oracle.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Get Started
Talk to a Press Contact

Joann Wardrip

  • +1.650.607.1343

OUD – Oracle Unified Directory 11.1.2.3 Backups Tips and Tricks

Yann Neuhaus - Wed, 2017-03-29 09:51

Backing up an OUD consists of several components

  • The OUD software itself
  • The OUD back end data
  • The OUD configuration
  • The OUD logical export as a ldif file

However, in this post I would like to take a closer look at the back end data. Unlike the old OID, the OUD directory server uses the Berkeley DB Java Edition (JE) as its primary back end. The OUD backup command allows you to backup all back ends in one shot, or a single back end, you can do full or incremental backups, you can compress it and you can even encrypt your back end data, if you like too.

One of the first questions that comes up is where to put the backup files. In a replicated environment, it makes a lot of sense to put them on a NFS share. In case you should loose one OUD host, you still have the access to backups on the other host.

I choose to backup the back end data to /u99/backup/OUD, which is a directory on a NFSv4 mount.

[dbafmw@dbidg01 OUD]$ mount | grep u99
dbidg03:/u99 on /u99 type nfs4 (rw,relatime,vers=4.1,rsize=32768,wsize=32768,namlen=255,hard,proto=tcp,port=0,timeo=600,retrans=2,sec=sys,clientaddr=192.168.56.201,local_lock=none,addr=192.168.56.203)

Before we issue the first backup command, it is good to know which back ends we have. Some back ends change quite frequently and others might not. I am using the OUD only for TNS name resolution, so, the most important for me is the OracleContext0.

[dbafmw@dbidg01 ~]$ list-backends
Backend ID        : Base DN
------------------:----------------------------------------
Eus0              :
EusContext0       :
Fa0               :
OIDCompatibility  : cn=OracleContext,cn=OracleSchemaVersion
OracleContext0    : "cn=OracleContext,dc=dbi,dc=com"
adminRoot         : cn=admin data
ads-truststore    : cn=ads-truststore
backup            : cn=backups
monitor           : cn=monitor
schema            : cn=schema
subschemasubentry :
tasks             : cn=tasks
userRoot          : "dc=dbi,dc=com"
virtualAcis       : cn=virtual acis


[dbafmw@dbidg01 ~]$ list-backends -n OracleContext0
Backend ID     : Base DN
---------------:---------------------------------
OracleContext0 : "cn=OracleContext,dc=dbi,dc=com"

Ok. Lets start a full backup of all back ends to the backup directory /u99/backup/OUDand and compress them.

[dbafmw@dbidg01 ~]$ backup --backUpAll --compress --backupDirectory=/u99/backup/OUD
[29/Mar/2017:08:55:49 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend virtualAcis
[29/Mar/2017:08:55:49 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:55:49 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend OracleContext0
[29/Mar/2017:08:55:49 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:55:49 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend tasks
[29/Mar/2017:08:55:49 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend schema
[29/Mar/2017:08:55:49 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend OIDCompatibility
[29/Mar/2017:08:55:49 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:55:49 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend userRoot
[29/Mar/2017:08:55:49 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:55:49 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend replicationChanges
[29/Mar/2017:08:55:49 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:55:49 +0200] category=TOOLS severity=NOTICE msgID=10944795 msg=The backup process completed successfully

For backing up your OUD server back ends, the OUD itself does not have to be up and running. You can back it up while it is offline too.

[dbafmw@dbidg01 ~]$ stop-ds
Stopping Server...

[29/Mar/2017:08:57:46 +0200] category=BACKEND severity=NOTICE msgID=9896306 msg=The backend cn=OIDCompatibility,cn=Workflow Elements,cn=config is now taken offline
[29/Mar/2017:08:57:46 +0200] category=BACKEND severity=NOTICE msgID=9896306 msg=The backend cn=OracleContext0,cn=Workflow elements,cn=config is now taken offline
[29/Mar/2017:08:57:46 +0200] category=BACKEND severity=NOTICE msgID=9896306 msg=The backend cn=userRoot,cn=Workflow Elements,cn=config is now taken offline
[29/Mar/2017:08:57:46 +0200] category=BACKEND severity=NOTICE msgID=9896306 msg=The backend cn=virtualAcis,cn=Workflow Elements,cn=config is now taken offline
[29/Mar/2017:08:57:46 +0200] category=CORE severity=NOTICE msgID=458955 msg=The Directory Server is now stopped


[dbafmw@dbidg01 ~]$ backup --backUpAll --compress --backupDirectory=/u99/backup/OUD
[29/Mar/2017:08:58:06 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend virtualAcis
[29/Mar/2017:08:58:06 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:58:06 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend OracleContext0
[29/Mar/2017:08:58:06 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:58:06 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend tasks
[29/Mar/2017:08:58:06 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend schema
[29/Mar/2017:08:58:06 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend OIDCompatibility
[29/Mar/2017:08:58:06 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:58:06 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend userRoot
[29/Mar/2017:08:58:06 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:58:06 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend replicationChanges
[29/Mar/2017:08:58:06 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:08:58:06 +0200] category=TOOLS severity=NOTICE msgID=10944795 msg=The backup process completed successfully
[dbafmw@dbidg01 ~]$

Backing up a single back end is done by the following command.

[dbafmw@dbidg01 ~]$ backup --backendID OracleContext0 --compress --backupDirectory=/u99/backup/OUD
[29/Mar/2017:15:14:22 +0200] category=TOOLS severity=NOTICE msgID=10944792 msg=Starting backup for backend OracleContext0
[29/Mar/2017:15:14:22 +0200] category=JEB severity=NOTICE msgID=8847446 msg=Archived: 00000000.jdb
[29/Mar/2017:15:14:22 +0200] category=TOOLS severity=NOTICE msgID=10944795 msg=The backup process completed successfully

The backup which I have done is reflected now in the following directory.

[dbafmw@dbidg01 OUD]$ ls -rtl /u99/backup/OUD/backup-OracleContext0*
-rw-r--r-- 1 dbafmw oinstall 19193 Mar 28 15:11 /u99/backup/OUD/backup-OracleContext0-20170328131137Z
-rw-r--r-- 1 dbafmw oinstall 56904 Mar 28 15:20 /u99/backup/OUD/backup-OracleContext0-20170328132004Z
-rw-r--r-- 1 dbafmw oinstall 27357 Mar 29 15:14 /u99/backup/OUD/backup-OracleContext0-20170329131419Z
-rw-r--r-- 1 dbafmw oinstall 27357 Mar 29 15:15 /u99/backup/OUD/backup-OracleContext0-20170329131552Z
-rw-r--r-- 1 dbafmw oinstall 84556 Mar 29 15:16 /u99/backup/OUD/backup-OracleContext0-20170329131622Z

The backups done via the OUD backup command are documented in a file called backup.info. If you grep for the last backup piece, you will find it there as the last entry.

[dbafmw@dbidg01 OUD]$ cat /u99/backup/OUD/backup.info | grep -B 8 backup-OracleContext0-20170329131622Z

backup_id=20170329131622Z
backup_date=20170329131625Z
incremental=false
compressed=false
encrypted=false
property.last_logfile_name=00000000.jdb
property.last_logfile_size=84330
property.archive_file=backup-OracleContext0-20170329131622Z

There is another method to find the last backup which was done. Before the backup command starts, it copies the current backup.info to backup.info.save, and so, you just need to do a diff, and then you know which is the latest backup.

[dbafmw@dbidg01 OUD]$ diff backup.info backup.info.save
48,56d47
< backup_id=20170329131622Z
< backup_date=20170329131625Z
< incremental=false
< compressed=false
< encrypted=false
< property.last_logfile_name=00000000.jdb
< property.last_logfile_size=84330
< property.archive_file=backup-OracleContext0-20170329131622Z
<

But what happens if you don’t need some old backup anymore. e.g. the backup-OracleContext0-20170328131137Z.

[dbafmw@dbidg01 OUD]$ cat backup.info | grep backup-OracleContext0-20170328131137Z
property.archive_file=backup-OracleContext0-20170328131137Z

Unfortunately, there is no purge procedure delivered with OUD to clean up old backups. You have to clean it up yourself. e.g. in case you want to clean up Oracle Context backups older than 2 days, you could do like this.

[dbafmw@dbidg01 OUD]$ find /u99/backup/OUD -maxdepth 1 -type f -name "backup-OracleContext0*" -mtime +2 | awk -F "/" '{ print $5 }' | awk -F "-" '{ print $3 }'
20170328132004Z

[dbafmw@dbidg01 OUD]$ find /u99/backup/OUD -maxdepth 1 -type f -name "backup-OracleContext0*" -mtime +2 | awk -F "/" '{ print $5 }' | awk -F "-" '{ print $3 }' | while read i
do
echo /u99/backup/OUD/backup-OracleContext0-${i}
rm /u99/backup/OUD/backup-OracleContext0-${i}
sed -i "/backup_id=${i}/,/property.archive_file=backup-OracleContext0-${i}/d" /u99/backup/OUD/backup.info
done
[dbafmw@dbidg01 OUD]$ cat backup.info | grep 20170328132004Z
[dbafmw@dbidg01 OUD]$

This script is of course not baby save, but you got the idea. ;-)

Conclusion

The Oracle OUD delivers quite a lot good options regarding backups. However, regarding purging the old stuff, you have to handle it yourself.

 

 

Cet article OUD – Oracle Unified Directory 11.1.2.3 Backups Tips and Tricks est apparu en premier sur Blog dbi services.

Can I do it with PostgreSQL? – 10 – Timezones

Yann Neuhaus - Wed, 2017-03-29 08:59

This post is inspired by a question we received from a customer: In Oracle there is the sessiontimezone which returns the time zone of the session. Asking for the time zone of the session in Oracle returns you the offset to the UTC time:

SQL> select sessiontimezone from dual;

SESSIONTIMEZONE
---------------------------------------------------------------------------
+02:00

This is fine as I am based in Switzerland and we skipped one hour in the night from last Saturday to Sunday :)

How can we do something similar in PostgreSQL? To check the current time zone of your session:

(postgres@[local]:4445) [postgres] > show timezone;
   TimeZone   
--------------
 Europe/Vaduz
(1 row)

Or:

(postgres@[local]:4445) [postgres] > select current_setting('timezone');
 current_setting 
-----------------
 Europe/Vaduz
(1 row)

So, PostgreSQL will not show you the offset to UTC but the name of the time zone as specified by the Internet Assigned Numbers Authority (IANA). When you want to have the offset to UTC you can do something like this:

(postgres@[local]:4445) [postgres] > select age(now(),now() at time zone 'UTC');
   age    
----------
 02:00:00
(1 row)

You can do it using the extract function as well:

(postgres@[local]:4445) [postgres] > select extract( timezone from now() ) / 60 /60;
 ?column? 
----------
        2
(1 row)

How can you change the session time zone? One way is to set the PGTZ environment variable before starting a new session when you use a libpq client:

postgres@centos7:/home/postgres/ [PG3] export PGTZ=Europe/Berlin
postgres@centos7:/home/postgres/ [PG3] psql postgres
psql.bin (9.6.2.7)
Type "help" for help.

(postgres@[local]:4445) [postgres] > show timezone;
   TimeZone    
---------------
 Europe/Berlin
(1 row)

The other way is to directly set it in the session:

Time: 1.048 ms
(postgres@[local]:4445) [postgres] > set time zone 'Europe/Paris';
SET
Time: 82.903 ms
(postgres@[local]:4445) [postgres] > show timezone;
   TimeZone   
--------------
 Europe/Paris
(1 row)

Of course you can also set the timezone parameter in postgresql.conf.

To get the current timestamp you can use:

(postgres@[local]:4445) [postgres] > SELECT current_timestamp;
        current_timestamp         
----------------------------------
 29-MAR-17 15:41:59.203485 +02:00
(1 row)

And finally, to calculate the current time in another time zone you can do something like this:

(postgres@[local]:4445) [postgres] > SELECT current_time AT TIME ZONE 'Europe/Zurich', current_time AT TIME ZONE 'US/Samoa';
      timezone      |      timezone      
--------------------+--------------------
 15:43:05.634124+02 | 02:43:05.634124-11
(1 row)

All the time zone names can be found in pg_timezone_names:

(postgres@[local]:4445) [postgres] > select * from pg_timezone_names;
               name               | abbrev | utc_offset | is_dst 
----------------------------------+--------+------------+--------
 America/North_Dakota/Beulah      | CDT    | -05:00:00  | t
 America/North_Dakota/Center      | CDT    | -05:00:00  | t
 America/North_Dakota/New_Salem   | CDT    | -05:00:00  | t
 America/Argentina/Ushuaia        | ART    | -03:00:00  | f
...

Hope this helps…

 

Cet article Can I do it with PostgreSQL? – 10 – Timezones est apparu en premier sur Blog dbi services.

Take a few minutes to patch Oracle APEX 5.1

Dimitri Gielis - Wed, 2017-03-29 08:00
Yesterday a first patch set of Oracle Application Express (APEX) 5.1 has been made available to download.

one-of patches

If you encounter issues, you can ask for support and most likely a bit later a patch is made available through support.oracle.com. The APEX team is doing a great job with this.

For example some people using APEX Office Print had an issue which was caused by a bug in APEX_JSON (which we heavily use behind the scenes). The next day the APEX Dev Team already made a patch available (PSE 25650850).

patch set

Instead of applying those one-off patches, you can wait for a patch set which includes those one-off patches and more. If you didn't move to Oracle APEX 5.1 yet, you can just download the latest version which includes 5.1.1 immediately. 

There're many fixes for the Interactive Grid features, but next to that, many others as well, like for example login issues.

applying the patch set

If you're on Oracle APEX 5.1, search for patch 25341386. Unzip the file, stop the webserver, run @apxpatch, copy the images folder and start the webserver again.
About 2 minutes later you're on the latest version. 


Happy patching...
Categories: Development

New Certifications Demonstrate Continued Momentum for Oracle Public Cloud

Oracle Press Releases - Wed, 2017-03-29 07:00
Press Release
New Certifications Demonstrate Continued Momentum for Oracle Public Cloud Cloud compliance certifications further validate Oracle Cloud in highly regulated sectors

Redwood Shores Calif—Mar 29, 2017

Oracle today announced it has achieved a series of compliance certifications and attestations for its Public Cloud offering, including certifications and attestations for ISO 27001, HIPAA, SOC1 and SOC2 for a number of core services. Administered by Schellman & Co., these certifications in industries such as healthcare help provide validation of Oracle’s offerings in areas including security, availability, processing integrity and privacy.
 
Oracle’s portfolio of Platform-as-a-Service (PaaS) and Infrastructure-as-a-Service (IaaS) solutions received Service Organization Control (SOC) attestations for the following key services: Database Public Cloud Service, Java Public Cloud Service, Database Backup Cloud Service, Exadata Cloud Service, Big Data Cloud Service, Big Data Preparation Service, Big Data Discovery, Application Builder Cloud Service, Storage Cloud Service, Dedicated Compute Cloud Service, and Public Compute Cloud Service. These SOC certifications confirm Oracle’s compliance with international service organization reporting standards. SOC reports are standards that help organizations establish trust and confidence in their service delivery processes by assessing whether service organizations are performing their duties appropriately in a controlled, stable and secured environment.
 
Oracle recently received a Health Insurance Portability and Accountability Act (HIPAA) attestation for its Oracle Fusion Suite of Software-as-a-Service (SaaS) applications—including Enterprise Resource Planning (ERP), Human Capital Management (HCM), and Customer Relationship Manager (CRM) Cloud Service—demonstrating that its SaaS solutions meet the requirements established by the U.S. Department of Health and Human Services for organizations working in the healthcare industry. HIPAA attestations affirm the proper saving, accessing and sharing of individual medical and personal information, as well as compliance with national security standards to protect health data created, received, maintained or transmitted electronically.
 
Oracle recently received an International Standards Organization (ISO) 27001 certification demonstrating the proper management and security of assets such as financial information, intellectual property, employee details or information entrusted to an organization by third parties, for its Public Cloud SaaS suite of services in the core areas of Fusion ERP, HCM, CRM, Taleo Social, Taleo Business Edition, Service Cloud, Eloqua Marketing Cloud, BigMachines CPQ, and Field Service Cloud. 
 
 
“Oracle is continuously investing time and resources to meet our customers’ strict requirements across highly regulated industries,” said Erika Voss, Global Senior Director, Public Cloud Compliance, Risk and Privacy, Oracle. “These new certifications not only validate the reliability and security features of the Oracle Cloud; they effectively make Oracle’s solutions available to thousands of new customers in the Healthcare and Public Sector industries.”
 
Contact Info
Scott Thornburg
Oracle
+1.415.816.8844
scott.thornburg@oracle.com
About Oracle Cloud

Oracle Cloud is the industry’s broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data. The Oracle Cloud delivers nearly 1,000 SaaS applications, and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world supporting 55 billion transactions each day. For more information, please visit us at http://cloud.oracle.com.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Scott Thornburg

  • +1.415.816.8844

pl/sql code debugging - long running block

Tom Kyte - Wed, 2017-03-29 05:06
hi - our developers have a package that they are running within a begin... end block. They are telling us that this block seems to run for a very long time. this is the only thing that is running in the database and using over 90% of cpu. we ran the ...
Categories: DBA Blogs

equivalent of DBMS_XMLGEN.GETXML to generate json

Tom Kyte - Wed, 2017-03-29 05:06
We are currently generating XML data based on DBMS_XMLGEN.GETXML() to send it to client. Instead of xml , we want to send data as JSON. Is there anything similar to DBMS_XMLGEN.GETXML to generate json ?
Categories: DBA Blogs

Extents Tablas Oracle

Tom Kyte - Wed, 2017-03-29 05:06
Tom, because when I create a table with the following values ??in each of its partitions, I generate 195 extents? If the partitions have an INITIAL if the size of the partition. COMPRESS BASIC STORAGE ( INITIAL 7748954362 - 7.2 GB NE...
Categories: DBA Blogs

oracle 12.2 approximate functions

Tom Kyte - Wed, 2017-03-29 05:06
When I run the new Oracle 12c approximate square root function on a negative number, I keep getting the same answer. What's going on? <code> SQL> select approximate_sqrt(-1) from dual; APPROXIMATE_SQRT(-1) ---------------------- ...
Categories: DBA Blogs

Reclaim/reuse LOB space

Tom Kyte - Wed, 2017-03-29 05:06
Hi, We have a table with a BLOB column, general observation - about 50% to 60% of total DB space is occupied by this table. In order to reduce overall DB space, we run purge program which will selectively delete older entries. However we observe...
Categories: DBA Blogs

Apex 5.1.1 released

Flavio Casetta - Wed, 2017-03-29 02:53
Categories: DBA Blogs

ODPI-C 2.0.0 Beta 2 is out with runtime client linking

Christopher Jones - Tue, 2017-03-28 17:04

Anthony Tuiningajust released ODPI-C2.0.0-beta.2 on GitHub. The release notes list all changes.

ODPI-C is an open source library of C code that simplifies the useof common Oracle Call Interface (OCI) features for Oracle Databasedrivers and user applications. It sits on top of OCI and requiresOracle client libraries.

The big change in this release is the addition of runtime dynamiclinking of the Oracle client libraries. It was initiated by a commentfrom Vincent Rogier, authorof OCILIB when hetook a look at ODPI-C.

One you have downloadedODPI-C source (and written something using its API, or copied thesamples) you can compile your code without needing the Oracleheader files (e.g. you don't need the Oracle Instant Client SDK). Allyou need to have are the Oracle client libraries from Oracle Database11.2, 12.1 or 12.2 in your path when you run your application. Theseclient libraries can be found in the Instant Client Basic or Basic Light packages, in a databaseORACLE_HOME, or in a full Oracle Client install. Your ODPI-C -basedapplication will use the first Oracle client libraries in your loadpath. More details about configuring the Oracle client are in the documentation. In summary you only need to build your applicationonce and it will run using Oracle 11.2, 12.1 or 12.2 clientlibraries.

If you want to see ODPI-C in action in a bigger 'example', look atthe masterbranch of cx_Oracle.

ODPI-C 2.0.0 Beta 2 is out with runtime client linking

Christopher Jones - Tue, 2017-03-28 17:04

Anthony Tuininga just released ODPI-C 2.0.0-beta.2 on GitHub. The release notes list all changes.

ODPI-C is an open source library of C code that simplifies the use of common Oracle Call Interface (OCI) features for Oracle Database drivers and user applications. It sits on top of OCI and requires Oracle client libraries.

The big change in this release is the addition of runtime dynamic linking of the Oracle client libraries. It was initiated by comment from Vincent Rogier, author of OCILIB when he took a look at ODPI-C.

One you have downloaded ODPI-C source (and written something using its API, or copied the samples) you can compile your code without needing the Oracle header files (e.g. you don't need the Oracle Instant Client SDK). All you need to have are the Oracle client libraries from Oracle Database 11.2, 12.1 or 12.2 in your path when you run your application. These client libraries can be found in the Instant Client Basic or Basic Light packages, in a database ORACLE_HOME, or in a full Oracle Client install. Your ODPI-C -based application will use the first Oracle client libraries in your load path. More details about configuring the Oracle client are in the documentation. In summary you only need to build your application once and it will run using Oracle 11.2, 12.1 or 12.2 client libraries.

If you want to see ODPI-C in action in a bigger 'example', look at the master branch of cx_Oracle.

The blog is evolving

Anthony Shorten - Tue, 2017-03-28 16:48

As you may of noticed, the blog has not been updated as regularly as it used to. Oracle is moving its blog platform soon to a new platform and during that process the number of blog changes has been limited to aid in the migration.

So here are the proposed plans for this blog:

  • This blog will be retired long term and replaced with a new Oracle Utilities Application Framework blog centered around technology and tips/techniques.
  • More people will be involved in creating new content with special guests coming into publishing content on the blog.
  • We are preparing new content for our next release 4.3.0.4.0 which is going to be exciting with new features and updated features. The new blog will house that content.

We are still preparing for the migration and I will keep you posted on this site when it will all happen. I will also post a final post to this blog pointing to the new exciting platform.

The blog is evolving

Anthony Shorten - Tue, 2017-03-28 16:48

As you may of noticed, the blog has not been updated as regularly as it used to. Oracle is moving its blog platform soon to a new platform and during that process the number of blog changes has been limited to aid in the migration.

So here are the proposed plans for this blog:

  • This blog will be retired long term and replaced with a new Oracle Utilities Application Framework blog centered around technology and tips/techniques.
  • More people will be involved in creating new content with special guests coming into publishing content on the blog.
  • We are preparing new content for our next release 4.3.0.4.0 which is going to be exciting with new features and updated features. The new blog will house that content.

We are still preparing for the migration and I will keep you posted on this site when it will all happen. I will also post a final post to this blog pointing to the new exciting platform.

Oracle Application Express 5.1.1 now available

Joel Kallman - Tue, 2017-03-28 16:18
Just in time for APEX World 2017, Oracle Application Express 5.1.1 is now released and available for download.  If you wish to download the full release of Oracle Application Express 5.1.1, you can get it from the Downloads page on OTN.  If you have Oracle Application Express 5.1 already installed, then you need to download the APEX 5.1.1 patch set from My Oracle Support.  Look up patch number 25341386.

As is stated in the Patch Set Note that accompanies the Oracle Application Express 5.1.1 patch set:
  • If you have Oracle Application Express release 5.1 installed, download the Oracle Application Express 5.1.1 patch set from My Oracle Support and apply it.  Remember - patch number 25341386.
  • If you have Oracle Application Express release 5.0.4 or earlier installed, download and install the entire Oracle Application Express 5.1.1 release from the Oracle Technology Network (OTN).
  • If you do not have Oracle Application Express installed, download and install the entire Oracle Application Express 5.1.1 release from the Oracle Technology Network (OTN).

As usual, there are a large number of issues corrected in the Application Express 5.1.1 patch set (over 106!).  You can see the full list in the 5.1.1 Patch Set Notes.

    Oracle Linux 6 update 9

    Wim Coekaerts - Tue, 2017-03-28 15:56
    We just released Oracle Linux 6 update 9. The channels are on ULN and on our yum repo. The ISOs are available for download through MOS and in the next few days also on the software delivery cloud page, as customary. The release notes with changes are published and so on.

    One thing we discovered during testing of OL6.9 was that a recent change in "upstream" glibc can cause memory corruption resulting in a database start-up failure every now and then.

    Since we caught this prior to release, we have, of course, fixed the bug.

    The following code change introduced the bug (glibc-rh1012343.patch)

    char newmode[modelen + 2];

    - memcpy (mempcpy (newmode, mode, modelen), "c", 2);

    + memcpy (mempcpy (newmode, mode, modelen), "ce", 2);

    FILE *result = fopen (file, newmode);
    As you can see, someone added e to newmode (c to ce) but forgot to increase the size of newmode (2 to 3) so there is no null character at the end.
    The correct patch that we have in glibc as part of OL6.9 is:

    - char newmode[modelen + 2];

    - memcpy (mempcpy (newmode, mode, modelen), "ce", 2);

    + char newmode[modelen + 3];

    + memcpy (mempcpy (newmode, mode, modelen), "ce", 3);
    The Oracle bug id is 25609196. The patch for this is in the glibc src rpm. The customer symptom would be a failed start of the database because of fopen() failing.
    Something like this:
    Wed Mar 22 *17:19:51* 2017 *ORA-00210: cannot open the specified control file* ORA-00202: control file:'/opt/oracle/oltest/.srchome/single-database/nas/12.1.0.2.0-8192-72G/control_001' ORA-27054: NFS file system where the file is created or resides is not mounted with correct options *Linux-x86_64 Error: 13: Permission denied* Additional information: 2 ORA-205 signalled during: ALTER DATABASE MOUNT... Shutting down instance (abort)

    Oracle Linux 6 update 9

    Wim Coekaerts - Tue, 2017-03-28 15:56
    We just released Oracle Linux 6 update 9. The channels are on ULN and on our yum repo. The ISOs are available for download through MOS and in the next few days also on the software delivery cloud page, as customary. The release notes with changes are published and so on.

    One thing we discovered during testing of OL6.9 was that a recent change in "upstream" glibc can cause memory corruption resulting in a database start-up failure every now and then.

    Since we caught this prior to release, we have, of course, fixed the bug.

    The following code change introduced the bug (glibc-rh1012343.patch)

     	
    	     char newmode[modelen + 2];
    	  -  memcpy (mempcpy (newmode, mode, modelen), "c", 2);
    	  +  memcpy (mempcpy (newmode, mode, modelen), "ce", 2);
    	     FILE *result = fopen (file, newmode);
    

    As you can see, someone added e to newmode (c to ce) but forgot to increase the size of newmode (2 to 3) so there is no null character at the end.
    The correct patch that we have in glibc as part of OL6.9 is:
    	-  char newmode[modelen + 2];
    	-  memcpy (mempcpy (newmode, mode, modelen), "ce", 2);
    	+  char newmode[modelen + 3];
    	+  memcpy (mempcpy (newmode, mode, modelen), "ce", 3);
    

    The Oracle bug id is 25609196. The patch for this is in the glibc src rpm. The customer symptom would be a failed start of the database because of fopen() failing.
    Something like this:
      Wed Mar 22 *17:19:51* 2017
      *ORA-00210: cannot open the specified control file*
      ORA-00202: control file:
      
    '/opt/oracle/oltest/.srchome/single-database/nas/12.1.0.2.0-8192-72G/control_0
    01'
      ORA-27054: NFS file system where the file is created or resides is
      not mounted with correct options
      *Linux-x86_64 Error: 13: Permission denied*
      Additional information: 2
      ORA-205 signalled during: ALTER DATABASE   MOUNT...
      Shutting down instance (abort) 
    
    

    Pages

    Subscribe to Oracle FAQ aggregator