Home » RDBMS Server » Networking and Gateways » Tns: protocol adapter error
Tns: protocol adapter error [message #198612] Tue, 17 October 2006 23:56 Go to next message
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 #198657 is a reply to message #198612] Wed, 18 October 2006 02:33 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
here
Re: Tns: protocol adapter error [message #198661 is a reply to message #198612] Wed, 18 October 2006 02:49 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: unable to start listener
Next Topic: ora-12560 error,unable to solve
Goto Forum:
  


Current Time: Tue Dec 06 04:22:30 CST 2016

Total time taken to generate the page: 0.13059 seconds