After setting the oracle_sid, you run oradim80 to create a new database
instance.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Naushi Hussain" <naushi.hussain_at_alliedsignal.com> wrote in message
news:3A23D5A6.614DBE80_at_alliedsignal.com...
> In answer to your answer for 3 - I did set the oracle_sid to the new one
but
> still get the same error. I set the oracle_sid to the existing one and i
dont
> get the error. But I need to set the instance to the new one so I can
create
> the new db.
>
> 4. database is up snd running I can ping the server from the work station
but
> cant connect through Entprize manager or sqlplus window.
>
> I do appreicate your help int his matter. Anything eles you can help me
with
> to get this resolved will be appreictaed. Oracle tech support has been
> terrible in this matter.
>
> Sybrand Bakker wrote:
>
> > Answers embedded
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > "Naushi Hussain" <naushi.hussain_at_alliedsignal.com> wrote in message
> > news:3A22E60C.5FB27E53_at_alliedsignal.com...
> > > NT problems
> > >
> > > 1. does anyone know how do we find out in command mode what is the
> > > current oracle-home or oracle-sid.
> >
> > Type set without parameters to display current environment variables.
> > >
> > > 2. how do you set your environment to a new oracle home or SID.
> > >
> > set oracle_sid=<any value> in a dos box, or change the string var
> > hklm\software\oracle\oracle_sid
> >
> > > 3. I am trying to create a new database using a 'create database
script'
> > > but when I type svrmgrl I get an error 'tns:12560: protocol adapter
> > > error'.
> > >
> > > I do not get an error when I set my env. to an existing database and
> > > then try svrmgrl.
> > >
> > > How can I successfully execute svrmrgl so I can create a database
> > >
> >
> > You didn't set Oracle_SID
> >
> > > 4. Novell platform
> > >
> > > I have installed Oracle successfully and listener is running fine but
I
> > > cant connect from my work station using EOM or sqlplus. I get the
error
> > > 'tns12500: listener failed to start a dedicated process.
> > >
> > > would appreciate any help.
> > >
> > Is the database up?
>
Received on Tue Nov 28 2000 - 10:13:47 CST
