Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [Oracle 9i Personal Edition] Start oracle database...

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

From: Frank <fbortel_at_nescape.net>
Date: Sat, 20 Dec 2003 16:12:38 +0100
Message-ID: <bs1oc3$fip$1@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.
>>I've choosed to install only the software and to skip the creation of
>>a database during installation procedure.
>>
>>I've restarted the machine and I've made next step to create a
>>database manually (following the "Oracle 9i Administration Guide":
>>1. I've created a Password File with the command orapwd in the
>>$oracle_home directory
>>The password I've choosed is "secret".
>>2. I've created an initialization file in the oradata directory with
>>the name init$db_name.ora
>>3. I connect with the command sqlplus as user "sys/secret as SYSDBA"
>>to launch the command "create database"
>>
>> B U T
>>
>>at this point when i insert a usr/pwd (i have tryed with
>>sys/change_on_install as sysdba, system/manager, sys/secret,
>>scott/tiger, all...) in Windows98 appears a dialog box (the same
>>obtained clicking on the menu voice "Start Oracle database") that ask
>>for a password: not a username/password, only a password. I've
>>inserted the same passed to the orapwd command and all known password
>>but it say that it's incorrect.
>>
>>After this I've disinstalled all and reinstalled responding "yes" when
>>Universal Installer ask to install a database. In this way all run
>>correctly.
>>
>>Probably in Windows98 u have to permit the installation of a db to use
>>oracle.
>>Probably the installation of personal edition on a win98 system has
>>some mistakes.
>>Probably the administration guide doesn't give correct procedure for
>>win98.
>>Certainly, it isn't simple
>>
>>Thanks for help
>>Bye
> 
> 
> certinaly it isnt supported on Win 98
> certinaly you dont really know what you are doing
> 
> 

As if that helps. And there IS a supported version.

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)!

-- 
Merry Christmas and a Happy New Year,
Frank van Bortel
Received on Sat Dec 20 2003 - 09:12:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US