Feed aggregator

Where are my static application files of Oracle APEX?

Dimitri Gielis - Fri, 2019-03-29 06:18
Ever got the error that there's an issue with your environment because the Application Express files have not been loaded when you try to open Oracle APEX in your environment?


Since the Announcement of the availability of Oracle APEX Static Resources on a Content Delivery Network I typically configure APEX to use the CDN.

Steps to do so for the entire environment:
  • Navigate to the apex/utilities subdirectory from the directory you unzipped APEX to
  • Connect to your database as the SYS user
  • Run:  @reset_image_prefix.sql
  • when prompted for the image prefix, enter the correct path, e.g. https://static.oracle.com/cdn/apex/18.2.0.00.12/
Now, when I got the above error, I forgot which images folder APEX was using. Was there an issue with the connection to the CDN, was it a local issue?

Below is how I found out how the APEX images directory was configured and if it was using the CDN or local files.
Connect as SYS in a SQL window (SQLcl, SQL Developer, SQL Plus, ...):

SQL> set serveroutput on
SQL> begin
2 dbms_output.put_line(apex_180100.wwv_flow_image_prefix.g_image_prefix);
3 end;
4 /
/i/

PL/SQL procedure successfully completed.

SQL> begin
2 dbms_output.put_line(apex_180200.wwv_flow_image_prefix.g_image_prefix);
3 end;
4 /
https://static.oracle.com/cdn/apex/18.2.0.00.12/

PL/SQL procedure successfully completed.

Above you see that in APEX 18.1 the /i/ directory is used on the local web server.
On APEX 18.2 the CDN is being used.

Note: whenever you run the above command change to the correct APEX user (version), so for APEX 19.1 you use apex_190100.
Categories: Development

Deploying an Application to Pivotal Cloud Foundry through Spinnaker and then invoking a resize operation

Pas Apicella - Thu, 2019-03-28 22:36
In this post we show a basic deployment to Cloud foundry in fact Pivotal Cloud foundry 2.4 using spinnaker 1.13.0.

Assumptions:

1. Configured a Cloud Foundry provider as shown below

spinnaker@myspinnaker-spinnaker-halyard-0:/workdir$ hal config provider cloudfoundry account add pez208 --user admin --password mypassword --api api.system.run.myenv.io --environment dev --appsManagerURI https://apps.system.run.myenv.io
+ Get current deployment
  Success
+ Add the pez208 account
  Success
Problems in default.provider.cloudfoundry:
- WARNING To be able to link server groups to CF Metrics a URI is
  required: pez208

+ Successfully added account pez208 for provider cloudfoundry.

2. Enable cloud foundry provider

spinnaker@myspinnaker-spinnaker-halyard-0:/workdir$ hal config provider cloudfoundry enable
+ Get current deployment
  Success
+ Edit the cloudfoundry provider
  Success

+ Successfully enabled cloudfoundry

3. Run "hal deploy apply"

spinnaker@myspinnaker-spinnaker-halyard-0:/workdir$ hal deploy apply
+ Get current deployment
  Success
+ Prep deployment
  Success
+ Preparation complete... deploying Spinnaker
+ Get current deployment
  Success
+ Apply deployment
  Success
+ Deploy spin-clouddriver
  Success
+ Deploy spin-front50
  Success
+ Deploy spin-orca
  Success
+ Deploy spin-deck
  Success
+ Deploy spin-echo
  Success
+ Deploy spin-gate
  Success
+ Deploy spin-igor
  Success
+ Deploy spin-rosco
  Success
+ Run `hal deploy connect` to connect to Spinnaker.

IN this demo I can simply going to deploy my artifact sitting within my GitHub repo using a HTTP endpoiunt so for that will need to enable HTTP artifact support in Spinnaker as shown below

$ hal config features edit --artifacts true
$ hal config artifact http enable
$ hal config artifact http account add apples-http
$ hal deploy apply

Steps:

1. Lets create a new application called "pastest" as shown below. Be sure to select "CloudFoundry" provider.


2. Click "Create"

3. Click on "Create Server group"

4. Fill in the fields as shown below. In this example I am using the following

  • Account "pez208" which was the cloud foundry provider name we used above
  • Region is basically the CF space we will deploy into
  • HTTP artifact which I enabled called "apples-http".
  • Fully qualified path to my JAR file I wish to deploy
  • Form based manifest settings to define my application deployment settings




5. Click "Create"

6. Verify your application is going through the deploy phase as shown in the dialog



7. Oncer complete we can see our deployed application in Pivotal Cloud Foundry Applications Manager as shown below.


8. Now if we return to the Spinnaker UI we will see various views of what we just deployed as follows

