Install Oracle9i in Linux

 

LinuxInstallOracle9i

Database Version: oracle9i R2 ( 9.2.0 . 1.0) 1. Create users and groups: ------------------------- Switch to the root user and execute the following commands $ Su- # Groupadd oinstall # Groupadd DBA # Useradd-G oinstall-g dba Oracle # Passwd Oracle 2. Create a directory. -------------------------- We will install everything in the/opt/ora9 directory: # Mkdir-P/opt/ora9/product/9.2 # Mkdir/var/opt/Oracle # Chown oracle. DBA/var/opt/Oracle # Chown-r oracle. DBA/opt/ora9 3. Pre-installation (system configuration ): --------------------------- 3.1 install these compatibility libraries: Compat-gcc-7.3-2.96.118.i386.rpm Compat-libgcj-7.3-2.96.118.i386.rpm Compat-libgcj-devel-7.3-2.96.118.i386.rpm Nss_db-compat-2.2-20.i386.rpm You can find these packages on the installation CD. The first file is in the RedHat RPMs directory of cd1. The other three files are in the RPMs directory of CD2. 3.2 set kernel parameters to enable successful startup: Add these rows to/etc/sysctl. conf If you have more RAM, you can also change these values: Kernel. shmmax = 536870912 Kernel. shmmni = 4096 Kernel. Shmall = 2097152 Kernel. SEM = 250 32000 100 128 FS. File-max = 65536 Net. ipv4.ip _ local_port_range = 1024 65000 Add these rows to/etc/security/limits. conf Oracle soft nofile 65536 Oracle hard nofile 65536 Oracle soft nproc 16384 Hard nproc 16384 Restart the system to make these kernel changes take effect. If the restart is not allowed, you can run the following command to change the kernel parameters: # Echo 250 32000 100 128>/proc/sys/kernel/SEM # Echo 536870912>/proc/sys/kernel/shmmax # Echo 4096>/proc/sys/kernel/shmmni # Echo 2097152>/proc/sys/kernel/Shmall # Echo 65536>/proc/sys/fs/file-max # Echo 1024 65000>/proc/sys/NET/IPv4/ip_local_port_range 4. Pre-installation (Oracle environment ): ---------------------------- Log On As an oracle user: Su-Oracle Place the following rows in ~ /. Bashrc: # Oracle 9i Export oracle_base =/opt/ora9 Export ORACLE_HOME =/opt/ora9/product/9.2 Export Path = $ ORACLE_HOME/bin: $ ORACLE_HOME/Apache/bin: $ path Export oracle_owner = Oracle Export oracle_sid = ora9i Export oracle_term = VT100 Export ld_assume_kernel = 2.4.1 Export threads_flag = native Export LD_LIBRARY_PATH =/opt/ora9/product/9.2/lib: $ LD_LIBRARY_PATH Export Path =/opt/ora9/product/9.2/bin: $ path # # Change the NLS settings based on your local conditions: # Example: # German_germany.we8iso8859p15, american_america.we8iso8859p2 etc. # Export nls_lang = 'croatian _ Croatia. ee8iso8859p2' If you need other country settings (these are from Croatia), refer to the supported settings here and modify the nls_lang variable accordingly. 5. installation: ------------------------ Log on as a root user and allow the user to write data to the X Display in Oracle: Su- Xhost + Log On As an oracle user: Su-Oracle Start installation. Do not switch to your CD-ROM installation directory because you will not be able to remove the first CD as needed to insert another CD. /Mnt/CDROM/install/Linux/runinstaller During installation, the system prompts you to insert another installation disk. Open a new console, run umount/dev/CDROM (as the root user) to detach the current disk and replace it. If redhat9 is not automatically installed, run the Mount/dev/CDROM command to install it. Two installation errors are generated. * First, you will see an error dialog box prompting questions about ins_oemagent.mk. If you select ignore, the error will be corrected after installation. * In the second dialog box, you will be notified of "error in invoking target install of makefile $ ORACLE_HOME/CTX/lib/ins_ctx.mk ". If this error occurs, open a new console and Log On As an oracle user. Run the following command: $ CD $ ORACLE_HOME/install $ Tail make. Log You will see a line similar to the following: Gcc-O ctxhx-L/opt/ora9/product/9.2/CTX/lib/-L/opt/ora9/product/9.2/lib/ -L/opt/ora9/product/9.2/lib/stubs/opt/ora9/product/9.2/CTX/lib/ctxhx. o -L/opt/ora9/product/9.2/CTX/lib/-lm-lsc_ca-lsc_fa-lsc_ex-lsc_da-lsc_ut -Lsc_ch-lsc_fi-lctxhx-LC-wl,-rpath,/opt/ora9/product/9.2/CTX/lib-lnls9 -Lcore9-lnls9-lcore9-lnls9-lxml9-lcore9-lunls9-lnls9 Copy this row, add-LDL at the end of the row, and then run it in $ ORACLE_HOME/bin. $ CD $ ORACLE_HOME/bin $ Gcc-O ctxhx-L/opt/ora9/product/9.2/CTX/lib/ -L/opt/ora9/product/9.2/lib/-L/opt/ora9/product/9.2/lib/stubs/ /Opt/ora9/product/9.2/CTX/lib/ctxhx. O-L/opt/ora9/product/9.2/CTX/lib/ -Lm-lsc_ca-lsc_fa-lsc_ex-lsc_da-lsc_ut-lsc_ch-lsc_fi-lctxhx-lC -Wl,-rpath,/opt/ora9/product/9.2/CTX/lib-lnls9-lcore9-lnls9-lcore9 -Lnls9-lxml9-lcore9-lunls9-lnls9-LDL Now, click the ignore button in the dialog box to continue the installation. Finally, Oracle installation may prompt you that the agent fails to start. Select ignore. We will change this error later. 6. Post-Installation --------------------------- Open a console and Log On As an oracle user. Run these commands: $ CD $ ORACLE_HOME/Network/lib $ Make-F ins_net_client.mk install Then edit the $ ORACLE_HOME/CTX/lib/ins_ctx.mk file and extract the Lines 13-14 from: Ctxhx: $ (ctxhxobj) $ (Link) $ (ctxhxobj) $ (inso_link) Change Ctxhx: $ (ctxhxobj) $ (Link)-LDL $ (ctxhxobj) $ (inso_link) Then execute $ Make-F $ ORACLE_HOME/CTX/lib/ins_ctx.mk install Now, you will be able to start your agent with the following command $/Opt/ora9/product/9.2/bin/agentctl start 7. Start the database ------------------------------ Do not worry if your installer is suspended in the last step of section 5th. Wait for a while to see whether it responds. If it does not, terminate it. Add the following lines in a shell script (such as setvar. Sh) # Oracle 9i Export oracle_base =/home1/orahome Export ORACLE_HOME =/home1/orahome/ora92 Export Path = $ ORACLE_HOME/bin: $ ORACLE_HOME/Apache/bin: $ path Export oracle_owner = Oracle Export oracle_sid = ora9i Export oracle_term = VT100 Export ld_assume_kernel = 2.4.1 Export threads_flag = native Export LD_LIBRARY_PATH =/opt/ora9/product/9.2/lib: $ LD_LIBRARY_PATH Export Path =/opt/ora9/product/9.2/bin: $ path Export ora_nls33 = $ ORACLE_HOME/ocommon/NLS/admin/Data Save the file and run it at the command prompt. $ Source setvar. Sh Go to $ ORACLE_HOME/bin Use any editor to edit the dbca script $ Kwrite dbca Find the jre_home environment variable. It points to JDK 1.8, which is part of the installation CD. Change the variable and point it to jdk1.3 or 1.4 installed in your Linux system and go to the end of the file. This variable is used to call the Java program. Delete the bin directory from the path and rename the JRE executable file to a Java file. This is just like using our own JDK to call Java programs. Start $./Dbca 8. Start the database instance Open a sqlplus session and log on as the system database administrator using sys/passwd. SQL> Create spfile from pfile = 'full path of the. ora File Created by the dbca utility '; EG/home1/orahome/admin/dl226b/pfile/initdl226b. ora SQL> shutdown immediate; SQL> startup;