Re: [Oracle 9i Personal Edition] Start oracle database...

From: Frank <fbortel_at_nescape.net>
Date: Sun, 21 Dec 2003 17:30:36 +0100
Message-ID: <bs4ha7$7ea$1@news1.tilbu1.nb.home.nl>

robysimoni wrote:

> "Frank" <fbortel_at_nescape.net> wrote in message
> news:bs1oc3$fip$1_at_news4.tilbu1.nb.home.nl...
>

>>DJ wrote:
>>
>>
>>>"robysimoni_N-O-S-P-A-M_at_inwind.it" <robysimoni_at_inwind.it> wrote in

>
> message
>

>>>news:ae986593.0312200524.6a9ead3d_at_posting.google.com...
>>>
>>>
>>>>Hi, I've installed the Oracle 9i Personal Edition on my Windows 98
>>>>machine.
>>
>>...
>>...
>>...
>>
>>Few points wrong here (maybe typographic errors):
>>- password file goes into %ORACLE_HOME%\database
>>- ini file (pfile) doesn't matter, although the default is
>>   the same %ORACLE_HOME%\database
>>- create database should be preceded by:
>>   startup nomount pfile=<the location where you stored yours>.
>>   The preferred place is an admin directory, which the
>>   installer would create under %ORACLE_HOME%\
>>
>>Your spfile would be stored in %ORACLE_HOME%\database
>>(as part of the post create steps by OraInst).
>>
>>Next time, just recreate the orapwd file. Don't, if
>>you have created users with DBA privileges (which
>>you shouldn't, but that's another thread)!

>
>
> Thanks for the help
> I think I'll try to examine what DBCA does when it create the first
> database. Where it put pwd & init files, etc... with this info & admin guide
> probably i'll find where i make mistakes
>
> Thanks
> bye
>
>

Welcome.
Beware, that DBCA creates the passwordfile in background - if it's still there, the create database statment will fail.

-- 
Merry Christmas and a Happy New Year,
Frank van Bortel

Received on Sun Dec 21 2003 - 10:30:36 CST