74 Matching Annotations
  1. May 2024
    1. Unlike other default asset permissions, SMS code permissions can only be setup for security groups, not individual users. SMS codes are not created by users and aren't an asset type you can manage with Asset Creation controls for the security group. You can only setup default SMS code permissions for the security group at a time. You cannot grant individual users default SMS code permissions. The permissions are for the security group.
    1. In Oracle Eloqua, contacts are created by email address and email addresses are expected to be unique. Therefore, a single phone number may be associated to multiple contacts if someone is in Oracle Eloqua under two separate emails but has only given one phone number. In this case, if that phone number is opted in, then phone opt in appears against both contacts.
    1. The SMS Message Designer provides an easy-to-use interface to build your message content and easily add features like field merges, hyperlinks, and keywords. An SMS keyword is a word or phrase that your subscribers can text to an SMS code to interact with your SMS campaign. A code and keyword combination cannot be activated simultaneously on multiple campaigns.
    1. Oracle Eloqua can only send SMS messages to valid contact Business Phone or Mobile Phone numbers. You are responsible for maintaining valid phone numbers in your contact database. Phone numbers must be in International or e.164 format. You can enable phone number validation to prevent invalid numbers from being saved in your database.

      Phone number validation is available.

      https://docs.oracle.com/en/cloud/saas/marketing/eloqua-user/Help/ContactFields/Tasks/PhoneNumberValidation.htm

      https://docs.oracle.com/en/cloud/saas/marketing/eloqua-user/Help/Forms/Tasks/StyleForm.htm#Field

    1. Custom and Help types do not perform any system action and can be used for pure marketing orchestration setup. Custom keyword allows you to interact with your customer base via SMS content, while the Help keyword offers an intuitive way for the customer to receive assistance or clarification.
  2. Nov 2023
  3. Jul 2023
    1. Server Control Utility (SRVCTL)

      SRVCTL is a command-line interface that you can use to manage an Oracle RAC database from a single point. You can use SRVCTL to start and stop the database and instances and to delete or move instances and services. You can also use SRVCTL to manage configuration information, Oracle Real Application Clusters One Node (Oracle RAC One Node), Oracle Clusterware, and Oracle ASM.

    1. Recovery Manager Documentation Roadmap

      LA liste de lectures pour RMAN etc.

      Begin by reading "Getting Started with RMAN". This brief chapter, which explains the most basic RMAN techniques, may be adequate for your purposes. For a more comprehensive explanation of how to implement a backup and recovery strategy with RMAN, read the chapters in the following order (optional chapters are not listed

  4. Nov 2022
    1. Friday, August 01, 2008 OTN members, don't change your e-mail account! I am regular user of OTN and its forums. Last week I was trying to login to OTN from a public computer and I got the "invalid login" error everytime I tried. I was sure I was typing my password correct but I could not get in anyway. So, I tried to get my password reset and sent to my e-mail address. Then I remembered that the e-mail address I used to register for OTN was from my previous employer meaning I did not have access to it anymore. As OTN does not allow changing the registration e-mail address I was stuck. I send a request from OTN to get my password delivered to my current e-mail address. Here is the reply I got:Resolution: Oracle's membership management system does not currently supportthe editing of the email address or username in your membership profile.(It will support this capability in a future release.)Please create a new account with the new email address you wish to use. However,it is possible to change the email at which you receiveDiscussion Forum "watch" emails (see "Your Control Panel" when logged in).They tell me to create a new user and forget about my history, watch list, everything. What a user centric approach this is.If you are an OTN member do not lose your password and your e-mail account at the same time, you will not find anybody from OTN who is willing to solve your problem and help you to recover your password.I am used to bad behavior and unwillingness to solve problems in Metalink, now I get the same behavior in OTN. Whatever, just wanted to let you know about it.
      • IMPORTANT
    1. What Is a Blockchain Oracle? A blockchain oracle is a secure piece of middleware that facilitates communication between blockchains and any off-chain system, including data providers, web APIs, enterprise backends, cloud providers, IoT devices, e-signatures, payment systems, other blockchains, and more. Oracles take on several key functions: Listen – monitor the blockchain network to check for any incoming user or smart contract requests for off-chain data. Extract – fetch data from one or multiple external systems such as off-chain APIs hosted on third-party web servers. Format – format data retrieved from external APIs into a blockchain readable format (input) and/or making blockchain data compatible with an external API (output). Validate – generate a cryptographic proof attesting to the performance of an oracle service using any combination of data signing, blockchain transaction signing, TLS signatures, Trusted Execution Environment (TEE) attestations, or zero-knowledge proofs. Compute – perform some type of secure off-chain computation for the smart contract, such as calculating a median from multiple oracle submissions or generating a verifiable random number for a gaming application. Broadcast – sign and broadcast a transaction on the blockchain in order to send data and any corresponding proof on-chain for consumption by the smart contract. Output (optional) –  send data to an external system upon the execution of a smart contract, such as relaying payment instructions to a traditional payment network or triggering actions from a cyber-physical system.

      Seems related to the paradox of information systems. Add to Anki deck

  5. Sep 2022
    1. If your triggers depend on the "firing order", you NEED to (must) consolidate them into a single trigger (put them in separate procedures, have one trigger that calls them in order) UPDATE 15 Jan 201911g Added the precedes and follows clauses to triggers. This allows you to define which order trigger fire. https://www.oracle.com/pls/topic/lookup?ctx=dblatest&id=GUID-AF9E33F1-64D1-4382-A6A4-EC33C36F237B__CJAEJAFB
  6. Aug 2022
  7. Feb 2022
    1. I got this error message for one of these two reasons: Most likely: you are trying to convert a local time that does not exist for reasons of DST switch, e.g. '28-MAR-21 02:34' does not exist in Germany (timezone Berlin/Europe), because clocks jump from 1:59 AM to 3:00 AM during night. Solution: add one hour, UTC will then reflect the correct time.
      • ORA-01878
      • DST
    1. The problem is “one hour missing” when DST starts at 2am — the time moves forward to 3am. It won’t happen when DST ends — the time moves backward 3am to 2am.
      • ORA-01878
      • DST
    2. As you can see from the above query results, any attempts to find data between 2am~3am with timezone information will trigger the error. As a comparison, without timezone info, query between 2am~3am works.
      • IMPORTANT
      • but timezone info of type 'region', not 'offset'
    1. @WernfriedDomscheit, the double conversion is necessary to convert from a time zone region to a time zone offset. There is more information about the difference here stackoverflow.com/tags/timezone/info. With your example the output is the same as the input is an offset and the output is the same offset. What is implicit about this answer is that it uses the sessions's timezone – Hamish Carpenter Jul 12, 2018 at 1:57 Yes, the difference between a time zone and a time zone offset is important. This does not mean, that you need to go through two type conversions to achieve the result. The important thing is, that a timestamp with time zone, which uses actual time zone (not just an offset) is actually more precise, that a timestamp with time zone, where there's just offset. You can get the offset from both, you can't get the full time zone (region) when just having the offset. – Hilarion Jan 31, 2020 at 10:51
      • IMPORTANT
      • my case: define variable TIME_ZONE='region/capital'
      • with it, Oracle takes into account the DST
    1. Oracle recommends that you set the default_timezone attribute to a regions name instead of absolute time zone offset, in order to ensure that daylight saving adjustments are being taken into account.
      • IMPORTANT
      • use region name, to detect invalid range, ora error
    1. the time changes from 01:59:59 a.m. to 3:00:00 a.m. when Daylight Saving Time goes into effect. The interval between 02:00:00 and 02:59:59 a.m. does not exist
      • DST change Values in that interval are invalid.
    1. When you return TIMESTAMP WITH LOCAL TIME ZONE data, it’s returned in the current session’s time zone. The session time zone also takes effect when a TIMESTAMP value is converted to the TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH LOCAL TIME ZONE data type.
      • time zone (SESSION)
    2. Note that the database time zone is relevant only for TIMESTAMP WITH LOCAL TIME ZONE columns. Also, Oracle recommends that you set the database time zone to UTC (0:00) to avoid data conversion and improve performance when data is transferred among databases.
      • oracle
      • time zone
    1. My system is using version 32, which is the default time zone file for Oracle 19c (which is what I’m using). This file is located at the following location: $ORACLE_HOME/oracore/zoneinfo/timezlrg_32.dat
      • IMPORTANT
      • file for time zones
  8. Jan 2021
  9. Oct 2020
  10. Jul 2020
  11. Aug 2017
    1. Oracle DBA Tutorial covers installation, database backup, restore with examples Oracle DBA Sample Resume Database or essentially DB is a sorted out and organized accumulation of data which can be to productively recovered, refreshed and investigated. A straightforward VB code, C, exceed expectations or notebook can't oversee extensive number of clients and documents. Additionally simple extraction, reinforcement and reclamation of information is unrealistic with this approach. To counter this impediment Oracle has thought of Oracle database or Oracle RDBMS

  12. Jun 2017
  13. Feb 2014
    1. “Yes, I do command them, so that you may perish all the sooner for your impiety, and never again come to inquire of my oracle about giving up those that seek refuge with you.”

      1.159 Aristodikos the Cymean re-asks the Oracle at Branchidai about Pactyes and receives a direct response the god. This direct contact with the divine is a rarity in Herodotus's histories. In the conversation between the god and Aristodikos, the god reprimands Aristodikos for questioning the divine in a "how dare you even ask that question" fashion.