Connect the Pathfinder database to Oracle
- Abir Haque
- Vanina Soprano
If you use an Oracle database server and would like to store the Pathfinder database in there, you have to create a database connection in Pathfinder.
If you have Pathfinder open, please save your work and close the program.
STEP 1:
Press and hold the F8 key while starting Pathfinder. The dialog for managing the Pathfinder databases opens.
STEP 2:
Click on to create a new database connection.
STEP 3:
Enter the database name using the following syntax:
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = tcp)
(HOST = <servername>)
(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = <service>)))
Please replace square brackets. For example '<servername>' and '<service>' → 'oracleservername' and 'oracleservicename'.
Port 1521 is used by default by Oracle databases. If you changed the port when installing the database server, please adjust it here accordingly.
STEP 4:
Enter your login information ( login + password ) with which the database can be accessed (write).