Tags

, , , ,

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.

dedicatedserver_connectstring01

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