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: Pb Creating database using oracle scripts

Re: Pb Creating database using oracle scripts

From: Saad Ben Barka <Saad.Ben.Barka_at_apic.fr>
Date: Thu, 10 Oct 2002 14:30:49 +0200
Message-ID: <ao3s1p$eto$1@s1.read.news.oleane.net>


Thanks for your reply,

The error is because the "PWDpcit.ORA" file does not exist in the {ORACLE_HOME}\DATABASE directory.
This is what I found in the "pcitALERT.LOG" file and the "TRC" file. What I forgot to tell, is : If a create immediately the database with database assistant there is no problem.

Regards,

Dump file D:\oracle\ora90\RDBMS\trace\ORA01980.TRC Thu Oct 10 11:17:33 2002
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586 Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586 Instance name: pcit

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 1980, image: ORACLE.EXE

--
********************************************************
Saad Ben Barka
Chef de Projet
Apic SA - 113 Avenue Aristide Briand - 94117 Arcueil Cedex (France)
Tel: +33 (0) 1 49 08 83 00 - Fax: +33 (0) 1 49 69 92 93
*******************************************************
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> a ecrit dans le message de
news: ao3pc4$ca8$1_at_babylon.agtel.net...

> 1092 means the instance crashed and you probably can find out the reason
> in alert log and trace files if there are any. This may be a bug or a
> misconfiguration issue. Without seeing messages from alert log and/or
trace
> it's hard to tell more.
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer. >
Received on Thu Oct 10 2002 - 07:30:49 CDT

Original text of this message

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