Hi Maciej,
yes, it works!!
1. We have installed on Oracle Client Installation in RUNTIME mode
2. created tnsnames.ora file like this:
# tnsnames.ora Network Configuration File:
C:\oracle\product\10.2.0\client\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = your host)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
3. set environments variables:
setenv TNS_ADMIN /app/oracle/product/10.2.0/client_1/network/admin/
setenv ORACLE_HOME /app/oracle/product/10.2.0/client_1/
Many thanks for your Help and kind regards,
Anna
-----Ursprüngliche Nachricht-----
Von: Maciej Sobczak [mailto:[email protected]]
Gesendet: Sonntag, 19. April 2009 21:48
An: General-purpose list for SOCI users.
Betreff: Re: [SOCI-users] configure ip host for soci connection to oracle
Hello,
Pitaev, Anna wrote:
> The only thing I don't yet understand:
>
> The oracle local configuration (tnsnames.ora) is installed on my oracle
> machine and my c++ client application as well soci installation on the
> client side.
I do not fully understand the above. Does it mean that the file
tnsnames.ora does not exist on the client side?
It should be somewhere there, because this file defines the physical
connection parameters for each known service.
Please note that the Oracle Client installation does not only provide
the client-side libraries (the ones which are also required by SOCI),
but also a set of useful programs - the most important is sqlplus.
This program allows to do a lot of thing with the database (real admins
can do everything with this program alone) and in particular to check
whether everything is installed properly.
For example, if you plan to use the following SOCI properties:
service=orcl user=scott password=tiger
then you should be able to start the sqlplus program like this:
sqlplus sc...@orcl
(and then provide the password when asked for it)
After connecting, you should be able execute SQL command directly in the
command line, please try it.
There is also a tnsping command, please try it at the client side like this:
tnsping orcl
(where mydatabase is the service name you are interested in)
The interesting thing about sqlplus is that it will either work or fail
together with SOCI (usually for the same reason), so if you cannot use
sqlplus, you will not be able to use SOCI either. This also means that
you can ask your local Oracle admin for help even if he is not aware of
SOCI.
BTW - please note that orcl, scott and tiger are settings which are used
in Oracle tutorials and in some default and example installations. They
might not be appropriate in your case - this depends on how the database
was installed.
Please let us know if you managed to get it working, it might be a
useful case for others.
Regards,
--
Maciej Sobczak * www.msobczak.com * www.inspirel.com
------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
Please help Logica to respect the environment by not printing this email /
Pour contribuer comme Logica au respect de l'environnement, merci de ne pas
imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen Sie
so Logica dabei die Umwelt zu schuetzen / Por favor ajude a Logica a
respeitar o ambiente nao imprimindo este correio electronico.
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.
------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
