Re: Where, oh where, did my directory go?

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sat, 27 Jun 2015 00:32:47 +0300
Message-ID: <CAOVevU4MWibPZSmA5+U=P0L7CE3gZsAUp1zAfMttA9_eS8XAdA_at_mail.gmail.com>

Have you tried to trace it with 10046 and with 10053? Are you sure that you hadn't executed "alter system set current_user=SYSTEM" or maybe something like connect through proxy_user? And could you show also "select * from dba_directories" and "select * from cdb_directories" without predicates?

On Sat, Jun 27, 2015 at 12:19 AM, Sweetser, Joe <JSweetser_at_icat.com> wrote:

> Me too! :)
>
> FWIW, I also see the same behavior when connected as SYS.
>
> -joe
>
> 15:15:02 pdb2> drop directory joe_dir;
>
> Directory dropped.
>
> 15:15:21 pdb2> show user
> USER is "SYS"
> 15:15:26 pdb2> create directory joe_dir as '/u04/oradata/backup/joe';
>
> Directory created.
>
> 15:15:32 pdb2> select directory_name from dba_directories where
> directory_name like '%JOE%';
>
> no rows selected
>
> 15:15:38 pdb2> select object_name ||' - '|| object_type ||' - '|| created
> from dba_objects where object_name like '%JOE%';
>
> OBJECT_NAME||'-'||OBJECT_TYPE||'-'||CREATED
>
> --------------------------------------------------------------------------------
> JOE_DIR - DIRECTORY - 26-JUN-15
> 15:16:09 pdb2>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Rich Jesse
> Sent: Friday, June 26, 2015 3:09 PM
> To: oracle-l_at_freelists.org
> Subject: Re: Where, oh where, did my directory go?
>
> Joe writes:
>
> > Without going into the details, I came across something strange in my
> > environments today. Basically, I have a 12c pluggable database where
> > a user-created directory does not show up in dba_directories. I have
> > another one where it works as expected. These are simply the single,
> > pluggable database that can be created without licensing the feature.
> > Utilities like data pump work as expected in both databases. I just
> > don't see an entry in dba_directories. There are undoubtedly
> > differences between the servers, notably the version of Linux. But I
> don't know if that's any issue.
>
> I see you're logged in as SYSTEM and the directory is owned by SYS. I'd
> have thought that the SELECT ANY DICTIONARY of the DBA role would allow
> that to be viewed, but I only have 11.2 here.
>
> Just a thought...
>
> Rich
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> Confidentiality Note: This message contains information that may be
> confidential and/or privileged. If you are not the intended recipient, you
> should not use, copy, disclose, distribute or take any action based on this
> message. If you have received this message in error, please advise the
> sender immediately by reply email and delete this message. Although ICAT,
> Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for
> viruses, it does not guarantee that either are virus-free and accepts no
> liability for any damage sustained as a result of viruses. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

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

Received on Fri Jun 26 2015 - 23:32:47 CEST