Re: ORA-12560 on NT

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 14 May 2003 22:25:47 -0700
Message-ID: <1ac7c7b3.0305142125.7f5ee9e9@posting.google.com>

sunny123 <member29620_at_dbforums.com> wrote in message news:<2876600.1052896102_at_dbforums.com>...
> hi,
> I meet the same trouble.OS is windows NT,Oracle version is 8.1.6.0
> Type 'sqlplus /nolog' in dos command line, then
> 1, If type 'connect system/manager' ,get the 'ora-12560, adapter
> error' message.
> 2, If type 'connect system/manager_at_SID', can access the oracle
> successfully.
>
>
> The Oracle server works for weeks normally before yesterday.In last
> night, the oracle server may be pow off by accident.
>
> best regards &thanks
>
> Sunny Sun

1. set the oracle_sid
2. make sure the service is started.
3. connect in via sqlplus (or svrmgrl if you are used to that)
4. start the instance if it is not started.
5. adjust the configuration so that the service and instance start automatically. (NOTE: back in 8.1.7.0.0 - the autostart functionality was not there. patch. or better yet, upgrade to 8.1.7.0.0 and patch to 8.1.7.4.1).

c:\> set ORACLE_SID=SID
c:\> net start OracleService%ORACLE_SID%
c:\> d:
d:\> cd oracle\ora81\bin
d:\oracle\ora81\bin\> sqlplus /nolog

SQL> connect / as sysdba
SQL> select * from v$database;

what do you get?
if its "connected to an idle instance" type

SQL> startup

and you should be good to go.

other things to check are -
- is the service set to start automatically?

    HKLM\SYSTEM\CurrentControlSet\Services\OracleService%ORACLE_SID%

       If the key "Start" is set to "0x2" - it will autostart.
       If the key "Start" is set to "0x3" - it will not autostart.
   this can also be checked in "Services".

- is the instance started when the services is started?

    HKLM\SOFTWARE\ORACLE\HOMEn\ORA_%ORACLE_SID%_AUTOSTART (TRUE) - is the path in the registry to the parameter file set correctly?

    HKLM\SOFTWARE\ORACLE\HOMEn\ORA_%ORACLE_SID%_PFILE

Pd Received on Thu May 15 2003 - 00:25:47 CDT