Oracle Database connection error -- ORA-12560: TNS:protocol adapter error

[#1]

Hi,

I am unable to connect to Oracle 8i database  getting the following error

Cause:

SAP system to be migrated from Windows 2000 NT to Windows 2003 Operating system

SAP Installatoin Version 4.6 C with Oracle Database 8.1.7 installed on New server

Offline database backup restored successfully using BR commands

Error while connecting to the database on new server

sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 10 11:44:43 2012

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

Steps followed :

• Listener services checked and tested
• TNS files checked
• Environment variables checked
• TNS ping to SID possible
• Oraacle SID env set

Attaching herewith the network files

Thanks in advance

Regards,

Kunal Kulkarni

tnsnames.ora.zip

sqlnet.ora.zip

listener.ora.zip

[former_member189725]

Can you please paste the output of the command set executed in the same login where you are trying to connect.

Regards

Ratnajit

[Former Member]

Hi Ratanjit,

Please find below the commands executed

C:\Documents and Settings\d11adm.MUMSERVER>set oracle_sid=D11

C:\Documents and Settings\d11adm.MUMSERVER>sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 10 13:50:54 2012

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

SQL>

Regards,

Kunal