note 11133 deleted from function.ociplogon by sixd

Note Submitter: steve at stevedix dot de ---- IF you're wondering exactly what you are dealing with, here's a brief explanation: Oracle is NOT like mysql, which makes it very easy to connect between databases. Oracle uses a product called sql*net to control connection between remote machines, clients and databases. It is capable of operating on multiple different network protocols, and requires listeners to be configured for the network protocol you plan to use (usually tcp). This system has its own domain name system which rationalises database names with machines (which is why you don't have a host variable in the OCIPlogin). Configuring these listeners is not easy and requires the editing of two files tnsnames.ora and sqlnet.ora. Even more important is to make sure that the oracle environment variable TNS_ADMIN points to the place where you put tnsnames.ora and sqlnet.ora A good place to start reading about this is http://www.atr.net/faq/software/FRONT_END/faqnet.htm A more detailed version can be found at : http://www.orafaq.net/faqnet.htm Bear in mind that this is an incredibly complex product and not something that you should really be playing with if you don't know what you're doing. I've seen (otherwise) experienced oracle admins baulk at configuring sql*net. Pat solutions (like the one above) cannot be used verbatim - you will need to know and substitute several symbolic names. HTH