| ORA-1256:TNS: protocol adapter error, Plz help me [message #67167] |
Sun, 11 January 2004 04:56  |
phani
Messages: 9
Registered: November 2000
|
Junior Member |
|
|
Hi G'Day,
I am newbie in using oracle 8.1.7.Plz help me.When I am installing the oracle 8.1.7 and when it is creating database it is giving the above said error and couldn't logon to sql*plus.
Thank you in advance
my tnsnames.ora looks like this
# TNSNAMES.ORA Network Configuration File: f:Oraclenetworkadmintnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
my listener.ora looks like this
# LISTENER.ORA Network Configuration File: f:Oraclenetworkadminlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = f:Oracle)
(PROGRAM = extproc)
)
)
|
|
|
|
| Re: ORA-1256:TNS: protocol adapter error, Plz help me [message #67168 is a reply to message #67167] |
Sun, 11 January 2004 09:27  |
Mark
Messages: 284
Registered: July 1998
|
Senior Member |
|
|
Try this, your oracle home and presentation clause may be different:
name_of_your_db=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = name_of_your_db)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
Listerner:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = your_db)
(ORACLE_HOME = C:oracleora90)
(SID_NAME = your_db)
)
)
good luck....
|
|
|
|
| Re: ORA-1256:TNS: protocol adapter error, Plz help me [message #67455 is a reply to message #67168] |
Wed, 04 August 2004 00:07 |
Paresh
Messages: 9
Registered: January 2001
|
Junior Member |
|
|
Try this, your oracle home and presentation clause may be different:
name_of_your_db=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = name_of_your_db)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
Listerner:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = your_db)
(ORACLE_HOME = C:oracleora90)
(SID_NAME = your_db)
)
)
good luck....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
