Re: Oracle 8.1.6 on NT/Oracle 8.1.5 on NLM

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 - 09:56:22 CST