You can specify a connection string for database targets in two ways: fill in the blanks and let OEM create the connection string (my preference) or paste a Preferred Connect String on the bottom of the page.
Our default setting in our shop is to use multi-threaded servers. On the rare occasion when we need to change if, we paste the connect string from tnsnames.ora in place and add the SERVER=DEDICATED parameter.
Some things to keep in mind:
- The Preferred Connect String takes precedence over strings OEM might generate from the individual entries
- The string should start with “DESCRIPTION=”
- Keep those darn () straight. The easiest way to do that is to paste the string into an editor that supports syntax highlighting