Re: Retrieving Trace Files for Oracle on AWS

I have not, but I will look into. Thanks Mladen.

--
mohammed

On Fri, Apr 14, 2017 at 6:36 AM, Mladen Gogala <gogala.mladen_at_gmail.com>
wrote:



> Have you tried ADRCI utility?


>

>

> On 04/13/2017 04:42 PM, Mohammed Bhatti wrote:

>

> Hi Vijay,

>

> Thanks for your input.  I tried that query and I was unable to locate the

> trace file.  It's frustrating.

>

> I checked background_dump_dest and it point to /rdsdbdata/log/diag/rdbms/

> acme_a/ACME/trace.

>

> I then run this query:

> SELECT p.tracefile

> FROM   v$session s

>        JOIN v$process p ON s.paddr = p.addr

> WHERE  s.sid = 649;

>

> Which shows me that the file generated is in /rdsdbdata/log/diag/rdbms/

> acme_a/ACME/trace/ACME_ora_13615.trc

>

> I then exec rdsadmin.manage_tracefiles.refresh_tracefile_listing;

>

> Then run the following:

> select filename, mtime

> from rdsadmin.tracefile_listing

> order by mtime;

>

> But my file doesn't show up.

>

> I also checked dba_directories and it shows that BDUMP points to

> /rdsdbdata/log/trace.

>

> So, I'm confused because BDUMP points to a location that is not the same

> as the tracefile location.  I've tried creating a directory to that

> location but I get insufficient privileges and I'm logged on as awssys.

>

> Anyway, the regular DBA gets back next week, and this wasn't critical, and

> I'm very new to Oracle on RDS, but it's just bugging me.  Why can't I get

> to my trace files?

>

> Thanks again Vijay.

>

> --

> mohammed

>

> On Thu, Apr 13, 2017 at 4:06 PM, vijayrsehgal <vijaysehgal21_at_gmail.com>

> wrote:

>

>> HI Mohammed,

>>

>> I am also new to AWS and learning, I used the below query to list the

>> file and then I logged in AWS console to download the file. There are other

>> ways as well, you can see if below query lists your file.

>>

>> select * from table(rdsadmin.rds_file_util.listdir('BDUMP'));

>>

>> Regards,

>> Vijay Sehgal

>>

>> On Thu, Apr 13, 2017 at 12:39 PM, Mohammed Bhatti <

>> mohammed.bhatti1_at_gmail.com> wrote:

>>

>>> Grrrr....hit send before I finisihed my email, sorry.

>>>

>>> So, I'm the backup dba for a number of databases on running on AWS.  The

>>> real DBA comes back next week.  Not having done DBA work for a while, I'm

>>> turning to the list for some help.

>>>

>>> Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit

>>> Production

>>> CentOS release 6.7 (Final)

>>>

>>> I've turned on 10046 trace for a user and I'm able to identify the trace

>>> file generated for this user using the following query:

>>>

>>> SELECT p.tracefile

>>> FROM   v$session s

>>>        JOIN v$process p ON s.paddr = p.addr

>>> WHERE  s.sid = 20;

>>>

>>> So this lists a directory path /rdsdbdata/log/diag/rdbms/.../.../...

>>> where my actual file is.  I want to view the contents of this file.  I've

>>> tried stuff from here: http://docs.aws.amazon.com/Ama

>>> zonRDS/latest/UserGuide/USER_LogAccess.Concepts.Oracle.html

>>>

>>> e.g. refresh the view on backgroud_dump_dest using this

>>>

>>> exec rdsadmin.manage_tracefiles.refresh_tracefile_listing;

>>>

>>> But when I query this

>>>

>>> rdsadmin.tracefile_listing

>>>

>>>

>>> I don't see the file.

>>>

>>>

>>> The file is not in background_dump_dest as shown by the location above.

>>>

>>>

>>> So, how do you retrieve trace files from RDS?

>>>

>>>

>>> Thanks

>>>

>>> --

>>>

>>> mohammed

>>>

>>> On Thu, Apr 13, 2017 at 12:33 PM, Mohammed Bhatti <

>>> mohammed.bhatti1_at_gmail.com> wrote:

>>>>

>>>> So, I'm the backup dba for a number of databases on running on AWS.

>>>> The real DBA comes back next week.  Not having done DBA work for a while,

>>>> I'm turning to the list for some help.

>>>> I've turned on 10046 trace for a user and I'm able to identify the

>>>> trace file generated for this user using the following query:

>>>>

>>> --

> Mladen Gogala

> Oracle DBA

> Tel: (347) 321-1217

>

>


--
http://www.freelists.org/webpage/oracle-l