ODBC connection from Unix to Windows

[cadbilbao]

Hi!

I've got installed Oracle 8.0.5 on a Unix machine (HP-UX 10.20),
and an application running on Oracle.

This application has its own database, with its own ORACLE_SID: XXX,
and I can connect it via 'sqlplus' or 'server manager'.

I would like to connect this database via ODBC from my Windows PC, and
I've got some questions:

+) In wich way must I modify 'listener.ora' and 'tnsnames.ora'?

+) How can I start/stop 'listener' on Unix?

+) On Windows, wich parameters must I set?

Regards,

 

[THoey]

I don't think you need to modify the Listener on the Unix side, you just need to make sure it is running. After that, Make sure there is an entry for the database in the tnsnames.ora file on the Windows side. You will also need to create an entry in your Windows side ODBC connections under Control Panel. That should make Windows able to SQL*Plus into the database.

As far as starting/stopping the Listener, I think the command is lstnrctl stop or lstnrctl start. If it isn't that, it is something really close...

Hope that helps. Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[kindus]

It is lsnrctl start/stop. Before starting you check the status with lsnrctl stat.