Oracle 10 In Windows Xp Prof - How To Connect The

[DAMIAN 0]

I've installed ORACLE 10 in a WINDOWS XP PROFESSIONAL as Server. Everything is working OK and my Delphi ERP system is connecting perfectly using the service name by Oracle and BORLAND BDE.But the clients in my network are having difficults to connect. I already install Oracle in other WINDOWS XP computer (parts of it, because I couldn't find the Client option during installation) but I can't CONNECT to the server, gives the message: "ORA-12170: TNS:Connect timeout occurred"Below is the TNSNAMES.ORA from the server. How to configure the client in the program NET CONFIGURATION ASSISTANT???Thanks,DamianVitoria(ES) - Brazil-----# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\tnsnam es.ora# Generated by Oracle configuration tools.ORCL2_CREA.RM.COM.BR =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = GATEWAY.orsa.com.br)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ORCL2_CR.RM.COM.BR)))

[alphamek 2]

Hello Damian,

 

To improve the connection of your Oracle Database with your application, its is better you to configure following files:

 

1 - sqlnet.ora

2 - tnsnames.ora

 

Both, they are inside folder $ORACLE_HOME\network\admin

 

Its makes steps:

 

1º) Inside your tnsnames.ora, to use always the name your SID, not global name. Sample:

 

YOUR_INSTANCE =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST =IP_MACHINE)(PORT = 1522))    )    (CONNECT_DATA =      (SID = Your_Instance)    )  )

Before, to configure your sqlnet.ora

 

AUTOMATIC_IPC = OFF TRACE_LEVEL_CLIENT = OFF NAMES.DEFAULT_DOMAIN = world NAME.DEFAULT_ZONE = world NAMES.DIRECTORY_PATH= (TNSNAMES)

Now, your database it is deciding by TNSNAMES service. For see results, execute following command in DOS, LINUX or UNIX:

 

tnsping YOUR_INSTANCE

Case, you've reply of service, your network it is OK! Else, you've problems.

 

More doubts, its answers here.

 

Regards,

 

http://forum.imasters.com.br/public/style_emoticons/default/clap.gif