https://www.staffordnet.uk/ 2026-04-05T18:24:31+00:00 https://www.staffordnet.uk/ https://www.staffordnet.uk/lib/exe/fetch.php?media=favicon.ico text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:install_apex_ssl&rev=1669207782&do=diff Install APEX SSL Follow the process described in Enabling SSL for Oracle HTTP Server. Locations of the appropriate Oracle components can be determined by using Oracle Universal Installer. In particular ensure: * the correct instance of Oracle Application Server (containing Oracle HTTP Server) is used text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:install_apex_upgrade&rev=1669207782&do=diff Install APEX Upgrade This page shows how to upgrade an instance of Oracle APEX on a CentOS server. Prerequisites You must have a server with APEX installed. This guide assumes that you are running APEX on a Glassfish Web Application Server. Upgrade APEX text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:install_apex_without_glassfish&rev=1669207782&do=diff Install APEX Without Glassfish This page details how to install APEX 4.2.6 (Oracle Application Express) on a CentOS 6 x64Server running Oracle Database 11gR2. These instructions are a modified version those contained in two videos posted by Przemysław Mazur on YouTube. text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:install_apex_with_glassfish&rev=1669207782&do=diff Install APEX with Glassfish on Linux This page details how to install APEX 4.2.2 (Oracle Application Express) on a Linux Server running Oracle Database 11gR2. In this guide, we use the open source version of Oracle's Glassfish application server. Prerequisites text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:install_mysql&rev=1669207782&do=diff Install MySQL This page shows how to install MySQL on CentOS 6 64bit. Prerequisites You must have a CentOS machine already set up in accordance with the the Install CentOS 6 guide. Install MySQL Install the MySQL server. Run all the following commands as root. text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:install_oracle_11gr2&rev=1669207782&do=diff Install Oracle 11gR2 This page shows how to install 64bit Oracle 11gR2 SP3 on CentOS 6 64bit. Prerequisites You must have a CentOS machine already set up in accordance with the Install CentOS 6 guide. It is assumed that the system has a blank 80G+ disk attached to it at /dev/sdc. text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:install_postgresql&rev=1669207782&do=diff Install Postgresql This page shows how to install Postgresql on on CentOS 6 64bit. Prerequisites You must have a CentOS machine already set up in accordance with the the Install CentOS 6 guide. Install Postgresql Run the following as root yum install postgresql postgresql-server chkconfig postgresql on service postgresql initidb service postgresql start text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:mysql_cheat_sheet&rev=1669207782&do=diff MySQL Cheat Sheet Clear Screen On Linux CTRL+L General Database Connect to MySQL mysql -uUSERNAME -p -h hostname -P 3306 Assuming that you are connecting to the localhost and that MySQL is running on the default port of 3306, you can use a shorter command text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:odbc&rev=1669207782&do=diff ODBC ODBC Location The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 Automate ODBC Setup ODBC entries are just registry keys. You can automate the setup of ODBC entries with registry files. This section assumes * You are setting up ODBC on a x64 bit Windows 7 machine. * You are logged into the machine as a domain administrator. * You have already installe… text/html 2022-11-23T12:49:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.staffordnet.uk/doku.php?id=databases:useful_oracle&rev=1669207782&do=diff Useful Oracle Commands This page contains a bunch of useful tips for using Oracle. Change Hostname and IP For this example, we assume the database is up and running and that it has full network connectivity. In other words, before starting this process, you should be able to access the EM console on the database server from your workstation (