📄 itms_oracle_install.html
字号:
<HTML><HEAD><TITLE> ITMS Oracle Patch Install </TITLE><META NAME="Author" CONTENT="Matt Palmerlee"><META NAME="Keywords" CONTENT="ITMS Oracle Patch INstall"><META NAME="Description" CONTENT="This page describes how to install the Oracle Database patch for ITMS"></HEAD><BODY><H3>ITMS Oracle Patch Install</H3><h4>You should have the folowing files to install the ITMS Oracle patch:</h4><UL> <LI>itms.cron</LI> <LI>add_ldap_users_to_itms.php</LI> <LI>config.php</LI> <LI>db_tools.php</LI> <LI>db_tools_oracle73.php</LI> <UL> <LI>NOTE: If you are using Oracle DB version 7.3 or lower please delete the db_tools.php file (for version 8 or higher) and rename db_tools_oracle73.php to db_tools.php</LI> </UL> <LI>group_delete.php</LI> <LI>group_edit.php*</LI> <LI>group_mgt.php*</LI> <LI>header.php*</LI> <LI>index.php*</LI> <LI>login.php*</LI> <LI>logout.php*</LI> <LI>myprefs.php*</LI> <LI>process.php*</LI> <LI>process_assign.php*</LI> <LI>process_assign2.php</Li> <LI>process_assign3.php*</LI> <LI>process_create.php*</LI> <LI>process_delete.php*</LI> <LI>process_edit.php*</LI> <LI>reminder.php*</LI> <LI>task.php*</LI> <LI>task_assign.php*</LI> <LI>task_assign2.php*</LI> <LI>task_create.php*</LI> <LI>task_delete.php*</LI> <LI>task_edit.php*</LI> <LI>task_pending_edit.php*</LI> <LI>toolbox.php*</LI> <LI>user_delete.php*</LI> <LI>user_edit.php*</LI> <LI>user_mgt.php*</LI> <LI>user_tasks_reassign.php*</LI> <LI>itms.sql*</LI></UL><h4>*Oracle has a problem with the column name: 'uid', therefore this patch includes all files in which 'user_id' has replaced all references to 'uid'. In future ITMS releases this column name will be changed and future Oracle patches will not need most of these files. </h4><br><h4>In all the above files, where ever a database column name was referenced with lower-case (i.e. $row["column_name"]) that column name was changed to upper-case (i.e. $row["COLUMN_NAME"]).</h4><br><br><h4>Instructions:</h4><UL> <LI>Download the most current full ITMS build and follow the applicable ITMS_install_guide.html instructions up to the point where it says: "Edit the config.php file" (i.e. don't install MySQL if you are going to use Oracle for your Database).</LI> <LI>If you are using Oracle Database 7.1 (and the Rename db_tools_ora.php or db_tools</LI> <LI>Copy the above files included in this patch over the corresponding files in the full build.</LI> <LI>Finish following the ITMS_install_guide.html instructions.</LI></UL><hr><H3>ITMS Oracle Patch Change Log</H3><UL> <LI>config.php</LI> <ul> <li>Added variables: $ORA_HOME_DIR and $TNS_ADMIN.</li> </ul> <LI>db_tools.php</LI> <ul> <li>Oracle PHP OCI functions have been substituted for corresponding MySQL DB functions.</li> </ul> <LI>db_tools_oracle73.php</LI> <ul> <li>PHP functions for (Oracle DB versions 7.3 and lower) have been substituted for corresponding MySQL DB functions. Overwrite the db_tools.php file with this file if you are using Oracle DB versions 7.3 and lower. Note: This file wasn't tested at the time of release of this patch.</li> </ul> <LI>toolbox.php</LI> <ul> <li>Added ENT_QUOTES parameter to htmlspecialchars function call in make_clean function.</li> </ul> <LI>itms.cron</LI> <ul> <li>All MySQL specific backup features have been removed from the itms.cron file.</li> </ul> <LI>itms.sql</LI> <ul> <li>Since Oracle doesn't support the Auto Increment feature like MySQL does, itms.sql now creates sequences and triggers for each table that used to have an autoincrement column. Also all data types were converted to Oracle datatypes.</li> </ul> </UL></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -