Home » RDBMS Server » Server Administration » tns and ora errors
tns and ora errors [message #216184] Thu, 25 January 2007 08:09 Go to next message
maoro
Messages: 310
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


Re: tns and ora errors [message #216188 is a reply to message #216184] Thu, 25 January 2007 08:25 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
show the tnsnames.ora and sqlnet.ora file from both client and server plese.
Re: tns and ora errors [message #216194 is a reply to message #216184] Thu, 25 January 2007 09:02 Go to previous messageGo to next message
maoro
Messages: 310
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
Re: tns and ora errors [message #216199 is a reply to message #216194] Thu, 25 January 2007 09:40 Go to previous messageGo to next message
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
Re: tns and ora errors [message #216241 is a reply to message #216194] Thu, 25 January 2007 13:52 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Oops, I meant to also ask for the server listener.ora file.
Re: tns and ora errors [message #216322 is a reply to message #216184] Fri, 26 January 2007 08:05 Go to previous messageGo to next message
maoro
Messages: 310
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

Re: tns and ora errors [message #216342 is a reply to message #216322] Fri, 26 January 2007 11:53 Go to previous messageGo to next message
joy_division
Messages: 4644
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
Re: tns and ora errors [message #216343 is a reply to message #216184] Fri, 26 January 2007 12:01 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: tns and ora errors [message #216750 is a reply to message #216184] Tue, 30 January 2007 04:29 Go to previous message
maoro
Messages: 310
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
Previous Topic: Please help me find answers to the Qns.. TIA
Next Topic: Storage (next extent)
Goto Forum:
  


Current Time: Sat Dec 10 22:28:42 CST 2016

Total time taken to generate the page: 0.22787 seconds