Re: How to get the file transfer working between virtual box oracle developer vm and mac(host)

Hi Kunwar,

You can use any SQL client for that:
1. Create oracle directory for trace directory: begin

   for r in (SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace') loop

      execute immediate utl_lms.format_message( q'{create directory TRACE_DIR as '%s' }', r.value);

   end loop;
end;
/
select directory_path from dba_directories where directory_name='TRACE_DIR';

2. Then you can use bfilename('TRACE_DIR',tracefile_name) to get it. Note, that you need to specify just file name, not full path to file. For example: select bfilename('TRACE_DIR','ORA19_j000_14336.trc') f from dual;

3. To get a list of trace files in this directory you can use this pl/sql block:
declare

   PROCEDURE LIST_FILES (lp_directory varchar2, lp_string varchar2, lp_limit binary_double default 'inf')

   AS

      lv_pattern VARCHAR2(1024);
      lv_ns VARCHAR2(1024);
   BEGIN
      SELECT directory_path
      INTO lv_pattern
      FROM dba_directories
      WHERE directory_name = lp_directory;

      SYS.DBMS_BACKUP_RESTORE.SEARCHFILES(lv_pattern, lv_ns);

      FOR file_list IN (
         SELECT FNAME_KRBMSFT AS file_name
         FROM sys.X$KRBMSFT
         WHERE --FNAME_KRBMSFT LIKE '%'|| lp_string||'%'
           regexp_like(FNAME_KRBMSFT ,lp_string)
         and rownum <= lp_limit
      )
      LOOP
         dbms_output.put_line(file_list.file_name);
      END LOOP;

> Hi Listers,
> I am trying to get the file transfer working between vm and the host (mac)
>
> Basically i wanted to transfer a 10046 trace and i couldn't get it working
> despite all the google searches and trying various stuff including adding
> VBoxGuestAdditions_5.1.18.iso
>
> Not sure where do to go from here. Can you please suggest.
>
> Host MAC OS version :10.11.6 (15G22010)
> Virtulbox version : 5.1.18
>
> i am able to connect to the database using the method mentioned in the
> below link , but stuck at file transfer now.
>
>
> https://blogs.oracle.com/opal/the-easiest-way-to-install-oracle-database-on-apple-mac-os-x
>
> Any pointers are welcome , thanks much in advance.
>
> --
> Cheers,
> Kunwar
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

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