- . Oracle client on Debian Linux. 487278 Feb 1, 2006 1:41 PM (in response to 477243) Hi Can you tell me where did you get the oracle client installation? I'm looking for the 9i release. Thanks. Like Show 0.
- 9 Installing Oracle Database Client. After configuring the oracle user's environment, start Oracle Universal Installer and install Oracle Database as follows: To start Oracle Universal Installer, enter the following command.
Data. Base/Oracle - Debian Wiki. Translation(s): English - Português# Oracle XE Debian repository.
Please, keep in mind that I'm no Oracle specialist, this is a minimalist guideline to try help people during this process (hopefully with less pain). I documented the steps and made different comments and references with regards to what I found on the Internet. There are probably different (and better) ways to install and deploy Oracle and I'll be more than happy to add such info (or to see somebody else do it).
The main goal is to make a tutorial more Debian way. I really hope this helps. Preparations. One of the hard things if you're a first time adventurer in Oracle (or if there's a long time since of you last mess with it), is to know how the system works in terms of partitions and file system space. Both 1. 0g and 1. At least 1. 5. Gi. B of space for the zip files containing the database, installer and documentation, I put those in /srv/oracle At least 1.
. user with the proper xauth permissions, just run the installer. As you are installing on Debian and it is not certified by Oracle. ~$. /usr/local/bin/oraenv oracle@debian-sid:~$ dbstart $ORACLE_HOME. Start Oracle on. Installing PHP and the Oracle Instant Client for Linux and Windows For PHP 5.4 and Oracle Database 11g Release 2. By Christopher Jones. Updated April 2012. . While installing Oracle you sometimes may stumble upon compilation errors. Even though those are not fatal it may mean tools such as dbca. Installing Oracle11 and Oracle12 on Debian Wheezy, Squeeze. Posted by. Oracle Instant Client enables development and production deployment of Oracle Database applications. It is used for popular languages and environments including Node.js, Python and PHP, as well as providing. Installing. The.
Gi. B of space for the installed binaries and resources, that should appear under /opt. Some free space for the databases, they usually go under /u. Oracle documentation says you can choose whatever letter you want and a fixed width number, it could be /z. Regarding swap space, for some bizarre reason Oracle 1. Gi. B and Oracle 1.
Gi. B. I did one installation with less, but our team decided to reinstall it with the requested amount. Although there is a graphical installer you don't need to install X Window System on the server. You can use X1. 1Forwarding or use the Oracle Silent Install. First, I'm documenting graphical install via SSH (using X1. Creating users and groups.
Personally, I decided to create system users and groups because they take care of a service (Oracle database and family of applications). You'll find several articles creating regular groups and users, this should be equivalent just with a different point of view in terms of organization and philosophy. Oracle requirements (sysctl and security limits)sysctl.
Usually you'll find articles recommending you edit /etc/sysctl. I would recommend you to create a file /etc/sysctl. Oracle recommends total machine Ram - 1 byte).
I didn't find recommendations of vm in the Oracle docs, but several articles spoke about it and the installer failed without it. The value for vm. To load the sysctl configuration you can run sysctl or reboot the machine # sysctl - p /etc/sysctl. Edit /etc/security/limits. Those are not magical numbers, I took them from the Oracle® Database Quick Installation Guide. Usually, on a regular Debian 6 installation, you just have to enable pam_limits. Nasty hacks. Yes, it's required, believe me, I tried to install without it.
Do not remove this symbolic link after installation as several commonly used utilities require it. Oracle RPM packages in multiarch systems. Directory Structure. Create a directory structure required to install Oracle Data.
Base. # mkdir - p /opt/oracle/product/1. Inventory. # chown - R oracle: dba /opt/oracle/. R oracle: dba /opt/ora. Inventory. Oracle on Debian (amd. Initial steps. We need to install some packages. Oracle 1. 0g on Debian Squeeze: aptitude install build- essential gcc- multilib ia.
Oracle 1. 2c on Debian Sid: apt- get install build- essential binutils libcap- dev gcc g++ libc. Oracle either direct or indirect because of 3.
And yes, I tried to install without any extra packages and only installed what was necessary to fix a given problem. X1. 1 forwarding magic happen. Unzip the Oracle files. Unzip the Oracle files in the user's $HOME directory. XXX_database_1of.
XXX_database_2of. Environment variables.
For example: oracle@oracle: ~# export ORACLE_HOSTNAME=localhost. ORACLE_OWNER=oracle. ORACLE_BASE=/opt/oracle. ORACLE_HOME=/opt/oracle/product/1. ORACLE_UNQNAME=orcl. ORACLE_SID=orcl. oracle@oracle: ~# export PATH=$PATH: $ORACLE_HOME/bin. LD_LIBRARY_PATH=$LD_LIBRARY_PATH: /usr/lib/x.
ORACLE_OWNER: User with permission on Oracle files. ORACLE_BASE: Directory that will store the distinct Oracle Services. ORACLE_HOME: Directory that will store the Oracle database.
ORACLE_UNQNAME: Unique name of database. ORACLE_SID: Service Identifier of Listener.
PATH: Path to binary files. LD_LIBRARY_PATH: Path to library. Installation. You must run the installer as the oracle user. If you'll use the installer via SSH with X1. SSH and the oracle user. You may have noticed that a system user (as the one I created in this article) doesn't have a password.
To login directly as oracle you could use SSH keys to login or simply passwd oracle . Don't forget to enable X1. Forwarding in configuration files or use: $ ssh - XC $SOMEUSER@orclserver. If you decided to create a different non- privileged user to login via SSH (or if you are using root) you should use: $ ssh - XC $SOMEUSER@orclserver. MIT- MAGIC- COOKIE- 1 abcdef.
MIT- MAGIC- COOKIE- 1 abcdef. Once you are the oracle user with the proper xauth permissions, just run the installer.
As you are installing on Debian and it is not certified by Oracle, you need to tell the installer to ignore some checks or pre- requisites using - Ignore. Sys. Pre. Reqs. If you want to see all the options you can use - help. Installer - Ignore. Sys. Pre. Reqs. From this point on, it's up to you and your DBA. Just for the record, here are the values we used: Inventory directory: /opt/oracle/ora.
Inventory OS group name: oinstall Standard Edition Installation Name: Ora. Db. 10g_home. 1 Path: /opt/oracle/product/1. You'll hit a problem about the collect .
I couldn't fix it, but I found some places mentioned it is just for certified systems and won't affect the install, just hit the Continue button and finish the installation. The rest is pretty straightforward as Oracle will tell you what to do (including running a pair of shell scripts to fix permissions and copy some binaries into /usr/local/bin. Common problemsgcc- multilib: linking pthread problems/usr/bin/ld: skipping incompatible /usr/lib/gcc/x. INFO: collect. 2: ld returned 1 exit status. INFO: make: *** [ctxhx] Error 1. INFO: End output from spawned process. INFO: - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -.
INFO: Exception thrown from action: make. Exception Name: Makefile. Exception. Exception String: Error in invoking target 'install' of makefile '/opt/oracle/product/1. Solution: install gcc- multilib and its dependencies.
First steps. Start Oracleoracle@debian- sid: ~$ . ORACLE_HOMEStart Oracle on Systemd. Create daemon "/etc/systemd/system/oracle.
Unit]. Description=Oracle 1. Data. Base. Environment="ORACLE_HOME=/opt/oracle/product/1. Exec. Start=/bin/su oracle - c '/opt/oracle/product/1. ORACLE_HOME'. Wanted. By=multi- user. target. Updates changes made to service files of system, enables de Oracle service and starts it up.
Add Users. Let say you need a couple of users scott and foo with passwords tiger and bar in order to run the DBD: :Oracle Perl module tests. You can add those users running the following steps: oracle@debian- sid: ~$ sqlplus SYS AS SYSDBA. SQL> CREATE USER c##scott IDENTIFIED BY tiger. SQL> GRANT ALL PRIVILEGES TO c##scott. Grant succeeded. SQL> CREATE USER c##foo IDENTIFIED BY bar. SQL> GRANT ALL PRIVILEGES TO c##foo. Grant succeeded. References.
There is a great reference document that helped clearing up some doubts with regards to what should I add or not in terms of configuration, it is an official Oracle documentation called Oracle® Database Quick Installation Guide, it briefly documents the aspects of installation in Linux x. Category. Proprietary.