Sunday 11 June 2023

Oracle Free Certification for OCI => Race to Certification Challenge 2023

 Dear All,

Good News for all Oracle Cloud Learners, this month oracle announced Fee Oracle cloud Certifications with Free Gifts for first 300 Successfully certified professionals.

then how we can achieve this follow below instructions .


see the wheel for 3 levels of Certification race .





Below are the Oracle Official Rules :

    OFFICIAL RULES

NO PURCHASE NECESSARY. A PURCHASE WILL NOT IMPROVE YOUR CHANCES OF WINNING. VOID WHERE PROHIBITED OR RESTRICTED BY LAW.

BY REGISTERING FOR THIS CHALLENGE, YOU FULLY AND UNCONDITIONALLY AGREE TO COMPLY WITH ALL OF THE TERMS AND CONDITIONS BELOW. IF YOU DO NOT AGREE WITH ALL OF THESE TERMS AND CONDITIONS, DO NOT REGISTER FOR THIS CHALLENGE.

1. DESCRIPTION OF THE CHALLENGE:

Oracle University is launching a free training and certification promotion for OCI between 01-Jun-2023 and 31-Aug-2023, called 'Race to Certification'. This challenge is open to anyone wanting to learn and certify on OCI technologies.

Participants can earn badges and win prizes as they complete courses and certification exams.

Participants are required to complete certain criteria such as taking online digital courses on MyLearn, attending an Oracle University live session and passing certification exams in order to win prizes in the Race to Certification Challenge. There are 3 sectors in the race, and prizes are awarded as participants complete each sector in the Race to Certification. All participants who successfully complete the criteria for Sector 1, Sector 2 and Sector 3 will receive a special Oracle University Community digital Badge for each sector completed. The first 300 participants to successfully complete Sector 2 with the highest cumulative exam score, will receive an Oracle branded cap. The first 300 participants to successfully complete Sector 3 with the highest cumulative exam score, will receive an Oracle branded jacket. Oracle is the sponsor of the Challenge.

2. ELIGIBILITY:

This Challenge is limited to all registered participants of the Free Oracle Certification for OCI promotion who are 18 years of age or older, and the age of majority in entrant’s state, province, or territory as of the time of the Entry.

Persons in any of the following categories are not eligible to participate or win the prize(s) offered in this Challenge: (a) persons who are employees or agents of Oracle, its affiliates, subsidiaries, and their service agencies and independent contractors; (b) persons who are or were engaged in the development, production, distribution of materials, prizes, or Challenge of winners for this Challenge; (c) persons who are immediate family (defined as spouse, parent, sibling or child, regardless of where they reside) of, or anyone who resides in the same household as, any person in either of the preceding categories; (d) residents of the province of Quebec, Canada, the country of Italy, the Russian Federation, Belarus, Venezuela or any country under U.S. embargo during the Entry Period or at the time of Challenge; (e) employees, officers, or officials of any government entity or government or state owned entity, including, but not limited to, any person acting in an official capacity for or on behalf of any national, state, provincial or local government, or any department or agency thereof, or who otherwise is considered a public official; and (f) employees of any company that has a policy against and/or legally prohibits participation in the Challenge or the awarding of a prize/award to an employee.

3. Challenge PERIOD:

The Challenge begins at 12:00 a.m. GMT on June 1, 2023 and ends at 11:59 p.m. GMT on August 31, 2023 (the "Entry Period").

Sponsor’s clock is the official time clock for the Challenge. IMPORTANT NOTICE TO PARTICPANTS: EACH PARTICIPANT IS RESPONSIBLE FOR DETERMINING THE CORRESPONDING TIME ZONE IN PARTICIPANT’S RESPECTIVE GEOGRAPHICAL LOCATION. Activations prior to or after the Entry Period will be disqualified.

4. CONDITIONS OF ENTRY:

Participants must follow these steps to activate their access to the free promotion:

  • Visit https://education.oracle.com/oci
  • Select a Learning Path on oracle MyLearn
  • Login and activate using an Oracle Single Sign On account
  • Accept the Terms & Conditions for the Race to Certification Challenge
  • Start Learning & Certifying

Each activation into the promotion will be considered one “Entry.” Entries that do not comply with these Official Rules will be disqualified. All information collected from Entries shall be deemed collected and evaluated in the United States.

Certification exams included in the Challenge are limited to the following:


Oracle Cloud Infrastructure

