Oracle is his Thang Was:Re: [CLUE-Tech] set user id of script

[Adam Bultman]

So Jed, you say oracle is your thing?

Okay, I might take advantage of that re: backups and restores, which I'm
currently learning about.  I've managed to become a bit of an Oracle DBA
(My boss: "Hey adam. Build an oracle and coldfusion based server") While I
get some things:  Cold backups, init files, how it works, some basic
commands-- what I can't do yet is to back up and restore specific tables.
Since I had two weeks to set up the server (and that includes shipping and
ordering parts, and I didn't get all the parts until the friday before it
was due on monday)  I haven't actually had time to really get that
working. Every night,  I halt the db and do a cold, db file backup.  I
haven't needed it yet (whew!) but I REALLY need to get table-by table
backups running.  The only piece of the puzzle that I'm missing is the
Oracle Management Server.  I dont' seem to have that installed somehow,
so I can't start it. I'm downloading the Oracle817ntee.zip file now (did
I mention it was on windows?) to try install it, but I'm unsure.

I set up a 'dev' server so that I (and the programmers) don't have to do
open brain surgery on a production server, so I can afford to screw up.

Oh, well. thanks.

Adam


-- 
Adam
Bultman adam at glaven.org [ http://www.glaven.org ]


On Thu, 6 Jun 2002, Jed S. Baer wrote:

> On Thu, 6 Jun 2002 11:23:11 -0600
> Dave Price <davep at kinaole.org> wrote:
>
> > Hi,
> >
> > Is there a 'nice' way to execute a line in a script (or a script at
> > startup under the priveleges of another user ...
> >
> > I need to run some oracle scripts as different oracle uids which have
> > appropriate priveleges ...
>
> Dave, you can use the su command (as root) to run commands as anybody. You
> might notice this technique on your system now as the standard Oracle
> startup/shutdown procedure. (The invocation of /usr/local/bin/dbstart in -
> sheese, I need to get on an Oracle machine again - memory isn't working
> today.)
>
> For example, I use this command on my box to bring up the MySQL server as
> user "mysql".
>
>   su - mysql -c /usr/bin/safe_mysqld &
>
> The first hyphen says to run the login environment, then -c "command". You
> need the first hyphen so that stuff like $ORACLE_HOME, $ORACLE_SID, and
> $PATH are set for the Oracle operations. You could export those
> beforehand, I suppose. Since it runs as a subshell, I think it will
> inherit them - I've never done it that way though. It's less maintenance
> to just let the command pick up what it needs from oraenv.
>
> BTW, if you need some more help, Oracle is my thang, ya know.
>
> Later,
> jed
>