TNS Error installing Compiere 2.5.1b on Windows XP
[email protected] Thu, 22 Jul 2004 12:06:19 +0200
| Newsgroups | gmane.comp.compiere.user |
|---|---|
| Message-ID | <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA8Rr//Izru0i4L4CGCUVPGMKAAAAQAAAATydLYh1LKEmMv4GDSpqsIgEAAAAA@opensourcearabia.com> |
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C46FE4.4F0A7AD0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
I tried to install Compiere 2.5.1b on Windows XP.
I followed al the instructions (on the compiere website) and installed
Oracle 9i and Java 1.4.2_05.
Also the compiere user has been created and the right environment variables
have been set.
When I run the RUN_Setup.bat script I and the compiere
server setup window is displayed, after filling out the
necessary fields, I always get this error message:
ERROR TNS connection. Error connecting to database
compiere via TNS name : compiere.mycompany.com
This is the error I get:
OK: Database URL =
jdbc:oracle:thin:@T40E99NRWDX:1521:COMPIERE
JDBC = jdbc:oracle:thin:@T40E99NRWDX:1521:COMPIERE
OK: Database UserID = compiere/compiere
OK: Database UserID = compiere/compiere
TNS = jdbc:oracle:oci8:@COMPIERE.MYCOMPANY.COM
Check setup of Oracle Server / Oracle Client /
LD_LIBRARY_PATH
java.lang.UnsatisfiedLinkError: make_c_state
I can connect fine from the command line with:
sqlplus compiere/compiere@compiere
databasename: compiere
domain: mycompany.com
I can even tnsping compiere from a command line.
and the test script RUN_Env.bat does not complain when
testing the TNS.
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
(HOST = T40E99NRWDX)(PORT = 1521))) (CONNECT_DATA =
(SERVICE_NAME = compiere.mycompany.
com)))
OK (10 msec)
I would appreciate all the help I can get!
Thanks.
Niko Tambuyser
------=_NextPart_000_0000_01C46FE4.4F0A7AD0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 7 4 9 2 2 5 2 4 4;}
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:Courier;
color:black;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hi,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I tried to install Compiere 2.5.1b on Windows =
XP.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I followed al the instructions (on the compiere =
website) and
installed Oracle 9i and Java 1.4.2_05.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Also the compiere user has been created and the right
environment variables have been set.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>When I run the RUN_Setup.bat script I and the =
compiere <br>
server setup window is displayed, after filling out the <br>
necessary fields, I always get this error message:<br>
<br>
ERROR TNS connection. Error connecting to database <br>
compiere via TNS name : =
compiere.mycompany.com<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<pre><font size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>This is the error I =
get:<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>OK: Database URL =3D =
<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>jdbc:oracle:thin:@T40E99NRWDX:1521:COMPIERE<o:=
p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'> JDBC =3D =
jdbc:oracle:thin:@T40E99NRWDX:1521:COMPIERE<o:p></o:p></span></font></pre=
><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>OK: Database UserID =3D =
compiere/compiere<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>OK: Database UserID =3D =
compiere/compiere<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'> TNS =3D =
jdbc:oracle:oci8:@COMPIERE.MYCOMPANY.COM<o:p></o:p></span></font></pre><p=
re><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>Check setup of Oracle Server / Oracle Client =
/ <o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>LD_LIBRARY_PATH<o:p></o:p></span></font></pre>=
<pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>java.lang.UnsatisfiedLinkError: =
make_c_state<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><fon=
t
size=3D2 color=3Dblack face=3DCourier><span style=3D'font-size:10.0pt'>I =
can connect fine from the command line =
with:<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>sqlplus =
compiere/compiere@compiere<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><fon=
t
size=3D2 color=3Dblack face=3DVerdana><span =
style=3D'font-size:10.0pt;font-family:Verdana'>databasename: =
compiere<br>
domain: mycompany.com<br>
<br>
I can even tnsping compiere from a command =
line.</span></font><o:p></o:p></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><fon=
t
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>and the test script RUN_Env.bat does not =
complain when <o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>testing the =
TNS.<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><fon=
t
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>Used TNSNAMES adapter to resolve the =
alias<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>Attempting to contact (DESCRIPTION =3D =
(ADDRESS_LIST =3D <o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>(ADDRESS =3D (PROTOCOL =3D =
TCP)<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>(HOST =3D T40E99NRWDX)(PORT =3D 1521))) =
(CONNECT_DATA =3D <o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>(SERVICE_NAME =3D =
compiere.mycompany.<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>com)))<o:p></o:p></span></font></pre><pre><fon=
t
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>OK (10 =
msec)<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><fon=
t
size=3D2 color=3Dblack face=3DCourier><span style=3D'font-size:10.0pt'>I =
would appreciate all the help I can =
get!<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>Thanks.<o:p></o:p></span></font></pre><pre><fo=
nt
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><fon=
t
size=3D2 color=3Dblack face=3DCourier><span =
style=3D'font-size:10.0pt'>Niko Tambuyser<o:p></o:p></span></font></pre>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------=_NextPart_000_0000_01C46FE4.4F0A7AD0--
-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click