On-premise SamePage connecting to Oracle RAC [Knowledgebase]

Information for users using screen reader software to work with eTouch SamePage. To repeat this information, press ALT+R key.

eTouch SamePage supports Internet Explorer 6 and Mozilla Firefox 1.5 and above on Windows 2000 and Windows XP Platforms. You need to enable Javascript, CSS and Images to work with eTouch SamePage. eTouch SamePage supports several global accesskeys to support keyboard navigation. These keys are

ALT+J = begincontent
ALT+H = Help
ALT+C = crumb
ALT+M = Text Menu
ALT+N = Graphical Menu
ALT+S = Search field
ALT+X = Focus on Editor Toolbar
ALT+Z = Focus on Editor Content
ALT+I = Sign In
ALT+O = Sign Out
ALT+U = username (to sign in)
ALT+P = password (to sign in)
ALT+0 = Page Hierarchy
ALT+1 = Open View of a page
ALT+2 = Edit a page
ALT+3 = Open Discussion view of a page
ALT+4 = Open History view of a page


	Support Home Downloads FAQ Training Knowledgebase Discussion Forum

Welcome guest

Advanced Search

Help

Projects > Knowledgebase > Support > On-premise SamePage connecting to Oracle RAC

View

Discussion

Edit

Attachments


On-premise SamePage connecting to Oracle RAC

The SamePage installer by default expects the normal JDBC connection string to connect to Oracle database. This looks something like this: jdbc:oracle:thin:@servername:1521:SID

However, if you plan to use Oracle RAC (Real Application Cluster) , the normal connection string will not work. It needs a connection string that looks like this:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1512))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1512))
(ADDRESS=(PROTOCOL=TCP))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=servicename))
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES = 180)(DELAY=5))))

You need to do the following during installation of SamePage (for Linux) to connect to a Oracle RAC.

Download the samepage.zip installable and unzip it as usual. But do not start the install.
Download the attached ojdbc14.jar and copy it under the Setup lib folder within the exploded zip. Delete the existing driver jars - classes12.jar and classes12.jar.8i
Start the installation. Remember to specify the full connection string when the installer prompts for DB connection URL.

Tags : Configuration, Database, Oracle

Short Link: http://support.etouch.net/cm/wiki/?id=35027

1 Attachments

Contact