OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » tns and ora errors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tns and ora errors [message #216184]

Thu, 25 January 2007 08:09

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
i have oracle 9i on as400, where the database is up and runing the listener in runing and sqlplus connects fine.
from a windows client where there is oracle developer 6i, i can ping the server , the tnsnames.ora file is fine , but i cant connect using sqlplus ,i get errors like ora-12203 or tns-03505
even tns ping dosent work ....

help friends
thank u

Report message to a moderator

Re: tns and ora errors [message #216188 is a reply to message #216184]

Thu, 25 January 2007 08:25

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

show the tnsnames.ora and sqlnet.ora file from both client and server plese.

Report message to a moderator

Re: tns and ora errors [message #216194 is a reply to message #216184]

Thu, 25 January 2007 09:02

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
this is the sqlnet.ora from the server
---------------------------------------------------
# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
---------------------------------------------------

and the tnsnames.ora file
---------------------------------------------------
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

####################

ASD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = toshiba-user)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = asd)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
----------------------------------------------------------

the same files are on the client side
thanks

Report message to a moderator

Re: tns and ora errors [message #216199 is a reply to message #216194]

Thu, 25 January 2007 09:40

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
You have more than one tnsnames.ora file in your system. ?

In client side tnsnames.ora entry is set correctly set.
regards
Taj

Report message to a moderator

Re: tns and ora errors [message #216241 is a reply to message #216194]

Thu, 25 January 2007 13:52

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Oops, I meant to also ask for the server listener.ora file.

Report message to a moderator

Re: tns and ora errors [message #216322 is a reply to message #216184]

Fri, 26 January 2007 08:05

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
this is the listener.ora file from the server:
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = asd)
(SID_NAME = asd)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = toshiba-user)(PORT = 1521))
)
)

--------------------
thanks friends

Report message to a moderator

Re: tns and ora errors [message #216342 is a reply to message #216322]

Fri, 26 January 2007 11:53

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Try changing the tnsnames.ora file on the client to use:

SID=asd instead of SERVICE_NAME=asd

Report message to a moderator

Re: tns and ora errors [message #216343 is a reply to message #216184]

Fri, 26 January 2007 12:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>from a windows client where there is oracle developer 6i, i can ping the server , the tnsnames.ora file is fine , but i cant connect using sqlplus ,
AFAIK, this means you have TWO separate ORACLE_HOME trees & the key network related files don't match between theo 2 trees.

Report message to a moderator

Re: tns and ora errors [message #216750 is a reply to message #216184]

Tue, 30 January 2007 04:29

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
i sont have two trees i only have developer 6i on the client machine, no other oracle onstallation is there

thanks

Report message to a moderator

Previous Topic:	Please help me find answers to the Qns.. TIA
Next Topic:	Storage (next extent)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:41:41 CDT 2024