473,324 Members | 1,678 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

TNS 12545 urgent !!

I have my Oracle 9i database running on my XP box. I can connect to it
from Solaris 5.8. I am able to connect from sqlplus. But during a
install, script is not able to establish connection. My sqlnet.log

Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=
(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO)) (CONNECT_DATA=(CID=(PROGRAM=)(HOST=salvo)(USER=dee pak))))

VERSION INFORMATION:
TNS for Solaris: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version
8.1.5.0.0 - Production
Time: 24-NOV-03 18:41:38
Tracing not turned on.
Tns error struct:
nr err code: 0
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 can connect using sqlplus from both XP and solaris. That means ip,
port, username, password, SID, service name, etc. are correct. Also
this means my listener and service are running fine on XP. Does the
log point to any potential problems?
Jul 19 '05 #1
3 20673
Deepak wrote:
I have my Oracle 9i database running on my XP box. I can connect to it
from Solaris 5.8. I am able to connect from sqlplus. But during a
install, script is not able to establish connection. My sqlnet.log

Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=
(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO)) (CONNECT_DATA=(CID=(PROGRAM=)(HOST=salvo)(USER=dee pak))))

VERSION INFORMATION:
TNS for Solaris: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version
8.1.5.0.0 - Production
Time: 24-NOV-03 18:41:38
Tracing not turned on.
Tns error struct:
nr err code: 0
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 can connect using sqlplus from both XP and solaris. That means ip,
port, username, password, SID, service name, etc. are correct. Also
this means my listener and service are running fine on XP. Does the
log point to any potential problems?


You use BEQ - that's a local protocol (e.g. will only work
on the solaris box).
Do NOT set the SID in the Solaris environment (which you didn't)
and use a tns alias in the connect string.

Your script is wrong, and does a connect or something similar,
without a connect string
--
Regards, Frank van Bortel

Jul 19 '05 #2
One common problem - does the ODBC know about the TNSNAMES? In other
words, are you using the same TNSNAMES file for ODBC as you are for
SQL*Plus?

Are there multiple homes? Was the ODBC driver installed into/linked
with an Oracle_home whose TNSNAMES works? Does that ODBC driver
undrstand the TNSNAMES_ADMIN variable?

(I haven't looked at 8.1.5 in a donkey's age. Consider upgrading to one
that's supported if possible!)
Jul 19 '05 #3
Deepak wrote:
I have my Oracle 9i database running on my XP box. I can connect to it
from Solaris 5.8. I am able to connect from sqlplus. But during a
install, script is not able to establish connection. My sqlnet.log

Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=
(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO)) (CONNECT_DATA=(CID=(PROGRAM=)(HOST=salvo)(USER=dee pak))))

VERSION INFORMATION:
TNS for Solaris: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version
8.1.5.0.0 - Production
Time: 24-NOV-03 18:41:38
Tracing not turned on.
Tns error struct:
nr err code: 0
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 can connect using sqlplus from both XP and solaris. That means ip,
port, username, password, SID, service name, etc. are correct. Also
this means my listener and service are running fine on XP. Does the
log point to any potential problems?


You use BEQ - that's a local protocol (e.g. will only work
on the solaris box).
Do NOT set the SID in the Solaris environment (which you didn't)
and use a tns alias in the connect string.

Your script is wrong, and does a connect or something similar,
without a connect string
--
Regards, Frank van Bortel
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Rob | last post by:
I have a form - when you click the submit button, it appends a variable to the URL (e.g. xyz.cgi?inputID=some_dynamic_variable) It also opens a new page. Now, that some_dynamic_variable is...
9
by: Stefan Bauer | last post by:
Hi NG, we've got a very urgent problem... :( We are importing data with the LOAD utility. The input DATE field data is in the format DDMMYYYY (for days) and MMYYYY (for months). The target...
8
by: Mike | last post by:
Hello, I have a few rather urgent questions that I hope someone can help with (I need to figure this out prior to a meeting tomorrow.) First, a bit of background: The company I work for is...
28
by: Tamir Khason | last post by:
Follwing the struct: public struct TpSomeMsgRep { public uint SomeId;
16
by: | last post by:
Hi all, I have a website running on beta 2.0 on server 2003 web sp1 and I keep getting the following error:- Error In:...
3
by: N. Spiker | last post by:
I am attempting to receive a single TCP packet with some text ending with carriage return and line feed characters. When the text is send and the packet has the urgent flag set, the text read from...
6
by: laconicamit | last post by:
HI!, Using SQL+, when i try to connect to a server giving RAC_srv as service name. It get connected, However sometimes it throws me following error. ORA-12545: Connect failed because target...
7
by: Cirene | last post by:
I used to use the Web Deployment Project with my VS2005 projects. Now I've fully upgraded to VS2008. Do I have to download a new version of the Web Deployment Project? If so where can I find...
3
by: Deepak | last post by:
I have my Oracle 9i database running on my XP box. I can connect to it from Solaris 5.8. I am able to connect from sqlplus. But during a install, script is not able to establish connection. My...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.