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: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Fri, 11 Oct 2002 11:23:54 +0400
Message-ID: <ao5ud5$a6u$1@babylon.agtel.net>


Well, if you take a closer look at the batch file the DBCA generated, you should notice that there is a call to ORADIM utility, which creates new service for the instance, and the password file (PWD<sid>.ORA) automatically for you. at the very beginning of the batch script. The script should also create directories needed for database files. If you didn't run the batch script and instead ran sqlplus scripts manually right away, the dirs, the service and the password file were not created. Now that you created the directories manually, you should also create the service and the password file using ORADIM.
You can also create the password file using ORAPWD utility. Running both utilities without parameters will cause them to print their help screen.

--
Vladimir Zakharychev (bob@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.


"Saad Ben Barka" <Saad.Ben.Barka_at_apic.fr> wrote in message
news:ao3s1p$eto$1_at_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.
Received on Fri Oct 11 2002 - 02:23:54 CDT

Original text of this message

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