Connection manager

Hi
Do i need to congifgure the MTS and a seperate server in order to use the connection manager.

UKDBA

You don't NEED to run connection manager on a seperate server. However, the benefits of connection multiplexing and pooling wouldn't make much sense if they were on the same box.

MTS is needed to take advantage of Multiplexing and Pooling. However, If you just want a connetion gateway with dedicated servers, connection manager will work.

At the moment i am testing it on NT and database server and connection manager are both on the same machine. what port i should use for cman and database for NT.

In my cman.ora i have these parameters

CMAN = (ADDRESS_LIST=
(ADDRESS=
(SERVICES=CMAN)
(PROTOCOL=tcp)
(HOST=10.1.39.2)(PORT=1630)
)
)

cman_admin = (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.39.2)(PORT=1650))

cman_profile = (parameter_list=
(MAXIMUM_RELAYS=1024)
(LOG_LEVEL=1)
(TRACING=no)
(RELAY_STATISTICS=yes)
(SHOW_TNS_INFO=yes)
(USE_ASYNC_CALL=yes)
(AUTHENTICATION_LEVEL=0)
(REMOTE_ADMIN=FALSE)
)





But when i typed cmctl start cm i received this error message
TNS-04039: CMCTL: error while spawning a process

and when i typed cmctl start admin i received the following message
TNS-04018: CMCTL: missing Connection Manager name, admin_admin, in cman.ora


I have also set the USE_CMAN in sqlnet.ora of client and also add (source_route=on) in tnsnames.ora of server.

i have never used it before to i am naive about this . can someone help me on this problem.
Thanks
UKDBA

I really need help on this topic.
UKDBA

I really need help from moderator on this topic .
UKDBA

Your setup looks OK.

The error you are receiving points to OS resources as being the problem.

I setup CMAN by using:
http://metalink.oracle.com/metalink/...p_id=1030314.6

Thanks Jeff
But i could not acces that file on metalink.Could you please email me on

[email protected]
I will appreciate asap
UKDBA

It looks like Oracle has dropped this document. I will search for something similar...

I have found some documents on metalink but didn't help me so if you have a copy of that document then it will be more beneficial as you have used it before.
Thnaks
UKDBA

Ah, here we go...
http://metalink.oracle.com/metalink/...p_id=2077721.6

Thankyou very much for the documentation and it helped a lot. Now i manage to restrict the user to connect to the database and now i am working to allow specific user to connect to the database but i am getting the same message when i restrict it even though permission is given to him.

If anyone know that what could be the possible mistake i am doing.

Thanks
UKDBA

I am bit confuse now because i followed all the documentation and finally the cman and cmanadmin starts running .i added the rules for cman and allow one ip address which means only that ip address can talk to the connection manager but what is happening is that i found no effect of the ip address rejection and acceptance parameter in the cman_rules. but if i remove the source_route parameter from the client then it allows the client to connect to the database and when i add this parameter then it refuses the connection.
According to my understanding that when i use the source_route then client connection should first connect to the cman and then connection manager direct it to connect to the database.but this is not happening because if i reject or accept in rule then still it is not connectiong to the database.

can moderator help me on this issue.
I also used the metalink but the are also not responding on it promptly.
UKDBA

Quote:

---

Originally posted by UKDBA
but if i remove the source_route parameter from the client then it allows the client to connect to the database

---

I'm guessing that you are conneting to the database, but not via connection manager.

Quote:

---

According to my understanding that when i use the source_route then client connection should first connect to the cman and then connection manager direct it to connect to the database.

---

Yes, this is correct. See http://technet.oracle.com/docs/produ...ams.htm#454077 for confirmation.

Thank you jeff for all your help. It is working fine the way i want for the moment.But without your help it seems impossible. i tried oracle support but you are much better than them.
Cheers

UKDBA