Server Group Main Page


Load Balancer Page



Instance Page


9. Now let's actually scale our application to 2 instances rather than just a single instance. To do that lets click the "Resize Option" in the "Server Group Page" as shown below



10. In the dialog which appears set "Resize to" to "2"


11. Click "Submit"


12. Return to Pivotal Cloud Foundry Applications Manager and verify we now have 2 instances of our application as shown below



13. This will also be reflected on Spinnaker UI as well



More Information

Cloud Foundry - Cloud Provider
https://www.spinnaker.io/reference/providers/cf/
Categories: Fusion Middleware

MAX aggregation function shows different results when partitioned

Tom Kyte - Thu, 2019-03-28 16:26
Hi everyone, I'm getting strange results from a query. I have a table list partitioned by id, when I execute this : <code>select max(col1) from table where id=100;</code> it returns the value 'A1'. Then I execute the following (keep in mind ...
Categories: DBA Blogs

Infidelity when storing XMLType data elements (spaces)

Tom Kyte - Thu, 2019-03-28 16:26
When saving XMLType data into table. The data fidelity is is not maintained for fields containing only spaces (see LiveSQL). Before save, spaces are present in <COL> </COL> After reading the saved data, spaces are gone and we see empty tag <COL...
Categories: DBA Blogs

Using operating system users to connect to PostgreSQL

Yann Neuhaus - Thu, 2019-03-28 14:39

PostgreSQL supports many authentication methods by default and one of them is Ident authentication. Using that method you can use the users defined in the operating system and map them to users in PostgreSQL. So how does that work?

To start, lets create a new operating system user we want to use for connecting to the database:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo groupadd user1
postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo useradd -g user1 -m user1

The next step is to create a so called user name map. A user map contains the name of the map, the operating system user and the user in PostgreSQL:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] echo "my-map       user1         user1" >> $PGDATA/pg_ident.conf
postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] tail -5 $PGDATA/pg_ident.conf
# Put your actual configuration here
# ----------------------------------

# MAPNAME       SYSTEM-USERNAME         PG-USERNAME
my-map       user1         user1

In our case the name of the PostgreSQL user and the name of the operating system user is the same. You might well map the operating system to another user in PostgreSQL, e.g. user2.

Obviously our user needs to exist in PostgreSQL, so:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] psql -c "create user user1 with login" postgres
CREATE ROLE

Finally we need to add an entry to pg_hba.conf that matches our map and authentication method:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] echo "host    all    all    192.168.22.0/24    ident map=my-map" >> $PGDATA/pg_hba.conf
postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] pg_ctl -D $PGDATA reload
server signaled

Lets try to connect to the database with our new user:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo su - user1
[user1@pgbox ~]$ /u01/app/postgres/product/DEV/db_1/bin/psql -h 192.168.22.99 -p 5433 -U user1 postgres
psql: FATAL:  Ident authentication failed for user "user1"

… and that fails. When we check the PostgreSQL log file this is reported:

2019-03-19 18:33:26.724 CET - 1 - 8174 - 192.168.22.99 - user1@postgres LOG:  could not connect to Ident server at address "192.168.22.99", port 113: Connection refused
2019-03-19 18:33:26.724 CET - 2 - 8174 - 192.168.22.99 - user1@postgres FATAL:  Ident authentication failed for user "user1"
2019-03-19 18:33:26.724 CET - 3 - 8174 - 192.168.22.99 - user1@postgres DETAIL:  Connection matched pg_hba.conf line 94: "host    all    all    192.168.22.0/24    ident map=my-map"

Our entry in pg_hba.conf matches, at least that is fine. But PostgreSQL is not able to connect to the Ident server and this confirms that nothing is listening on that port:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo netstat -tulpen | grep 113

I am running CentOS 7 so the procedure for installing and starting an ident server is this:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo yum search oident
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: pkg.adfinis-sygroup.ch
 * epel: pkg.adfinis-sygroup.ch
 * extras: mirror1.hs-esslingen.de
 * updates: mirror.softaculous.com
=============================================================================================== N/S matched: oident ===============================================================================================
oidentd.x86_64 : Implementation of the RFC1413 identification server

  Name and summary matches only, use "search all" for everything.

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo yum install oidentd
postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] systemctl list-unit-files | grep -i ident
oidentd.service                               disabled
postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo systemctl enable oidentd.service
Created symlink from /etc/systemd/system/multi-user.target.wants/oidentd.service to /usr/lib/systemd/system/oidentd.service.
postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo systemctl start oidentd.service
postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo netstat -tulpen | grep 113
tcp        0      0 0.0.0.0:113             0.0.0.0:*               LISTEN      0          48553      8978/oidentd        

