Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Linux \ Ubuntu install Oracle 10g process and problem solution     - MySQL service failed to start thinking of settlement under CentOS7 (Database)

- Linux OOM killer mechanism (Linux)

- grep command Series: grep command to search for multiple words (Linux)

- Ubuntu way of decompressing files (Linux)

- Oracle 12c users create (Database)

- The minimum initial use of the Linux operating system RancherOS feelings (Linux)

- PXE + Kickstart automatically install CentOS 6.5 (Linux)

- Close Pycharm spell check (Programming)

- Tune in high resolution to 1280x800 in Fedora 14 (Linux)

- How linux network security configuration (Linux)

- SUSE Linux firewall configuration notes (Linux)

- Why not use the ifconfig command under RedHat Linux 5 (Linux)

- Selection sort, insertion sort, and Shell sort (Programming)

- Linux see whether there is a hacker program (Linux)

- How do I cancel (almost) any operations in Git, (Linux)

- To teach you how to safely send mail (Linux)

- Windows environment Android Studio v1.0 Installation Guide (Linux)

- Ubuntu 14.10 install KDE Plasma 5.2 (Linux)

- Linux 64-bit porting (Programming)

- Mind mapping software installed in CentOS 7 in XMind (Linux)

 
         
  Ubuntu install Oracle 10g process and problem solution
     
  Add Date : 2018-11-21      
         
         
         
  PS: Ubuntu 12.04 install Oracle 10g whole process (perfect) and problem-solving approach under normal circumstances, the perfect correct. . If you encounter problems, there are solutions

1. Installation preparation work

1.1 oracle official website to download to their own computers oracle package;

I was: Oracle Database 10gRelease 2 (10.2.0.1.0) Enterprise / Standard Edition for Linux x86 under: 10201_database_linux32.zip

Address: http: //www.oracle.com/technetwork/database/10201linuxsoft-097986.html

1.2 update ubuntu

# Apt-get update

# Apt-get upgrade

1.3 install additional javaJDK

Ubuntu Software Center in [] search OPENjdk, OpenJDK complete path after the installation path is automatically set up

1.4 install the missing package and reduce GCC version

apt-get install gcc make binutils lesstif2 libc6 libc6-dev rpm libmotif3 libaio1 alien

apt-get install ksh libtool libstdc ++ 5 build-essential compat-libstdc ++


Uninstall gcc-4.6, install gcc-4.4 version

apt-get remove gcc-4.6

apt-get install gcc-4.4


1.5 Create oracle user

Log on to the root user the following:


1.5.1 modify shell

ls -l / bin / sh if it is modified to bash dash

rm / bin / sh

ln -s / bin / bash / bin / sh


1.5.2 create users and groups and oracle installation path

addgroup oinstall

addgroup dba

addgroup nobody

usermod -g nobody nobody


adduser oracle

usermod -g oinstall -G dba oracle

id oracle

id nobody


mkdir -p / opt / oracle

mkdir -p / opt / oradata

chown -R oracle: dba / opt / ora *

chmod -R 775 / opt / ora *


1.5.3 Create deceive Disclaimer

vi / etc / RedHat-release

Then adding Red Hat Linux release 3.1


1.5.4 establish a link

ln -s /usr/bin/gcc-4.4 / usr / bin / gcc

ln -s /lib/i386-linux-gnu/libgcc_s.so.1 /lib/libgcc.s.so.1


ln -s / usr / bin / awk / bin / awk

ln -s / usr / bin / rpm / bin / rpm

ln -s / usr / bin / basename / bin / basename


mkdir /etc/rc.d

ln -s /etc/rc0.d /etc/rc.d/rc0.d

ln -s /etc/rc1.d /etc/rc.d/rc1.d

ln -s /etc/rc2.d /etc/rc.d/rc2.d

ln -s /etc/rc3.d /etc/rc.d/rc3.d

ln -s /etc/rc4.d /etc/rc.d/rc4.d

ln -s /etc/rc5.d /etc/rc.d/rc5.d

ln -s /etc/rc6.d /etc/rc.d/rc6.d

ln -s /etc/init.d /etc/rc.d/init.d


1.5.5 add users to the list sudoer

vi / etc / sudoers

In the "root ALL = (ALL: ALL) ALL" the next line, add:

oracle ALL = (ALL: ALL) ALL


1.5.6 modify kernel parameters and system variables

A modify /etc/sysctl.conf file (can not modify)

gedit /etc/sysctl.conf

Add the following:

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 25 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

B modification /etc/security/limits.conf (can not modify)

gedit /etc/security/limits.conf

Add the following:

* Soft nproc 2407

* Hard nproc 16384

* Soft nofile 1024

* Hard nofile 65536

Note: Do not forget the "*" sign can be replaced with oracle


C ubuntu modify the oracle user's environment variables

/home/oracle/.profile And modify / etc / profile file two

vi /home/oracle/.profile

vi / etc / profile

Add the following:

#oracle_path start

export ORACLE_HOME = / opt / oracle

export ORACLE_SID = orcl

export ORACLE_OWNER = oracle

export PATH = $ PATH: $ ORACLE_HOME / bin

#oracle_path end


1.5.7 enable the parameters

Reboot the system or terminal Run sysctl -p

1.5.8 The oracle installation file downloaded to the next mv / home / oracle, and unzip it. Logout root user login oracle user


2. Start the installation oracle

2.1 Open a terminal, cd to the next / home / oracle / database of oracle-extracting files, execute the following command

./runInstaller -jreLoc / usr / lib / jvm / java-6-openjdk-i386 / jre

  java-version is java version installed, which is a fancy to oracle in the image will not be garbled or block

Then to install the same image under windows installation interface.


Does not work, use English installation interface

export LANG = ENGLISTH

./runInstaller


2.2 Follow the steps image

 http://www.cnblogs.com/luochengor/archive/2011/08/20/2147041.html

2.3 Configuration script to execute

  Switch to the root, execute the script in the terminal

  /home/oracle/oralnventory/orainstRoot.sh

  /opt/ora10/root.sh

2.4 appears oracle database 10g installation is complete, note the two URL.


2.5 Install Database

  Run the following command in the terminal:

$ Dbca // If the Chinese garbled, run the following command

$ Cd / opt / ora10 / bin

$ Gedit dbca

Find "JRE_DIR = / opt / ora10 / jdk / jre" in dbca, replace the JRE_DIR = / usr / lib / jvm / java-1.6.0-openjdk / jre, then save and exit

$ Dbca // normal show

2.6 perform the following steps

  http://www.cnblogs.com/luochengor/archive/2011/08/20/2147041.html

  But: To use the database name and SID must be written on orcl

  Until the installation is complete.

3. Start the oracle


In the "Terminal" Run as oracle


Start TNS listener: $ ORACLE_HOME / bin / lsnrctl start

($ ORACLE_HOME, is the oracle installation directory:. / Opt / ora10 direct cd, into the oracle installation directory to the bin folder, $ lsnrctl start, too).


Close TNS: $ ORACLE_HOME / bin / lsnrctl stop

Start sqlplus: $ ORACLE_HOME / bin / sqlplus / nolog


Close sqlplus: SQL> exit


4. In order to be able to use the same as under the windows up and down keys to flip command, also need to install rlwrap package:


sudo apt-get install rlwrap


Then modify the oracle user's ~ / .bashrc file and / etc / profile document, in its final add two lines:

So the arrow keys can be used.


Finally, to solve the problem oracle Chinese character set. Not surprisingly, then, start oracle will find all the Chinese are "?", Or is garbled, this is actually a server-side character set and client character set is inconsistent result.

Solution to: DBA identity into sqlplus, make inquiries

SQL> select userenv ( 'language') from dual;

Copy the query results, in /etc/bash.bashrc file plus line: export NLS_LANG = "Search Results" and re-log problem is solved. For example: my query results SIMPLIFIED CHINESE_CHINA.AL32UTF8, then add a new behavior export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.AL32UTF8".

But sometimes this approach is not always successful, you can

export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.AL32UTF8"

export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

Two files are written to try, but two written documents must be consistent.


5. If you have a problem, according to the following procedure Treatment:

5.1

Question: call makefile '. . Error install '/sqlplus/lib/ins_sqlplus.mk' goal '. See '/home/oracle/oraInventory/logs/installActions2011-12-06_11-03-18AM.log' for details.


Workaround: $ ORACLE_HOME / sqlplus / lib / env_sqlplus.mk add a line: EXPDLIBS = -lclntsh, then click the "Retry" button, ok.

In fact, after install gcc-4.4 does not have this problem.


5.2

Question: call makefile '. . Error agent nmo nmb 'when /sysman/lib/ins_sysman.mk' goal '. See '. . /oraInventory/logs/installActions2011-12-06_11-03-18AM.log 'for more information.

Analysis: Error encountered later in fact essentially a main problem is the version of gcc high, oracle10g the gcc version is 3.4 or so, but ubuntu speed of development has long used the version 4.0 or higher, and you can not install apt low version

Workaround: Uninstall gcc-4.6, install gcc-4.4 version

apt-get remove gcc-4.6

apt-get install gcc-4.4


5.3

Call makefile '. . Error install '/network/lib/ins_net_server.mk' goal '. See '. . /oraInventory/logs/installActions2011-12-06_11-03-18AM.log 'for more information.

        Analysis: Internet I found an article similar documents, see (click to open the link), but I still have a problem, manually compiled, and not -lons parameters of the problem he had referred in oracle10g in.

        Or gcc version of the problem, I have tried to install a lower version of gcc, but a start compiling on the error, so give up, if someone can successfully reduce version environment, I believe we can solve all the wrong question, which is why ubuntu 8 can naturally successful installation of an explanation.

        Method: At present, I have no way to follow the instructions of their .mk file, this thing seems to be time to re-link the database link with fracture

Workaround: Uninstall gcc-4.6, install gcc-4.4 version

In the / usr / bin made of soft links /usr/bin/gcc-4.4

cd / usr / bin

ln -s /usr/bin/gcc-4.4 / usr / bin / gcc


5.4

Call makefile '. . Error all_no_orcl ihsodbc '/rdbms/lib/ins_rdbms.mk' goal '. See '. . /oraInventory/logs/installActions2011-12-06_11-07-36-AM.log 'for more information.

      Analysis: We look at the log file

        Information: Generating BASE ORASDK library ...

        Information: Creating /opt/ora10/lib/liborasdkbase.so.10.2

        Information: gcc: Error: /lib/libgcc_s.so.1: No such file or directory

        gcc: error:. / usr / lib / libstdc ++ so.5: No such file or directory

        We are finally seeing that a lot of mistakes, but it is still gcc problem, re-download the libgcc_s.so.1, and re-do stdc ++ links 5, but the problem still more, because only soft links and Download a dynamic library is impossible to solve all the problems.

Workaround: Install the compat-libstdc ++ - 33_3.2.3-48.3_i386.deb, try again. .

In a soft link libgcc_s.so.1

cd / lib

ln -s /lib/i386-linux-gnu/libgcc_s.so.1 libgcc.s.so.1


6. boot


6.1 root the following modifications: vi / etc / oratab

orc1: /opt/oracle/product/10.2.0/db_1: Y

This is the N Y


6.2 oracle following modifications:

cd $ ORACLE_HOME / bin

vi dbstart

ORACLE_HOME_LISTNER find this line, modified to:

ORACLE_HOME_LISTNER = / opt / oracle / product / 10.2.0 / db_1

Modify or directly to:

ORACLE_HOME_LISTNER = $ ORACLE_HOME


Test Run dbshut, dbstart see if I can start oracle service and listener service

ps -efw | grep ora_

lsnrctl status

ps -efw | grep LISTEN | grep -v grep


Create a file under 6.3 root:

vi /etc/rc.d/init.d/oracle10


#! / Bin / bash

# Chkconfig: 345 99 10

# Description: Startup Script for Oracle Databases

# /etc/init.d/oracle10

export ORACLE_SID = ym

# Export ORACLE_HOME_LISTNER = / data / files / oracle / 10g / bin

#oracle installation directory

export ORACLE_HOME = / data / files / oracle / 10g

export PATH = $ PATH: $ ORACLE_HOME / bin

case "$ 1" in

start)

su oracle -c $ ORACLE_HOME / bin / dbstart # Start Service

su oracle -c $ ORACLE_HOME / bin / lsnrctl start # start listening

touch / var / lock / oracle

echo "OK"

;;

stop)

echo -n "Shutdown Oracle:"

su oracle -c $ ORACLE_HOME / bin / dbshut # start shutting down services

su oracle -c $ ORACLE_HOME / bin / lsnrctl stop # Close monitoring

rm -f / var / lock / oracle

echo "OK"

;;

*)

echo "Usage: 'basename $ 0' start | stop"

exit 1

esac

exit 0


then

chmod 775 oracle10

chkconfig --add oracle10

chkconfig --list oracle10
     
         
         
         
  More:      
 
- java.net.NoRouteToHostException of Hadoop problem: no route to host (Server)
- MySQL main and backup replication structures (using mysqld_multi) (Database)
- Simple solution CC attack under Linux VPS (Linux)
- Java factory pattern (Factory mode) (Programming)
- XenServer Virtual Machine Installation --- first ISO image file storage expansion (Linux)
- State and Linux nf_conntrack TCP disconnect time (Programming)
- linux remote control software (Linux)
- Red-black tree in C ++ (Programming)
- Red Hat Linux mount U disk (Linux)
- Singleton (Linux)
- How comprehensive resist attacks from the network (Linux)
- Linux shell script to adjust the Task Scheduler (Linux)
- imp / exp Oracle Database import and export commands (Database)
- How do you prevent other users from accessing your home directory in Linux (Linux)
- Use the dd command to the hard disk I / O performance test (Linux)
- Check the Linux server performance with ten or so commands in a minute (Server)
- Modify Linux SSH default port 22 in several ways (Linux)
- 11G ASM disk group does not automatically handle MOUNT (Database)
- Traffic monitor Linux Python Version (Programming)
- Linux Troubleshooting: How to save the status of the SSH session is closed (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.