Personal Oracle7: creating a second database

I'm having difficulty creating a second database with Personal Oracle7. I'm running Win95, PO7 version 7.2 (no svrmngr).

I changed ORACLE_SID to "CC1" and created a password file (pwdcc1.ora, password=pswd) using orapwd72.exe. I have my initcc1.ora file set up.

So I run sqldba from an msdos box, then connect internal. If I don't set DBA_AUTHORIZATION to pswd I have to supply it here (I've tried it both ways). Then is says connected. I try to startup the instance using my init file, but then is says I have insufficient privileges. Example: SQLDBA> connect internal
Connected.
SQLDBA> startup pfile=d:\oracle\dbs\initcc10.ora nomount ORA-01031: insufficient privileges
SQLDBA> The documentation seems pretty scarce on creating new databases from scratch. I've tried playing around with other parameters like ORACLE_CC1_PWFILE but that doesn't seem to have any effect.

Anybody been able to create a second DB with PO7 on Win95? Were you able to put it in a different directory than %ORACLE_HOME%\database?

Thanks for any help.

Steven Patenaude Received on Mon Jun 23 1997 - 00:00:00 CDT