Skip to Main Content
Forums

LiveLabs & Workshops

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OEM 13c Fundamentals Lab setup issue: SSH Private Key issue

Consistently get the following error in OEM 13c console, in the step where ROOT named credential needs to have the SSH private key uploaded.
Failed to launch process: invalid privatekey: [B@6fb56120
Same issue on OEM 13.3 (older version) and 13.4 RU5 (latest version on live labs)
Same issue from MacOS Mojave and Catalina.
Tried a few variations of ssh-keygen on MacOS to no avail
ssh-keygen / ssh-keygen -t rsa / ssh-keygen -t rsa -b 4096
Also tried converting to PEM format which threw a different error in the OEM console.
This step needs to work for use of EMCLI.
Please advise asap as need this working for future customer workshops. Not sure if its a MAC only issue.
thanks

Comments

Christian Neumueller-Oracle
Answer

Hi Tim,

the parser for supporting objects which splits a clob into runnable statements is rather simplistic. A "/" on a single line ends the statement. For example, you could use the multi line code pattern of the APEX export files:

c_pkg_spec_script constant t_max_vc2 := apex_string.join(apex_t_varchar2 (
    'CREATE OR REPLACE PACKAGE #PKG_NAME#',
    'AS',
    '  #FUNC_PROC#',
    'END #PKG_NAME#;',
    '/' ));

Since this is about code generation, I sometimes also write templates like this to get consistent alignment and have the template stand out:

c_pkg_spec_script constant t_max_vc2 := regexp_replace(q'[
  % CREATE OR REPLACE PACKAGE #PKG_NAME#
  % AS
  %   #FUNC_PROC#
  % END #PKG_NAME#;
  % /
  ]',
  '^\s+% ', null, 1, 0, 'm' );

Regards,

Christian

Marked as Answer by Tim Halbach · Sep 27 2020
Tim Halbach

Hi Christian,

Thank you so much for that, that's exactly what I was looking for.

1 - 2

Post Details

Added on Nov 21 2020
#livelabs-discussions
3 comments
635 views