Re: startup nomount

CS wrote:

> Thanks Gabriel for taking the time.
> I planed on creating a database with my own specs first, mounting it then
> doing an import. (Plan not proven)
>
> What I have is a development database that we are trying to deploy on a CD.
> Our initial script asks for the user to insert their Oracle Install CD and
> Install Oracle.
> Then I want to replace the default oracle DB with ours. The original plan
> was to use DBartisan to create scripts. I thought we could just use
> Export/Import utilities in a script.
>
> I inherited this project so thing are a but fuzzy, especially since I'm new
> to Oracle dba requirements. I've been developing in MSSQL the porting all
> of the triggers and SP to Oracle. My company thinks it is a short step to
> Oracle DBA chores. NOT
>
> Any light you can help shed would be greatly appreciated.
>
> CS
>
> "Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote in message
> news:bgednUa8nMQQlvujXTWckQ_at_giganews.com...
> > Ok back up a step... Why are you doing this? Why startup nomount? Why
> > shutdown/startup at all? You mention IMP, but IMP needs the database to
> be
> > up and running, startups should not be involved. Also, why call oradim?
> >
> > Unless you're doing cold backups, shutting down a db is NOT part of normal
> > maintenance.
> >
> > If you have as big a mess in your hands as it appears you do, it's a good
> > thing you can't login in as sysdba!
> >
> > Sorry to say that but what you say you are trying to do makes no sense at
> > all!
> >
> > "CS" <sheley_at_interaccess.com> wrote in message
> > news:orn9a.5595$fa.2431759_at_dca1-nnrp1.news.algx.net...
> > > I'm a newbie to Oracle DBA chores.
> > > I'm trying to setup a script that installs Oracle then IMPort a
> database.
> > >
> > > After installing oracle, my batch file Starts the listener, then calls
> > > sqlmgrl.
> > >
> > > What should I connect as and what password?? I'm getting 'Insufficient
> > > Privilege's logging on as Sys or System when I issue the command
> STARTUP
> > > NOMOUNT
> > >
> > > I can't seem to get on using AS SYSDBA.
> > >
> > > Here is the command I issue before starting Svrmgrl
> > > oradim -new -sid MYDB -startmode manual -pfile
> > > D:\ORACLE\ora81\database\initMYDB.ora -intpwd password
> > >
> > > Once I get the command line down, I plan to put it in a SQL script
> > >
> > > Any Ideas would be really appreciated.
> > >
> > > Thanks
> > > CS
> > >
> > >
> > >
> >
> >

This has unhappy ending written all over it.

Oracle is not MS Access and should not be treated like it is. If you need Oracle's capabilities then do it right. If you just need MS Access use it instead.

Daniel Morgan Received on Wed Mar 05 2003 - 10:53:56 CST