I posted a query about CMAN a few weeks ago,and I'm still puzzled as to what to put where in the various .ora files.
I am trying to configure a server running W2K x64 and Oracle 10g which will be used by a group of developers, some inhouse and some remote. I want to control the access for the remote developers to the databases running on this machine (hostname <server> for the purposes of this post) via CMAN, which is installed to listen on port 1522 and seems to be working ok. I can start it via CMCTL for example, and telnet in through our firewall to 1522, and get a response. If I shutdown CMAN via CMCTL, then the telnet attempt fails with no connection. I used the example cman.ora as a template for mine, and I believe it has been set up correctly although at present I am not using it to restrict connections - I need to get connections working first.
I have been re-reading the Oracle docs for configuring tnsnames.ora in association with CMAN, and they still confuse me, as the example snippets do not refer to a consistent situation, they simply seem to choose service and host names afresh for each example. It is also not at all clear on which machine (server or client) I am supposed to be making the changes!
My two questions are: If I have a database named <db> running on a server named <server> which also has CMAN running on it listening on port 1522, (1) what do I need in tnsnames.ora on the server and (2) in tnsnames.ora on a client PC in order to ensure that I can connect from the PC to the server via Connection Manager? For information (in case you need it), the tnsnames.ora on my server currently contains an entry for the CMAN listener as shown below:
# Connection Manager listener
The name cman_<server> is the same as that used to define the CMAN instance in cman.ora.
Again, in case it's important to consider, when I installed Oracle it configured the default listener on 1521 and this is currently running. Assuming port 1521 is open, I can therefore happily connect to a database <db> directly using an entry like
(ADDRESS = (PROTOCOL = TCP)(HOST = <server>)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = <db>)
I just need two snippets that I can drop the appropriate host name and database name into - and I will be eternally grateful to anyone who can supply them!