Re: Manually creating Oracle 9i database

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 14 Nov 2002 06:16:00 +1100
Message-ID: <ypxA9.76004$g9.214322@newsfeeds.bigpond.com>

"Amish Shah" <email_amishs_at_yahoo.com> wrote in message news:b6440577.0211131104.424fecbf_at_posting.google.com...
> I'm trying to create a new database manually, and I'm having trouble
> connecting to SQLPlus. I've set my new SID and try to "connect / as
> sysdba". This is a Win2K Prof. machine and I am in the appropriate
> Oracle admin groups.
>

Hmmm. Bit sparse on the detail, aren't we? What's the error message you're getting (full text, please, not just a number).

You say you're a member of the 'appropriate Oracle admin groups'. And they would be... what, exactly? There should really only be one of them, namely ORA_DBA.
> Is it possible to connect to SQLPlus as sysdba without having a
> database created?
>

Of course it is... who do you think you have to be to actually issue the 'create database' command?

Regards
HJR
> Thanks much.
>
> Amish.
Received on Wed Nov 13 2002 - 13:16:00 CST