Feed aggregator

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
1.650.506.0076
julie.sugishita@oracle.com
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.

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

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 11.2.0.4 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

https://www.vmworld.com/en/video-library/search.html#text=%22KUB2038%22&year=2020

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

Recursive Function

Tom Kyte - Tue, 2020-10-27 03:46
Can you please give me an example for recursive function in plsql Which takes i_date as an input variable using this i_date it should perform operations like it should fetch data from table into cursor From this cursor I should insert data into a file .This file should be generated seperately for date that is passed in as input Let us take that my input date is 01012016 the function should recursively perform until it reaches 31122016 (for every last day of a month i.e total 12 times)
Categories: DBA Blogs

Number of CPUs and Degree of Parallelism

Tom Kyte - Tue, 2020-10-27 03:46
Hi Tom, 1) Is there or What is the relationship between number of CPUS the host has to the degree of Parallelism selected say while running DBMS_STATS. 2) Is there a relationship between DB sessions and Degree of Parallelism. If I have say 4 CPUS and select degree of 4 When I run DBMS_STATs will it show 4 DB sessions and consume 4 CPUS ? Or It will definitely show 4 DB sessions but no. of CPU depends upon availabilty from OS side. So even 2 CPUS will be used for 4 sessions ? 3) Is there always one to one relationship between a DB session ( from v$session) and OS process (seen with ps command ) 4) DBMS_SCHEDULER does it need to have job_queue_processes set like the old days with dbms_job Please answer with respect to 9208 and 11107 version.
Categories: DBA Blogs

Materialized View Log

Tom Kyte - Tue, 2020-10-27 03:46
Db Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production <code>desc Par_trials; Column Name Pk Null? Data Type PARTY_TRIAL_ID 1 N NUMBER (11) PARTY_ID N NUMBER (11) PARTY_ROLE_TYPE_ID N NUMBER (11) CLINICAL_TRIAL_ID N NUMBER (11) START_DT Y DATE END_DT Y DATE CORE_CREATE_DT N DATE CORE_LAST_UPDT Y DATE EDC_FLAG Y VARCHAR2 (1 Byte) CPAC_FLAG Y VARCHAR2 (1 Char) ELMS_FLAG Y VARCHAR2 (1 Char) CREATE MATERIALIZED VIEW LOG ON par_trials WITH ROWID, SEQUENCE (party_id,party_role_type_id,clinical_trial_id,start_dt,end_dt,core_create_dt,core_last_updt,edc_flag,cpac_flag,elms_flag), PRIMARY KEY INCLUDING NEW VALUES Insert into PAR_TRIALS (PARTY_TRIAL_ID, PARTY_ID, PARTY_ROLE_TYPE_ID, CLINICAL_TRIAL_ID, START_DT, CORE_CREATE_DT) Values (365352, 50858, 528, 1055, TO_DATE('10/30/2019 20:53:51', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/07/2019 12:03:59', 'MM/DD/YYYY HH24:MI:SS')); COMMIT; update par_trials set core_create_dt=sysdate where party_Trial_id=365352; select * from MLOG$_PAR_TRIALS</code> Question: 1) Would like to include a new column called "OPERATION$" in MLOG$_PAR_TRIALS table which should have below column values "UU" which indicates before update and should contain all its corresponding old values "UN" which indicates after update and should contain all its corresponding new values 2) In mlog creation script, have included "INCLUDING NEW VALUES" and i do have requirement to "exclude old values". Expectation here is just to retain only new values in mlog. Is that possible? If yes, kindly share example. 3) Can we do delete operation against MLOG$_PAR_TRIALS?If yes, kindly share example.
Categories: DBA Blogs

Locking issue on self created Counter scheme in our HMIS Application

Tom Kyte - Tue, 2020-10-27 03:46
Dear Team We had recently upgraded our Application counter scheme ( Previously using oracle sequences) to our own created procedure to generate Next number/counter due to our requirement to generate seperate counters for our different Hospital Campuses. Every year we have to reset all sequences because our scheme is using year based counter values. Now the issue is locking problem on our Physician Encounter where we have to generate 7-8 different counters on the same time and our procedure sometimes get locked and does not return any counter value due to locking issue Our application user may loss data to No Counter return We have two options of Row update, wait 1 sec and Nowait, sample code is mentioned below. can you please guide us on method close to Oracle sequence so that we can update code and overcome this locking issue. Also Please guide do you recommend to use FOR UPDATE without wait or NOWAIT option in SQL ? <code> IF NVL(P_LOCK_WAIT, 'N') = 'Y' THEN SELECT ROWID INTO P_ROWID FROM COUNTERS.SYSTEM_COUNTERS_VALUES T WHERE T.COUNTER_ID = P_COUNTER_ID AND T.SERIAL_NO = P_SERIAL_NO FOR UPDATE WAIT 1; ELSE SELECT ROWID INTO P_ROWID FROM COUNTERS.SYSTEM_COUNTERS_VALUES T WHERE T.COUNTER_ID = P_COUNTER_ID AND T.SERIAL_NO = P_SERIAL_NO FOR UPDATE NOWAIT; END IF </code>
Categories: DBA Blogs

DB link access between (20 Containers in the same Zone ( Oracle Suppoer cluster)

Tom Kyte - Tue, 2020-10-27 03:46
Hi Tom, We have a customer, who deployed multiple databases on the same supercluster zone and required a full segergation between each database. Here let's talk about one of zones which are having 2 databases and required a full network segergation between each other. We configured for each database a seprate network with different subent on the cluster and for sure different scan IPs and VIPs. Everything went smootly except the connectivity between the databases in the same zone with each others so we agreed to implment TCP.EXCLUDED_NODES to prevent each database to connect to the other but the problem it is not working and still database A can connect on B and viceversa, we did a test between databases in different zones and this parameter "TCP.EXCLUDED_NODES" is working properly. My Question is why it is not working with two databases in the same zone? - DB 12.1 - Zone O.S is Solaris Sparc : 11.4 - (2) Containers with (2) Different databases in the same Zone , we need to stop DB access from one DB to the other
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator