EdStevens wrote:
> peter wrote:
> > EdStevens wrote:
> > > peter wrote:
> > > > Hello Expert,
> > > >
> > > > I am trying to migrate oracle 8i (8.1.5) to oracle 9i (9.0.1) on window
> > > > XP sp2.
> > > > According to documentation I am doing all steps but I am facing in
> > > > starting.
> > > >
> > > > shutdown database with internal user.
> > > >
> > > > 1) Install oracle 9i (9.0.1).
> > > > 2)on dos prompt made new password file in (Oracle 9i)
> > > > ORACLE_HOME/database/pwdhhh.ora.
> > > > orapwd file="d:\oracle\ora90\database\pwdhhh.ora" password=dx
> > > > 3) oradim -delete -sid hhh
> > > > 4) oradim -new -sid hhh -intpwd dx
> > > > 5) set oracle_sid=hhh
> > > > 6) sqlplus "/ as sysdba"
> > > >
> > > > then I am getting error here insuffi. privs.
> > > > then I connect with sys/dx as sysdba
> > > > I changed parameter in parameter file like add db_cache_size
> > > > but it is not able to recognise this parameter.
> > > >
> > > > as well as
> > > > when I try to startup nomount with sys getting error insuff. privs.
> > > > Please tell me what is the wrong step and what else step I can take to
> > > > start it in nomount stage with new parameter.
> > >
> > > First, if this is truely an urgent problem, newsgroups are not the
> > > place to be asking for help.
> > >
> > > Second, which version of Windows XP -- home or pro? I don't believe
> > > Oracle is certified on home. Certainly not any 8.x version of Oracle.
> > > If this is XP-home, and it is a production database .... your shop is
> > > in worse shape than mine. If it is not a production database, then
> > > this is NOT an "urgent" problem. If it is XP-Home, since it is not
> > > certified, you're pretty much 'SOL.'
> >
> > It is XP Prof.
> > Urg means I have to do this, very early in future.
> >
> > > Third. If 'sqlplus "/ as sysdba"' returns 'insufficient privileges' it
> > > means you are not logged on to the server with an account that is a
> > > member of the local ora_dba group. You must fix this before adressing
> > > the rest of the problems.
> >
> > User is member of Ora_dba now what.
>
> Now what? Confirm that you can connect. Were you able to connect to
> do the shutdown, but not the startup? Did you by any chance install
> the 9 software into the same oracle_home as the 8?
Yes Sir, I did install oracle 9i in same Oracle Base.
and user had ora_dba privs from starting.
It is not RAC simple oracle database. In Parameter File remote_pass. is
NONE.
so password file should not create any problem but still I am not able
to connect sys without password. As well as when I connect to sys with
password and issue the command
Startup nomount
it is giving error "Insuff. Privs."
I know it is strange but I do know what to on this condition.
even it is not accepting new parameters like db_cache_size as I told.
Received on Tue Aug 29 2006 - 12:38:36 CDT
