Oracle testing in Ubuntu

I have never wanted to install Oracle in the Linux series during my initial Oracle trial in Ubuntu. I have read the official documentation before. There are a bunch of things to configure to install Oracle on the Linux platform, and the installation may fail many times, very careful. Recently, we need to install Oracle on the Linux platform to test a certain function of the product, and there are many Linux clients. We need to make up for the shortcomings, I decided to install Oracle on Ubuntu, and practiced it for simple use. Run the following command to check the Ubuntu version on the VM. If you know that the version can be installed with Oracle10g, You have to install the 10g trainer first and then install it several times, if you have more exercises, you will be familiar with them. [Plain] root @ ubuntu :~ # Cat/etc/issue Ubuntu 11.04 \ n \ l upload the installation file to the Ubuntu virtual machine, decompress it, open the file % oracle_installer_root % \ database \ doc \ index.html, (% oracle_installer_root % is the directory for extracting the Oracle Installation Package) you can find the Installation Guide for the Oracle database through this file. The Installation Guide is rich and includes the following content: [plain] • Reviewing Information About This Guide • Logging In to the System as root <span style = "color: # ff0000; "> <strong> • Checking the Hardware Requirements • Checking the Software Requirements • Creating Required Operating System Groups and Users • Grouping Kernel Parameters • Creating Required Directories • Grouping the oracle User's Environment </strong> </span> <span style = "color: #000099; "> <strong> • Mounting the Product Disc • Installing Oracle Database • Installing Products from the Oracle Database 10g Companion CD </strong> </span> • What to Do Next? • Additional Information • Documentation Accessibility The highlighted content is system check (hardware check and Software Check) and system configuration (such as user configuration and parameter configuration ), blue is the Oracle installation process. We can see that this installation package can be installed in the following OS. [Plain] • The operating system must be one of the following: Unsupported Red Hat Enterprise Linux 3.0 (Update 3 or later) according to Red Hat Enterprise Linux 4.0 unzip SUSE Linux Enterprise Server 9.0 unzip Asianux 1.0 unzip Asianux 2.0, we found that there is no Ubuntu, but this does not affect our installation. The most troublesome part of the installation process is the previous system configuration. It is best to patiently follow the instructions in the installation step by step. Otherwise, errors may occur easily. For example, [plain] kernel. shmall = 2097152 kernel. shmmax = 2147483648 kernel. shmmni = 4096 kernel. sem = 250 32000 100 128 fs. file-max = 65536. net. ipv4.ip _ local_port_range = 1024 65000 rmem_default = 262144 rmem_max = 262144 wmem_default = 262144 wmem_max = 262144 if you put fs. if file-max is written as 65535, an error may be reported during installation (although the error may not affect your installation, you can ignore it ). As Ubuntu did not list it in the installation guide, I checked the information to create a version declaration file, declare Ubuntu as Redhat, cheat Oracle, and then continue the installation, the procedure is as follows: [plain] echo 'Red Hat Linux release 4'>/etc/redhat-release configures the parameters. After creating the parameters, you can enter the installation process. The preceding configuration is correct. When executing the installation command, a GUI is displayed for installation. The installation process, Oracle_home, and other directories are read to the configured directory. In addition, it is best to restart the computer during installation to install the new oracle user. If you create an oracle database instead of an oracle database, you need to replace the oracle database with the corresponding username during parameter configuration. Otherwise, errors may occur. The installation was successful this time and there was no problem. The installation was successful and then started to use it. Open a Terminal window, habitually break into "sqlplus-v", prompt "command not found", switch oracle user, the command can be successfully executed. [Plain] root @ ubuntu :~ # Sqlplus-v sqlplus: command not found root @ ubuntu :~ # Su oracle @ ubuntu:/root $ sqlplus-v SQL * Plus: Release 10.2.0.1.0-Production oracle @ ubuntu:/root $ from this point we can see these operations, it is better to operate on Oracle users. The following operations are performed under Oracle users. Linux is different from Windows in that it does not automatically start listeners and data for you. You need to manually start the listener or add a script to enable automatic start of the listener. Start the listener. In the Terminal window, run the following command to start the listener: [plain] lsnrctl start the listener. In the Terminal window, run the following command to start the database: [plain] dbstart [plain] start the listener. In the Terminal window, run the following command to start the listener: [plain] After the lsnrctl start database is started, you can use sqlplus or a client to connect and use it.