| Tns: protocol adapter error [message #198612] |
Tue, 17 October 2006 23:56  |
charankarthikeyan
Messages: 16
Registered: August 2006
|
Junior Member |
|
|
Good day,
i've oracle 9i installed 10 months back, last week i've installed internet broadband connection i dont know why after this i'm receiving ;TNS protocol error while logging in sqlplus , my oracle listener service is started and oracleservicedawn(dawn my db name) is not starting and prompts "
could not start oracleservicedawn on local computer error 1067 the process terminated unexpectedly"
my sqlnet.log file:
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracledawn)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CON NECT_DATA=(SID=dawn)(CID=(PROGRAM=C:\oracle\ora90\bin\sqlplus.exe)(HOST=KARTHI)(USER=karthik))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.0.1.1.0 - Production
Time: 17-OCT-2006 22:50:46
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0
****************************************************************
listener.ora:
# LISTENER.ORA Network Configuration File: C:\oracle\ora90\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = karthi)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora90)
(PROGRAM = extproc)
)
)
(SID_DESC = //this line i've included of my own from ref:
(GLOBAL_DBNAME = DAWN)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = DAWN)
)
)
tnsnames.ora:
####################################
# TNSNAMES.ORA Configuration File:C:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Tue Oct 17 23:26:44 GMT+05:30 2006
####################################
DAWN_KARTHI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = karthi)(PORT = 1521))
)
(CONNECT_DATA = (SID = dawn)(SERVER = DEDICATED))
)
DAWN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = karthi)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = dawn))
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = karthi)(PORT = 1521))
)
(CONNECT_DATA = (SERVER = SHARED)(SERVICE_NAME = dawn)(PRESENTATION = http://HRService))
)
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))
)
even i inclded SID_DISC in listener of my own from references
but still the oracleservicedawn is refusing to start
any one pls help me out, will be a great help since i'm suffering for this for past 1 wk, and my informatica repository depends oracle.
with warm wishes
karthik
|
|
|
|
|
|
| Re: Tns: protocol adapter error [message #198661 is a reply to message #198612] |
Wed, 18 October 2006 02:49  |
charankarthikeyan
Messages: 16
Registered: August 2006
|
Junior Member |
|
|
Hi,
i've already chose it in Google and tried, did'nt get remedy thats what i posted in forum elaborately can someone provide
solutions of what exact will be the cause & the remedy,i ve submitted all the required files.
assistance pls
with warm wishes
karthik
|
|
|
|
| Re: Tns: protocol adapter error [message #199678 is a reply to message #198612] |
Wed, 25 October 2006 15:32 |
pankyz
Messages: 11
Registered: October 2006
|
Junior Member |
|
|
Hi Karthik,
Well u have installed internet connection so i think your IP address keeps on changing everytime you log on to the internet.So U just go to start menu>programs>oracle home>sql net easy configuration and modify the service there and change the ip address same as of your ip address(See your IP address by IPCONFIG at command prompt).I think i should work ....
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
