Feed aggregator

PeopleSoft Configuration Day November 19th, 2020

Jim Marion - Thu, 2020-10-29 15:54

Announcing PeopleSoft Configuration Day! Join me online Thursday, November 19th for a full day of configuration alternatives to customizations. Space is limited so register now!

Register Now!

Here is a sample of the topics:

  • Page and Field Configurator
  • Fluid Forms and Approval Builder
  • Activity Guide Composer
  • Related Content and Related Actions
  • Drop Zones and Event Mapping
  • Best practices, tips, and tricks!

A primary benefit of SaaS is that SaaS applications are always current. With selective adoption and continuous delivery, your PeopleSoft instance can stay current as well. What holds us back from always current? Is it customizations? Join me, Jim Marion, on November 19th, 2020 as I share configuration alternatives to customizations. Learn tips and techniques to replace customizations with upgrade-friendly configuration alternatives.

Who should attend this webinar?

  • Functional Business Analysts
  • PeopleSoft Developers
  • Project Managers
  • Team Leads

The cost is $250 per person, which is nearly 70% off our standard daily rate! We are recording the event and are offering 60-days access to registered attendees. This is going to be so much fun! Bring your questions. We'll have time for Q&A. The chat bar will be available and monitored all day.

Do you have a group of 10 or more? Contact us at info@jsmpros.com for a quantity discount!

Register Now!

AWR warehouse set up using pluggable databases

Tom Kyte - Thu, 2020-10-29 10:46
Is it not possible to use a pluggable or container database as the AWR warehouse database? The documentation doesn't state anything about it but when i go to configure the awr warehouse, there is no option to select those types of databases.
Categories: DBA Blogs

Accent-insensitive conversion

Tom Kyte - Thu, 2020-10-29 10:46
Hello TOM, Is there a way to perform a accent-insensitive conversion ONLY? I'm using the construct: <code>SELECT utl_raw.cast_to_varchar2(NLSSORT('ABCoua', 'nls_sort=binary_ai')) FROM dual;</code> which - as byproduct - is performing also a case-insensitive replacement, that is not required. Something like this: <code>SELECT my_funct('ABCoua') FROM dual;</code> should output: <code>ABCoua</code> and not: <code>abcoua</code> In case you're wondering why i need this, it's because we're storing the data in UNICODE format in our database, but we need to export it using LATIN-based characters to an international institution. Thanks,
Categories: DBA Blogs

NLS_LANG configuration for PRO*C app

Tom Kyte - Thu, 2020-10-29 10:46
<code></code><code></code><code></code><code></code><code></code>Hi Gurus, I have a problem with my Pro*C application. MY OS -> RedHat release 5.5 (Tikanga) My database; Oracle Database 11g Enterprise Edition Release - 64bit Production PL/SQL Release - Production CORE Production TNS for Linux: Version - Production NLSRTL Version - Production nls_paramters; NLS_LANGUAGE <b>AMERICAN</b> NLS_TERRITORY <b>AMERICA</b> NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_CHARACTERSET <b>WE8ISO8859P9</b> NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE Before I run my C app, I set NLS_LANG. For example ; export NLS_LANG=AMERICAN_AMERICA.UTF8 and I run appl on unix terminal -> <code>./app sqlstmt"select * from mus_test_char"</code> Connected to ORACLE as user: mus/mus123@orcl Unloading 'select * from must_test_char' Array size = 10 IDD,TEXT "1"|<b>"(null)"</b> if I export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P9 and I run <code>./app sqlstmt"select * from mus_test_char" </code> Connected to ORACLE as user: mus/mus123@orcl Unloading 'select * from must_test_char' Array size = 10 IDD,TEXT "1"|<b>"?aaaa?aaaaa?aaaaa?aaaaa?aaaaa?aaaaa?aaaa?aaa"</b> 1 rows extracted If I unset NLS_LANG -> unset NLS_LANG and I run -> <code>./app sqlstmt"select * from mus_test_char"</code> Connected to ORACLE as user: mus/mus123@orcl Unloading 'select * from must_test_char' Array size = 10 IDD,TEXT "1"|<b>"Saaaa?aaaaaUaaaaaOaaaaaCaaaaa?aaaaa?aaaaoaaa"</b> 1 rows extracted My original data in database following; 1 Saaaa?aaaaaUaaaaaOaaaaaCaaaaa?aaaaa?aaaaoaaa Can you help me about this problem ? Edit: I tried my app another Database. It's NLS Settings , AMERICAN_AMERICA.AL32UTF8 And I set on my client NLS_LANG=AMERICAN_AMERICA.UTF8 Then I run my app on that machine , I get values correctly.. 1 Saaaa?aaaaaUaaaaaOaaaaaCaaaaa?aaaaa?aaaaoaaa Thanks.
Categories: DBA Blogs

