Oracle Database Discussions

Hi

Any body can help me on this please..

I am not able to connect to the db through sqlplus and svrmgrl.

Windows 2003 server - Oracle db version 8.1.7.0.0

Please find the error given below while trying with sqlplus "/ as sysdba", svrmgrl,sqlplus /nolog

C:\Documents and Settings\vamanana>set ORACLE_SID=MP2

C:\Documents and Settings\vamanana>sqlplus "/as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on Sßb Nov 7 20:28:28 2009

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

ERROR:
ORA-12560: TNS:protocol adapter error


ORA_DBA privilege is added to this user,Oracle windows service is running.

Please find the sqlnet.ora, listener.ora, tnsnames.ora given below:

sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PXW3150MX4)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PXW3150MX4)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = mp2))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = sims))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = Y:\u01\dba\oracle\product\8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = mp2)
(ORACLE_HOME = Y:\u01\dba\oracle\product\8.1.7)
(SID_NAME = mp2)
)
(SID_DESC =
(GLOBAL_DBNAME = sims)
(ORACLE_HOME = Y:\u01\dba\oracle\product\8.1.7)
(SID_NAME = sims)
)
)


tnsnames.ora:

MP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = PXW3150MX4)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = PXW3150MX4)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = MP2)
)
)