Sep 3, 2021

upload big file via command line (console) to a SR on support.oracle.com


Note id Source: How to Upload Files to Oracle Support (Doc ID 1547088.2)


 If you need to upload a big file (trc,log, tfa, zip, etc..) to SR on support.oracle.com, you have a very good alternative using curl from the command line. Indeed you can leave this on background without problem. The format for the upload is the next one:

curl -v -T "bigfile.zip" -u "username_or_email@oracle.com" https://transport.oracle.com/upload/issue/xxxSR_numberXXX/


So, for our example the output it will be the next way (also you can use the --progress-bar  command for review progress ):


MacBook-Pro[12:08:32]tfa->curl -v  -T "tfa_file_log_rac_nodes.zip" -u "username_or_email@oracle.com" https://transport.oracle.com/upload/issue/3-82512956273/


Enter host password for user 'username_or_email@oracle.com':

*   Trying 141.146.1.169:443...

* TCP_NODELAY set

* Connected to transport.oracle.com (141.146.1.169) port 443 (#0)

* ALPN, offering http/1.1

* successfully set certificate verify locations:

*   CAfile: /opt/anaconda3/ssl/cacert.pem

  CApath: none

* TLSv1.3 (OUT), TLS handshake, Client hello (1):

* TLSv1.3 (IN), TLS handshake, Server hello (2):

* TLSv1.2 (IN), TLS handshake, Certificate (11):

* TLSv1.2 (IN), TLS handshake, Server finished (14):

* TLSv1.2 (OUT), TLS handshake, Client key exchange (16):

* TLSv1.2 (OUT), TLS change cipher, Change cipher spec (1):

* TLSv1.2 (OUT), TLS handshake, Finished (20):

* TLSv1.2 (IN), TLS handshake, Finished (20):

* SSL connection using TLSv1.2 / AES128-SHA

* ALPN, server did not agree to a protocol

* Server certificate:

*  subject: C=US; ST=California; L=Redwood City; O=Oracle Corporation; OU=Oracle GIT-NETWORK US; CN=transport.oracle.com

*  start date: Mar 19 00:00:00 2021 GMT

*  expire date: Apr 19 23:59:59 2022 GMT

*  subjectAltName: host "transport.oracle.com" matched cert's "transport.oracle.com"

*  issuer: C=US; O=DigiCert Inc; CN=DigiCert TLS RSA SHA256 2020 CA1

*  SSL certificate verify ok.

* Server auth using Basic with user 'username_or_email@oracle.com'

> PUT /upload/issue/3-82512956273/tfa_file_log_rac_nodes.zip HTTP/1.1

> Host: transport.oracle.com

> Authorization: Basic ZmVsaXBlLmRvbm9zb0BvcmFjbGUuY29tOlZicDE0NDIyLg==

> User-Agent: curl/7.65.3

> Accept: */*

> Content-Length: 1830171599

> Expect: 100-continue

>

* Mark bundle as not supporting multiuse

< HTTP/1.1 100 Continue


* We are completely uploaded and fine


And thats all 

Cheers.


Sep 2, 2021

Problem with small fonts and GUI interface in SQLDeveloper with windows 10 (on Mac Parallel VM) ?

 

If you use sqldeveloper on windows 10 on mac parallel VM maybe you have the next issue: a very small fonts and GUI interface (Actually it's so hard to read every word )



The solution for that issue is change the properties for sqldeveloper.exe file:


On the next window on the compatibility tab, you need to select the option button "Change high DPI Seetings"



Here you need to change option High DPI Scaling override to value : SYSTEM

And after the change you'll have your sqldeveloper with very normal font size and GUI :D




Cheers









Aug 11, 2021

Clone PDB Locally (easy way)


¿How to clone PDB locally? ¿For example to clone PDB1 to PDB2 ? The steps are so easy:

Link from my github: https://github.com/felipower/scripts_oracle/blob/master/oracle_multitenant_PDB_local_clone__clonar_PDB_localmente.sql



/*
* Clone locally a PDB easy way
* author: Felipe Donoso, felipe@felipedonoso.cl, felipe.donoso@oracle.com
*/

[oracle@lab-db12-2-ol7 u01]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 11 12:56:35 2021

Copyright (c) 1982, 2016, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO


SQL> /* script for clone local PDB , remember change the folfer for the new datafiles for new pdb*/
CREATE PLUGGABLE DATABASE PDB2 FROM PDB1
FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdb1/','/u01/app/oracle/oradata/cdb1/pdb2/')
-- Remember you can omit or include in the except list some tablespaces if you need
-- USER_TABLESPACES=('xxx', 'yyyy')
-- omit the clause USER_TABLESPACE is the same that use USER_TABLESPACES=ALL
--
-- Also remember you can clone only metadata if you need (no rows)
-- using NO DATA option
-- the NO DATA option above is valid only when you aren't using:
; 2 3 4

Pluggable database created.

SQL> ALTER PLUGGABLE DATABASE pdb2 OPEN;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE pdb2 save state;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
SQL>

DONE! :D

Jul 1, 2021

Upgrade Video from 12c to 19c (youtube channel Mallik034)

 

I want to share a very good video about the upgrade process from 12c to 19c. This video is ownership from the youtube channel:Mallik034 a very good DBA. This video for me is the easiest and the most practice way for describe all upgrade steps. Enjoy :)

https://www.youtube.com/watch?v=y8LiiQ8WaOM