Getting your SQL Statement's SQL_ID

Hemant K Chitale - Thu, 2020-10-29 09:55

 SQL*Plus now can provide you the SQL_ID of the last statement executed in your own session with SET FEEDBACK SQL_ID.

A quick demo :

SQL> set feedback on sql_id
SQL> select count(*) from my_target where factory='SYS';


1 row selected.

SQL_ID: g1mk14hdxc1ww
SQL> select * from table(dbms_xplan.display_cursor('g1mk14hdxc1ww'));

SQL_ID g1mk14hdxc1ww, child number 0
select count(*) from my_target where factory='SYS'

Plan hash value: 1690349505

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
| 0 | SELECT STATEMENT | | | | 6 (100)| |
| 1 | SORT AGGREGATE | | 1 | 5 | | |
|* 2 | INDEX RANGE SCAN| MY_TARGET_NDX | 2683 | 13415 | 6 (0)| 00:00:01 |

Predicate Information (identified by operation id):

2 - access("FACTORY"='SYS')

19 rows selected.

SQL_ID: 5dyyqqwuyu01v

After I executed my query against the "my_target" table, SQL*Plus provided my the SQL_ID ("g1mk14hdxc1ww").  I could then immediately get the Execution Plan for the statement, without having to query for the SQL_ID in V$SQL or V$SQLAREA.

This demonstration is with SQL*Plus 19.0 against a 19c Database.  (I think "set feedback on sql_id" was introduced in SQL*Plus 18)

Categories: DBA Blogs

Pennsylvania State University Joins Oracle Academy to Help Students Become Cloud Developers and Technology Leaders

Oracle Press Releases - Wed, 2020-10-28 18:23
Press Release
Pennsylvania State University Joins Oracle Academy to Help Students Become Cloud Developers and Technology Leaders Penn State’s 22 Campuses Gain Free Cloud Resources, Curriculum, Faculty Training, and Technology

Redwood Shores, Calif.—Oct 28, 2020

Today, Oracle announced that The Pennsylvania State University (Penn State) will now offer Oracle Academy computing education curriculum and resources across 22 campuses, which serve nearly 100,000 students. Through the collaboration, students receive hands-on technology experience and develop skills to become career-ready in the era of cloud computing, artificial intelligence, data science, and beyond.
“In today’s economy, technology is essential to every industry,” said Donald J. Welch Ph.D., Penn State’s vice president for Information Technology and chief information officer. “Oracle Academy’s wide range of resources – including creative and engaging curriculum designed for diverse groups, personalized faculty trainings, and access to Oracle Cloud Free Tier – provide Penn State students with unique opportunities to understand and experience the technologies changing the world.”
“We are thrilled that Penn State has joined Oracle Academy in a shared mission to advance computing education,” said Denise Hobbs, North America Regional Director, Oracle Academy. “Deploying Oracle Academy resources at one of the world’s leading higher education and research institutions highlights the value of our program and helps bring essential computing knowledge and skills to more American university students.”
Oracle’s leadership in cloud and emerging technologies propels Oracle Academy’s innovation-focused curriculum, resources, and workshops. As an Oracle Academy Institutional Member, Penn State will gain free access to a wide range of computing tools and training, including:
  • Oracle Academy Cloud Program: Access to Oracle Autonomous Database and Compute Virtual Machines (VM) through Oracle Cloud Free Tier, as well as 3,500 hours of free cloud credits annually for emerging technologies, infrastructure, database, application development, and more.
  • Oracle Application Express (APEX): Access to Oracle Application Express (APEX) for hands-on practice in the cloud. APEX is a cloud-based, low-code development platform that enables users to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere.
  • NetSuite: Access to NetSuite and NetSuite OneWorld software as a service (SaaS) solutions to provide students with practical, hands-on business computing experience in enterprise resource planning (ERP), sales and marketing, ecommerce, supply chain, and more.
  • Curriculum and Learning Resources: College-ready and career-focused curriculum and learning modules in Java, database, and project management. A sampling of courses include: Artificial Intelligence with Machine Learning in Java, Oracle Application Express (APEX) Development Foundations, and Oracle Primavera P6 Professional Project Management Fundamentals.
