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.

TRCANLZR (TRCA): SQL_TRACE/Event 10046 Trace File Analyzer

I want recommend you a tool very very useful for oracle traces analyzer, this tool is call: TRCANLZR (owner: Carlos Sierra, carlos.sierra@oracle.com). This tool allow you to summarize and describe trace files better than tkprof. It generates a HTML File with all information about the traces: top querys, top event waits, execution plans and much more:

Some Examples about the output after execution:

Full HTML Example about the output after execution traces analyzer:

https://drive.google.com/uc?export=download&id=0B8Tjo6f10a1WbEVDaTBSNUpwd1E

In Metalink can see information about this tool in the note:

TRCANLZR (TRCA): SQL_TRACE/Event 10046 Trace File Analyzer - Tool for Interpreting Raw SQL Traces (Doc ID 224270.1)

The Download link: https://mosemp.us.oracle.com/epmos/main/downloadattachmentprocessor?attachid=224270.1%3ATRCA_TOOL_11458&docType=TROUBLESHOOTING&action=download

The install tool is very simple:

1.- Uncompress the zip file.

2.- Enter the folder: trca/install

3.- Execute: sqlplus "/as sysdba" @tacreate.sql

This step is for create database schemas. The tool require a database instance.

4.- enter the folder diag/....trace/ (the folder where is located the database's alert log)

5.- In that directory copy the *.trc file what you will analyze.

6.- Go the folder trca/install

7.- Execute: sqlplus  "TRCANLZR/password_database" @trcanlzr.sql file_trace_to_analyzer.trc

8.- When the procesess finish, will be generated ZIP file on the folder trca\run

And open that zip file and you can see the HTML unique file with all results analyzer. (Example output: https://drive.google.com/uc?export=download&id=0B8Tjo6f10a1WbEVDaTBSNUpwd1E)

PD: For 9i trace files, you should to use this tool:
9i SQL Tuning Health Check Script SQLHC Doc ID 1366133.1


Link from author tool: https://carlos-sierra.net/2013/04/25/differences-between-tkprof-and-trace-analyzer-trcanlzr-trca/