Installing oracle 10g in suse linux enterprise 10)

Minimum Oracle10G system requirements:
Memory: 1 GB recommended, 768 MB in the VM
Swap partition: 1 GB, set to 2 times of memory
/Tmp disk space: More than MB
Disk Space: Software 3.5 GB Data 1.2 GB

Required software:
SUSE Linux Enterprise 10 for x86 (SLES http://blog.chinaunix.net/u/27474/showart_212310.html)

Oracle database 10gR2 for linux32

Http://www.eygle.com/archives/2008/06/10gr2_download_link.html

Orarun-1.8-XXX.XX.i586.rpm software package (which is available in the sles software installation oracle database, can also be downloaded from http://ftp.novell.com/partners/oracle/sels-9

Installation steps:
1. Install the SUSE operating system and install the "C/C ++ Compiler and Tools" software package. In the Development Section

2. Install the required software package. Install the orarun software package, that is, the oracle database package installed in the software, saving a lot of settings. In the database Column

3. Oracle user settings
When the orarun software package is installed, a user named oracle and an oinstall group are automatically created. We only need to set this user to enable and change shell from/bin/false to/bin/bash. In addition, the orarun package automatically generates the ORACLE_HOME folder, which reduces a lot of trouble.

4. Set Oracle environment variables
Modify environment variables such as the/ect/profile. d/oracle. sh file and ORACLE_HOME and ORACLE_SID as needed.
For example:
ORACLE_HOME = $ ORACLE_BASE/product/10gR2
ORACLE_SID = ORCL
The default value is NLS_LANG = AMERICAN. If the installation interface in Chinese OS is garbled.We recommend that you install it in an English environment..

# Note: Garbled characters are displayed incorrectly in the Chinese environment. You can change the user language to English for installation.
# Set the language environment
# Set both LANG and LC_ALL.
$ Export LANG = en_US
$ Export LC_ALL = en_US
This is a temporary change to the user's language environment. After logon, it will be restored to the previous one.
If not, you can use yast to change the language environment. Then, log on again or restart your computer.

If you need a Chinese installation interface, please refer to the additional one at the bottom.

5. Install Oracle10gR2
Log out of the root user and log on to the KDE again as an oracle user. Do not use su-oracle under the root user to switch to the oracle user for installation. The GUI cannot be started.
Run./runInstaller-ignoresysprereqs to start installing Oracle.-ignoresysprereqs ignores operating system authentication,Oracle10gIt cannot be installed on SUSE Linux10 by default.Upper. Of course, you can also copy the installation file to the hard disk, modify the database/install/oraparam. ini file, add the SuSE-10 item to it, and copy it according to the suse9 parameter so that you do not use the-ignoresysprereqs parameter.

The following figure shows the graphic interface for smooth installation. There may be a prompt in the middle of the system detection, no matter, click Next until the end.
It is very convenient to install Oracle on SUSE Linux10, so you do not need to set too many parameters. The SUSE Linux10 interface is also very beautiful. If you are interested, try it. Thank you!

 

Installation image:

 

 

 

 

Add Simplified Chinese

 

 

The system will still prompt that some tests fail. If there is no error prompt, continue the installation.

 

Here, only the software is installed, and then dbca is used to create a database.

 

Enter the terminal command line, switch to the root user (su command switch, enter the password), and execute the following two. sh files.

 

 

Reference: http://blog.chinaunix.net/u/27474/showart_209366.html

 

Additional 2: Firewall

The default SuSE firewall is used to disable all external connections. If you want to open a port, You have to modify the firewall settings to open the port. This article describes how to modify the SUSE firewall settings to open a specified port. Manual modification: # Vi/etc/sysconfig/SuSEfirewall2 # TCP port: FW_SERVICES_EXT_TCP = "6000" # UDP port status: FW_SERVICES_EXT_UDP = "177" Effective firewall settings: # RcSuSEfirewall2 restart

 

 

Add a complete solution for installing Oracle Chinese Character garbled characters in linux

1. Install JDK
Create a Temporary Folder under/tmp
# Cd/tmp
# Mkdir javacn
# Cd javacn

Download the j2sdk-1_4_2_02-linux-i586.bin from an online search and save it to/tmp/javacn
You can also download the latest http://java.sun.com/products/archive/ here

Add executable permissions to files
# Chmod 755 j2sdk-1_4_2_02-linux-i586.bin

Install JDK in the execution File
#./J2sdk-1_4_2_02-linux-i586.bin
... (A lot of license information)
Check whether you agree. Of course, select yes.
.........

Delete the installation file after installation
# Rm-rf *. bin

It seems that the installation is just to decompress it. The decompressed result is the j2sdk1.4.2 _ 02 folder.

This folder cannot be placed in/tmp. What should I do if I accidentally delete it one day? Move and rename it!
# Mv j2sdk1.4.2 _ 02/usr/j2sdk

The JDK installation is not complete yet. You need to set the environment variable:
# Cd/etc
# Vi profile
Add the following section before the export PATH
JAVA_HOME =/usr/j2sdk
Export JAVA_HOME

JRE = $ JAVA_HOME/jre
Export JRE

PATH = $ JAVA_HOME/bin: $ JRE/bin: $ PATH
Log out and log on again
OK. JDK installation is complete!
2. to install the system font javacn.zip, download http://download.csdn.net/source/1430575.
Decompress the attachment file to/tmp/javacn. The extracted results are as follows:
# Cd/tmp
# Cd javacn
# Ls-l
Total usage 23184
-Rw-r -- 1 root 8102 font. properties
Drwxr-xr-x 9 root 4096 June 24 15:36 j2sdk1.4.2 _ 02
-Rw-r -- 1 root 12642204 1970-01-01 SimSun18030.ttc
-Rw-r -- 1 root 10500352 1970-01-01 simsun. ttc
-Rw-r -- 1 root 7764 1970-01-01 sm. sh
-Rw-r -- 1 root 260472 1970-01-01 tahomabd. ttf
-Rw-r -- 1 root 265528 1970-01-01 tahoma. ttf

Next, you need to rename the font. properties file in $ JRE/lib and copy the font. properties file in/tmp/javacn to $ JRE/lib.

# Cd $ JRE
# Cd lib
# Mv font. properties font. properties. bak
# Cp/tmp/javacn/font. properties ./

The remaining operation is to execute/tmp/javacn/sm. sh.
After sm. sh is executed, the system restarts automatically. Therefore, save the ongoing work before performing the following operations!
# Cd/tmp
# Cd javacn
#./Sm. sh
Bash:./sm. sh: insufficient Permissions
# Chmod 755 sm. sh
#./Sm. sh
The operating system restarts.
The second part is completed.

3. Set the operating system font
Copy all files under/usr/X11/lib/X11/fonts/TrueType to $ JAVA_HOME/jre/lib/fonts
# Cp/usr/X11/lib/X11/fonts/TrueType/*. * $ JAVA_HOME/jre/lib/fonts

Use an oracle user to log on and set the application font and window title Font to SimSun.

(The following steps are in KDE and should be similar in GNOME)
Start> Control Center> appearance and subject> font
Click "adjust all fonts", configure the settings in the following interface, select the font check box, and select "Simsun" in the list (in fact, this is what everyone is familiar with in the Window ), you don't need to worry about the font style. Select the size check box and select 9 in the list. After the configuration is complete, click OK. Return to the previous window and close the window.

Last 4. Install Oracle
Switch to the Oracle user and run./runInstaller. The interface should be a friendly Chinese interface. If it is still garbled, check the above steps.

Another simple method is provided:The following parameters are specified during installation:InstallJDK

./RunInstaller-jreLoc/opt/oracle/jdk1.6.0.18/jre/

After the database software is installed, there is a small tail project. That is, the Chinese garbled characters on the DBCA and EM interfaces are fixed. After Oracle is installed, it will install its own JDK. Several of its tools use its own JDK.

 

Add zero: Install JDK

My downloaded version is jre-6u18-linux-i586.bin, download page http://java.sun.com/javase/downloads/widget/jdk6.jsp

1. Put the jre-6u18-linux-i586.bin locally, I put it under the/opt/oracle/directory, and I put all the oracle-related items below. Oh. Follow these steps to switch to the root permission.

2. Set the execution permission chmod a + x jdk-6u <version>-linux-i586.bin

3. Run self-extract:./jdk-6u <version>-linux-i586.bin, prompting for authorization instructions, q skipped, then enter yes and wait for it to complete. Finally, the installation is completed in opt/oracle/(that is, decompress the package in the current path)

4. Open/etc/profile and add it to the end of the profile file:

#

# Set java enviornment

#

JAVA_HOME =/opt/oracle/jdk1.6.0 _ 18

JAVA_BIN =/opt/oracle/jdk1.6.0 _ 18/bin

PATH = $ PATH: $ JAVA_HOME/bin

CLASSPATH =.: $ JAVA_HOME/lib/dt. jar: $ JAVA_HOME/lib/tools. jar

Export JAVA_HOME

Export JAVA_BIN

Export PATH

Export CLASSPATH

5. Verify that the JDK version is successfully verified. You can delete this binfile if you want to save space.

Chinese garbled characters are displayed when DBCA assistant is used:

Solution: You need to install the new JDK version. For installation instructions, refer to "add 0: Install JDK ".

Use gedit to open the dbca file and edit the JRE_DIR path to point to the directory you installed. For example, in the/opt/oracle/product/10.2/db_1/bin directory of oracle10G,

The JDK1.6.XXX path is in/opt/oracle/jdk1.6.0.18/jre. Then run dbca, which is the culture in the interface.

OK. All problems are solved. Other similar problems can be solved by reference!

 

Additional 2:Configure windowsConnect the client to linuxOracleDatabase

Reference: http://doc.linuxpk.com/52076.html

Prerequisites:

1. Install the oracle client component on the client. (This is already installed on a computer that has installed the oracle database)

2. on the server side, ensure that the listener has been started (lsnrctl status) and that the database has been started. (> Sqlplus "/as sysdba"> startup)

3. Configure the Net Configuration Assistant on the client, or modify the file.

The file is located:

$ ORACLE_HOME \ network \ admin \ tnsnames. ora (for windows)
$ ORACLE_HOME/network/admin/tnsnames. ora (for unix)

Red font of modified content

Orcl =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.80.29) (PORT = 1521 ))

(LOAD_BALANCE = yes)

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

Note:

Orcl = here orcl is the identification, connection string.

HOST = 192.168.80.29. The red text here indicates the remote host ip address.

SERVICE_NAME = orcl, which is the name of service_name on the server.

After the above basics, you can. Then, tnsping 192.168.80.29 returns the OK value, indicating that the connection is successful. If not, check whether the server has enabled the firewall. Close.

Additional 3: Start the database and automatically start the database

After installation, log on to the terminal as an oracle user:
$ Sqlplus/nolog
SQL> connect/as sysdba
SQL> startup
Set oracle Auto-start:
Modify the/etc/sysconfig/oracle file:
START_ORACLE_DB = "yes"
START_ORACLE_DB_LISTENER = "yes"
Modify the last line of the/etc/oratab file:
Orcl:/home/app/oracle/product/10.2/db_1: N:
Orcl:/home/app/oracle/product/10.2/db_1: Y

Set environment variables:
Add the following two variables to the/etc/profile file:
NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
LANG = zh
Export LANG NLS_LANG
These two environment variables are not set. If the uploaded SQL script contains Chinese characters, these Chinese characters cannot be identified. When using our GUI, garbled characters are displayed in some places.

To enable the root user to directly use the SQL command, the following two lines can be used in the/etc/profile file:
PATH = $ PATH:/opt/oracle/product/10.2/db_1/bin
Export PATH
Note:
1. There cannot be spaces before and after environment variable =; otherwise, an error will occur.
2. Run the following command to modify the file:
#. Profile
This will take effect; or you can restart your computer.