Re: Starting instance - Access denied

"J. Fleck" <fleckj__at_hotmail.com> wrote in message news:9pig3l$2kk6$1_at_scavenger.euro.net...
> Hi,
> I am trying to re-install Oracle 8.1.7 (I have tried both the enterprise
and
> personal edition) under win2k professional. After configuring the Listener
> using Oracle default values. I try to create a new database. I always get
> the message "ora-12560 tns protocol adaptor error" (or someting like
that).
> Basically this means that there is no Oracle instance running. This is
true
> because if I look in the Windows control panel I see in the event viewer
> that when starting Windows none of the Oracle sevices could be started
> (Access is denied).. If I try to start them manually I get the same
message
> ('Error 5: Access is denied').
>
> I have seen posts from other people with the same problem (ora-12560). The
> standard answer is 'listener.ora and / or tnsnames.ora are not configuered
> correctly'. This maybe the case. However no one actually says what the
> correct configuration is. The Oracle document delivered with the download
> version is a little coy about this. The sample files are Unix orientated
> and adapting them does not help.
>
> I only want to be able to access a local Oracle database in order to carry
> out a limited number of tests.
>
> Basically the question is, why does Oracle refuse access when starting an
> instance and what must I do to solve the problem?
>
> Thanks for the help that I know that I going to get from you dedicated
> professionals out there.
>
> Regards,
>
> Jim Fleck
>
>
>
>
>
>

If you are on the database server, 12560 could be as well the symptom of ORACLE_SID not being present in the registry (in hklm\software\oracle) or not being present as environment variable, or set incorrectly. Usually, with Oracle_SID set, you don't need net8 at all.

As far as I am concerned, there is no difference at all in configuring net8 for Unix or NT/Win2k.
As you have two different versions installed on the system, you also may want to look into potential problems with PATH environment variable. You didn't hopefully installed those 2 products in one Oracle Home and/or have two instances with the same SID? Both situations will definitely create havoc.
If these pointers are insufficient, please respond to these questions and/or post your full net8 config (three files)

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 04 2001 - 15:58:05 CDT