in reply to Re: TNSNAMES.ORA and Recdescent
in thread TNSNAMES.ORA and Recdescent
Sorry, didn't realize the ambiguity in my question. What I am trying to do is check the syntax of tnsnames.ora entries. This file contains information about how to connect to an oracle database.
The code: AddressTCP : Community(?) ProtocolTCP Host Port defines the particular order which the entry must follow for it to match. BUT that is not the action I am trying to achieve. The entry could come in any order so I would need to include the following to match every possible order.
AddressTCP : Community(?) ProtocolTCP Host Port AddressTCP : Community(?) ProtocolTCP Port Host AddressTCP : Community(?) Host ProtocolTCP Port AddressTCP : Community(?) Port ProtocolTCP Host AddressTCP : Community(?) Host ProtocolTCP Port AddressTCP : Community(?) Host Port ProtocolTCP AddressTCP : Community(?) Port Host ProtocolTCP .... Would include every combination of each of these four fields.
I picked AddressTCP as an example for the question but most of the fields on the parser could have this problem. All of a sudden this problem becomes unmanagle.Thanks for the help so far.
Here is a sample TNSNAMES.ORA entry
PRDSAP01 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mercury.empire.com)(PORT = 15 +21)) ) (CONNECT_DATA = (SERVICE_NAME = PRDSAP01) ) )
|
|---|