Feed aggregator

Announcing: Integration Tools Update Course

Jim Marion - Tue, 2020-04-07 21:34

PeopleSoft Integration Tools is normally taught as a five-day introductory course designed to answer questions such as:

  • What is Integration Broker?
  • How do you configure it?
  • What are Service Operations?
  • How should I integrate with PeopleSoft?

But a lot of us already know the basics of Integration Broker. So last fall, we decided to add another course to our library: PeopleTools Integration Tools Update. This is a three-day class showing what's new with Integration Broker and covers topics such as:

  • Producing and Consuming REST,
  • Constructing Documents and understanding the role of Documents in integration,
  • Creating structured and unstructured JSON responses,
  • Understanding and implementing content negotiation,
  • Responding to REST verbs,
  • Using pre-built services such as Query Access Service,
  • Securing integration points.

As we integrate Chatbots and Cloud solutions with PeopleSoft, it is critical that we understand PeopleSoft's modern integration capabilities.

Our next class begins April 14, 2020. Register now to reserve your seat!

How to print ref cursor and nested table as out parameter in procedure using anonymous

Tom Kyte - Tue, 2020-04-07 19:26
Hi Sir, I want to print all out parameters using sql developer and anonymous block. Please refer below scripts. <code>CREATE TABLE EMP ( empno number(4,0) not null, ename varchar2(10 byte), job varchar2(9 byte), mgr number(4,0), hiredate da...
Categories: DBA Blogs

GoldenGate 19c error - ORA-12549: TNS:operating system resource quota exceeded

Tom Kyte - Tue, 2020-04-07 19:26
I`ve tried to start two Extract. One is started and works. But when I try start one more Extract I get error: <code> 2020-04-06T15:27:30.549+0300 ERROR OGG-02615 Oracle GoldenGate Capture for Oracle, e_rf.prm: Login to the database as user GGA...
Categories: DBA Blogs

Spool sql query output in single excel file but in two separate work sheets

Tom Kyte - Tue, 2020-04-07 19:26
I have written shell script which connect to Oracle DB (11g) and spool output into excel (.csv / .xls). This works perfectly fine to fetch data in single excel file. I want to enhance my script which will connect to DB and execute 2 different querie...
Categories: DBA Blogs

database authentication

Tom Kyte - Tue, 2020-04-07 19:26
could u please explain the difference between os authentication and database authentication and how it is done, briefly...i have read it but unable to understand it completely(w.r.t oracle 9i)
Categories: DBA Blogs

MemOptimized Rowstore

Tom Kyte - Tue, 2020-04-07 19:26
I tried to create a table learning from with a tutorial <code>create table key_val_pair( id number constraint id_pk primary key, key_val varchar2(100), key_name varchar2(100)) segment creation immediate memoptimize for read;</code> it is sh...
Categories: DBA Blogs

Using a video capture usb stick with Linux / Ubuntu

Dietrich Schroff - Tue, 2020-04-07 13:04
Three weeks ago i ordered a video capture usb stick at banggood and today it arrived:




So will this device work with my ubuntu?

I inserted the stick on my laptop and dmesg showed:

[123483.143071] hid-generic 0003:534D:0021.0002: hiddev0,hidraw1: USB HID v1.10 Device [MACROSILICON AV TO USB2.0] on usb-0000:00:14.0-1/input4

That was all...
But there was a module missing:

modprobe uvcvideo
and after that:
[125822.751366] usb 1-1: new high-speed USB device number 19 using xhci_hcd
[125822.901442] usb 1-1: New USB device found, idVendor=534d, idProduct=0021
[125822.901449] usb 1-1: New USB device strings: Mfr=1, Product=2, SerialNumber=3
[125822.901454] usb 1-1: Product: AV TO USB2.0
[125822.901458] usb 1-1: Manufacturer: MACROSILICON
[125822.901478] usb 1-1: SerialNumber: 20150130
[125822.902702] uvcvideo: Found UVC 1.00 device AV TO USB2.0 (534d:0021)
[125822.902835] uvcvideo: UVC non compliance - GET_DEF(PROBE) not supported. Enabling workaround.
[125822.904681] uvcvideo 1-1:1.0: Entity type for entity Processing 2 was not initialized!
[125822.904691] uvcvideo 1-1:1.0: Entity type for entity Camera 1 was not initialized!
[125822.911070] hid-generic 0003:534D:0021.0004: hiddev0,hidraw1: USB HID v1.10 Device [MACROSILICON AV TO USB2.0] on usb-0000:00:14.0-1/input4
Checking with
root@zerberus:~# ffmpeg -sources |grep video
Auto-detected sources for video4linux2,v4l2:
  /dev/video1 [AV TO USB2.0]
  /dev/video0 [HD WebCam: HD WebCam]
plus:
root@zerberus:~#  ffmpeg -list_formats all -i /dev/video1

[video4linux2,v4l2 @ 0x55b0d1ca38c0] Compressed:       mjpeg :          Motion-JPEG : 480x320 640x480 720x480
[video4linux2,v4l2 @ 0x55b0d1ca38c0] Raw       :     yuyv422 :           YUYV 4:2:2 : 480x320
/dev/video1: Immediate exit requested

Now i was able to open /dev/video1 with VLC:



The video came from a camera connected via TS832 --[5.8GHz]--> RC832...





PL/SQL, AST, DIANA, Attributes and IDL

Pete Finnigan - Tue, 2020-04-07 01:06
I have been wanting to write a detailed post about this subject for a very long time and indeed I have had some notes and screen dumps for some of this for more than 15 years for some parts of....[Read More]

Posted by Pete On 06/04/20 At 08:57 PM

Categories: Security Blogs

Install Azure CLI on MacBook Pro

DBASolved - Mon, 2020-04-06 18:58

Microsoft has enabled its cloud platform to have a command line (CLI) utility that can interact with the cloud based services.  This CLI is installed on the Mac OS X operating system by using homebrew.   Homebrew To install homebrew, use the package manager.  Homebrew makes it easy to install the Azure CLI with very few commands. […]

The post Install Azure CLI on MacBook Pro appeared first on DBASolved.

Categories: DBA Blogs

What is the Zachman Framework ?

OracleApps Epicenter - Mon, 2020-04-06 10:55
In layman word Zachman Framework is matrix for managing enterprise architecture. The Zachman Framework uses a 36-column matrix to help organize your company’s enterprise architecture and lend insight into your organization’s IT assets. One axis, normally spread about the horizontal of the matrix, consists of the following fundamental elements of human analysis in template include […]
Categories: APPS Blogs

Using Materialized View as ETL option

Tom Kyte - Mon, 2020-04-06 06:46
Hello TOM, Any comment regarding Using Materialized View as ETL option to populate data from OLTP to OLAP? Pros and Cons will be useful. Thanks, Rajneesh
Categories: DBA Blogs

SAAS Vs IAAS Vs PAAS for DBCS related query

Tom Kyte - Mon, 2020-04-06 06:46
Hello TOM, I need to use DBCS for implementing Reporting Solution on cloud. Hence need to understand SAAS, IAAS and PAAS platform for cloud. Can you please help me to understand in simple layman terms with examples of all 3. Thanks, Rajnee...
Categories: DBA Blogs

Application Express Form

Tom Kyte - Mon, 2020-04-06 06:46
How can I make a text field bring the email of the person logged in?
Categories: DBA Blogs

Number of connections and sessions in a given time

Tom Kyte - Mon, 2020-04-06 06:46
Hello, Ask Tom Team. I would like to know the number of sessions and connections to an Oracle database in a given time. Thanks in advanced.
Categories: DBA Blogs

Unable to connect to database xe using sql developer

Tom Kyte - Mon, 2020-04-06 06:46
Hi , I am unable to connect to oracle database using SQL DEVELOPER. It gives me" i/o error network adapter could not establish connection". Please let me know what are the possible reasons for it and provide me the solution for the same. - I am u...
Categories: DBA Blogs

Parsing out a field in MS Access that is CSV (JSON) data

Tom Kyte - Mon, 2020-04-06 06:46
I have a CSV data file that I load into MS Access. No problem doing that. I?ve got it all loaded. My issue is that one of the records in the file contains a field that contains CSV data (JSON data) which is line item invoice data (ProductData) a...
Categories: DBA Blogs

Common table expression using sample() referenced more than once does not produce correct results.

Tom Kyte - Mon, 2020-04-06 06:46
Hi Here is a very much simplified example of real world situation. <code> drop table lh_a; create table lh_a as (select level nro, cast(' ' as char(100)) dummy from dual connect by level < 1000000); create unique index lh_a_ind on l...
Categories: DBA Blogs

[AZ-900] Microsoft Azure Fundamentals: Cloud Computing – CapEx vs OpEx Model

Online Apps DBA - Mon, 2020-04-06 04:31

There are two ways of investing in Cloud resources: 1. Capital Expenditure(CapEx) 2. Operational Expenditure(OpEx) • Is Azure Reserved VM an example of the CapEx model? • What are the pros and cons of each of these models? Get answers to all these questions about Mircosoft Azure CapEx & OpEx pricing models on K21Academy’s blog […]

The post [AZ-900] Microsoft Azure Fundamentals: Cloud Computing – CapEx vs OpEx Model appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Thank you kubie exactly what I needed

Pas Apicella - Sun, 2020-04-05 22:59
On average I deal with at least 5 different Kubernetes clusters so today when I saw / heard of kubie I had to install it.

kubie is an alternative to kubectx, kubens and the k on prompt modification script. It offers context switching, namespace switching and prompt modification in a way that makes each shell independent from others

Installing kubie right now involved download the release from the link below. Homebrew support is pending

https://github.com/sbstp/kubie/releases

Once added to your path it's as simple as this

1. Check kubie is in your path

$ which kubie
/usr/local/bin/kubie

2. Run "kubie ctx" as follows and select the "apples" k8s context

papicella@papicella:~/pivotal/PCF/APJ/PEZ-HaaS/haas-236$ kubie ctx



[apples|default] papicella@papicella:~/pivotal/PCF/APJ/PEZ-HaaS/haas-236$

3. Switch to a new namespace as shown below and watch how the PS1 prompt changes to indicate the k8s conext and new namespace we have set as result of the command below

$ kubectl config set-context --current --namespace=vmware-system-tmc
Context "apples" modified.

[apples|vmware-system-tmc] papicella@papicella:~/pivotal/PCF/APJ/PEZ-HaaS/haas-236$

4. Finally kubie exec is a subcommand that allows you to run commands inside of a context, a bit like kubectl exec allows you to run a command inside a pod. Here is some examples below
  
[apples|vmware-system-tmc] papicella@papicella:~/pivotal/PCF/APJ/PEZ-HaaS/haas-236$ kubie exec apples vmware-system-tmc kubectl get pods
NAME READY STATUS RESTARTS AGE
agent-updater-75f88b44f6-9f9jj 1/1 Running 0 2d23h
agentupdater-workload-1586145240-kmwln 1/1 Running 0 3s
cluster-health-extension-76d9b549b5-dlhms 1/1 Running 0 2d23h
data-protection-59c88488bd-9wxk2 1/1 Running 0 2d23h
extension-manager-8d69d95fd-sgksw 1/1 Running 0 2d23h
extension-updater-77fdc4574d-fkcwb 1/1 Running 0 2d23h
inspection-extension-64857d4d95-nl76f 1/1 Running 0 2d23h
intent-agent-6794bb7995-jmcxg 1/1 Running 0 2d23h
policy-sync-extension-7c968c9dcd-x4jvl 1/1 Running 0 2d23h
policy-webhook-779c6f6c6-ppbn6 1/1 Running 0 2d23h
policy-webhook-779c6f6c6-r82h4 1/1 Running 1 2d23h
sync-agent-d67f95889-qbxtb 1/1 Running 6 2d23h
[apples|vmware-system-tmc] papicella@papicella:~/pivotal/PCF/APJ/PEZ-HaaS/haas-236$ kubie exec apples default kubectl get pods
NAME READY STATUS RESTARTS AGE
pbs-demo-image-build-1-mnh6v-build-pod 0/1 Completed 0 2d23h
[apples|vmware-system-tmc] papicella@papicella:~/pivotal/PCF/APJ/PEZ-HaaS/haas-236$

More Information

Blog Page:
https://blog.sbstp.ca/introducing-kubie/

GitHub Page:
https://github.com/sbstp/kubie
Categories: Fusion Middleware

Using sshUserSetup.sh for Passwordless ssh

Michael Dinh - Sun, 2020-04-05 07:03

Quick short and sweet. I am creating POC for Dataguard with multiple standby configuration using/hacking vagrant virtual box.

Being as lazy as I am and not liking to have to enter password, use sshUserSetup.sh

[oracle@ol7-121-dg1 ~]$ cd /u01/software/database/sshsetup/
[oracle@ol7-121-dg1 sshsetup]$


[oracle@ol7-121-dg1 sshsetup]$ ./sshUserSetup.sh -h
Please specify a valid and existing cluster configuration file.
Either user name or host information is missing
Usage ./sshUserSetup.sh -user <user name> [ -hosts "<space separated hostlist>" | -hostfile <absolute path of cluster configuration file> ] [ -advanced ]  [ -verify] [ -exverify ] [ -logfile <desired absolute path of logfile> ] [-confirm] [-shared] [-help] [-usePassphrase] [-noPromptPassphrase]
[oracle@ol7-121-dg1 sshsetup]$


[oracle@ol7-121-dg1 sshsetup]$ ./sshUserSetup.sh -user oracle -hosts "ol7-121-dg1 ol7-121-dg2 ol7-121-dg3" -noPromptPassphrase
The output of this script is also logged into /tmp/sshUserSetup_2020-04-05-11-53-56.log
Hosts are ol7-121-dg1 ol7-121-dg2 ol7-121-dg3
user is oracle
Platform:- Linux
Checking if the remote hosts are reachable
PING ol7-121-dg1.localdomain (192.168.56.101) 56(84) bytes of data.
64 bytes from ol7-121-dg1.localdomain (192.168.56.101): icmp_seq=1 ttl=64 time=0.016 ms
64 bytes from ol7-121-dg1.localdomain (192.168.56.101): icmp_seq=2 ttl=64 time=0.019 ms
64 bytes from ol7-121-dg1.localdomain (192.168.56.101): icmp_seq=3 ttl=64 time=0.036 ms
64 bytes from ol7-121-dg1.localdomain (192.168.56.101): icmp_seq=4 ttl=64 time=0.045 ms
64 bytes from ol7-121-dg1.localdomain (192.168.56.101): icmp_seq=5 ttl=64 time=0.041 ms

--- ol7-121-dg1.localdomain ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4293ms
rtt min/avg/max/mdev = 0.016/0.031/0.045/0.012 ms
PING ol7-121-dg2.localdomain (192.168.56.102) 56(84) bytes of data.
64 bytes from ol7-121-dg2.localdomain (192.168.56.102): icmp_seq=1 ttl=64 time=0.333 ms
64 bytes from ol7-121-dg2.localdomain (192.168.56.102): icmp_seq=2 ttl=64 time=0.657 ms
64 bytes from ol7-121-dg2.localdomain (192.168.56.102): icmp_seq=3 ttl=64 time=0.547 ms
64 bytes from ol7-121-dg2.localdomain (192.168.56.102): icmp_seq=4 ttl=64 time=0.539 ms
64 bytes from ol7-121-dg2.localdomain (192.168.56.102): icmp_seq=5 ttl=64 time=0.514 ms

--- ol7-121-dg2.localdomain ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4310ms
rtt min/avg/max/mdev = 0.333/0.518/0.657/0.104 ms
PING ol7-121-dg3.localdomain (192.168.56.103) 56(84) bytes of data.
64 bytes from ol7-121-dg3.localdomain (192.168.56.103): icmp_seq=1 ttl=64 time=0.356 ms
64 bytes from ol7-121-dg3.localdomain (192.168.56.103): icmp_seq=2 ttl=64 time=0.554 ms
64 bytes from ol7-121-dg3.localdomain (192.168.56.103): icmp_seq=3 ttl=64 time=0.463 ms
64 bytes from ol7-121-dg3.localdomain (192.168.56.103): icmp_seq=4 ttl=64 time=0.362 ms
64 bytes from ol7-121-dg3.localdomain (192.168.56.103): icmp_seq=5 ttl=64 time=0.472 ms

--- ol7-121-dg3.localdomain ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4517ms
rtt min/avg/max/mdev = 0.356/0.441/0.554/0.076 ms
Remote host reachability check succeeded.
The following hosts are reachable: ol7-121-dg1 ol7-121-dg2 ol7-121-dg3.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
firsthost ol7-121-dg1
numhosts 3
The script will setup SSH connectivity from the host ol7-121-dg1.localdomain to all
the remote hosts. After the script is executed, the user can use SSH to run
commands on the remote hosts or copy files between this host ol7-121-dg1.localdomain
and the remote hosts without being prompted for passwords or confirmations.

NOTE 1:
As part of the setup procedure, this script will use ssh and scp to copy
files between the local host and the remote hosts. Since the script does not
store passwords, you may be prompted for the passwords during the execution of
the script whenever ssh or scp is invoked.

NOTE 2:
AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY
AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEDGES TO THESE
directories.

Do you want to continue and let the script make the above mentioned changes (yes/no)?
yes

The user chose yes
User chose to skip passphrase related questions.
Creating .ssh directory on local host, if not present already
Creating authorized_keys file on local host
Changing permissions on authorized_keys to 644 on local host
Creating known_hosts file on local host
Changing permissions on known_hosts to 644 on local host
Creating config file on local host
If a config file exists already at /home/oracle/.ssh/config, it would be backed up to /home/oracle/.ssh/config.backup.
Creating .ssh directory and setting permissions on remote host ol7-121-dg1
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host ol7-121-dg1. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host ol7-121-dg1.
Warning: Permanently added 'ol7-121-dg1,192.168.56.101' (ECDSA) to the list of known hosts.
oracle@ol7-121-dg1's password:
Done with creating .ssh directory and setting permissions on remote host ol7-121-dg1.
Creating .ssh directory and setting permissions on remote host ol7-121-dg2
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host ol7-121-dg2. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host ol7-121-dg2.
Warning: Permanently added 'ol7-121-dg2,192.168.56.102' (ECDSA) to the list of known hosts.
oracle@ol7-121-dg2's password:
Done with creating .ssh directory and setting permissions on remote host ol7-121-dg2.
Creating .ssh directory and setting permissions on remote host ol7-121-dg3
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host ol7-121-dg3. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host ol7-121-dg3.
Warning: Permanently added 'ol7-121-dg3,192.168.56.103' (ECDSA) to the list of known hosts.
oracle@ol7-121-dg3's password:
Done with creating .ssh directory and setting permissions on remote host ol7-121-dg3.
Copying local host public key to the remote host ol7-121-dg1
The user may be prompted for a password or passphrase here since the script would be using SCP for host ol7-121-dg1.
oracle@ol7-121-dg1's password:
Done copying local host public key to the remote host ol7-121-dg1
Copying local host public key to the remote host ol7-121-dg2
The user may be prompted for a password or passphrase here since the script would be using SCP for host ol7-121-dg2.
oracle@ol7-121-dg2's password:
Done copying local host public key to the remote host ol7-121-dg2
Copying local host public key to the remote host ol7-121-dg3
The user may be prompted for a password or passphrase here since the script would be using SCP for host ol7-121-dg3.
oracle@ol7-121-dg3's password:
Done copying local host public key to the remote host ol7-121-dg3
cat: /home/oracle/.ssh/known_hosts.tmp: No such file or directory
cat: /home/oracle/.ssh/authorized_keys.tmp: No such file or directory
SSH setup is complete.

------------------------------------------------------------------------
Verifying SSH setup
===================
The script will now run the date command on the remote nodes using ssh
to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,
THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR
PASSWORDS. If you see any output other than date or are prompted for the
password, ssh is not setup correctly and you will need to resolve the
issue and set up ssh again.
The possible causes for failure could be:
1. The server settings in /etc/ssh/sshd_config file do not allow ssh
for user oracle.
2. The server may have disabled public key based authentication.
3. The client public key on the server may be outdated.
4. ~oracle or ~oracle/.ssh on the remote host may not be owned by oracle.
5. User may not have passed -shared option for shared remote users or
may be passing the -shared option for non-shared remote users.
6. If there is output in addition to the date, but no password is asked,
it may be a security alert shown as part of company policy. Append the
additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file.
------------------------------------------------------------------------
--ol7-121-dg1:--
Running /usr/bin/ssh -x -l oracle ol7-121-dg1 date to verify SSH connectivity has been setup from local host to ol7-121-dg1.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Sun Apr  5 11:54:28 UTC 2020
------------------------------------------------------------------------
--ol7-121-dg2:--
Running /usr/bin/ssh -x -l oracle ol7-121-dg2 date to verify SSH connectivity has been setup from local host to ol7-121-dg2.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Sun Apr  5 11:54:28 UTC 2020
------------------------------------------------------------------------
--ol7-121-dg3:--
Running /usr/bin/ssh -x -l oracle ol7-121-dg3 date to verify SSH connectivity has been setup from local host to ol7-121-dg3.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Sun Apr  5 11:54:28 UTC 2020
------------------------------------------------------------------------
SSH verification complete.
[oracle@ol7-121-dg1 sshsetup]$

I wonder if Tim reads my blog?

__ATA.cmd.push(function() { __ATA.initDynamicSlot({ id: 'atatags-26942-5e8a477d8cadf', location: 120, formFactor: '001', label: { text: 'Advertisements', }, creative: { reportAd: { text: 'Report this ad', }, privacySettings: { text: 'Privacy settings', } } }); });

Pages

Subscribe to Oracle FAQ aggregator