OTD: How to generate the private key from an OTD CSR

Context: The Certificate request has been created from OTD and the certificate must now be moved to another server. Question is how to retrieve the private key stored into the key4.db file.

To retrieve the private key, first generate the pkcs12 file, which contains both the private key and the certificate into an encrypted format.

${ORACLE_HOME}/bin/pk12util -o <name>.p12 -d /u01/app/otd/instances/<instance>/net-<config>/config -n <certifcate nickname>

 

Then extract the private key only from the p12 file. Specify the password just given when generating the p12 file.

openssl pkcs12 -in <name>.p12 -out <name>.key -nocerts -nodes
Advertisements

Generating a source file from a rdf file

Context: You need to troubleshoot some pre-report or post-report trigger from a SQL*Report file, for example from E-Business suite.

To generate the source file (rex file) from an RDF File:

$ORACLE_HOME/bin/rwconverter stype=RDFFILE source=<NAME>.rdf dtype=REXFILE dest=<NAME>.rex userid=apps/<password>@<service> batch=yes

Upgrading javavm after db/oh upgrade

MOS 429787.1

-- Start of File rmcorejvm.sql
connect / as sysdba
spool rmcorejvm.log
set echo on
set serveroutput on
select owner, status, count(*) from all_objects
 where object_type like '%JAVA%' group by owner, status;
execute rmjvm.run(false);
shutdown immediate
set echo off
spool off
exit
-- End of File rmcorejvm.sql

then

-- Start of File corejvminst.sql
connect / as sysdba
spool corejvminst.log
set serveroutput on
set echo on
startup mount
alter system set "_system_trig_enabled" = false scope=memory;
alter database open;
select owner, status, count(*) from all_objects
 where object_type like '%JAVA%' group by owner, status;
create or replace java system
/
shutdown immediate
set echo off
spool off
exit
-- End of File corejvminst.sql

and

@?/rdbms/admin/utlrp.sql