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? 3 20682
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
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!)
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
by: Tamir Khason |
last post by:
Follwing the struct:
public struct TpSomeMsgRep
{
public uint SomeId;
|
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:...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |