Oracle Database Discussions

Hey Guys,

I know this particular query has been pinging around for ages now, but i cannot seem to get a good answer from anywhere :)

Oracle 10g Database RAC installation- installed/ and running

Oracle 10g Client on different box.
-------------------------------------------------------------------------------------------------------
Problem:
-------------------------------------------------------------------------------------------------------
[user@myserver ~]$ sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Apr 4 16:14:11 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: user
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist
-------------------------------------------------------------------------------------------------------
All env variables are set in user .profile:
-------------------------------------------------------------------------------------------------------
export ORACLE_HOME=/space/oracle/oracle/product/10.2.0/client_1
export ORACLE_SID=MSRAC

PATH=$PATH:$ORACLE_HOME/bin:$JAVA_HOME/bin
export PATH
-------------------------------------------------------------------------------------------------------
Full contents of tnsnames.ora on client machine:
-------------------------------------------------------------------------------------------------------
LISTENER_ORCLTELE =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.9)(PORT = 1521))


ORCLTELE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.9)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcltele)
)
)

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

MSRAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.13)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MSRAC)
(failover_mode =
(type=select)
(method=basic)
(retries=180)
(delay=5))
)
)
-------------------------------------------------------------------------------------------------------
I am not sure if the first 3 connection entries are even needed in here, are they?
The last entry is the connect info for the live database.
-------------------------------------------------------------------------------------------------------

What buggs me is that this works:

[user@myserver ~]$ sqlplus 'user/user@msrac'

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Apr 4 16:19:40 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
With the Real Application Clusters option

SQL>quit
-------------------------------------------------------------------------------------------------------



BTW: This is the error catpured in sqlnet.log

***********************************************************************
Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/space/oracle/oracle/product/10.2.0/client_1/bin/oracle)(ARGV0=oracleMSRAC)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus)(HOST=myserver.me.com)(USER=user))))

VERSION INFORMATION:
TNS for Linux: Version 10.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.3.0 - Production
Time: 04-APR-2008 16:14:16
Tracing not turned on.
Tns error struct:
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 2
nt OS err code: 0


I have a funny feeling that the problem lies with either:

PROTOCOL=beq
and/or
ARGV0=oracleMSRAC

I have tried everything to remedy this, this is why i am now turning to you guys.

Any and all help is always greatly appreciated.

Robert