Hello TOM, hello Connor,

For me, as a DBA, and perhaps for developpers, there are differences when you work with the Cloud.

The big problem is that you cannot acces the Linux server and the files like alert.log, listener.ora, listener.log, tnsnames.ora etc etc and programs like lsnrctl to check the listener.

I found some nice objects to resolve a part of this problem but I think there are more :
- to see the content of alert.log (and maybe listener.log) : synonyms ALERT_LOG and V$DIAG_ALERT_EXT ==> you can use the power of SQL to investigate this file :-)
- to see some informations on the listener : synonym V$LISTENER_NETWORK

To see the content of tnsnames.ora I found nothing but maybe I can use an external table.

But how can I check the status and services for the listener? I used lsnrctl status or lsnrctl services but impossible to use them in the Cloud control...

How can I use in the Cloud a trace 10046 and tkprof without linux?

From my experience, my job was easier when we worked on-premises.

Have a nice day.

David D. from Paris

How can I use in the Cloud a trace 10046 and tkprof without linux?

you can still access the cloud database from Putty with Public and private keys attached to the Putty console.
However for 10046 trace since 12.2 it is available via two V$ tables (v$diag_trace_file and v$diag_trace_file_contents)
Just query those two v$ tables to get the 10046 trace contents. you dont need the server access.

Hello Jeyabal,

Thank you very much for the informations about the V$ but I don't understand why you talk about Putty.

When I use Putty, it is because I can connect to a Linux server. But, if I cannot connect drectly, via Putty, on this server, I have to use the Oracle Cloud Control or Toad.

And, with the Cloud Control, it is impossible to create a 10046 trace, the SQL Worksheet isn't powerfull enought for that task.

Last thing, in the v$diag_trace_file_contents, I think it is the raw 10046 trace file but it is not very easy to read it, that is why I use tkprof. But I cannot use it in the Cloud Control because it is a Linux command.

David D. from PARIS

Some points....

David, let me put some points for you :

a. some Oracle Cloud offers work as a PAAS (Platform As A Service, where you have a SERVER available for your use and you can install anything that you need AND possesses a License) and others as DBAAS (DB As A Service, where you have access ONLY TO A DATABASE) : of course, Jeyabal was referring to a situation of PAAS, in that case you CAN access the server via puTTY and to use locally the database running on it... IF your Cloud service is DBAAS, sure, puTTY will be useless for you... I myself already saw both cases, and in the case of PAAS I use puTTY normally to login in the Oracle server ...

b. tkprof ** DO NOT DEMAND ** an execution IN THE SAME SERVER where the database runs : it is totally POSSIBLE to run tkprof in YOUR machine where YOU installed some small Oracle database, maybe XE... I did it many many many times for trace files coming from some remote customer...

c. the trace file is a pure, simple TEXT FILE, delimited with EOLs - NO binary portion exists on it ...

=> So, adding b. with c. you CAN for sure make a SELECT on the V$ containing the trace file contents, write in your local personal machine a TEXT FILE with the content (maybe via SPOOL command in sqlplus, maybe with UTL_FILE, or even using the DATA EXPORT tools inside SQL DEVELOPER) , and later run a TKPROF against this text file.... Trivial work...

Regards,

Chiappa

"And, with the Cloud Control, it is impossible to create a 10046 trace, the SQL Worksheet isn't powerfull enought for that task."

Yeah, David : Cloud Control is a very weak and feature-missing tool, in my opinion, agree - I discarded it promptly for ORACLE SQL DEVELOPER and sqlplus together with my own custom scripts and routines, yes....

To generate a trace file (on-demand OR cloud environment, it doesn't matter) I always prefer : some internal package, such as DBMS_MONITOR (the preferred one), DBMS_SYSTEM, DBMS_SUPPORT, OR to use the event 10046 (via ALTER SESSION, ALTER SYSTEM, etc) , OR even via ORADEBUG (oradebug is an 'internal' tool isnide sqlplus, and you CAN connect with sqlplus to a remote database, CLOUD or not)..... Point is, cloud or not check WHAT are your permissions on these alternatives...
And just to remember, the ALTER alternatives and the internal packages) CAN be executed interactively from some kind of client tool (sqlplus, SQL DEVELOPER, etc) OR can be used inside some TRIGGER, such as a LOGON TRIGGER....

Regards,

Chiappa

Thank you very much for all your responses :-)

David D. from Paris

> How can I use in the Cloud a 10046

I recently check and didn't find the way to turn on tracing in Autonomous Transaction Processing db (either through alter session or dbms_monitor).
Only several option of ALTER SESSION are allowed in ATP now:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/experienced-database-users.html#GUID-791E7112-07F7-46F0-BD81-777C8FAD83A0

Chiappa,

IF your Cloud service is DBAAS, sure, puTTY will be useless for you...


DBaaS Classic allows server level access; it's only autonomous that doesn't.

One of the issues with AskTom is that he has very little experience with being a real world DBA managing hundreds of databases. Answers to questions like this are made to sound simple and easy but in reality when you are managing hundreds of databases the answers are not always feasible in real world scenarios.