1Z0-1085-23Oracle Cloud Infrastructure 2023 Foundations Associate
(English, Brazilian Portuguese, Spanish)
Does not require a “Race to certification” exam attempt
1Z0-1109-23Oracle Cloud Infrastructure 2023 DevOps Professional
(English, Brazilian Portuguese, Spanish)
1Z0-1104-23Oracle Cloud Infrastructure 2023 Security Professional
1Z0-1110-23Oracle Cloud Infrastructure 2023 Data Science Professional
(English, Brazilian Portuguese, Spanish)
1Z0-1067-23Oracle Cloud Infrastructure 2023 Cloud Operations Professional
1Z0-997-23Oracle Cloud Infrastructure 2023 Architect Professional
1Z0-1072-23Oracle Cloud Infrastructure 2023 Architect Associate
(English, Brazilian Portuguese, Spanish)
1Z0-1084-23Oracle Cloud Infrastructure 2023 Developer Professional
(English, Brazilian Portuguese, Spanish)
1Z0-1111-23Oracle Cloud Infrastructure 2023 Observability Professional
(English, Brazilian Portuguese, Spanish)
1Z0-1115-23Oracle Cloud Infrastructure 2023 Multicloud Architect Associate
1Z0-1071-23Oracle Cloud Infrastructure 2023 Digital Assistant Professional
1Z0-1042-23Oracle Cloud Infrastructure 2023 Application Integration Professional
1Z0-1041-23Oracle Cloud Infrastructure 2023 Enterprise Analytics Professional
1Z0-1118-23Oracle Cloud Fusion Analytics Warehouse 2023 Implementation Professional
1Z0-1114-23Oracle Redwood Application 2023 Developer Associate
1Z0-770Oracle APEX Cloud Developer Professional
1Z0-1120-23Oracle Content Management 2023 Implementation Professional

Oracle Database Management

1Z0-1105-23Oracle Cloud Data Management 2023 Foundations Associate
(English, Brazilian Portuguese, Spanish)
Does not require a “Race to certification” exam attempt
1Z0-1096-23Oracle Machine Learning using Autonomous Database 2023 Associate
1Z0-1094-23Oracle Cloud Database 2023 Migration and Integration Professional
1Z0-1093-23Oracle Base Database Services 2023 Professional
1Z0-931-23Oracle Autonomous Database Cloud 2023 Professional

Oracle Cloud Applications

Business Process Exams

1Z0-1106-2Oracle HCM Business Process Foundations Associate Rel 2
(English, Brazilian Portuguese, Spanish)
1Z0-1107-2Oracle Financials Business Process Foundations Associate Rel 2
(English, Brazilian Portuguese, Spanish)
1Z0-1108-2Oracle Sales Business Process Foundations Associate Rel 2
1Z0-1112-2Oracle Procurement Business Process Foundations Associate Rel 2
1Z0-1125-2Oracle SCM Business Process Foundations Associate Rel 2

5. LICENSE GRANTED:

By participating in the Challenge, Participant grants Sponsor a perpetual, irrevocable, worldwide, royalty-free, fully sub-licensable, and non-exclusive license (a) to make, use, sell, offer for sale, or import any discovery or invention covered or used by the Entry in the United States and its territorial possessions and in all foreign countries and a perpetual, irrevocable, worldwide, royalty-free, fully sub-licensable, and non-exclusive license to all Letters Patent or similar legal protection in the United States and its territorial possessions and in any and all foreign countries to be obtained for said discovery or invention from any application or any continuation, continuation-in-part, divisional, reexamination, renewal, substitute, reissue and/or any application claiming priority thereof, including any legal equivalent thereof, in a foreign country, to the extent Participant has any such rights for the full term or terms for which the same may be granted; and (b) to use, reproduce, copy, adapt, publicly perform, communicate to the public, make available and publicly display any Entry on Sponsor's web sites and web pages and/or in other marketing promotions related to Sponsor, its products and services and /or this Challenge in any and all media, now or hereafter devised, worldwide in perpetuity, without additional compensation, notification or permission, unless prohibited by law.

6. HOW TO ENTER:

To enter this Challenge, go to https://education.oracle.com/oci and (1) Select any Certification or Learning Path and (2) Sign-in and activate, using an Oracle Single Sign On account (3) Review and Accept the Terms and Conditions for the Race to Certification Challenge.

Alternative methods of entry are not accepted. Duplicate entries will be deleted and incomplete activations will not be considered. An entry in the challenge is deemed made by the authorized account holder of the email address submitted at time of activation. The authorized account holder of an email address is defined as the natural person who is assigned an email address by an Internet access provider, online service provider or other organization that is responsible for assigning email addresses or the domain associated with the submitted email address. A potential prize winner may be required to provide proof (to Sponsor’s satisfaction) that such potential prize winner is the authorized MyLearn account holder of the email address associated with the potentially prize-receiving Entry.

