Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Pb Creating database using oracle scripts
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...Received on Fri Oct 11 2002 - 02:23:54 CDT
> Thanks for your reply,
>
> The error is because the "PWDpcit.ORA" file does not exist in the
> {ORACLE_HOME}\DATABASE directory.
![]() |
![]() |