Vtiger CRM - Oracle Database Support
From vtiger.com
[edit] Installation Prerequisites
- Install Oracle Client in the machine in which vtiger CRM to be installed
- Create Oracle SID for vtiger CRM
- Modify the php.ini file to load the Oracle related PHP libraries
extension=php_oci8.dll extension=php_oracle.dll
[edit] Installation Procedure
1. Install vtigerCRM_4_0_1_Source.zip in Apache document root
2. Modify the following lines in <vtiger CRM Home>/connection.php and save the file.
$mysql_username = '<oracle_username>'; $mysql_password = '<oracle_password>'; $mysql_port = '<oracle_port>';
Where,
<oracle_username> is user name in Oracle <oracle_password> is password for the user name in Oracle <oracle_port> is port at which oracle runs. Default port is 1521
3. Modify the following lines in <vitger_dir>/apache/htdocs/vtigerCRM/config.php and save the file.
$dbconfig['db_host_name'] = '<oracle_host>:<oracle_port>'; $dbconfig['db_user_name'] = '<oracle_username>'; $dbconfig['db_password'] = '<oracle_password>'; $dbconfig['db_name'] = '<oracle_sid>'; $dbconfig['db_type'] = 'oci8'; $host_name = '<oracle_host>:<oracle_port>';
Where,
<oracle_sid> is the SID of oracle <oracle_host> is the HostName/IP of the machine in which Oracle is installed <oracle_port> is the port in which oracle runs. Default port is 1521
4. Modify the following lines in <vitger_dir>/apache/htdocs/vtigerCRM/install/2setConfig.php and save the file.
change [line no 102]
$db_name = '<oracle_sid>';
Where,
<oracle_sid> is the SID of oracle
5. Modify the following lines in <vitger_dir>/apache/htdocs/vtigerCRM/install/4createConfigFile.php and save the file.
change [ line no 235]
$config .= "\$dbconfig['db_type'] = 'mysql';\n\n";
to
$config .= "\$dbconfig['db_type'] = 'oci8';\n\n";
6. Now start the vtigerCRM installation script, i.e., <vtiger CRM Home>/install.php in Web browser.