7. SELECTION OF POTENTIAL WINNERS:


Race to Certification Challenge Criteria
Completion CriteriaAllowed Courses, Live Sessions and Exams
* 1 Digital Course in MyLearn
* 1 Oracle University Certification Exam
* 1 Oracle University Live Session
Only those listed in the promotion https://education.oracle.com/oci
* 2 Digital Courses in MyLearn
* 2 Oracle University Certification Exam
* 1 Oracle University Live Session
Only those listed in the promotion https://education.oracle.com/oci
* 3 Digital Courses in MyLearn
* 4 Oracle University Certification Exams. (2 must be professional credentials)
* 1 Oracle University Live Session
Only those listed in the promotion https://education.oracle.com/oci

Sponsor will notify the potential winner(s) immediately following the conclusion of the promotion. The first 300 winner(s) of sector 2 and 3 will be required to sign and return an Affidavit of Eligibility/Liability/Publicity Release ("Affidavit") within ten (10) business days following notification. If Sponsor is unable to reach a potential winner, the Affidavit is not properly completed and returned to Sponsor within ten (10) business days from the date it was mailed to a potential winner, if a prize or prize notification is returned as non-deliverable, or if a potential winner is found not to have complied with these Official Rules in any way, the prize will be forfeited and an alternate winner will be selected.

8. PRIZES:

Entrants that complete Sector 1, 2 & 3 in the Race to Certification will be awarded prizes as follows:

All EntrantsFirst 300 With Highest Cumulative Score
Sector 1Oracle Digital Badge
Sector 2Oracle Digital BadgeOracle Branded Cap
Sector 3Oracle Digital BadgeOracle Branded Jacket

All properly claimed prizes will be awarded but in no event will the Sponsor award more prizes than are provided for in these Official Rules. No prize substitutions allowed, in whole or in part, except Sponsor reserves the right to substitute a prize of comparable value if a prize becomes unavailable. Winner(s) are solely responsible for any local, provincial, state, federal or any other applicable taxes, and any other costs, expenses and fees connected with the prize. If a potential winner fails to provide such documentation or comply with such laws, the prize may be forfeited and Sponsor may, in its sole discretion, select an alternative potential winner. All other expenses not specified herein are the responsibility of the winners.

9. CONDITIONS OF PARTICIPATION AND WINNING:

By entering this Challenge, Entrants agree to be bound by the terms of these Official Rules, which are final and binding on all matters pertaining to this Challenge. As between Sponsor and Entrant, the intellectual property rights to an Entry, if any, will remain with the Entrant, except that these Official Rules do not supersede any other assignment or grant of rights according to any other separate agreement between Entrant and other parties. Reasonable requests to anonymise certain aspects of an Entry will be honored should an Entrant otherwise not be permitted to participate in the Challenge. Acceptance of a prize constitutes permission for, and a winner's consent to, Sponsor and its agencies to use Entrant’s name and/or likeness and Entry for advertising and promotional purposes without additional compensation, unless prohibited by law. An Entrant may be prohibited from participating in this Challenge if, in Sponsor’s sole discretion, it reasonably believes that the Entrant has attempted to undermine the legitimate operation of this Challenge by cheating, deception, or other unfair playing practices or annoys, abuses, threatens or harasses any other Entrants, Sponsor or Sponsor's associated agencies. Any false information provided within the context of the Challenge by any Entrant concerning identity, email address, postal address, telephone number, ownership of right or non-compliance with these Official Rules or the like may result in the immediate elimination of the Entrant from the Challenge. Sponsor further reserves the right to disqualify any Entry that it believes, in its sole and unfettered discretion, infringes upon or violates the rights of any third party or otherwise does not comply with these Official Rules. Prizes are conditioned on verification that Sponsor's provision, and Entrant's acceptance, of a prize, complies with all applicable laws, regulations, and/or rules of Entrant's nation, state or province, locality and/or employer.

10. RELEASE/DISCLAIMER OF LIABILITY:

Prizes are provided "as is" without warranty of any kind from Sponsor, express or implied, without limitation, except where this would be contrary to federal, state, provincial, or local law or regulation. To the extent permitted by law, Entrants agree to hold Sponsor, its parent, subsidiaries, agents, directors, officers, employees, representatives and assigns ("Released Parties") harmless from any injury or damage caused or claimed to be caused by participation in the Challenge and/or use or acceptance of any prize. Sponsor is not responsible for any typographical or other error in the printing of the offer, administration of the Challenge or in the announcement of a prize. Each Entrant also waives and releases Released Parties from any and all claims that Entrant may now or hereafter have in any jurisdiction based on "moral rights" or "droit moral" (including without limitation any limitation any rights or claims under the Visual Artists Protection Act (17 USC section 106A)) or unfair competition with respect to Sponsor's exploitation of Entries without further notification or compensation to Entrants of any kind, and use of Entrant's likeness. Released parties are not responsible for electronic transmission errors in the Challenge resulting in omission, interruption, deletion, defect, delay in operations or transmission. Released parties are not responsible for theft or destruction or unauthorized access to or alterations of Entries, or for technical, network, telephone equipment, electronic, computer, hardware or software malfunctions or limitations of any kind. If for any reason the Challenge is not capable of running as planned, including infection by computer virus, bugs, tampering, unauthorized intervention, fraud, technical failures, disruption or termination of the public website for any reason or any other causes which corrupt or affect the administration, security, fairness, integrity, or proper conduct of this Challenge, Sponsor reserves the right at its sole discretion to immediately cancel, terminate, modify or suspend the Challenge. Sponsor reserves the right to disqualify any individual who tampers with the entry process.

CAUTION: Any attempt by an individual to deliberately damage any web site or undermine the legitimate operation of the Challenge is a violation of criminal and civil laws and should such an attempt be made, Sponsor reserves the right to seek damages from any such individual to the fullest extent of the law.

11. DISPUTE RESOLUTION/CHOICE OF LAW:

To the extent permitted by law, the rights to litigate, to seek injunctive relief or to make any other recourse to judicial or any other procedure in case of disputes or claims resulting from or in connection with this Challenge are hereby excluded, and any Entrant expressly waives any and all such rights. Entrants agree that these Official Rules and the Challenge are governed by the laws of California, USA 500 Oracle Pkwy., Redwood Shores, CA 94065, without regard for conflicts of law doctrine of any jurisdiction. The parties specifically disclaim the UN Convention on Contracts for the International Sale of Goods. Any and all claims, judgments, and awards shall be limited to actual out-of-pocket costs incurred, including costs associated with participating in this Challenge, but in no event attorneys’ fees. Entrants hereby waive all rights to (i) claim or be awarded any punitive, direct, indirect, incidental, and consequential damages and any other damages, other than for actual out-of-pocket expenses, and (ii) to have damages multiplied or otherwise increased, including for willful patent infringement.

12. DATA PRIVACY:

Entrants agree that personal data, especially name and address, may be processed, stored and otherwise used for the purposes and within the context of the Challenge and any other purposes outlined in these Official Rules or in Oracle’s Privacy Policy, located at http://www.oracle.com/html/privacy-policy.html. Sponsor may use and share an Entrant’s personal data with third parties to the extent necessary to fulfill its obligation to administer and sponsor this Challenge.

13. INDEMNITY:

To the maximum extent permitted by law, each Entrant indemnifies and agrees to keep Sponsor indemnified and held harmless at all times from and against any liability, actions, claims, demands, losses, damages, costs and expenses for or in respect of which Sponsor will or may become liable by reason of or related or incidental to any act, default or omission by a participant under these Official Rules including without limitation resulting from or in relation to any breach, non-observance, act or omission, whether negligent or otherwise, pursuant to these Official Rules by an Entrant.

14. SEVERABILITY:

If any provision(s) of these Official Rules are held to be invalid or unenforceable, all remaining provisions hereof will remain in full force and effect.

15. WINNERS LIST:

To the extent allowed by law, Oracle will provide the name of the winner(s) or a copy of the Official Rules upon request.

16. SPONSOR CONTACT:

You may contact Sponsor at Oracle, 500 Oracle Pkwy., Redwood Shores, CA 94065.


Thanks,

Srini

Friday 9 June 2023

Data Pump Conventional Export/Import from OnPrem to OCI Cloud

 Dear All,


In this post i am sharing 

Data Pump Conventional Export/Import from OnPrem to OCI Cloud.


On-Prem # Make Directory

$ mkdir -p /opt/oracle/dump

$sqlplus / as sysdba

SQL> Create directory dpump_dir as '/opt/oracle/dump';

# Perform Export Operation (connecting to your non-cdb database or PDB)

$ expdp system/Oracle321@oracleonprem:1521/onpredb1 schemas=dbatest directory=dpump_dir flashback_time=systimestamp dumpfile=exp_dbatest_schema.dmp logfile=exp_dbatest_schema.log

 

# SCP the Dumpfiles from On-Prem Machine to OCI DB System

Above Export command will create the exp_dbatest_schema.dmp file this you can copy to destination server which is OCI DB system .

 

