Hi Mohammed,
Have you just tried listing the trace files using the AWS CLI or the console?
In the console:
- Select the instance (checkbox)
- Instance Actions -> See Details
- Recent Events and Logs Tab
- Scroll down to find your log, or use the search box
- Click view, watch or download
In the CLI:
aws rds describe-db-log-files --db-instance-identifier myinstance1
aws rds download-db-log-file-portion --db-instance-identifier myinstance1
--log-file-name trace/ORCL_j001_37382.trc --starting-token 0 --output text
You might want to also look at the docs for both of these CLI commands, since
they have lots of other useful options.
Let me know if you need any further assistance and the docs don't provide what
you need. I work for AWS and can get you help if needed.
Jeremiah
From: "Mohammed Bhatti" <mohammed.bhatti1@xxxxxxxxx>
To: "gogala mladen" <gogala.mladen@xxxxxxxxx>
Cc: "Oracle Mailing List" <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, April 14, 2017 7:08:32 AM
Subject: 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@xxxxxxxxx >
wrote:
Have you tried ADRCI utility?
On 04/13/2017 04:42 PM, Mohammed Bhatti wrote:
BQ_BEGIN
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@xxxxxxxxx >
wrote:
BQ_BEGIN
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@xxxxxxxxx
wrote:
wrote:BQ_BEGIN