Lets try again:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo su - user1
Last login: Tue Mar 19 18:33:25 CET 2019 on pts/1
[user1@pgbox ~]$ /u01/app/postgres/product/DEV/db_1/bin/psql -h 192.168.22.99 -p 5433 -U user1 postgres
psql (12devel)
Type "help" for help.

postgres=> 

… and now it works. We can connect using the operating system without specifying a password. To complete this post lets create another operating system user and map it to a different account in PostgreSQL:

postgres@pgbox:/home/postgres/ [PGDEV] sudo groupadd user2
postgres@pgbox:/home/postgres/ [PGDEV] sudo useradd -g user2 -m user2
postgres@pgbox:/home/postgres/ [PGDEV] echo "my-map       user2         user1" >> $PGDATA/pg_ident.conf
postgres@pgbox:/home/postgres/ [PGDEV] tail $PGDATA/pg_ident.conf
# a SIGHUP signal.  If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect.  You can
# use "pg_ctl reload" to do that.

# Put your actual configuration here
# ----------------------------------

# MAPNAME       SYSTEM-USERNAME         PG-USERNAME
my-map       user1         user1
my-map       user2         user1
postgres@pgbox:/home/postgres/ [PGDEV] pg_ctl -D $PGDATA reload
server signaled

user2 should now be able to connect to user1 in PostgreSQL as well:

postgres@pgbox:/u02/pgdata/DEV/ [PGDEV] sudo su - user2
Last login: Tue Mar 19 18:55:06 CET 2019 on pts/1
[user2@pgbox ~]$ /u01/app/postgres/product/DEV/db_1/bin/psql -h 192.168.22.99 -p 5433 -U user1 postgres
psql (12devel)
Type "help" for help.

postgres=> 

Finally, be careful with this authentication method. The documentation is very clear about that: “The drawback of this procedure is that it depends on the integrity of the client: if the client machine is untrusted or compromised, an attacker could run just about any program on port 113 and return any user name they choose. This authentication method is therefore only appropriate for closed networks where each client machine is under tight control and where the database and system administrators operate in close contact. In other words, you must trust the machine running the ident server. Heed the warning: The Identification Protocol is not intended as an authorization or access control protocol.”

Cet article Using operating system users to connect to PostgreSQL est apparu en premier sur Blog dbi services.

Getting Support for Java Plug-In While Transitioning to Java Web Start

Steven Chan - Thu, 2019-03-28 12:09

We recently provided guidance that we highly recommend all our Oracle E-Business Suite customers to migrate their Oracle E-Business Suite client tiers to use Java Web Start (JWS) without delay.

It's essential to note that as of March 2019, Java Web Start is the only certified version of Java for the Oracle E-Business Suite client tier that also comes under Premier or Extended Support for Java SE.

This raises the question of what support we will provide for Java Plug-In for customers as they transition to Java Web Start. The answer is in two parts:

  • Through to at least September 2020, Oracle plans to continue shipping the components required to launch Java applets on Internet Explorer 11 using Java Plug-in.
  • Oracle E-Business Suite Support will continue to accept service requests against issues found when using the Java Plug-in with EBS until September 2020.

Please note that above support schedule is contingent on Microsoft continuing to support the APIs required by the Java Plug-in with Internet Explorer until the dates specified.

References

 

Related Articles
Categories: APPS Blogs

Getting Support for Java Plug-In While Transitioning to Java Web Start

Steven Chan - Thu, 2019-03-28 12:09

We recently provided guidance that we highly recommend all our Oracle E-Business Suite customers to migrate their Oracle E-Business Suite client tiers to use Java Web Start (JWS) without delay.

It's essential to note that as of March 2019, Java Web Start using JRE 8 is the only certified version of Java for the Oracle E-Business Suite client tier that also comes under Premier or Extended Support for Java SE.

This raises the question of what support we will provide for Java Plug-In for customers as they transition to Java Web Start. The answer is in two parts:

  • Through to at least September 2020, Oracle plans to continue shipping the components required to launch Java applets on Internet Explorer 11 using Java Plug-in.
  • Oracle E-Business Suite Support will continue to accept service requests against issues found when using the Java Plug-in with EBS until September 2020.

Please note that above support schedule is contingent on Microsoft continuing to support the APIs required by the Java Plug-in with Internet Explorer until the dates specified.

References

 

Related Articles
Categories: APPS Blogs

High Processes Cause Semaphore Errors

Bobby Durrett's DBA Blog - Thu, 2019-03-28 10:38

I could not create a new Delphix virtual database because I kept getting semaphore limit errors. I ended up reducing the processes parameter value to resolve the issue.

I got these errors creating the new VDB:

ERROR : SQL> ORA-27154: post/wait create failed 
ERROR : ORA-27300: OS system dependent operation:semget failed with status: 28
ERROR : ORA-27301: OS failure message: No space left on device
ERROR : ORA-27302: failure occurred at: sskgpcreates

The processes variable was set to 3000 on production so Delphix tried to create the VDB with the same value. I reduced processes to 100 and the VDB came up cleanly.

I have been living with this problem for a year or two but yesterday I really needed to resolve it and I finally figured it out. I got the idea of reducing processes from this Oracle support document:

Instance Startup Fails With Error ORA-27154,ORA-27300,ORA-27301,ORA-27302 (Doc ID 314179.1)

I looked these errors up on Oracle’s support site several times in the past and never saw the idea of reducing processes so I thought I would mention it here if only to remind myself.

Bobby

Categories: DBA Blogs

Join us at the Oracle EMEA IaaS & PaaS Partner Community Forum

Dear Partner,  The 2019 Oracle EMEA IaaS & PaaS Partner Community Forum will take place in Rome, Italy, on 8th & 9th May 2019. This year’s forum will be focused...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Join us at the Oracle EMEA IaaS & PaaS Partner Community Forum

Dear Partner,  The 2019 Oracle EMEA IaaS & PaaS Partner Community Forum will take place in Rome, Italy, on 8th & 9th May 2019. This year’s forum will be focused...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Two nice Pivotal Container Service (PKS) CLI commands I use very often

Pas Apicella - Wed, 2019-03-27 23:07
Having always created multiple PKS clusters at times I forget the configuration of my K8S clusters and this command comes in very handy

First lets list those clusters we have created with PKS

papicella@papicella:~$ pks clusters

Name    Plan Name  UUID                                  Status     Action
lemons  small      5c19c39e-88ae-4e06-a1cf-050b517f1b9c  succeeded  CREATE
banana  small      7c3ab1b3-a25c-498e-8179-9a14336004ff  succeeded  CREATE

Now lets see how many master nodes and how many worker nodes actually exist in my cluster using "pks cluster {name} --json"

papicella@papicella:~$ pks cluster banana --json

{
   "name": "banana",
   "plan_name": "small",
   "last_action": "CREATE",
   "last_action_state": "succeeded",
   "last_action_description": "Instance provisioning completed",
   "uuid": "7c3ab1b3-a25c-498e-8179-9a14336004ff",
   "kubernetes_master_ips": [
      "10.0.0.1"
   ],
   "parameters": {
      "kubernetes_master_host": "banana.yyyy.hhh.pivotal.io",
      "kubernetes_master_port": 8443,
      "kubernetes_worker_instances": 3
   }
}

One final PKS CLI command I use often when creating my clusters is the --wait option so I know when it's done creating the cluster rather then continually checking using "pks cluster {name}"

papicella@papicella:~$ pks create-cluster cluster1 -e cluster1.run.yyyy.hhh.pivotal.io -p small -n 4 --wait

More Information

https://docs.pivotal.io/runtimes/pks/1-3/cli/index.html

Categories: Fusion Middleware

Oracle ACE Program: A High-Five for New Members and Category Climbers

OTN TechBlog - Wed, 2019-03-27 13:40

The 25 people featured in this post have a great deal in common. Each has demonstrated substantial technical skill and knowledge about Oracle technologies across a variety of specialties and interests. But beyond that, each has shown considerable enthusiasm for sharing that expertise with the community through articles, presentations, videos, and other means of communication. Those two factors, technical skill and an enthusiasm for sharing it, are what the Oracle ACE Program is all about.

The faces looking up at you from this page belong to the latest crop of experts to earn a place at one of the three levels in that program, having been confirmed in the first quarter of calendar year 2019. Read a bit about them. Reach out to them. They're great resources.

As you head out to conferences or meet-ups over the next several months, the chances are good that you'll see some of these folks. If so, I think a congratulatory high-five is in order.

Well done, people!

 

Oracle ACE Director

 

Ron Ekins
Bolnore Village, West Sussex, England
Twitter LinkedIn 

Ron is a TOGAF-certified Enterprise Architect with over 25 years experience in the design, development, and delivery of large enterprise systems and innovative IT solutions. He first became an Oracle ACE in June 2015, and was promoted to Oracle ACE Director on January 31, 2019.

 

Oracle ACE

 

Oracle ACE Roger Cornejo

Roger Cornejo
Durham, North Carolina
Twitter LinkedIn 

Roger has over 34 years of experience with large/complex Oracle applications (versions 4.1.4 – 18c). His main focus is on DB performance analysis and tuning, and for the past 8 years, diving deep into AWR tuning data. Confirmed as an Oracle ACE on January 30, 2019.

Oracle ACE David Dai

Mingming (David) Dai
Hefei,China
Twitter LinkedIn 

David has been engaged in Oracle Database-related work for 10 years, and has gained extensive experience in high availability, database diagnosis. and performance tuning. He is a core member of ACOUG(All China Oracle User Group) and CN'SOUG (China Southern Oracle User Group ). David first became an Oracle ACE Associate in 2014, and was promoted to Oracle ACE on February 14, 2009.

Oracle ACE Jeffrey Kemp

Jeffery Kemp
Stratton, Australia
Twitter LinkedIn 

Jeffrey is an application designer and developer specializing in Oracle APEX, Oracle SQL, and PL/SQL. He has 19 years experience with the Oracle Database, including 13 years designing, building and hosting APEX applications. Confirmed as an Oracle ACE on February 14, 2019.

Oracle ACE Satoshi Mitani

Satoshi Mitani
Tokyo, Japan
Twitter LinkedIn 

Satoshi has worked at Yahoo! Japan for 14 years, the last 8 years as Database Platform Technical Lead. He has extensive experience with MySQL and is an active member of the MySQL community within the Nippon Association in Japan. Confirmed as an Oracle ACE on February 14, 2019.

Oracle ACE Borys Neselovskyi

Borys Neselovskyi
Dortmund, Germany
Twitter LinkedIn 

Borys Neselovskyi is a leading Infrastructure Architect at OPITZ CONSULTING. His work there includes the conceptual design and implementation of infrastructure solutions based on Oracle Database/Middleware/Engineered Systems/Virtualization. He also regularly works as a trainer for Oracle University. Confirmed as an Oracle ACE on February 14, 2019.

Oracle ACE Yossi Nixon

Yossi Nixon
Ramat HaSharon, Israel
Twitter LinkedIn Oracle ACE

Chief Database Architect at Axxana, Yossi has more that two decades of experience in IT infrastructure management, database design, development, and administration. He became an Oracle ACE Associate in October 2017, and made the jump to ACE on March 19, 2019.

Oracle ACE Stefan Oehrli

Stephan Oehrli
Muri, Switzerland
Twitter LinkedIn 

Stefan is a principal consultant, trainer and partner at Trivadis. He began to work with database systems in the late 1998. His main interests include physical database design, backup and recovery, container technologies, database security, database internals and everything else related to the core Oracle Database technology. Confirmed as an Oracle ACE on February 14, 2019.

Oracle ACE Manish Sharma

Manish Sharma
Dehli, India
Twitter LinkedIn 

Manish, an Oracle certified professional, is an Oracle database trainer and consultant. His Rebellion Rider YouTube channel provides Oracle Database tutorials sto over 58K subscribers. Confirmed as an Oracle ACE on February 1, 2019.

 

Oracle ACE Associate

 

Oracle ACE Associate Flora Barriele

Flora Barriele
Nyon, Switzerland
Twitter LinkedIn 

Flora has been working in IT for 8 years, including 3 years as an Oracle Database Administrator. She now focuses on Multitenant and Exadata Cloud@Customer. She volunteers for Swiss Oracle User Group to organize events, and is involved in promoting and encouraging women in technology. Confirmed as an Oracle ACE Associate on February 14, 2019.

Oracle ACE Associate Lisandro Fernigrini

Lisandro Fernigrini
Santa Fe, Argentina
Twitter LinkedIn 

A Senior Software Developer with more than 15 years of experience in Oracle Database technologies, Lisandro first got involved with Oracle Database as a DBA, then as a PL/SQL Developer, and later as a Database Architect.  He is an active member of AROUG (Argentina Oracle User Group). Confirmed as an Oracle ACE Associate on  January 17, 2019.

Oracle ACE Associate Paolo Gaggia

Paolo Gaggia
Rome, Italy
Twitter LinkedIn 

Paolo has 20 years of experience with Oracle technology, with a focus on Oracle Database architecture and troubleshooting. An expert in Oracle Database and Middleware, he currently develops architecture and solutions based on Oracle Blockchain Cloud. Confirmed as an Oracle ACE Associate on March 20, 2019.

Oracle ACE Associate Caroline Hagemann

Carolin Hagemann
Hamburg, Germany
Twitter XING LinkedIn Oracle ACE Associate Carolin Hagemann

Carolin developed her first Oracle APEX application in 2010 after years of developing web applications with PHP and MySQL. She made the decision to become an APEX consultant after attending the DOAG conference and exhibition. She organizes Meetups in Hamburg and is active in the DOAG NextGen DOAG Development communities. Confirmed as an Oracle ACE Associate on March 11, 2019.

Oracle ACE Associate Bin Hong

Hong Bin
Chengdu, China
  LinkedIn 

With more than 10 years of experience with MySQL, Hong Bin is a technical director for Shanghai Action Information Technology Co. where he specializes in Database Management/Performance. Confirmed as an Oracle ACE Associate on February 15, 2019.

Oracle ACE Associate Firoz Hussain

Firoz Hussain
Ajman, United Arab Emirates
  LinkedIn 

Firoz is a Senior Oracle Apps DBA with the Thumbay Group. His specialties include Database Management and Performance, Application and Apps Technology, and Cloud Computing. Confirmed as an Oracle ACE Associate on February 14, 2019.

Oracle ACE Associate Jian Jiang

Jian Jiang
Ningbo, China
   

In his role as a database administrator with Yunqu Tech, Jian Jiang specializes in database management performance, and is also interested in SQL tuning. Confirmed as an Oracle ACE Associate on February 20, 2019.

Oracle ACE Associate Batmunkh Moltov

Batmunkh Moltov
Ulaanbaatar, Mongolia
Twitter LinkedIn 

An Oracle Certified Master, Batmunkh has over 8 years experience with Unix Systems and Oracle Database, with expertise in Database Management and Performance, Linux, Virtualization, Open Source, and Engineered Systems. Confirmed as an Oracle ACE Associate on February 15, 2019.

Oracle ACE Associate Daniel Nelle Daniel Nelle
Leimersheim, Germany
Twitter LinkedIn 

Since Daniel first started working with Oracle Databases in 2004, databases and IT security have become his core competencies. His focus is drawn to performance tuning and to finding solutions beyond the obvious. Confirmed as an Oracle ACE Associate on February 15, 2019.

Oracle ACE Associate Alex Pagliarini Alex Pagliarini
Rio Grande do Sul, Brazil
Twitter LinkedIn

With expertise in Applications and Apps Technology, MySQL, and Database App Development, Alex has been working professionally with Oracle EBS for 8 years. Confirmed as an Oracle ACE Associate on January 30, 2019.

Oracle ACE Associate Mahmoud Rabie Mahmoud Rabie
Riyadh, Saudi Arabia
  LinkedIn 

Mahmoud is a Senior IT Solution Architect and Senior IT Trainer with over of total 17 years’ experience. An Oracle Database SQL Certified Expert and Sun Certified Java Programmer, his expertise includes database app development, Linux, Virtualization, and Open Source. Confirmed as an Oracle ACE Associate on February 14, 2019.

Oracle ACE Associate Tomito Masahiro Masahiro Tomita
Nagano, Japan
Twitter Oracle ACE Associate

Masahiro works at Fujitsu Cloud Technologies, where he specializes in MySQL, Linux, Virtualization and Open Source. He is a representative of the Japan MySQL User group. Confirmed as an Oracle ACE Associate March 11, 2019.

Oracle ACE Associate Elisa Usai Elisa Usai
Pully, Switzerland
Twitter LinkedIn 

Elisa has  more than 10 years of experience in IT, with expertise that includes MySQL, Oracle technologies, and monitoring solutions. Active in the Oracle community, she is a member of the ITOUG board and regularly speaks at conferences and events. Confirmed as an Oracle ACE Associate on February 15, 2019.

Oracle ACE Associate Simo Vilmunen Simo Vilmunen
Toronto, Canada
Twitter LinkedIn 

Simo, a Technical Architect at Uponor Business Solutions, has worked with Oracle databases since 2000 and with Oracle Applications since 2004. His current focus is on using Oracle Cloud Infrastructure (OCI) functionality to modernize solutions like Oracle Applications by automation, scaling and infrastructure as code. Confirmed as an Oracle ACE Associate on February 15, 2019.

Oracle ACE Associate Shengdong Zhang Shengdong Zhang
Beijing, China
   Oracle ACE Associate

Shengdong Zhang has been working with Oracle database since 2010, and has extensive experience in database backup and recovery, monitoring, troubleshooting,performance tuning and architecture design.  Confirmed as an Oracle ACE Associate on March 20, 2019.

Oracle ACE Associate Chenxi Zhang Chenxi Zhang
Zhejiang, China

Chenxi Zhang is the Technical Manager for a domestic insurance company in China, and he is the co-founder of CN'SOUG (China Southern Oracle User Group), the largest Oracle User Group in southern China. His expertise is in Database Management/Performance, Middleware/SOA, Linux, Virtualization and Open Source. Confirmed as an Oracle ACE Associate on January 7, 2019.

About the Oracle ACE Program

Recognized for their technical expertise, Oracle ACEs contribute knowledge with articles, technical advice, blog posts, presentations, and tweets. Join the community and learn from their insights and experience. Learn more.

Related Resources

 

 

Quickly build self-signed certificates for Oracle GoldenGate 18c

DBASolved - Wed, 2019-03-27 13:30

With Oracle GoldenGate Microservices 12c and 18c, the architecture can be configured to use SSL certificates for securing and replicating between sites. This is a huge improvement for securing the replication framework and makes it a lot simpler to replicate data over standard HTTPS ports.

In order to configure Oracle GoldenGate 12c/18c Microserivces with SSL certificates, you either have to generate a self-signed certificate or bring your own certificate (BYOC) to use. This also requires you to build an Oracle Wallet to store the certificates in. Additionally, to secure both sides of the replication environment within a Microservices environment; the wallet is required to be copied to any other environment where you will be replicating to or from.

In this post, I’m providing you with a simple python script that will build the Self-Signed Certificates needed for testing purposes. By using this overly-simplified, script you assume responsibility of using the generated certificates.

For more details on configuring Oracle GoldenGate Microservices 12c/18c using Self-Signed Certificates, refer to the Oracle documentation for Securing Oracle GoldenGate Microservices (here).

My overly-simple python script is located here.

Happy Securing and Enjoy!!!

Categories: DBA Blogs

Accessing Visual Builder Business Objects through REST Services

Shay Shmeltzer - Wed, 2019-03-27 13:22

One nice thing about Visual Builder is that it helps you not only with the creation of the front end, but also with the creation of the backend for your app - through the use of the business objects feature. When you develop the UI in VB it is accessing the business objects through REST endpoints, and these REST endpoints can also be exposed so other UIs or systems can access the same data.

In the video below, I'm showing you how to access the business objects and perform the full set of CRUD operations against them.

There are many more capabilities to these REST APIs including advanced query options that help you optimize the amount of data you are getting back from them. Read about it in our documentation.

One more note - in the demo I use the Bearer Token security, but you can also switch to use basic authentication to access your services. To do this in your application settings, under the business object tab, you can check the check box for enabling this.

Security setting for business objects

 

 

Categories: Development

TWINSET Curates a Sophisticated Customer Experience with Oracle Retail

Oracle Press Releases - Wed, 2019-03-27 11:00
Press Release
TWINSET Curates a Sophisticated Customer Experience with Oracle Retail Italian Clothing Brand Modernizes Point of Service to Increase Storefronts and Better Engage Customers

REDWOOD SHORES, Calif. and MILAN, Italy—Mar 27, 2019

TWINSET curates a unique assortment of women’s ready-to-wear fashion, shoes and accessories sold online and across renowned Italian, European and Russian cities. As the company continued to grow, they knew maintaining harmony between delivering high-quality clothing and excellent customer service was essential. With Oracle Retail’s modern point of service (POS) technology, TWINSET can open more boutiques and corner stores that meet international requirements, while delighting sophisticated shoppers with associates that are informed and ready to help.

“We want our consumers, the brand and our associates to be in harmony when they enter the store. By putting intuitive and modern technology at our associates’ fingertips, they can focus on the customer and delivering a seamless omnichannel experience,” said Federico Tamburini, IT and logistic director, TWINSET. “Oracle also enables us to quickly roll out new boutiques by leveraging the international and localization capabilities inherent in the solution.”  

In the recent Topography of Retail Report, nearly 6,400 European consumers surveyed prioritized knowledgeable in-store staff (73 percent) as one of the most compelling attributes of a shopping experience. Oracle Retail Xstore Point-of-Service will empower TWINSET associates to deliver on the brand commitment in store with inventory visibility, customer intelligence, and seamless transactions.

For example, from a tablet, an associate will be able to easily pull up a customer’s recent transactions to get a sense of their style and make suggestions on new merchandise or easily order an out-of-stock item from the website and have it shipped directly to the customer with no hassle.

“The in-store experience must go beyond transactions alone. Retailers, particularly fashion retailers, must dazzle their customers at the point of interest. By modernizing in-store POS technology, brands such as TWINSET are putting consumer intelligence in the associates’ hands, allowing them to personalize the interaction and build trust between the brand and the individual,” said Mike Webster, senior vice president and general manager, Oracle Retail.

Contact Info
Kris Reeves
Oracle PR
+1.925.787.6744
kris.reeves@oracle.com
About Oracle Retail

