Re: problem in creating database

Hello,

I'm not working on Unix, but on WNT.

I have some similar problems : the internal user lost his password   for example : when oracle create the database, i cancel the process, and then internal lost his password.
(there are some years i create databases, it's not my first)

That i must do is to delete the OracleService (background process on unix), delete the password file of the database (C:\Oracle\Ora81\database\pwd<instance>.ora) and recreate the OracleService (it will create the password file), and the create the database.

You have the ORAPWD binary to create the password file.

Internal will be dessuport in version 8.2 : Oracle 8.1.6 on WNT create a new WNT group named ORA_DBA : it contains the users WNT who can shutdown and startup the database without connection via the internal user.
I wonder if oracle have bugs accessing system information ??

Regards

"lkw" <lkw_at_axiomatique.com> a écrit dans le message news: 91ptke$pq9$1_at_violet.singnet.com.sg...
> hi all,
>
> when i try to create another database, i encounter error below. what could
> be the reason?
>
> SVRMGR> _at_/appln/oracle/product/8.1.5/makedb.sql
> Connected.
> ORA-27146: post/wait initialization failed
> create database TEST
> *
> ORA-03114: not connected to ORACLE
>
>
> below is my makedb.sql file.
>
> >connect internal
> >startup nomount pfile=/appln/oracle/product/8.1.5/dbs/initTEST.ora
> >create database TEST
> > maxinstances 12
> > maxlogfiles 32
> > maxdatafiles 1022
> > character set "US7ASCII"
> > datafile
> > '/appln/oracle/oradata/TEST/SYSTEM_01.DBF' size 50M
> > logfile
> > '/appln/oracle/oradata/TEST/RLOG_01.DBF' size 10M,
> > '/appln/oracle/oradata/TEST/RLOG_02.DBF' size 10M;
>
>
>
> hope that everybody can help me, the problem has with me for more than 1
> day.
> ....thanks alot.
>
>
> lkw.
>
>
Received on Fri Dec 22 2000 - 00:32:41 CET