OCI DB-System Cloud :

 # Make Data Pump Directory

$ mkdir -p /u01/app/oracle/admin/export

SQL> create directory dpump_dir as '/u01/app/oracle/admin/export';

 # Create the tablespace for the destination

SQL> create tablespace dbaltab datafile '+DATA' size 10G;

 # Perform the Import operation

$ impdp system/Oracle786@"Host:port/service_name" SCHEMAS=dbatest DIRECTORY=dpump_dir dumpfile=exp_dbatest_schema.dmp logfile=imp_dbatest.log


Thanks,

Srini

Tuesday 6 June 2023

OCI Oracle DB Cloud Backup module


Dear All,

In this post i am sharing Oracle cloud Backup Module.

Setup on the On-Prem Machine

 # Create a new RSA Key

-bash-4.2$ java -jar oci_install.jar -newrsakeypair -walletDir

$ORACLE_HOME/dbs/opc_wallet

Oracle Database Cloud Backup Module Install Tool, build 19.3.0.0.0DBBKPCSBP_2019-10-16

OCI API signing keys are created:

PRIVATE KEY --> /opt/oracle/product/18c/dbhomeXE/dbs/opc_wallet/oci_pvt

PUBLIC KEY --> /opt/oracle/product/18c/dbhomeXE/dbs/opc_wallet/oci_pub

# Generate a Public Fingerprint from the Public Key

 Do it from the OCI Console

# Install the OCI Module

java -jar oci_install.jar -argFile arglist.txt

-host https://objectstorage.eu-frankfurt-1.oraclecloud.com

 -pvtKeyFile /opt/oracle/product/18c/dbhomeXE/dbs/opc_wallet/oci_pvt

-pubFingerPrint 07:2b:fc:10:34:b7:a4:b9:8d:83:72:ca:49:d6:11:27

-uOCID

 -tOCID

 -walletDir /opt/oracle/product/18c/dbhomeXE/dbs/opc_wallet

-libDir /opt/oracle/product/18c/dbhomeXE/lib

 -configFile /opt/oracle/opc/opc_installer/oci_installer/ociconfig.ora

# Perform an Encrypted Backup

 RMAN> set encryption on identified by "oracle12" only;

run

{

 configure channel device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/oracle/product/18c/dbhomeXE/lib/libopc.so , SBT_PARMS=(OPC_PFILE=/opt/oracle/opc/opc_installer/oci_installer/ociconfig.ora)';

backup as compressed backupset device type 'sbt_tape' database plus archivelog;

 }

 

Oracle Cloud Machine

# Create a new RSA Key

 [oracle@ocidbsystem oci_installer]$ java -jar oci_install.jar -newrsakeypair -walletDir $ORACLE_HOME/dbs/opc_wallet

Oracle Database Cloud Backup Module Install Tool, build 19.3.0.0.0DBBKPCSBP_2019-10-16

OCI API signing keys are created:

PRIVATE KEY --> /u01/app/oracle/product/18.0.0.0/dbhome_1/dbs/opc_wallet/oci_pvt

PUBLIC KEY --> /u01/app/oracle/product/18.0.0.0/dbhome_1/dbs/opc_wallet/oci_pub

Please upload the public key in the OCI console.

 # Generate a Public Fingerprint from the Public Key

 Do it from the OCI Console

 # Install the OCI Module

java -jar oci_install.jar -argFile arglist.txt

-host https://objectstorage.eu-frankfurt-1.oraclecloud.com

-pvtKeyFile /u01/app/oracle/product/18.0.0.0/dbhome_1/dbs/opc_wallet/oci_pvt

-pubFingerPrint 9d:38:a9:1c:13:57:38:ce:d3:b3:dc:c5:e7:54:16:7b

-uOCID

-tOCID

-walletDir /u01/app/oracle/product/18.0.0.0/dbhome_1/dbs/opc_wallet

-libDir /u01/app/oracle/product/18.0.0.0/dbhome_1/lib

-configFile /u01/app/oracle/staging/opc_installer/oci_installer/ociconfig.ora

 # Perform a Restore / Recover on the Oracle Cloud

 set dbid=2908503447;

SET DECRYPTION IDENTIFIED BY "oracle12";

Run

 {

 ALLOCATE CHANNEL t1 DEVICE TYPE 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/oracle/product/18c/dbhomeXE/lib/libopc.so ENV=(OPC_FILE=/opt/oracle/product/18c/dbhomeXE/dbs/opcXE.ora)';

 RESTORE CONTROLFILE FROM autobackup ;

 alter database mount ;

restore database ;

recover database;

 }


Thanks,

Srini