The Penn State faculty are fully supported by Oracle Academy to help students learn, build, explore, and become innovators and leaders in and outside of the classroom.
Supporting Resources
Contact Info
Julie Sugishita Cantor
Oracle Corporate Communications
About Oracle Academy
As Oracle’s global, philanthropic educational program, Oracle Academy advances computing education around the world to increase knowledge, innovation, skills development, and diversity in technology fields. The program engages with thousands of educational institutions and educators in more than 120 countries, helping millions of students become college and career ready.
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.


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

Julie Sugishita Cantor

  • 1.650.506.0076

Extract Data From Blob file Column (xml,json,xlsx,csv)

Tom Kyte - Wed, 2020-10-28 16:26
Hi, In apex i can able to extract data from EXCEL using XLSX PARSER, but in my case user uploading the file based on the file type (Ex: EXCEL/CSV/JSON/XML) i'm storing into as a blob column. i want to extract the data(from Blob column) based on the type and i want to storing into another table as a records. Is there any option to extract the data from blob column. Please provide any sample. Thanks, Praveen
Categories: DBA Blogs

Oracle RAC - I/O Performance

Tom Kyte - Wed, 2020-10-28 16:26
In a RAC environment since we are using more than one nodes for a database, will there be more read/write congestion than in a standalone ASM database? If yes, is there any solution to minimise that congestion.
Categories: DBA Blogs

Create web source module on APEX

Tom Kyte - Wed, 2020-10-28 16:26
Hi everyone, I have one web page name sth like that: 'https://bus/api/check'. When I run this web, it returns data normally. But when I create web source module, it shows me as below An error occurred during URL invocation. ORA-29024: Certificate validation failure I search on GG about that problem. I try to solve my problem follow this web: https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6121/index-en.html It is very cleart. I created new wallet named https_wallet and added certificate successfully. Howerver, I check by select statement on DB, with code: <code>select APEX_WEB_SERVICE.make_rest_request(p_url => ''https://bus/api/check',p_http_method => 'GET',p_wallet_path => 'file:C:/temp/wallet/https_wallet',p_wallet_pwd => 'pass_word') from dual;</code> <b>It shows HTTPS request failed and security violation. I don't know why that reason. I tried those steps on Google web, I can get certificate successfully. Now my certificate is from Amazone. I check web via checkssl online, everything it is ok, but I don't understand when I check serial number of the first of certificate, it shows me serial number is 00. Can anyone help me to solve my those problem. I do not have much experience in create web source module. Thank in advance.</b> Ask about Web Source Module
Categories: DBA Blogs

Query Performance on client significantly slower than on server

Tom Kyte - Wed, 2020-10-28 16:26
Hi all, we have an application which runs reports from Windows7/10 client against an ORCALE 19c Standard Edition Database on Windows Server 2019. Before, the application queries where running against ORACLE 12c Standard Edition. We have noticed that the reports run significantly longer against ORACLE 19C. So we have then tried to find the cause. Therefore we have taken the pure select SQL of the report and have run it from SQL Developer 20.0.0 from an Windows 10 Client and then directly on the Windows server. And still the same. The select uery run from SQL Developer on the Server runs approximately 3.5 secs, and from the client it needs about 180 secs. Then we have run autotrace from within SQL Developer on both platforms and it gives us exactly the same execution plan. The connection in SQL Developer on both platforms is defined with sys as sysdba and a TNS connection via a network alias. We have currently abosulutely no clue why this is happening. Basically everything is the same, the only difference is that SQL Developer runs once on Windows 10 and once on Windows Server 2019. We are lookoing forwrd to any hints and tipps you might have. Thanks a lot for your expertise. Cheers Que
Categories: DBA Blogs

Logging exception causing PSLQL or SQL statements inside PLSQL exception handler

Tom Kyte - Wed, 2020-10-28 16:26
Hi Tom, I would like to know if there is any way to code exception handlers in such a way as to capture the specific PLSQL or SQL statements that shall cause an exception inside the same PLSQL block for which the exception handler is written. For example, say below statement inside a PLSQL block, <code>v_num (a number datatype variable) := <text data>;</code> this shall cause the obvious exception and this particular statement shall be captured along with the parsed values (the actual value at the right hand side of this statement that was responsible for the exception), and logged from the exception handler. Similarly, another SQL statement in the same block, during the next run, shall cause some exception and the parsed version of that SQL statement shall be captured and logged from the exception handler. I know what I am asking is akin to the formal debugging mechanism, but is this something impossible to achieve ? Regards, Manohar Mishra.
Categories: DBA Blogs

Sending an e-mail with UTL_SMTP to multiple recipients shows only the first recipient in the list

Tom Kyte - Wed, 2020-10-28 16:26
Hello, I have a stored procedure to send e-mails using UTL_SMTP. It's prepared to accept a list of e-mail addresses in the "To" and the "CC" parameter. And functionally, it works as expected: it sends the e-mail to the list provided. The issue is, when the recipients open the e-mail, they only see the first e-mail address on the list, and if they want to reply-all they won't be able to do it, because the rest of the e-mail addresses does not display. For example, if I use the following code: <code>BEGIN IVC_SEND_MAIL('no-reply@mydomain.com', 'alex@mydomain.com', 'one@mydomain.com;two@mydomain.com;three@mydomain.com',NULL, 'Subject', 'Body'); END;</code> It will send the e-mail to alex, one, two and three; but, the e-mail will show the header of the e-mail as: To: alex@mydomain.com Cc: one@mydomain.com and it won't show two@mydomain.com nor three@mydomain.com So, the question is: what am I missing? How can I make sure the whole distribution list is displayed? Thank you. This is the code for the procedure I'm using: <code>CREATE OR REPLACE PROCEDURE IVC_SEND_MAIL (v_from in varchar2, v_to in varchar2, v_cc in varchar2, v_bcc in varchar2, v_subj in varchar2,v_body in varchar2) IS v_crlf VARCHAR2(2) := CHR( 13 ) || CHR( 10 ); v_mesg VARCHAR2(10000); v_conn utl_smtp.connection; v_email_svr VARCHAR2(4) := 'mailserver'; v_port NUMBER := 25; v_cc_msg VARCHAR2(2000); BEGIN v_conn := utl_smtp.open_connection( v_email_svr, v_port ); utl_smtp.helo( v_conn, v_email_svr ); utl_smtp.mail( v_conn, v_from); FOR x IN (SELECT LEVEL AS id, REGEXP_SUBSTR(v_to, '[^;]+', 1, LEVEL) AS TO_EMAIL_NAME FROM DUAL CONNECT BY REGEXP_SUBSTR(v_to, '[^;]+', 1, LEVEL) IS NOT NULL) LOOP utl_smtp.Rcpt(v_conn,x.TO_EMAIL_NAME); END LOOP; IF v_cc IS NOT NULL THEN FOR x IN (SELECT LEVEL AS id, REGEXP_SUBSTR(v_cc, '[^;]+', 1, LEVEL) AS CC_EMAIL_NAME FROM DUAL CONNECT BY REGEXP_SUBSTR(v_cc, '[^;]+', 1, LEVEL) IS NOT NULL) LOOP utl_smtp.Rcpt(v_conn,x.CC_EMAIL_NAME); END LOOP; v_cc_msg := 'CC: ' || v_cc || v_crlf; ELSE v_cc_msg := ''; END IF; IF v_bcc IS NOT NULL THEN FOR x IN (SELECT LEVEL AS id, REGEXP_SUBSTR(v_bcc, '[^;]+', 1, LEVEL) AS BCC_EMAIL_NAME FROM DUAL CONNECT BY REGEXP_SUBSTR(v_bcc, '[^;]+', 1, LEVEL) IS NOT NULL) LOOP utl_smtp.Rcpt(v_conn,x.BCC_EMAIL_NAME); END LOOP; END IF; v_mesg := 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || v_crlf || 'From:' || v_from || v_crlf || 'Subject: ' || v_subj || v_crlf || 'To: ' || v_to || v_crlf || v_cc_msg || 'Mime-Version: 1.0;' || v_crlf || 'Content-Type: text/html; charset="ISO-8859-1";' || v_crlf || '' || v_crlf || ''|| v_crlf||v_body; utl_smtp.data( v_conn, v_mesg ); utl_smtp.quit( v_conn ); END; / </code>
Categories: DBA Blogs

Expdp error: GetFileInformationByHandle() failure, unable to obtain file info

Tom Kyte - Wed, 2020-10-28 16:26
Hello TOM, We've recently upgraded an database to 19.3 on Windows 2012R2. As post-upgrade actions recommended, we changed the symbolic links on directories from UNC shares(\\computer_name\xxx) to a network drive with letter (e.g. Y:\) While trying to run expdp (with both 11.2 and 19.3 binaries) jobs on that network drive, we get the following errors <code>ORA-39000: bad dump file specification ORA-31641: unable to create dump file "Y:\...\...\..." ORA-27037: unable to obtain file status OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info O/S-Error: (OS 5) Access is denied.</code> I googled this OSD-04011 error message that looks a Microsoft OS error, but they are simply sending me back to Oracle. Could it be linked to the OS user that installed Oracle database/ORACLE_HOME ? We are running the database service using "LocalSystem" and the permissions are set correctly (i would say) on the share, namely using server's domain account (SERVERNAME$). Any thoughts ?
Categories: DBA Blogs

Equvivalent function for ISDATE()

Tom Kyte - Tue, 2020-10-27 22:06
Hi Tom, I've been using Oracle for Sometime now, I use a lot of MSSQL and Sybase, I'm trying to load some ascii file using SQL Loader(sqlldr), I want to know if there is any oracle function equvivalent to ISDATE() function in MSSQL or Sybase. If my Ascii file contains data which is not of date datatype, I want to insert a NULL instead of loading some wrong data or getting an error in sqlload. Thanks for your Help Srini
Categories: DBA Blogs

IP address

Tom Kyte - Tue, 2020-10-27 22:06
I have got an Oracle version 8.1.1 I'd like to know how you get the IP address from users when they have already logged on the Database. Would you, please, send me infomations about versions older than 8.i? Thanhs beforehand.
Categories: DBA Blogs

How to Become a Kubernetes Admin from the Comfort of Your vSphere

Pas Apicella - Tue, 2020-10-27 17:18

 My Talk at VMworld 2020 with Olive power can be found here.

Talk Details

In this session, we will walk through the integration of VMware vSphere and Kubernetes, and how this union of technologies can fundamentally change how virtual infrastructure and operational engineers view the management of Kubernetes platforms. We will demonstrate the capability of vSphere to host Kubernetes clusters internally, allocate capacity to those clusters, and monitor them side by side with virtual machines (VMs). We will talk about how extended vSphere functionality eases the transition of enterprises to running yet another platform (Kubernetes) by treating all managed endpoints—be they VMs, Kubernetes clusters or pods—as one platform. We want to demonstrate that platforms for running modern applications can be facilitated through the intuitive interface of vSphere and its ecosystem of automation tooling


Categories: Fusion Middleware

Back to Oracle Blogging

Andrejus Baranovski - Tue, 2020-10-27 10:35
I'm back to Oracle blogging Partying face. This time it will be Youtube vlogging focused on Oracle VBCS. My first video is live. I plan to post technical tips about VBCS at least twice per month.

Oracle Redaction

Tom Kyte - Tue, 2020-10-27 03:46
Hello I have a question on oracle redaction. Can oracle redaction be turned on based on a value in a column? please let me know Thanks subramanyam
Categories: DBA Blogs

Problem with the number 1/19

Tom Kyte - Tue, 2020-10-27 03:46
Oracle is under the impression that 1/19 * 19 - 1 = -6 x 10^(-40). You can replace 19 with 19 multiplied by any positive power of 100 and the problem remains. (When you multiply 19 by an odd power of 10, the answer is zero. For example, 1/1900 * 1900 - 1 = -6x10^(-40), but 1/190 * 190 - 1 = 0.) I understand it has to do with the way numbers are stored internally, but is there a simple way around it? Note that this also happens in version 10.2.4
Categories: DBA Blogs

How to reset sequences?

Tom Kyte - Tue, 2020-10-27 03:46
Sir, Greetings. I would just like to know if it is possible to truncate a sequence to reset back to its original starting number? Pls. help me. Thank you. Merry Christmass. - Vince Crismer C. Villena
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator