Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbie question to oracle8i
The easiest way is to go to a dos shell via start/run/cmd
type set ORACLE_SID=your oracle sid
type svrmgr23
type connect internal
type startup pfile='full file path of init.ora
(if your pfile is in $ORACLE_HOME/dbs you don't have to declare it)
Sebastian Müller wrote in message <7ikfk8$ul1$1_at_lisa.rz.hu-berlin.de>...
>hello,
>
>
>i have an extremely simple question, which i don't seem to be able to
solve,
>since i am a complete newbie to oracle and the docs are too complex to
begin
>with.
>
>the only thing i want to know are the exact steps what i have to do after i
>created a database with the configuration assistant.
>i have the INTERNAL and SYSTEM account (there was a third one i think) but
>when i login using sqlplus i can't create tables or anything because he
>tells me "ORA-01109: Database not opened".
>i can't figure out how to open it. i know it is mounted and the WinNT
>services are running but i must be missing something.
>
>any help is greatly appreciated,
>thanks in advance
>
>sebastian
>
>
Received on Thu May 27 1999 - 17:34:07 CDT