Re: Oracle 8.1.6 on NT/Oracle 8.1.5 on NLM

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 28 Nov 2000 00:28:31 +0100
Message-ID: <900dra$5ub8o$2@ID-62141.news.dfncis.de>

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 Mon Nov 27 2000 - 17:28:31 CST