Re: ORA-28009
From: gazzag <gareth_at_jamms.org>
Date: Tue, 16 Feb 2010 06:29:42 -0800 (PST)
Message-ID: <87812676-3b1d-4deb-b2b7-9b35ba03fe66_at_j27g2000yqn.googlegroups.com>
On 16 Feb, 13:57, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> Syd, what are you actually trying to do? Logging in as SYS is normally
> done to shut down or start up the database. There are very few things
> that require the SYSDBA privilege. The only exception to the rule is
> using the X$ tables but not even that should be done carelessly. Reading
> some of the X$ tables can greatly increase latch activity and severely
> impact the system.
> Starting and stopping database from a Perl script is a very unusual
> choice and should be reconsidered very carefully.
Date: Tue, 16 Feb 2010 06:29:42 -0800 (PST)
Message-ID: <87812676-3b1d-4deb-b2b7-9b35ba03fe66_at_j27g2000yqn.googlegroups.com>
On 16 Feb, 13:57, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> Syd, what are you actually trying to do? Logging in as SYS is normally
> done to shut down or start up the database. There are very few things
> that require the SYSDBA privilege. The only exception to the rule is
> using the X$ tables but not even that should be done carelessly. Reading
> some of the X$ tables can greatly increase latch activity and severely
> impact the system.
> Starting and stopping database from a Perl script is a very unusual
> choice and should be reconsidered very carefully.
Mladen,
From what I gather, the OP states:
> What I need is a username of one word (not three that makes the
> scripts barf)
> that has the powers to create tablespaces and users in a database that
> I created with dbca.
If he requires a login to a database that can create users, tablespaces and what-have-you, the SYSTEM login is all that he needs to use, rather than "SYS AS SYSDBA".
HTH
-g
Received on Tue Feb 16 2010 - 08:29:42 CST