Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trouble creating second db

Re: Trouble creating second db

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca>
Date: Wed, 10 Apr 2002 19:34:58 GMT
Message-ID: <Ct0t8.2032$H%6.88133@news0.telusplanet.net>


oradim doesn't create pfile. You have to do that yourself. Use an existing one as example.

--
Terry Dykstra
Canadian Forest Oil Ltd.
"Marty Phee" <martyphee_at_no_spmmm_earthlink.net> wrote in message
news:oe_s8.5175$3P4.454631_at_newsread2.prod.itd.earthlink.net...

> Thanks, that worked.
>
> Today I have a new problem. oradim wouldn't create the pfile...
>
> oradim -new -sid pipeprod
> pfile="e:\oracle\admin\pipeprod\pfile\initPipeProd.oar"
>
> And no pfile or directory.
>
> I did work around it by using the db assistant to copy the files, and then
> before I clicked on abort I copied the directories. Now I'm running the
> scripts manually.
>
> thanks for your help,
>
> marty
>
>
> Murali wrote:
>
> > Marty Phee <martyphee_at_no_spmmm_earthlink.net> wrote in message
> > news:<jFFs8.3124$3P4.252628_at_newsread2.prod.itd.earthlink.net>...
> >> They are setup correctly. I can't even connect to the working database
> >> with svrmgrl. I get the same 12560.
> >>
> >> I'm able to create an instance using oradim, connect to it with
sqlplus,
> >> and then load it with nomount within sqlplus. But, I still can't
connect
> >> to it with svrmgrl.
> >>
> >> >> I'm trying to create a second database instance on the machine with
> >> >> the "Database Configuration Assistant", but it keeps erroring out
with
> >> >> ora-12560.
> >> >>
> >> >> I've tried to set the ORACLE_SID both in the environment, and the
> >> >> registry but with no luck.
> >> >>
> >> >> I don't know what else to try?
> >
> >
> > Are you connecting to the Windows machine using Terminal Services
> > Client ? This method is unsupported and most of the database assistant
> > programs will fail to work properly. Here's what I do to create a new
> > database over Terminal Services.
> > Use the database configuration assistant to generate the db creation
> > scripts. Then in the yoursid.bat file add this environment variable
> > before creating the instance and running the sql files -
> > set LOCAL=yoursid
> >
> > Then run the bat file to create the database. You should also be able
> > to connect to the first database using svrmgrl by setting the variable
> > LOCAL to that instance name.
> >
> > If you are not using Terminal Services, then I am not sure about the
> > cause of the 12560 error.
> >
> > Murali
>
Received on Wed Apr 10 2002 - 14:34:58 CDT

Original text of this message

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