Install Oracle - Revision history

Vmurrell at 12:05, 30 March 2024

2024-03-30T12:05:19Z

Vmurrell at 12:12, 23 March 2024

2024-03-23T12:12:41Z

Plazarou at 15:21, 13 October 2022

2022-10-13T15:21:29Z

Plazarou: /* Driver Installation */

2022-10-13T15:10:31Z

‎Driver Installation

Plazarou: /* Connection Details */

2022-10-13T15:10:18Z

‎Connection Details

Plazarou: /* Driver Installation */

2022-10-13T15:09:07Z

‎Driver Installation

Plazarou: /* Driver Installation */

2022-10-13T15:09:02Z

‎Driver Installation

Plazarou: /* Obtaining and Specifying the Oracle JDBC Driver */

2022-10-13T15:08:34Z

‎Obtaining and Specifying the Oracle JDBC Driver

Plazarou: /* Connection Details */

2022-10-13T15:08:16Z

‎Connection Details

Plazarou: /* Driver Installation */

2022-10-13T15:06:30Z

‎Driver Installation

@@ Line 1: / Line 1: @@
-[[Category:Draft_-_Installation_and_Configuration]]
+[[Category:Installation_and_Configuration]]
 [[Category:How_To]]
 [[Category:How_To V11]]

← Older revision		Revision as of 12:12, 23 March 2024
Line 1:		Line 1:
		+	[[Category:Draft_-_Installation_and_Configuration]]
		+
	[[Category:How_To]]		[[Category:How_To]]
	[[Category:How_To V11]]		[[Category:How_To V11]]

@@ Line 5: / Line 5: @@
 = Obtaining and Specifying the Oracle JDBC Driver =
 To get FMR to communicate succesfully with an Oracle database, there are three tasks to perform:
 # Obtain the correct dependency file

@@ Line 26: / Line 26: @@
 For example:
-   CLASSPATH=/home/oracle/jdbc/ojdbc8.jar<br>
+   CLASSPATH=/home/oracle/jdbc/ojdbc8.jar
 where /home/oracle/jdbc is the directory containing the ‘ojdbc8.jar’ file.

@@ Line 32: / Line 32: @@
 FMR requires a database to be specified on the first page of the Install Wizard.  This can be changed at a later from the Administrator "Database Settings" page.
-Oracle by default uses port 1521. If you wish to make a custom connection to Oracle, the information you will likely need is:
+Oracle by default uses port 1521.
 {| class="wikitable" style="vertical-align:top; text-align:left;"

@@ Line 25: / Line 25: @@
 The recommended option is to add the filesystem location of the ‘ojdbc8.jar’ to the CLASSPATH of the application server. If using Apache Tomcat, this can be done by setting the CLASSPATH environment in the Tomcat ~/bin/setenv.sh script. <br>
-For example:<br>
+For example:
-CLASSPATH=/home/oracle/jdbc/ojdbc8.jar<br>
+where /home/oracle/jdbc is the directory containing the ‘ojdbc8.jar’ file.
 = Connection Details =

@@ Line 10: / Line 10: @@
 # Supply this to your Java Web Server (e.g. Tomcat) that you are using to run FMR.
 # Specify the appropriate Credentials to FMR.
 ==Obtaining the Oracle Connector Dependency==

@@ Line 35: / Line 35: @@
 FMR requires a database to be specified on the first page of the Install Wizard.  This can be changed at a later from the Administrator "Database Settings" page.
-Oracle by default uses port 1521.  If you wish to make a custom connection to Oracle, the information you will likely need is:
+Oracle by default uses port 1521. If you wish to make a custom connection to Oracle, the information you will likely need is:
 {| class="wikitable" style="vertical-align:top; text-align:left;"
 ! Connection String
 || Of the form:
-jdbc:sqlserver://<server url>:<server port>;databaseName=<your database>
+jdbc:oracle:thin:@server url>:<server port>/<oracle schema>
 <br/>
-e.g. jdbc:sqlserver://localhost:1433;databaseName=fusion_registry
+e.g. jdbc:oracle:thin:@localhost:1521/orcl12c
 |-
 ! Dialect
-|| org.hibernate.dialect.SQLServerDialect
+|| org.hibernate.dialect.Oracle10gDialect
 |-
 ! Class Name
-|| com.microsoft.sqlserver.jdbc.SQLServerDriver
+|| oracle.jdbc.driver.OracleDriver
 |}
-Here are some examples of a database custom string working correctly:
+  jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl12c)))
-Conenction String:
+  jdbc:oracle:thin:@ (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE=off) (FAILOVER = ON) (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) )  (CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=orcl12c) ) )

← Older revision		Revision as of 15:06, 13 October 2022
Line 31:		Line 31:

	..where /home/oracle/jdbc is the directory containing the ‘ojdbc8.jar’ file.<br>		..where /home/oracle/jdbc is the directory containing the ‘ojdbc8.jar’ file.<br>
		+
		+	= Connection Details =
		+	FMR requires a database to be specified on the first page of the Install Wizard. This can be changed at a later from the Administrator "Database Settings" page.
		+
		+	Oracle by default uses port 1521. If you wish to make a custom connection to Oracle, the information you will likely need is:
		+
		+	{\| class="wikitable" style="vertical-align:top; text-align:left;"
		+	! Connection String
		+	\|\| Of the form:
		+	jdbc:sqlserver://<server url>:<server port>;databaseName=<your database>
		+	<br/>
		+	e.g. jdbc:sqlserver://localhost:1433;databaseName=fusion_registry
		+	\|-
		+	! Dialect
		+	\|\| org.hibernate.dialect.SQLServerDialect
		+	\|-
		+	! Class Name
		+	\|\| com.microsoft.sqlserver.jdbc.SQLServerDriver
		+	\|}
		+
		+
		+	Here are some examples of a database custom string working correctly:
		+
		+	Conenction String:
		+
		+	jdbc:oracle:thin:@localhost:1521/orcl12c
		+
		+	jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl12c)))
		+	jdbc:oracle:thin:@ (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE=off) (FAILOVER = ON) (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) ) (CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=orcl12c) ) )
		+
		+	Dialect: org.hibernate.dialect.Oracle10gDialect
		+	Class Name: oracle.jdbc.driver.OracleDriver
		+
		+	1)
		+	jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl12c)))
		+	2)
		+	jdbc:oracle:thin:@
		+	(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE=off) (FAILOVER = ON) (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) )
		+	(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=orcl12c) ) )