Oracle is the modern platform for retail. Oracle provides retailers with a complete, open, and integrated platform for best-of-breed business applications, cloud services, and hardware that are engineered to work together. Leading fashion, grocery, and specialty retailers use Oracle solutions to accelerate from best practice to next practice, drive operational agility and refine the customer experience. For more information, visit our website www.oracle.com/retail.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly-Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at 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.

Talk to a Press Contact

Kris Reeves

  • +1.925.787.6744

ORA-00984 column not allowed here

VitalSoftTech - Wed, 2019-03-27 09:45
What is the cause of the "ORA-00984 column not allowed here" error? How do I resolve this?
Categories: DBA Blogs

Documented JSON Classes

Jim Marion - Tue, 2019-03-26 19:18

Looking through the PeopleTools 8.57 Feature Overview document, you may have noticed that 8.57 now includes support for several JSON classes as well as PeopleBooks documentation. As Chris Malek showed us a couple of years ago, the classes listed in the Feature Overview document are not new. What is new is the keyword Support and PeopleBooks documentation. Using the documentation, I was able to generate a sample on PeopleTools 8.57:

Local JsonBuilder &jbldr = CreateJsonBuilder();
Local string &json;

If &jbldr.StartArrayReturnsTrue("Employees") Then
REM Empl 1;
If &jbldr.StartObjectReturnsTrue("Employee") Then
If &jbldr.StartObjectReturnsTrue("Name") Then
&jbldr.AddProperty("First", "Jim");
&jbldr.AddProperty("Last", "Marion");
&jbldr.AddProperty("Middle", "J");
&jbldr.EndObject("Name");
End-If;
&jbldr.AddProperty("ID", 123456);
&jbldr.EndObject("Employee");
End-If;

REM Empl 2;
If &jbldr.StartObjectReturnsTrue("Employee") Then
If &jbldr.StartObjectReturnsTrue("Name") Then
&jbldr.AddProperty("First", "Lucy");
&jbldr.AddProperty("Last", "McGillicuddy");
&jbldr.AddProperty("Middle", "");
&jbldr.EndObject("Name");
End-If;
&jbldr.AddProperty("ID", 789123);
&jbldr.EndObject("Employee");
End-If;
&jbldr.EndArray("Employees");
End-If;

&json = &jbldr.ToString();

MessageBox(0, "", 0, 0, &json);

Alternatively, we can build JSON structures using JsonObject and JsonArray directly, but I like the way the JsonBuilder structures code so that child items appear indented, etc. Notice the code above begins the JSON structure with an array? Here is the output. Notice the root node is an object, not an Array:


Even though my very first call to JsonBuilder was to start an Array, it started an Object. What if you just want an array as the outer node? We can extract the array from the JsonBuilder RootNode using the following:

&jbldr.GetRootNode().GetJsonObject().GetJsonArray("Employees");
What if we want to format the code? First, I don't recommend formatting code you will transmit to external systems as white-space compressed JSON is preferred for data transmission. But formatting for debugging purposes is perfect. We can format JsonBuilder output using the JsonGenerator class. Here is a fragment that will format the JsonBuilder result:
Local JsonGenerator &jgen = CreateJsonGenerator();
&jgen.SetRootNode(&jbldr.GetRootNode());
&json = &jgen.ToString();

One thing to note is that JsonBuilder will let you generate invalid JSON. The parameter to StartXxxReturnsTrue is the name of the node to create. If we start the first node with a zero-length string: &jbldr.StartArrayReturnsTrue(""), then the generated JSON will include curly brace object notation, but no property name before the Array start.

As I look through the documentation for 8.57, I see every Json class method and property documented, but what about the CreateJsonXxx functions? Anyone find documentation for these functions? Did I miss something?

As Chris pointed out, these JSON Classes have been in PeopleTools since 8.55.11. Assuming that just the documentation is new and not the classes, I ran all of this code on 8.56 and it works without modification.

At jsmpros, we teach JSON strategies through our Integration Broker and PeopleTools Delta courses. Are you interested in learning more? Contact us to schedule your next PeopleTools training session.

Non-Deterministic Functions and Scalar Subquery Caching

Tom Kyte - Tue, 2019-03-26 09:26
Hi, i got one question regarding scalar subquery: Why does Oracle not restrict scalar-subquery-caching to functions which are declared to be deterministic? With the deterministic keyword the developer states that a function is deterministic...
Categories: DBA Blogs

dbms_assert package

Tom Kyte - Tue, 2019-03-26 09:26
Hi, Oracle provides dbms_assert package with functions which can be used to safeguard SQL injections. Shall I use this package like below in my java application. select DBMS_ASSERT.sql_object_name ('test') from dual; I didn't see people usi...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator