In this tutorial, you have learned about the Oracle database link concept and how to use the Oracle CREATE DATABASE LINK to create a new database link to a remote Oracle Database server. Use a service-specific entry in the tnsnames.ora instead of the database-specific alias so that you copy between product, test, and development environments, you don’t have to recreate the database link.
If you don’t follow this, the database will not work when someone changes the password of the user or even delete it. In addition, you should not give this user to anyone else. Remote database users: you should create a user dedicated for a database link.For example, instead of naming a database link SALES_PRD, you name it as SALES. Naming convention: the name of the database links should reflect the nature of data, not the database server.Here are some best practices using the database links: The result set is as follows: Oracle Database Link best practices sample extension.SELECT * FROM language: SQL (Structured Query Language) ( sql ) # Oracle database Ensure that these database connection properties aren’t commented out. Set and uncomment the database connection properties as shown below: db.name=alfrescoĭb.host=. For example: dir.root=C:/Alfresco/alf_data Open the / file.Įdit the following line with an absolute path to point to the directory in which you want to store Content Services data. In the SQL*Plus Console, run these commands: alter system set processes=275 scope=spfile sid='*' Īlter system set sessions=305 scope=spfile sid='*' Īlter system set transactions=330 scope=spfile sid='*'
Install the Oracle database connector to allow the database to talk to the server.ĭownload ojdbc7.jar from the Oracle download site.Ĭopy the JAR file into the /lib directory.įor example, for Tomcat, copy the JAR file into the /lib directory. Install Content Services using one of the options provided. The Oracle database is case sensitive, so any configuration setting that you add into the file must match the case used in Oracle.
Check the Supported platforms page for the correct driver.Ĭopy the JDBC driver into the /lib directory. This release requires mysql-connector-java-5.x.x.jar for compatibility with the SQL Server database. Install Content Serviceson your Amazon EC2 instance. For RHEL5, the user name is either root or ec2-user.For Amazon Linux, the user name is ec2-user.Use the ssh command to connect to the Amazon EC2 instance using a provided.
Note: Aurora support is only available when running in Amazon Web Services (AWS). By default, the first port in the range is assigned to the component, if it is available. This table lists the port numbers and protocols configured for Oracle Database components during a single-instance installation.