[CLUE-Tech] More oracle, Jed. Welcome to the nether regions of hades

[Adam Bultman]

Okay, Jed, with everyone else on the list mostly ignoring this:

Now that exports are working, I need to test imports.  My export file, by
the way, is like 60k. That seems a touch small.  No wait, 730k.

So, I'm trying to create a new database.  When I use the GUI, it *never*
works.  It creates the service, but then, it puukes:  TNS protocol adapter
error.  I'm trying to create an empty database sans the files on the CD
(since what I want to do is just take my other db files, and plunk them in
there).

Any ideas why this is happening?  This is like, the 5th Oracle server that
does this. Seems a bit bone-headed to create a gui that can't create a
database like it should. I'm going to try editing config files by hand and
fiddling that way, but I don't have much hope.  Abandon ye...

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


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

> On Thu, 6 Jun 2002 13:58:47 -0400 (EDT)
> Adam Bultman <adamb at glaven.org> wrote:
>
> > So Jed, you say oracle is your thing?
>
> Well, it was, last I was employed.
>
> > Okay, I might take advantage of that re: backups and restores, which I'm
> <snip>
> > 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
>
> The short version is if you want per-table backups, use export. You can
> set up a "control" file to hold all the parameters, including a table
> list, for the export. Make sure you read about read-consistent exports,
> and decide if you need those, or you can trust the database to be
> quiescent during them (or alter the database to be read-only during
> exports, or set the tablespaces readonly).
>
> The long version isn't really appropriate for this list, and quite
> honestly, I'd hope for a few consulting bucks to really set you up right.
> But other than that, you really want to read/understand archive log mode,
> and look at using RMAN, if your data is important. Your cold backups or
> nightly exports will worst-case lose the day's worth of data if you have a
> crash. There's lots of backup solutions for Windoze which will integrate
> with RMAN. I'm primarily a Unix weenie though. I guess I should make the
> obligatory crack that if you really care about your data, you get it off a
> Windoze box ;-).
>
> Feel free to e-mail me off list.
>
> Later,
> jed
>